Brad McGehee SQL Server 2008: The New Data Types Brad continues his helicopter-level view of the most interesting new features of SQL Server 2008 with a look at the... 11 October 2008 15 min read
Alex Kozak The Bejeweled Puzzle in SQL Alex Kozak provides another SQL puzzle to hone your SQL Skills with. … 09 October 2008 6 min read
Robert Sheldon Using Powershell to Generate Table-Creation Scripts For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL... 04 October 2008 19 min read
Ron Dameron Why This SQL Server DBA is Learning Powershell Ron describes how he decided to study Powershell as a single scripting system to automate all the common repetitive server... 30 September 2008 18 min read
Richard Morris SQL Response: The dim sum interview Richard Morris met David and Nigel of the SQL Response team, in a dim sum Restaurant in Cambridge. They had... 30 September 2008 13 min read
Joe Webb Using Covering Indexes to Improve Query Performance Designers of database systems will often assume that the use of a clustered index is always the best approach. However... 29 September 2008 12 min read
Phil Factor Robyn Page Database Design Workbench – Keys Robyn Page and Phil Factor explore the innocent subject of Keys for their latest workbench. Everybody knows about keys. Oh... 19 September 2008 18 min read
Brian Harris SQL Response: Choosing Our Words Carefully Historically, the profession of "technical author" emerged from the nascent aerospace and technology industries following the war, and brought with... 17 September 2008 9 min read
Brian Harris SQL Response: Does Everything Need a Name? Our overriding goal at Red Gate is to make our software more usable by "doing whatever works". That means to... 17 September 2008 5 min read
Anith Sen Faking Arrays in Transact SQL It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL.... 16 September 2008 20 min read
Richard Morris Kalen Delaney: Geek of the Week Kalen Delaney has been involved in SQL Server from the beginning. Her talks and her writings are always interesting but,... 16 September 2008 14 min read
Brad McGehee Policy-Based Management Every DBA knows the frustration of trying to manage tens of servers, each of which has a subtly different configuration.... 26 August 2008 20 min read
Patrick Index Passing Variables to and from an SSIS task In which Patrick Index casts a jaundiced eye on SSIS, and decides that, for all its faults, it has a... 20 August 2008 7 min read
Brian Harris Ziggurats, Batman and the Town Crier We asked Brian for a description of the Help System for the software he's working on and ends up quoting... 19 August 2008 11 min read
Richard Morris SQL Toolbelt 2008: Predominantly an Engineering Task The conversion of the Red-Gate tools to be compatible with SQL Server 2008 might not seem, on first impression, the... 18 August 2008 16 min read
Rodney Landrum SQL Server eBook Download – SQL Server Tacklebox The SQL Server Tacklebox contains a collection of practical tools and techniques to automate and standardize SQL Server installation, document... 05 August 2008 2 min read
Robert Sheldon SQL Server 2008 SSIS Cribsheet SSIS has achieved several new and interesting features in SQL Server 2008. And who better to guide you through them... 05 August 2008 19 min read
Anith Sen Concatenating Row Values in Transact-SQL It is an interesting problem in Transact SQL, for which there are a number of solutions and considerable debate. How... 31 July 2008 17 min read
Mario Broodbakker Investigating SQL Server 2008 Wait Events with XEVENTS Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy... 24 July 2008 9 min read
William Brewer JSON and other data serialization languages The easiest way to speed up an Ajax application is to take out the 'X' and use JSON rather than... 18 July 2008 9 min read
