Tag Archives: sql server

Finally, Create or Alter

Posted on November 29, 2016 by way0utwest

There are lots of reasons to upgrade to SQL Server 2016, but this is the one for me. We finally get a CREATE OR ALTER statement in T-SQL. This not only makes lots of code easier to write, it means … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

Monitor All the Changes

Posted on November 22, 2016 by way0utwest

Can you monitor every configuration change and setting on all your SQL Server instances? Can you get an alert every time code changes, or even if an option for an object changes, such as the changing of an EXECUTE AS … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Monitor All the Changes

A Joke Come True

Posted on November 17, 2016 by way0utwest

Yesterday was the opening of Microsoft Connect 2016. If you didn’t have the chance to watch the opening keynote, I’d recommend you do so. Mostly because one of my jokes, or perhaps a dream, has come true. SQL Server runs … Continue reading →

Posted in Editorial | Tagged | Comments Off on A Joke Come True

A New Recovery Tool for Your Toolbelt

Posted on November 15, 2016 by way0utwest

Those of us that administer databases and are responsible for ensuring the integrity and availability of data know that being able to restore systems is a core skill. In the SQL Server world, this should mean more than just being able to … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on A New Recovery Tool for Your Toolbelt