Joe Celko The SQL of Membership: Equivalence Classes & Cliques It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks... 28 July 2014 11 min read
Robert Sheldon Questions about SQL Server Data Types You were Too Shy to Ask Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their... 14 July 2014 41 min read
Dwain Camps Calculating and Verifying Check Digits in T-SQL A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check... 11 July 2014 24 min read
Grant Fritchey Why Put Your Database into Source Control? Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood.... 08 July 2014 7 min read
Melanie Townsend Avoiding Database Deployment Disasters – 7 Tips Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a... 02 July 2014 7 min read
Saurabh Dhoble Developing a Custom SSIS Source Component SSIS was designed to be extensible. Although you can create tasks that will take data from a wide variety of... 30 June 2014 21 min read
Grant Fritchey Rollback and Recovery Troubleshooting; Challenges and Strategies What happens if your database deployment goes awry? Do you restore from a backup or snapshot and lose all the... 26 June 2014 16 min read
Joshua Feierman The Mindset of the Enterprise DBA: Creating and Applying Standards to Our Work Although many professions, such as pilots, surgeons and IT administrators, require judgement and skill, they also require the ability to... 25 June 2014 12 min read
Robert Sheldon SQL Server Tables – 11 Questions You Were Too Shy to Ask There are some aspects of tables in SQL Server that a lot of people get wrong, purely because they seem... 18 June 2014 35 min read
Tony Davis Database Branching and Merging Strategies Source control will allow you to maintain branches in the development of your database, but the subsequent merge isn't pain-free.... 18 June 2014 23 min read
David Poole Experiments with NEO4J: Using a graph database as a SQL Server metadata hub NEO4J, the graph database, can be used to provide answers that are very tricky for relational databases, including providing diagrams... 17 June 2014 18 min read
Jonathan Hickford Using Migration Scripts in Database Deployments A SQL migration script is similar to a SQL build script, except that it changes a database from one version... 17 June 2014 20 min read
Joe Celko The SQL of The Game of Life Joe finds a reference to Conway's Game of Life whilst clearing out his desk, and is suddenly gripped with nostalgia.... 05 June 2014 7 min read
Kalen Delaney Row Versioning Concurrency in SQL Server The optimistic concurrency model assumes that several concurrent transactions can usually complete without interfering with each other, and therefore do... 05 June 2014 44 min read
Phil Factor On Comparing Tables in SQL Server How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It... 29 May 2014 20 min read
Saurabh Dhoble Setting Up Your SQL Server Agent Correctly It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges', and ensure... 28 May 2014 15 min read
Robert Sheldon TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get... 19 May 2014 31 min read
Joshua Feierman On Adopting the Mindset of an Enterprise DBA Although many of the important tasks a DBA has to perform should be done 'by hand', keying in commands or... 19 May 2014 11 min read
Database Administration Tony Davis in Database Administration Optimizing Transaction Log Throughput As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage"... 08 May 2014 35 min read
Phil Factor Producing JSON Documents from SQL Server queries via TSQL Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is... 06 May 2014 24 min read