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

SQL Saturday #316, MVP’s, MCMs and a baby.

G’Day,

Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).

We learnt a lot from running our first SQL Saturday back in August 2013 – which was SQL Saturday #252

For the second year in a row we hosted… Read more

0 comments, 154 reads

Posted in measure twice, cut once. on 27 June 2014

Import export wizard at the commandline

G’day,

Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something new.

Today I discovered that in order to use the “Import / Export Wizard” we don’t even have to open management studio.

Just type “dtswizard” into the run… Read more

0 comments, 249 reads

Posted in measure twice, cut once. on 12 May 2014

Two IDs, One database and a Magic Number (and maybe even an empty string)

G’day,

I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least I thought it was odd

Normally, I join with sys.dm_exec_sessions and filter out anything that is a system process (WHERE [sys].[dm_exec_sessions].[is_user_process] = 1 )

However, this time… Read more

0 comments, 245 reads

Posted in measure twice, cut once. on 26 March 2014

The SQL Elephant in my room

G’day,

Are people familiar with the saying “If there’s an elphant in the room, introduce it“? – if not, then to sum up here goes – “An important and obvious topic, which everyone present is aware of, but which isn’t discussed, as such discussion is considered to… Read more

2 comments, 3,225 reads

Posted in measure twice, cut once. on 19 March 2014

THE IIF statement – SQL has it at last.

G’day All,

While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came to my notice that we additionally have the IIF statement.

Again, this was added in 2012.

I’d assume that most people would be familiar with this… Read more

8 comments, 4,929 reads

Posted in measure twice, cut once. on 18 February 2014

The CHOOSE keyword

G’day,

I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced in SQL SERVER 2012.
So what does it do?
Well basically a label can be applied at a specific index in a list.
Here’s a demonstration script… Read more

3 comments, 388 reads

Posted in measure twice, cut once. on 17 February 2014

TSQL-Tuesday#050 – Automation

G’day,

Well, it’s the first TSQL-Tuesday of 2014 and one of my New Years resolutions for 2014 is to contribute to each TSQL-Tuesday of the year – lets see how we go!

Well, the subject of this months TSQL-Tuesday is Automation – which is quite obviously something that any… Read more

0 comments, 309 reads

Posted in measure twice, cut once. on 14 January 2014

Do you clean up after yourself?

G’day folks,

I remember a fair few years ago when I was relativly new to TSQL creating a stored procedure that used several temporary tables and had faily complex logic.

Occasionally during development the stored procedure would fail with errors – aside from the fact that the stored procedure… Read more

0 comments, 420 reads

Posted in measure twice, cut once. on 13 January 2014

Installed SQL SERVER 2012? maybe you’d like to re-set your shortcuts!

G’day,

Just a quick post on a seemingly trivial matter that others may find useful.

The post was prompted by the Simple-Talk article on SQL SERVER 2012 keyboard shortcuts

Anyway, I installed SQL SERVER 2012  sometime ago on my laptop and ever since the CTRL-R keyboard shortcut key has… Read more

0 comments, 298 reads

Posted in measure twice, cut once. on 30 December 2013

SQL Saturday #252, Christchurch New Zealand

SQL Saturday #252 Christchurch, New Zealand

G’day,

Well, these are exciting times for the Christchurch SQL SERVER User Group.

After a period of fragmentation where our meetings seemed to be at random intervals – mainly due to certain major events outside our control – such as earthquakes, the city… Read more

0 comments, 432 reads

Posted in measure twice, cut once. on 28 July 2013

Dedicated Admin Connections (DAC) and SQL SERVER 2012 SSMS

G’day,

As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open the relevant firewall port – normally 1433 for a default instance – Although this can be altered

As we know, you can open a dedicated administrated connection using… Read more

0 comments, 1,873 reads

Posted in measure twice, cut once. on 7 April 2013

Multiple ALTER DATABASE SET options

G’day,

Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.

It’s true, you can!

Mostly I never see this done.

Maybe it doesn’t make sense! maybe it’s just more readable if a single ALTER DATABASE statement contains a single SET operation!… Read more

0 comments, 865 reads

Posted in measure twice, cut once. on 6 April 2013

SSPI error and Incorrect timing.

G’day,

Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance using SQL SERVER Management Studio (SSMS)

Now, I could RDP to the server and connect to the local instance using SSMS, however any attempt to connect to the… Read more

0 comments, 522 reads

Posted in measure twice, cut once. on 28 March 2013

Following good practice saves wasted time down the line.

G’day,

Sometimes I come across what I call unusual coding practices. Developers usually have pressure on them to deliver and this often results in simply delivering code that works – with very little attention to best practice , performance or security.

Sometimes this lack of attention to best practice… Read more

1 comments, 1,769 reads

Posted in measure twice, cut once. on 10 September 2012

The first record on data page.

G’day,

I had a recent conversation about data pages. There was some debate about the location of the first record on that page and whether or not it’s location is always after the page header.

As we know the page header is 96 bytes long – so does it… Read more

0 comments, 616 reads

Posted in measure twice, cut once. on 6 August 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, 806 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,781 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, 591 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, 589 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, 494 reads

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

Older posts