Click here to monitor SSC

2014 February


Phil Factor

Sundown on Markdown?

5 comments

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, Ask.SQLServerCentral.com, 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

5 comments

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?

0 comments

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

0 comments

Generally, when users are implementing continuous delivery for their databases, using Red Gate tools (SQL Source Control, SQL Automation Pack, Deployment Manager – see here for an overview), they are using Red Gate’s own script folder format, working in SSMS, so that the database can be source controlled and managed as part of the delivery […]

11 February 2014 8:26 am by
Phil Factor

Getting normally-distributed random numbers in TSQL

8 comments

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
Fatherjack

Learning by doing (or not)

0 comments

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.

0 comments

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