Guest Columnist: Wayne Sheffield

Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.  Read more...

Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.  Read more...

Performance test of new SQL 2012 functions DateTimeFromParts and Format  Read more...

SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.  Read more...

A look at how the OVER clause is changing in SQL 11, based on the CTP 3 released to the public.  Read more...

Learn how to create and use templates in BIDS in this short SQL Spackle article.  Read more...

Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.  Read more...

Learn how to load data in an XML file into a table in SQL Server.  Read more...

How to set the default locations for backups, data files, and log files in SQL Server.  Read more...

A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.  Read more...

Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.  Read more...

This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.  Read more...

How to have SQL Server drive Excel spreadsheets  Read more...

This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.  Read more...

How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.  Read more...