SQLChamp

By default, SQL Server keeps only seven error logs; Errorlog and Errorlog.1 to Errorlog.6. The name of the current, most

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

You should avoid shrinking your database until and unless it becomes unmanageable. Shrinking is a Resource intensive task, Moreover it

set start-up mode of Standalone SQL Services to start automatically.

Here is another chance to learn from MVPs. Microsoft & MVPs present VTC – Virtual Tech Conference – 12 Hours

I know this one is very basic but in the recent past I noticed a couple of environments where the

Don’t keep the System Database files & Windows installation on same disk.

Many a times I’ve seen that DBAs forget to recycle the ErrorLog of their critical SQLServers. Now I also understand

SQL Server 2014 CTP1 is out with lots of cool & exciting features, if you’ve not yet downloaded it, you

When choosing service accounts, consider the principle of least privilege.