Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2012

2012 DDL for Roles

G’day,

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

0 comments, 831 reads

Posted in measure twice, cut once. on 22 April 2012

Listing SQL Instances on a machine (or list of machines)

G’day,

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

0 comments, 2,903 reads

Posted in measure twice, cut once. on 17 April 2012

SQL Saturday 136 – Wellington. Speakers review.

G’day,

On Saturday 16th April 2012, I attended SQL Saturday #136 in Wellington, New Zealand.

The day was run by Dave Curlewis [Blog | Twitter] and his excellent team –  a big hats off to them, the sponsors and the team at Whitireia Community Polytechnic (Porirua… Read more

0 comments, 620 reads

Posted in measure twice, cut once. on 16 April 2012

Speaking at SQL Saturday #136 – Wellington, New Zealand

G’day,

On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand.

My presentation is titled “Extended Events – A whirlwind tour”  - I first gave the presentation at SQL Saturday 76 in Auckland back in January and again at Christchurch code camp  a… Read more

0 comments, 609 reads

Posted in measure twice, cut once. on 12 April 2012

Database ownership

G’day,

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

0 comments, 523 reads

Posted in measure twice, cut once. on 4 April 2012