My Favourite, yet most Pointless, SQL Datatype

By Greg 4 comments

This month, for T-SQL Tuesday, Brent Ozar has asked us to write about our favourite data types. There is a list of data types over in the docs, and most of them have a use. Numbers and dates as I’ve already mentioned, strings obviously need to go in (either as extended ASCII or Unicode), and […]

TSQL-Tuesday – Automate Your Stress Away

By Greg 1 comment

Elizabeth Noble is hosting this months TSQL-Tuesday, and she asks a great question: How do you automate stress away from your life? I love automation, not because automation is cool in itself (although it is) but I love it because of all the side benefits it gives you. It means I stuff up less often […]

Fantasy SQL Feature – T-SQL Tuesday

By Greg 2 comments

This month for T-SQL Tuesday, Kevin Chant has asked the question “What is your Fantasy SQL Feature?” There are a few that I would love to have, but the one that keeps popping up is having a foreign key that can reference more than one table. I know this seems like an odd request, but […]

What is Your “Why”?

By Greg No comments

Andy Leonard (@AndyLeonard) has asked this month on T-SQL Tuesday “Why do you do what you do?” I have two answers to this question. On one hand I do what I do because it pays the bills. I have a full time job working for a company here in Australia and it pays the bills […]