Excellence in SQL Server

The default setting for the initial sizing of data and log files (and their autogrowth) is not adequate. I like to make sure that we set...

There are a number of queries widely available that will look at the DMVs and tell you what indexes you may be missing. This is a great...

By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose...

Whilst deploying some reports to a new Sharepoint installation I noticed that the global ReportName variable (Globals!ReportName)...