Click here to monitor SSC

Phil Factor


Phil Factor

Silos and Monoliths – Moving On to the Past

14 comments

The presenter positively glowed with enthusiasm as she showed us how easily the schemas collections of documents in MongoDB could follow the changes in the way you structure the data in your application. I was at an interesting presentation recently of MongoDB with .NET. The presenter explained, brightly, that using MongoDB was a liberating experience […]

11 April 2014 1:27 pm by
Phil Factor

Including timings, I/O and XML Execution plans in your SQL Test rigs

0 comments

Sometimes, when developing SQL code, you need to run an automated test and benchmark over and over again. In this test run 'with bits',  you want a lot of diagnostic information such as the CPU,  IO,  which can be saved, parsed and compared between runs.  You want the results of the SQL so you can […]

14 March 2014 4:37 pm by
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
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
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
Phil Factor

The Joy of Program Chrestomathy

9 comments

After days spent wrestling with an intractable mess of code, with the winter rain beating on the windows, I sometimes find it difficult to maintain my keenness for development work. Is it like this for everyone? You read of cool startups where the California sun streams through the windows and everyone is young and cool, […]

31 January 2014 1:10 pm by
Phil Factor

IT Aphorisms

52 comments

An aphorism is a concise or laconic statement that expresses an element of truth, and maybe a sting in the tail. such as ‘I’m an atheist, thank God’, or ‘The bearing of a child takes nine months, no matter how many women are assigned.’ An aphorism that is too often repeated becomes a cliché. The […]

19 December 2013 9:58 am by
Phil Factor

TSQL code to explore keys in a database.

0 comments

   /*These queries are all to explore and investigate the keys of a table or database, and are designed to accompany my article on primary keys that is here. You'll find, I hope, that is is quite easy to modify them for other purposes */   USE AdventureWorks; —or whatever GO /* list out all the […]

2 December 2013 2:26 pm by
Phil Factor

A Knights Tale

2 comments

There are so many lessons to be learned from the story of Knight Capital losing nearly half a billion dollars as a result of a deployment gone wrong. The Knight Capital Group (KCG N) was an American global financial services firm engaging in market making, electronic execution, and institutional sales and trading. According to the […]

25 October 2013 6:47 pm by
Phil Factor

How to get SQL Railroad Diagrams from MSDN BNF syntax notation.

2 comments

On SQL Server Books-On-Line, in the Transact-SQL Reference (database Engine), every SQL Statement has its syntax represented in  ‘Backus–Naur Form’ notation (BNF)  syntax. For a programmer in a hurry, this should be ideal because It is the only quick way to understand and appreciate all the permutations of the syntax. It is a great feature […]

28 September 2013 9:39 am by
Older posts