SQL Server Magazine

Visual Studio 2008 and SQL Server

Visual Studio 2008 offers support for three different editions of SQL Server 2005.

Visual Studio 2008 Express Editions

Get a taste of the new Visual Studio 2008 development features by downloading one of the free Visual Studio 2005 Express products.

SQL Server Innovators Solve Business Problems with Style

Blending ingenuity and skill, the 2007 SQL Server Innovators winners include a T-SQL program that does math for a video poker game, a way to centrally maintain applications' data, a database maintenance tool, and a hospital disaster recovery system.

SQL Server Trends in 2008

Learn which Microsoft and third-party products will have the tools you need to stay on top of SQL Server development, administration, and business intelligence (BI) challenges in the coming year.

Information Integration: SSRS and MOSS 2007

SSRS and MOSS integration promises better information access and report administration, but what will you have to do to make it work? This first article of a two-part series shows you how to set up SSRS and MOSS's information-integration environment.

What Can I Accomplish with Other SharePoint Technologies?

You can achieve the best information-integration experience by using MOSS, but don’t despair if you have Windows SharePoint Services 3.0 (WSS) or MOSS Standard Edition.

The Differences Between Authentication Modes

To select the appropriate authentication mode for your MOSS Web application configuration, here’s a quick guide to the differences between the available modes.

Migrating Reporting Services to MOSS

SQL Server Migration Assistant

Do you want to move to SQL Server from Oracle, but aren't sure how difficult the data conversion and migration will be? Find out how SSMA for Oracle can help you more easily move to SQL Server.

SQL Server Reporting Services

SQL Server Reporting Services (SSRS) lets you use repository data to create customized reports about job status, database backup status, and server details.

10 Steps to SQL Server 2005 Security

Apply protection at the perimeter, network, host, application, data, and physical environment layers of your database installation.

Using the newsequentialid() GUID Function

In SQL Server 2005, you can use a new GUID function called newsequentialid() to populate your uniqueidentifer column.

SQL Server Pros Keep On Innovating

The winners of this year's SQL Server Magazine Innovators contest epitomize ingenuity, developing fresh solutions to business problems ranging from change management to scheduling overtime.

Last Rites for a Beloved Server

One of our 2006 SQL Server Magazine Innovators contest winners brought levity to his workplace by developing SQL Server Funeral Services, a procedure that lets users bid adieu to a decommissioned server.