T-SQL Programming Solomon Rutzky in T-SQL Programming CLR Performance Testing Are Common Language Runtime routines in SQL Server faster or slower than the equivalent TSQL code? How would you go... 21 July 2011 19 min read
Database Administration Glenn Berry in Database Administration Configuring the Storage Subsystem The storage subsystem for a SQL Server can prove to be a bottleneck if the best choices of hardware aren't... 20 July 2011 42 min read
Learn SQL Server Chris Shaw in Learn SQL Server Building Your DBA Skillset As a DBA and hiring manager, Chris Shaw has been on those sides of the recruitement process. As an MVP... 06 July 2011 23 min read
Laerte Junior PowerShell Eventing and SQL Server Restores When you're managing a large number of servers, it makes no sense to run maintenance tasks one at a time,... 05 July 2011 13 min read
Fabiano Amorim Questions about SQL Server Distribution Statistics Fabiano was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current... 23 June 2011 20 min read
Robert Sheldon Table Value Constructors in SQL Server 2008 Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. This... 22 June 2011 11 min read
Andrew Clarke SSMS: The Query Window Keyboard Shortcuts Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations... 10 June 2011 5 min read
Robert Sheldon Subqueries in SQL Server Subqueries and derived tables can add great versatility to SQL statements, cut down complexity, but can occasionally be a curse... 26 May 2011 16 min read
Grant Fritchey SQL Server Backup and Restore for the Accidental DBA Not everyone who is tasked with the job of ensuring that databases are backed up, and easily restorable, consider themselves... 24 May 2011 15 min read
Phil Factor PATINDEX Workbench The PATINDEX function of SQL Server packs powerful magic, but it is easy to get it wrong. Phil Factor returns... 12 May 2011 14 min read
Joe Celko TIME Gentlemen please! The SQL Server temporal datatypes If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to... 12 May 2011 12 min read
Bert Jan van der Steeg Database Management for SharePoint 2010 With each revision, SharePoint becomes more a SQL Server Database application, with everything that implies for planning and deployment. There... 10 May 2011 13 min read
David Berry Performance Implications of Parameterized Queries Why don't we emphasize the huge advantages of parameterized queries over ad-hoc queries in SQL Server? There is a severe... 28 April 2011 19 min read
Phil Factor Import HTML Data into SQL Server with PowerShell: HTML Agility Pack and DataTable Approach Scrape HTML tables, lists, and unstructured content into SQL Server using PowerShell and the HTML Agility Pack (HAP). Covers reading... 30 March 2011 22 min read
Robert Sheldon Using SQL Server Integration Services to Bulk Load Data The most flexible way to bulk-load data into SQL Server is to use SSIS. It can also be the fastest,... 29 March 2011 15 min read
Hugo Shebbeare The Polyglot of Databases: How Knowledge of MySQL and Oracle Can Give SQL Server DBAs an Advantage Although switching between different RDBMSs can be the cause of some culture shock for the Database Administrator, it can have... 14 March 2011 16 min read
Feodor Georgiev SQL Server Default Trace: Auditing Guide with Scripts Complete guide to the SQL Server default trace. Covers database events, security auditing, object changes, and error tracking with ready-to-use... 14 March 2011 18 min read
Fabiano Amorim Lipoaspiration in your SQL Server Database Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now... 03 March 2011 13 min read
Paul White Understanding and Using Parallelism in SQL Server SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and... 03 March 2011 22 min read
Joe Celko SQL Server CASE Law SQLs CASE expressions can be powerful magic, but can trap the unwary who are used to the more familiar CASE... 03 March 2011 11 min read
