Backup Databases on Creation

One of the companies which I work with has the occasion to create new databases when they do releases of their software.  Normally this isn’t a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs.  As all the new databases are created in the […]

SQL PASS Day 1 Keynote

Today was the 1st day of the SQL PASS Summit and the keynote was full of some great announcements and demos.  The keynotes are a massive with almost all of the 3894 conference attendees from 57 different countries. All of the keynotes from this years conference not only are the keynotes being streamed live, but […]

SQL PASS Day 1 Keynote

Today was the 1st day of the SQL PASS Summit and the keynote was full of some great announcements and demos.  The keynotes are a massive with almost all of the 3894 conference attendees from 57 different countries. All of the keynotes from this years conference not only are the keynotes being streamed live, but […]

Passive AlwaysOn Replicas, not as free as you might think

With the release of SQL Server 2012 and specifically the AlwaysOn feature we need to rethink the way that we handle the licensing for servers that will be passive servers.  In the past it’s been assumed that passive servers didn’t need to be licensed, and that was true, for the most part.  The official docs […]