Robert Sheldon UPDATE Basics in SQL Server SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement. Bob Sheldon starts... 21 June 2010 17 min read
Hima Bindu Vejella Book Review: The Art of XSD – SQL Server XML schemas The 14 chapters of "The Art of XSD", written by MVP Jacob Sebastian, will take the reader step-by-step all the... 10 June 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – Lazy Spool Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator... 10 June 2010 9 min read
Josef Richberg SSIS and Parallelism: The Unseen Minions Sometimes, a procedural database process cannot easily be reduced to a set-based algorithm in order to reduce the time it... 10 June 2010 19 min read
Joe Celko Book Review: Defensive Database Programming With SQL Server It distils a great deal of practical experience; the writing of it was a considerable task; It packs in a... 10 June 2010 4 min read
Laerte Junior I’m a SQL Server DBA, and I’m in Love with PowerShell To learn PowerShell, Laerte suggests that you just start using it. To encourage you to start, he provides a series... 28 May 2010 13 min read
Jonathan Lewis Oracle to SQL Server: Crossing the Great Divide, Part 2 A well-known Oracle expert records faithfully his struggles with the unfamiliar : SQL Server. He now sets himself the task... 26 May 2010 19 min read
Kathi Kellenberger Set-based Speed Phreakery: The FIFO Stock Inventory SQL Problem The SQL Speed Freak Challenge is a no-holds-barred competition to find the fastest way in SQL Server to perform a... 25 May 2010 31 min read
Buck Woody Mission Critical: SQL Server General Configuration You know how to set up a SQL Server instance, but it is great to have a list of all... 24 May 2010 4 min read
Robert Sheldon SQL Server APPLY Basics One of the most interesting additions to SQL Server syntax in SQL Server 2005 was the APPLY operator. It allows... 24 May 2010 12 min read
Fabiano Amorim Operator of the Week – Spools, Eager Spool For the fifth part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser, he... 20 May 2010 12 min read
Rod Colledge Reliable Storage Systems for SQL Server By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC... 12 May 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – BookMark/Key Lookup Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he... 07 May 2010 7 min read
Robert Sheldon SQL Server Common Table Expression (CTE) Basics The SQL Server common table expression was introduced into standard T-SQL to simplify queries for which a derived table just... 29 April 2010 11 min read
Rod Colledge High Performance Storage Systems for SQL Server Rod Colledge turns his pessimistic mindset to storage systems, and describes the best way to configure the storage systems of... 29 April 2010 14 min read
Phil Factor Exploring SQL Server table metadata with SSMS and TSQL Phil shows how to start squeezing powerful magic from SSMS for doing a detailed exploration of the metadata of your... 29 April 2010 21 min read
Jonathan Lewis Oracle to SQL Server: Crossing the Great Divide, Part 1 When a SQL expert moves from Oracle to SQL Server, he can spot obvious strengths and weaknesses in the product... 28 April 2010 23 min read
Fabiano Amorim Showplan Operator of the Week – Compute Scalar The third part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser continues with... 28 April 2010 6 min read
Fabiano Amorim Showplan Operator of the Week – Concatenation Fabiano continues in his mission to describe, one week at a time, all the major Showplan Operators used by SQL... 22 April 2010 3 min read
Greg Larsen Deploying Reports using the ReportingServices2005 Class and the RS Utility Much of the routine administration of Reporting Services (SSRS), such as the routine deployment of RDL reports, can be automated... 16 April 2010 17 min read
