SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

T-SQL Tuesday #90 – Shipping database changes



Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by “The Database Avenger”  James Anderson. This month we’re talking about Shipping Database Changes – something I’ve done many times and mostly correctly – although we… Read more

0 comments, 180 reads

Posted in measure twice, cut once. on 9 May 2017

T-SQL Tuesday #89 – New horizons and new opportunities!


TSQL Tuesday

I thought that I’d write a few words about this months T-SQL Tuesday -the blog party started by Adam Machanic (blog | twitter) and this month hosted by hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/),- as it’s a subject I’ve discussed many times… Read more

0 comments, 425 reads

Posted in measure twice, cut once. on 11 April 2017

SQL Saturday South Island, New Zealand (SSSI)


Saturday 8th April 2017 will see the biggest ever SQL Saturday South Island New Zealand. The event started in 2013 as SQL Saturday Christchurch and has progressively grown in size.

Originally run solely by the Christchurch SQL Server user group, the event expanded in 2015 in order… Read more

0 comments, 522 reads

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

CREATE DATABASE – I’ve not seen that before.


It’s been a while

I thought that I’d make a quick blog post about an incident that I encountered today that I had not come across before.
I was working on my laptop when I tried doing a really basic task – creating a database.
So I keyed… Read more

4 comments, 537 reads

Posted in measure twice, cut once. on 22 January 2017

What’s happening in Asia Pacific?


I really am going to make an effort to blog more, and this post is really the start of that.
I figure that I’ll just have to be more disciplined and set aside some time to complete a lot of posts that I’ve started, but remain in draft… Read more

0 comments, 603 reads

Posted in measure twice, cut once. on 30 September 2015

TSQL Tuesday #68 – backup checksum default


Well it seems like TSQL Tuesday #68 is providing me with a real good reason to get back into my blogging again. It been a while – due to various life events – but I think it’s time to dust off my virtual pen and start a (hopefully)… Read more

1 comments, 855 reads

Posted in measure twice, cut once. on 7 July 2015

More Azure SQL Database Enhancements – Meet RLS (cloud first debut)


Well, it was only a few  days ago that I blogged about some major Azure SQL Database enhancements. Primarily, in that post,I was referring to new features that were made available in the new V12 preview portal, specifically for moving “On Prem” database to Azure SQL… Read more

1 comments, 1,567 reads

Posted in measure twice, cut once. on 30 January 2015

Azure Enhancements – Time to take a look (and read the ebook.)


Recently I’ve become quite interested in the latest incarnation of Azure SQL Database.

For those that are unaware of some of the latest developments of this product, there was a new preview portal opened up towards the end of 2014.

This latest offering – know as version… Read more

1 comments, 6,214 reads

Posted in measure twice, cut once. on 27 January 2015

2014 – A year in review.


And so another year passes, and as I’ve never wrote a “year in review” post before now seems like a good time to start.

2014 has been a pretty hectic year for me, both personally and professionally. The project that I’ve been working on for the past few… Read more

0 comments, 806 reads

Posted in measure twice, cut once. on 31 December 2014

I’ve joined the SQL SERVER MVP community – Thank you!


Today I awoke to find an email from Microsoft informing me that I’d been awarded an MVP. Wow.

I had to re-read the email several times over the course of the next hour to ensure it was true. Also checking the date – to make sure it was… Read more

1 comments, 761 reads

Posted in measure twice, cut once. on 1 October 2014

A real life table variable performance problem.


I’m sure we’ve all heard and read about the differences between table variables and temporary tables. In case you haven’t here’s one of many articles that you can read on the subject.

Anyway, there is a business process in one of my databases that calculates results via… Read more

2 comments, 1,515 reads

Posted in measure twice, cut once. on 30 September 2014

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


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

1 comments, 1,046 reads

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

Import export wizard at the commandline


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, 1,203 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)


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, 1,026 reads

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

The SQL Elephant in my room


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

6 comments, 5,010 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, 13,263 reads

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

The CHOOSE keyword


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

5 comments, 1,244 reads

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

TSQL-Tuesday#050 – Automation


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, 963 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, 1,077 reads

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

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


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, 968 reads

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

Older posts