m82labs   about   posts   categories   talks   feed

A Closer Look at OUTPUT

by Mark Wilkinson · January 15, 2018

Lots of people have used the OUTPUT clause in an INSERT/UPDATE/DELETE statement, but many may not know just how flexible it is, and what hidden gems there are in the documentation. In this post we are going to look at two interesting and surprising use cases for the OUTPUT clause.

Read More...

Automation Basics with Powershell and CMS

by Mark Wilkinson · September 12, 2017

As a DBA I use PowerShell every day. If it can be automated, I will automate it. In my environment I have 300+ instances to keep track of and maintain. When you manage that many instances, it’s important to have a “source of truth” for a full list of your instances. This is where Central Management Server (CMS) comes in. The combination of PowerShell and CMS is a powerful one. In this post we’ll explore a PowerShell function I wrote to retrieve servers from my CMS server.

Read More...