Click here to monitor SSC

2011 April

Phil Factor

A breathing-space for Software corpulence


A guest editorial for Simple TalkThe greatest struggle for anyone designing, building or maintaining applications is the fight against complexity. It chokes the lifeblood from any application. Chuck Moore, one of the founding fathers of IT recently said, in an interview with Simple-Talk: “Complexity is the problem. Moving it from hardware to software, or vice […]

28 April 2011 3:16 pm by



LiveJournal Tags: tsql,numbers table,chain letters,tsql super hero,csi OK, it’s not really a crime scene (although that depends on your opinions on Facebook I guess) but I got this in the middle of my Facebook news feed stream thing (I’m not a regular on Facebook!). Now apart from the chain letter tones later on in the […]

28 April 2011 3:00 am by
Grant Fritchey

SQL Azure Deployments


Over on I posted about the new Data-Tier Application (DAC) and DAC packages (DAC pac) this morning. You might be thinking, “Oh, now he’s on the Red Gate blog he’s going to rip it apart.” And you’d be wrong. I want to work from the premise that Microsoft is completely on to something. Not […]

25 April 2011 5:45 am by
John Magnabosco

Moving Dates


At the loading dock, hard working individuals load a semi trailer with your new television, stereo system and personal computer. There is a dependency in this process: it is that your favorite electronics store has a loading dock that will be able to accommodate the size of the semi. If the semi were to arrive […]

24 April 2011 12:32 am by

When my 6 beats your ten.


I started this blog post on some rambling story about UNION and Datatypes and IMPLICIT and EXPLICIT conversions and took an age to get anywhere so I scrapped it and you now get this abridged version. It’s a quick run through the SQL Server datatypes equivalent of Rock, Paper Scissors. I am guessing that most […]

20 April 2011 10:36 pm by
Grant Fritchey

SQL Azure Backup


Have some important information stored out there on the cloud? Want a way to get a copy of it down to your local machine? Here you go. A nice neat little backup tool from Red Gate, SQL Azure Backup. Let me talk about this a bit. First off, you need to know, you will pay […]

19 April 2011 10:00 am by
Grant Fritchey

Tracking Azure Costs


I posted this morning over on the Scary DBA blog about the costs of SQL Azure. It’s a confusing model and hard to track. I’ve mentioned this before here, but I think it bears repeating. Red Gate has a cloud based app that will monitor your usage and send you emails on the costs that […]

18 April 2011 5:15 am by
Louis Davidson

What Counts For a DBA: Failure


My family and I enjoy sitting down together to watch the TV show called “Wipeout“. The contestants try to run wacky obstacle courses filled with various bizarre and fiendish obstacles in the fastest possible time. Failure is a guaranteed occurrence; contestants run into fake walls, get hit by “cartoon” hammers, and generally end up falling […]

16 April 2011 4:59 pm by
Michael Williamson

An Agile House of Stone


A couple of weeks ago, Tony discussed why complex databases can’t be created in the Agile way. As someone that works on code from the database right up to the user interface, I wonder what makes a database so different from application code. The arguments in favour of an agile approach are just as strong […]

14 April 2011 1:17 pm by

SQLBits and beyond …


Well SQLBits was a brilliant event. There was a record attendance, an extra track and an early morning session to fit in all the sessions and I got a chance to speak in a lightning session. The details of the conference are all over the place with other bloggers so I will not repeat their […]

14 April 2011 10:00 am by
Older posts

Blog archive