Click here to monitor SSC

2012 April


David Atkinson

SQL Server source control from Visual Studio

1 comment

Developers have long since had to context switch between two IDEs, Visual Studio for application code development and SQL Server Management Studio for database development. While this is accepted, especially given the richness of the database development feature set in SSMS, loading a separate tool can seem a little overkill. This is where SQL Connect […]

30 April 2012 1:16 pm by
Richard Mitchell

DIVs of equal height

0 comments

It’s the same old old problem you want to make a set of columns the same height but life it too short for the CSS only version. It’s technically possible to do but nowadays you can’t run the web without having javascript turned on. There must be an easier way. After a short amount of […]

29 April 2012 9:35 am by
Tony Davis

IT Admin for Thrill Seekers

5 comments

A developer suggested to me recently that the life of the DBA was, surely, a dull one. My first reaction was indignation, but quickly followed by the thought that for many people excitement isn’t necessarily the most desirable aspect of their job. It’s true that some aspects of the DBA role seem guaranteed to quieten […]

27 April 2012 11:01 am by
David Atkinson

How the "migrations" approach makes database continuous integration possible

0 comments

Testing a database upgrade script as part of a continuous integration process will only work if there is an easy way to automate the generation of the upgrade scripts. There are two common approaches to managing upgrade scripts. The first is to maintain a set of scripts as-you-go-along. Many SQL developers I’ve encountered will store […]

26 April 2012 2:06 pm by
Louis Davidson

What Counts For A DBA: Foresight

2 comments

Of all the valuable attributes of a DBA covered so far in this series, ranging from passion to humility to practicality, perhaps one of the most important attributes may turn out to be the most seemingly-nebulous: foresight. According to Free Dictionary foresight is the “perception of the significance and nature of events before they have […]

26 April 2012 4:40 am by
David Atkinson

Database continuous integration step by step

1 comment

This post will describe how to set up basic database continuous integration using TeamCity to initiate the build process, SQL Source Control to put your database under source control, and the SQL Compare command line to keep a test database up to date. In my example I will be using Subversion as my source control […]

24 April 2012 7:25 pm by
David Atkinson

Ever wondered what the Object Explorer Details window is for?

0 comments

Typically, when I install SQL Server Management Studio and run it for the first time, the first thing I do is to close the Object Explorer Details window. After all, it doesn’t seem to serve a useful purpose, duplicating information that already exists in the Object Explorer. However, I have discovered that it has one […]

24 April 2012 3:40 am by
Damon Armstrong

Hierarchical Queries with Common Table Expressions

2 comments

I wanted a simple example of a hierarchical query using a common table expression in SQL Server.  MSDN had an example called Recursive Queries Using Common Table Expressions, but it relied on the Adventure Works database and was joining across three different tables.  Then I stumbled upon another blog called Working with hierarchical data in […]

24 April 2012 3:29 am by
David Atkinson

Using a SQL Prompt snippet with template parameters

0 comments

As part of my product management role I regularly attend trade shows and man the Red Gate booth in the vendor exhibition hall. Amongst other things this involves giving product demos to customers. Our latest demo involves SQL Source Control and SQL Test in a continuous integration environment. In order to demonstrate quite how easy […]

20 April 2012 12:00 pm by
Richard Mitchell

Red Gate Cloud Services – something new

0 comments

For the past several months I’ve been working on something new. This is a hosted service for maintaining cloud applications cunningly named Red Gate Cloud Services. It’s been live since the beginning of the year and it’s free to try it out too. Schedule SQL Azure Backups Simply put you can schedule backups of your […]

19 April 2012 1:27 am by
Older posts