Gail Shaw Finding the Causes of Poor Performance in SQL Server, Part 1 To tackle performance problems with applications, you first find the queries that constitute a typical workload, using SQL Profiler: Then,... 09 March 2009 13 min read
Richard Morris Gail Shaw: Geek of the Week Gail Shaw, the fabled 'gilamonster', earned her MVP, and the gratitude of a great number of SQL Server professional seeking... 09 March 2009 12 min read
Richard Morris Simon Sabin Says SQLBits SQLBits is the largest SQL Server conference in Europe. Because it is held on a Saturday, and is free, it... 03 March 2009 9 min read
Alex Kuznetsov Brain Teaser for Pi Day Alex has come up with a great idea for Pi Day. We should celebrate by trying to come up with... 02 March 2009 2 min read
Dan McClain How to Get Management Buy-In for Software purchases There is a good chance that the process of purchasing software or hardware in your organization involves several people. DBAs... 02 March 2009 15 min read
Grant Fritchey Understanding More Complex Query Plans In order to be able to tackle performance issues in SQL Server , and write effective SQL, it is essential... 26 February 2009 30 min read
Gayani Devapriya Designing A Data Access Layer in LINQ to SQL Gayani provides the complete source code for a sample Data Access Layer for LINQ to SQL, using the Northwind Database,... 21 February 2009 13 min read
Joe Celko Divided We Stand: The SQL of Relational Division Businesses often require reports that require more than the classic set operators. Surprisingly, a business requirement can often be expressed... 17 February 2009 17 min read
Allen White Let PowerShell do an Inventory of your Servers If you run a regular and comprehensive inventory of all the servers you manage, you can solve problems more quickly... 13 February 2009 15 min read
András Belokosztolszki Removing Duplicates from a Table in SQL Server Sometimes, in SQL, it is the routine operations that turn out to be the trickiest for a DBA or developer.... 11 February 2009 13 min read
Brad McGehee How to Identify Slow Running Queries with SQL Profiler With SQL Server Profiler, it is easy to discover all those queries that are running slowly. Once poorly performing queries... 03 February 2009 40 min read
Phil Factor Phrenetic Phil and the SQL Shootout Phil Factor turns to burlesque in order to reinforce his point that an ability to answer SQL Technical questions isn't... 03 February 2009 7 min read
Robert Sheldon Full-Text Indexing Workbench Robert Sheldon continues his guide to Full-Text Indexing, by putting down his pen and reaching for SSMS for a practical... 02 February 2009 11 min read
Brad McGehee Mastering SQL Server Profiler Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool...… 30 January 2009 2 min read
Phil Factor The TSQL of Text Files Phil returns to the old subject of 'Getting text-based data in and out of SQL Server'. He shows various easy... 19 January 2009 15 min read
Joe Celko Temporal Data Techniques in SQL In the first part of this series on Temporal Data, Joe explained how it is that the Common Era calendar... 18 January 2009 12 min read
Alex Kozak Estimating Disk Space Requirements for Databases In the first of a series of Database Maintenance Tips and Tricks, Alex Kozak discusses some general issues surrounding disk... 16 January 2009 16 min read
Roger Hart Good Wow / Bad Wow – The SQL Compare Development Process Roger points out the difference between a good 'Wow!' and a bad 'Wow!', when uttered by users trying to find... 13 January 2009 4 min read
Robert Sheldon Understanding Full-Text Indexing in SQL Server Microsoft has quietly been improving full-text indexing in SQL Server. It is time to take a good look at what... 29 December 2008 19 min read
Brad McGehee SQL Server 2008: Performance Data Collector With Performance Data Collector in SQL Server 2008, you can now store performance data from a number of SQL Servers... 29 December 2008 12 min read
