SQL Server Diaries

I recently came across a number of SSISDB databases (on SQL Server 2012 instances) configured with the default log retention settings. While this might not seem like a problem, on a system hosting a considerable number of packages, where some of said packages are scheduled to run multiple times a... [Read More]

This article assumes that the reader is aware of the benefits of deploying a standardized backup and maintenance solution. [Read More]

Transparent Data Encryption (TDE)has many advantages, and satisfies a number of audit, security and compliance requirements. This article is not about setting up TDE. [Read More]

Many times a DBA is asked to provide the list of permissions, for auditing purposes, or simply to review the current permissions. Sometimes the request is for server-wide permissions, sometimes the scope is limited to a database, sometimes to a Login, or combinations or “all of the above”. [Read More]

When creating an SQL Server environment using the Azure template, and after running the following query, it is observed that the system databases will be located on the OS partition. For reasons of performance and for example to avoid that the TEMPDB causes a server outage, these must be moved... [Read More]