Slipstream

“An introductory look at T-SQL functions” August 19, 2010.

“T-SQL subquery basics: When and how to apply them in SQL Server” July 16, 2010.

“Getting ‘trigonometric’ with T-SQL mathematical functions” June 22, 2010.

“The nuts and bolts of T-SQL aggregate functions in SQL Server 2008” May 19, 2010.

“T-SQL string functions: The ins and outs for SQL Server” April 26, 2010.

“Enter the matrix with Report Builder 3.0” March 15, 2010.

“Geospatial mapping made simple with Microsoft SQL Server” February 23, 2010.

“Adding charts to reports with Report Builder 3.0” January 26, 2010.

“Adding gauges to reports with Report Builder 3.0 for SQL Server” January 11, 2010.

“Combining result sets from multiple SQL Server queries” December 16, 2009.

“Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server” November 10, 2009.

“Working with IntelliSense in SQL Server 2008 Management Studio” September 14, 2009.

“Working with sparse columns in SQL Server 2008” June 2, 2009.

“Implementing SQL Server 2008 FILESTREAM functionality” May 25, 2009.

“Using the OPENROWSET function in SQL Server” April 16, 2009.

“Loading data files with SQL Server’s BULK INSERT statement” March 11, 2009.

“Importing and exporting bulk data with SQL Server’s bcp utility” February 18, 2009.

“Creating Windows PowerShell scripts to manage SQL Server 2008 instances” January 14, 2009.

“The sqlcmd utility in SQL Server” December 17, 2008.

“How to create a SQL inner join and outer join: Basics to get started” December 3, 2008.

“Implementing security audit in SQL Server 2008” November 11, 2008.

“New datetime data types in SQL Server 2008 offer flexibility” October 21, 2008.

“Using DATEADD and DATEDIFF to calculate SQL Server datetime values” October 7, 2008.

“Using SQL Server datetime functions GETDATE, DATENAME and DATEPART” September 11, 2008.

“SQL Server data conversions from date/time values to character types” August 11, 2008. The most viewed SQL Server tip by SearchSQLServer.com readers in 2008.

“Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005” July 29, 2008. Number 3 in the list of Top 10 most viewed SQL Server tips by SearchSQLServer.com readers in 2008.

“How to use rank function in SQL Server 2005” July 7, 2008.

“Create a computed column in SQL Server using XML data” June 16, 2008.

“Open SSIS packages without validation using these SQL properties” May 27, 2008.

“Create DDL table in SQL Server 2005 to audit DDL trigger activity” May 5, 2008.

“Retrieve XML data values with XQuery in SQL Server 2005” April 9, 2008.

“Five steps to event handlers in SQL Server Integration Services (SSIS)” March 10, 2008.

“Simplify queries with SQL Server 2005 common table expressions (CTEs)” February 13, 2008.

“Custom VB.Net scripting in SQL Server Integration Services” December 18, 2007.