Click here to monitor SSC

2014 February

Phil Factor

Sundown on Markdown?


Markdown is a way of using plain text to create markup, usually, but not exclusively, HTML. It is based on the plain-text email message conventions. It has never been a formal standard. If you’re a developer or DBA, and use StackExchange,, Stack Overflow or Github, then you’ll have used it. The idea behind Markdown, […]

28 February 2014 10:47 am by
Tony Davis

DevOps Dilemma


The term ‘DevOps’ has been widely misunderstood because the different teams within any really substantial development project understand the work of the other teams so poorly. There will be several teams, including business analysts, technical architects (maybe), UX specialists, designers, testers, and developers. No development specialists, however, have until recently had the production environment firmly […]

14 February 2014 1:21 pm by
Nirmal Sharma

How Scalable is Windows Server 2012 Compared to Windows Server 2008 R2?


Every new Hyper-V release provides new features or improvements over existing features. As part of the improvement, Microsoft also keeps scalability in mind. Scalability is required by large organizations to make sure the production load can be balanced by running multiple services on the servers. For example, you could run 512 virtual machines on a […]

11 February 2014 7:52 pm by
Ben Rees

Automating Deployment of Database Projects with Red Gate Tools


Update 31/03/2015 Since writing this article, a number of Redgate product development changes have taken place. Some of the references in the article are now out of date, so here’s a summary of the changes that have taken place: We now have a TFS Build Template that simplifies the setup of Red Gate tools on […]

11 February 2014 8:26 am by
Phil Factor

Getting normally-distributed random numbers in TSQL


When you are creating test data, you will, at some stage, hit the problem of simulating a distribution. There are plenty of different distributions. In the real world, variables such as height, rainfall, or examination  results conform to a Normal or Gaussian distribution, where the mean is the median, and variables are more likely  to […]

7 February 2014 6:17 pm by

Learning by doing (or not)


I have spent a lot of today repeating steps that I followed months ago and it is hopefully through writing it down here that I will remember the steps needed if it happens again. I was building a VM environment on my laptop (using VMWare but that is irrelevant) and it went like: Create VM […]

6 February 2014 3:44 pm by
Phil Factor

Converting Roman Numerals: More TSQL Program Chrestomathy.


As part of my series on TSQL Program Chrestomathy, this is a couple of TSQL routines that convert between integers and roman numerals.  There are two functions, one for each direction of conversion. These are a slight revision and expansion of what I published on a blog in 2011. I've added a bit more of […]

3 February 2014 4:46 pm by