Slipstream

“SQL Server 2012 release approaches — what you need to know” February 2012.

“Three tips for a better SQL Azure migration” February 2012.

“Keep cloud, on-premises data square with SQL Azure Data Sync” February 2012.

“Map data flow from Microsoft PowerPivot to Excel, SharePoint” February 2012.

“DAX formulas expand BI’s reach in PowerPivot” January 2012.

“Take BI up a notch with SQL Azure Reporting” December 2011.

“SQL Server-Hadoop highway to ‘big data’ ventures into new territory” November 2011.

“New to SQL Server PDW? First, tinker with client tools” November 2011.

“Before migrating from an open source RDBMS, do your homework” October 2011

“Microsoft retooling SQL Server Master Data Services after ‘vexing’ debut” October 2011.

“Top five features in SQL Server Developer Tools” September 2011.

“Putting the data to work: how to create a chart in PowerPivot” May 2011.

“Importing SQL Server data into PowerPivot for Excel” May 2011.

“Getting the most out of SQL Server information schema views” May 2011.

“Finally, development across platforms in Microsoft Visual Studio 2010” April 2011.

“Moving beyond SSIS: 5 third-party SQL Server tools for ETL” March 2011.

“Gain insight with SQL Server dynamic management views” February 3, 2011.

“Putting SQL Server catalog views to work” January 20, 2011.

“Working with SQL Server configuration functions” October 28, 2010.

“Exploring T-SQL metadata functions in SQL Server 2008” September 20, 2010.

“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. One of the top 10 SQL Server tips viewed by SearchSQLServer.com readers in 2009.

“Using the OPENROWSET function in SQL Server” April 16, 2009. One of the top 10 SQL Server tips viewed by SearchSQLServer.com readers in 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. The most viewed SQL Server tip by SearchSQLServer.com readers in 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.