SQL Tip-5 | Lightning Fast way to find errors in SQL Server Error Logs

In my first SQL Tip Don’t forget to recycle your SQLServer ErrorLog I listed some common problems you may face if you are not recycling your errorlogs timely. However, I do understand the criticality...


SQL Tip-4 | Do you know you can increase number of archived Errorlogs

By default, SQL Server keeps only seven error logs; Errorlog and Errorlog.1 to Errorlog.6. The name of the current, most recent log is Errorlog with no extension. In my SQL Tip-1 I advised why...


Best Practice No.24

Disable “xp_cmdshell” where it is not required. If this is required for some admin tasks make sure you disable this post completion of the activity to reduce surface area. Related posts: Best Practice No.1...


SQL Tip-3 | Don’t Shrink your Database

You should avoid shrinking your database until and unless it becomes unmanageable. Shrinking is a Resource intensive task, Moreover it introduces high degree of fragmentation which affects performance. Let’s say you shrink a Database,...


Best Practice No.23

set start-up mode of Standalone SQL Services to start automatically. Related posts: Best Practice No.17 Best Practice No.13 SQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic*


Virtual Tech Conference | 1st August 2013 | 4PM till 10PM

Here is another chance to learn from MVPs. Microsoft & MVPs present VTC – Virtual Tech Conference – 12 Hours of non stop learning. Register Today & Block your Seat, here are the URLs...


SQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic*

I know this one is very basic but in the recent past I noticed a couple of environments where the startup type of SQL Server Agent was set to manual which resulted in lot...


Best Practice No.22

Don’t keep the System Database files & Windows installation on same disk. Related posts: Best Practice No.6 Best Practice No.19 Best Practice No.11 Best Practice No.5 What do you mean by Principals? (with respect...