SQL Server Magazine

Microsoft Hosting Solutions Built to Your Needs

Sponsored Link
Rackspace is the expert when it comes to delivering hosting solutions. From building out Windows servers and highly complex configurations to managing and supporting network environments, mail solutions, storage, data backups and far more. We are here for you 24x7x365.

SQL Server Connections Audiocasts Now on ITTV.net!

SQL Server Magazine editor Sheila Molnar talks to SQL Server industry experts about green computing with SQL Server, Windows Azure and SQL Server Services, Visual Studio 2010 and Azure, and more topics. See the full list of audiocasts and videos from the Fall 2008 Connections Conferences at ittv.net!

Microsoft BI Unleashed - Free Online Conference

Learn when, where, and how to implement the BI features your systems already hold. Discover how you can enable enterprise BI on the Microsoft SQL Server BI stack. Register today and attend on Dec. 17th for your free, yet valuable BI training.

January 14, 2009

SQL Server Freebies at Microsoft's CodePlex Site

Microsoft’s AdventureWorks series of sample SQL Server databases is now available at its open-source website CodePlex—which is where you can find these 7 great downloads, plus more tools and utilities.

By Michael Otey

January 13, 2009

SQL Server Magazine is 10 Years Old!

SQL Server Magazine launched in the SQL Server 7.0 timeframe. In 1998 SQL Server was a distant third in the enterprise database market and was regarded as a small-scale departmental database; easy to use but not enterprise-ready. How things have changed.

By Michael Otey

January 2009

Handling Arrays as Inputs

Learn how to use a T-SQL split function to handle arrays as inputs for SQL Server stored procedures.

By Itzik Ben-Gan

January 2009

SQL Server 2008 (and Earlier) Build Versions

Your SQL Server build versions can affect whether you should perform an upgrade or a new installation—learn how to find your SQL Server version number and whether an upgrade is in your future.

By Michael Otey

December 22, 2008

Ready? Set? Kilimanjaro!

The pre-beta announcement of the business intelligence (BI) focused interim release of SQL Server, code-named Kilimanjaro, has Michael Otey concerned that Microsoft marketing might be jumping the gun and creating confusion for enterprise IT departments.

By Michael Otey

December 18, 2008

Handling Arrays

One way to use arrays as input for stored procedures is to employ dynamic SQL.

By Itzik Ben-Gan

December 2008

Top 20 SQL Server 2008 Enterprise Edition–Only Features

Not all SQL Server 2008 editions are created equal—check out 20 cool features that are found only in SQL Server 2008 Enterprise Edition.

By Michael Otey

December 2008

Up in the Air over Cloud Computing

Do you want to run SQL Server and other mission-critical applications from the cloud?

By Michael Otey

November 2008

Browser Wars Redux

The Google Chrome browser presents a challenge both Microsoft Internet Explorer (IE) and to SQL Server web application development.

By Michael Otey

BlogsGo to the Blogs Index Page

SQL Server BI

Extending Integration Services Capabilities with Premier 3rd Party Products

Two 3rd Party SSIS vendors that have delivered substantial additional value.

Comment on the blog Read this blog

Industry Bytes

Are SQL Server 2008’s T-SQL and Data Type Enhancements Compelling Enough to Migrate?

Unsure whether you should migrate to SQL Server 2008 for its T-SQL and data type functionality? Check out these resources, which offer you insight into the T-SQL and data type improvements in SQL Server 2008, and decide for yourself.

Comment on the blog Read this blog