-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I had previously used SQL Server Data Tools, and I tried…
I got motivated to write this post as there was a question on twitter which was like – The user was checking if there was a way to prevent procedures…
Lets start discussing about this subject by closely looking at the term Redundancy. What is redundancy all about ? Wikipedia defines redundancy as “In engineering, redundancy is the duplication of critical components or functions of a system with the…
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here. Policy based management(PBM) is indeed one of my favorite features. I normally like to play around…
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new databases which gets created will have page verify =…
A blog post about Microsoft Assessment Planning Toolkit was in my list for quite a while and today I decided to write about it. Let’s assume that you are working for a…
Today there was an interesting question posted on twitter, and that made me think about ways on how we can play around with SQL Server features/options to find solutions for…
Have you ever encountered this error message when tried to extract zipped backup files using built in ‘Extract All‘ facility of Windows – The error message will first give you…
Recently there was an interesting question from one of the forum users ,the question was something like ‘How long the data collector jobs are scheduled to run when I configure…
Lets start the month with some best practice’s. Microsoft® SQL Server® 2008 R2 Best Practices Analyzer will allow you to scan your sql server instance and will report potential issues.There is…
Cloud & SQLSailor 