Jes Borland SQL Server Indexed Views: The Basics Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style... 12 February 2014 23 min read
Joe Celko SQL Server SEQUENCE Basics The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is... 06 February 2014 13 min read
Nirmal Sharma Hosting SQL Server in Hyper-V Replica Environment A Hyper-V replica will provide a rapid disaster-recovery by simply replicating to a standby site a VM running at the... 04 February 2014 26 min read
Feodor Georgiev Collect Your SQL Server Auditing and Troubleshooting Information Automatically If you have a number of SQL Server instances with versions ranging from 2005 upwards, with a whole host of... 28 January 2014 12 min read
Robert Sheldon The SQL Server Sqlio Utility If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware's... 27 January 2014 14 min read
Joe Celko Nesting Levels in SQL The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way... 27 January 2014 13 min read
Dwain Camps The Performance of the T-SQL Window Functions Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there... 17 January 2014 16 min read
Gail Shaw SQL Server Deadlocks by Example When a SQL Server instance deadlocks, it can be anything from minor irritation to something far more severe. In this... 16 January 2014 54 min read
Hugo Kornelis Generating Test Data in TSQL To test SQL, you need test data. There are usually many reasons why you can't use production data. Although it... 14 January 2014 30 min read
Laerte Junior The PoSh DBA – Reading and Filtering Errors DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs... 10 January 2014 31 min read
Dev Nambi Agile Database Development Agile methodologies work well with database developments only if great care is taken to do things right. It requires good... 03 January 2014 28 min read
Robert Sheldon The SQL Server Sqliosim Utility The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It doesn't... 02 January 2014 14 min read
Dwain Camps Calculating the Median Value within a Partitioned Set Using T-SQL It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the... 17 December 2013 12 min read
Grant Fritchey SQL Enlight for SQL Server Management Studio The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that... 10 December 2013 17 min read
Laerte Junior The PoSH DBA – SQLPSX: SQL Server PowerShell Extensions Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed... 10 December 2013 26 min read
Learn SQL Server Phil Factor in Learn SQL Server Primary Key Primer for SQL Server Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules,... 02 December 2013 22 min read
Robert Sheldon SQL Server tablediff utility Rob Sheldon continues on his quest to explain all those command-line tools such as SQLCMD, Logparser, SQLIO and tablediff that... 02 December 2013 23 min read
Alex Kuznetsov Lessons Learned from Six Years of Agile Database Development Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a... 19 November 2013 26 min read
Robert Sheldon Microsoft’s Log Parser Utility: Swell ETL For loading text, CSV or XML files into SQL Server, the Log Parser utility, with its amazing SQL engine, is... 12 November 2013 21 min read
Joe Celko Window Functions in SQL SQL's windowing functions are surprisingly versatile, and allow us to cut out all those self-joins and explicit cursors. Joe Celko... 31 October 2013 16 min read
