Deploy or Migrate a Database using Scripts - part 1

A database migration is always a headache for DBAs.  There are different approaches one may take, some being simpler than others. A couple of weeks ago, in the Migrate Databases Using Backup-Restore article, I explained how a database migration can be carried out effortlessly and with minimal downtime.  This is... [Read More]

T-SQL to Transfer Data based on Periodic Date Ranges

I don’t think I’d be wrong in stating that almost all transactional and analytical systems store or make use of date, time, or parts of to achieve the respective functional targets.  A task I had to complete once was to find a way to retrieve data based on the period... [Read More]

Instance Pre-Installation Checklist

You have been requested to provide an SQL Server environment to host the database/s of Application123. Once you’ve identified the server onto which the instance will be installed there are a number of checks I would suggest, or at least these are the ones I follow. You will observe that... [Read More]

Configuring the SCOM 2012 SQL Server Management Pack for Low-Privilege Access

The System Center Operations Manager 2012 is Microsoft’s flagship product to monitor various aspects of the infrastructure.  Specific details about the product can be found in the TechNet at  Monitoring can be “extended” to SQL Server instances (2005 and later versions only) using the System Center Monitoring pack for... [Read More]