SQL Server Diaries

With the launch of SQL Server 2012 I decided to check the Microsoft Learning site to find out when the exams will be available.  It seems that the new SQL Server 2012 professional certifications (MCITP) have been reduced to two, one for the Data Platform and another for Business Intelligence.... [Read More]

A colleague recently told me that an SQL Server instance tempdb was installed to the Program Files folder of the C: drive and that occasionally the server was complaining of low disk space.  The only way this could be solved was by restarting the server. The tempdb is a system... [Read More]

Copies of live database are frequently hosted on development servers. In some cases these occupy several Megabytes or Gigabytes of disk storage. This is acceptable for the duration of the project development, testing (and other uses) however it might not be feasible, both from an economical as well as security... [Read More]

I was recently involved in the implementation of an SQL Server environment that would host the database for a Microsoft Service Center Configuration Manager (SCCM) deployment.  My expertiese was required to prepare the SQL Server instance and make reccomendations for performance, sizing, and of course security, which I did.  The... [Read More]

I recently wrote about auditing SQL Server instances using Traces, and after reviewing the solution with a “fresh” mindset I saw features that were missed during the research which led to a previous article.  Today’s post shows how to limit the auditing to UPDATE, INSERT and DELETE events (see note/insert... [Read More]