SQL Server Magazine

		Options
SQL Server Magazine’s 2005 Innovator Award Winners! Tried and true. The results are in for the 2005 Innovator Awards! Discover how our three winners used their skill and creativity to produce solutions for overwhelming IT problems. Get inspired by these pros to create, originate, and innovate.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Meet the Innovators!

The right mix of technical skill, creativity, and common sense produced three winning solutions in the 2005 SQL Server Magazine Innovators Awards. Read about them here.
By Dawn Cyr  , et al.

Creating UDFs in SQL Server 2005

Take advantage of SQL Server 2005's new ability to use classes written in .NET languages.
By Thiru Thangarathinam 

Reporting Services and Multivalued Parameters

SQL Server 2005 Reporting Services makes it easy to use multivalued parameters in embedded queries, but using these parameters in stored procedures requires a little more effort.
By Rodney Landrum 

SQL Server on a SAN

Get a handle on SAN fundamentals and learn more about how SANs can boost SQL Server database performance and improve database backups and restores.
By Mel Shum 

Red Gate Software SQL Data Compare 3.4

This companion product to SQL Compare can synchronize the data in two databases and simplify database development.
By Michael Otey 

LINQ—The Missing Piece of Database Development

Microsoft's new Language Integrated Query technology lets programmers use new query extensions to the .NET Framework to access database and XML data sources.
By Michael Otey 

Handy CLR Functions That You Can Call from T-SQL Code

Here are 17 string-manipulation functions written in Visual Basic, Visual C#, and Visual C++ that you can call from T-SQL code.
By Readers 

Get REORGANIZEd

SQL Server 2005 gives new options for cleaning up clutter.
By Kalen Delaney 

Analyzing Patterns in a Sequence

Recursive common table expressions (CTEs) in SQL Server 2005 let you analyze patterns in a sequence much faster than using cursors or set-based techniques. Learn about recursive CTEs by analyzing patterns in our DNA sequencing example.
By Itzik Ben-Gan 

New Products, January 2006

Check out new and improved SQL Server–related products.
By Dawn Cyr 

Just a Spoonful of Sugar...

Many of SQL Server’s new features aren’t automatic, but require some effort on your part to work. Here are some that deliver great benefits with only the smallest effort.
By Matt Nunn 

The Case of the Out-of-Date Cube

B.I. Powers turns up an OLAP cube that's dragging a company into the past. Is SQL Server 2005 behind the latency? Can Powers find a simple solution?
By Brian Larson 

Vendor Briefs, January 2006

Our editors share insights from their conversations with Idera, Stratus Technologies, Identify, and Revivio
By Editors