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

Generating Insert Statements

G’day,

I been asked a few times lately the best way to generate INSERT statements.

I’d always replied to use SSMS.

I know SSMS has this feature, it’s just not something that I have the need to use on a regular basic. And – as we all know – when… Read more

0 comments, 180 reads

Posted in measure twice, cut once. on 2 February 2019

Azure Notebooks – a nice little tool.

Gday,

I’ve been playing with Azure notebooks lately and have found them invaluable as

  • A teaching aid
  • A test sandbox

I’ve been using Python code, and this means that I don’t have to install Python on the machine that I am working at.

It also means that anybody I am… Read more

0 comments, 1,012 reads

Posted in measure twice, cut once. on 31 January 2019

T-SQL Tuesday #109 – Mentors and Mentees

G’day again,

So, it’s time for T-SQL Tuesday again, the blog party 
started by Adam Machanic ( This time we're talking about people you're influenced to get involved in SQL, strengthen their SQL, SQL join the community or in any other way. As I regional mentor in the APAC area… Read more

0 comments, 138 reads

Posted in measure twice, cut once. on 11 December 2018

TSQL Tuesday #108 – Learning to Learn

G’day,

One attribute that I think is more relevant today than ever is to have a broad base of skills with the ability to go deep when needed.

This requires the ability to learn quickly when needed.  Which, in turn, requires that we know how to learn quickly.

When I… Read more

0 comments, 158 reads

Posted in measure twice, cut once. on 15 November 2018

A lack of foreign keys – a bad culture example.

G’day,

One of the things that I’ve been seeing more often than I would like to lately is large databases with no foreign keys – or minimal foreign keys (and often with those minimal set of keys disabled)

By large databases I’m roughly meaning databases with several hundred tables, and… Read more

5 comments, 3,099 reads

Posted in measure twice, cut once. on 28 October 2018

T-SQL Tuesday #97 – We don’t need no Education! (or do we?)

G’day,

 

Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by Mala Mahadevan. This month we’re talking about “Setting Learning Goals for 2018.

With so much change going on in the IT… Read more

0 comments, 500 reads

Posted in measure twice, cut once. on 12 December 2017

Flexible connections and an old friend

G’day,

Just lately I’ve found myself involved with an app that needed to run on a server and nearly always (although not quite always) connect to the same SQL Instance.

And as the app progressed through the various environments I needed the flexibility to change that connection easily.

I… Read more

0 comments, 416 reads

Posted in measure twice, cut once. on 26 November 2017

What would you tell your younger self?

G’day,

 

Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by  Raul Gonzalez. This month we’re talking about “those important lessons that you learned the hard way.”  - but what does that mean.… Read more

0 comments, 600 reads

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

T-SQL Tuesday #90 – Shipping database changes

G’day,

 

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

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

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

G’day,

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

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

SQL Saturday South Island, New Zealand (SSSI)

G’day,

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

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

CREATE DATABASE – I’ve not seen that before.

G’day,

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

0 comments, 974 reads

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

What’s happening in Asia Pacific?

G’day,

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

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

TSQL Tuesday #68 – backup checksum default

G’Day,

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

0 comments, 1,348 reads

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

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

G’day,

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

0 comments, 2,275 reads

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

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

G’day,

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

0 comments, 6,509 reads

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

2014 – A year in review.

G’day,

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

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

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

G’Day,

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

0 comments, 1,073 reads

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

A real life table variable performance problem.

G’day,

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

0 comments, 2,063 reads

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

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

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

Older posts