Archives: April 2012
I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored procedures.
The particular case that I came across today was regarding roles and the ALTER ROLE syntax.
Prior to SQL SERVER 2012, it has… Read more
Recently I was updating some of my Powershell scripts for managing SQL SERVER instances.
Generally, when writing a Powershell script to do something SQL related, the script takes the form of the following,
Author : Martin Catherall
Get status of sql instances (must have sql 10 libraries… Read more
On Saturday 16th April 2012, I attended SQL Saturday #136 in Wellington, New Zealand.
On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand.
One of the features that I most like about management studio is the ability to generate a script of the actions that have been taken in one of the (many) dialog boxes.
This has tremendous value for both learning and for creating scripts to pass to another DBA. Read more