SQL Server Diaries

System Center Operations Manager 2012 is, to say the least, an interesting product.  I will not be delving into the product features or functionality, but just a particular error I came across and the obvious fix. [Read More]

All environments (hopefully…) have a proper backup strategy in place.  To tell the truth I’ve seen databases which were being backed up and the client asked me: “Why is it that the backup for an 80GB database is only 4GB?”.  In this particular case I discovered that the database recovery... [Read More]

We are planning a migration of our older SQL Server databases to one of the latest versions or possibly decommission them.  To have a better idea of the environments, our management requested a report containing the operating system versions, the SQL Server versions, the database names and the database sizes... [Read More]

One of the SQL Server Alerts implemented on all instances checkd for errors with a severity level of 20 and which is described as “Fatal Error in current process”. A similar alert can be created by Right-Clicking on the “Alerts” folder under SQL Server Agent, selecting “New Alert” and filling... [Read More]

Security is good.  Or to state that differently, lack of security is very bad.  So in the case of a SQL Server database, security is of the utmost importance.  For this reason DBAs work with security professionals to protect the data hosted on their servers.  The truth is that SQL... [Read More]