Developer Product Briefs
SQL Server Resources
Check out these publications, tools, SDKs, and community sites for additional information about SQL Server.
SQL Server Resources
Check out these publications, tools, SDKs, and community sites for additional information about SQL Server.
May 1, 2006
SQL Server
Download SQL Server 2005 SP1 for all editions except SQL Express (SSX) in x86, x64, or ia64 versions
Download Microsoft Core XML Services (MSXML) 6.0 for SSMSE
Download SQL Server 2005 Books Online (April 2006)
Download SQL Server 2005 Samples and Sample Databases (April 2006)
Download Northwind and pubs Sample Databases for SQL Server (optional)
Download SQL Server 2005 Report Packs
Read the "Using SQL Server 2005 Reporting Services with SAP NetWeaver Business Intelligence" technical paper
Read Microsoft's April 19, 2006 SQL Server SP1 and Visual Studio Express press releases
Read the technical article, "Add Reports and Charts to Web Pages" by Roger Jennings (Visual Studio Magazine, March 2006)
Read the technical article, "Build Client-Side Reports Easily" by Roger Jennings (Visual Studio Magazine, November 2005)
Read the technical article, "Manage Data With VS 2005" by Roger Jennings (Visual Studio Magazine, November 2005)
Read the technical article, "Create Interoperable Native Web Services" by Roger Jennings (Visual Studio Magazine, August 2005)
Read the technical article, "Take Advantage of New T-SQL Features" by Roger Jennings (Visual Studio Magazine, July 2005)
Read the technical article, "Encrypt and Decrypt Data in Yukon" by Roger Jennings (Visual Studio Magazine, June 2005)
Read the technical article, "Exploit Yukon's XML Data Type" by Roger Jennings (Visual Studio Magazine, April 2005)
Read the technical article, "Get Ready for SQL Server 2005" by Roger Jennings (Visual Studio Magazine, August 2004)
Visit the SQL Server Development Center on MSDN
Visit SQL Server Central
Visit the SQL Server Worldwide User Group
SQL Server Express Edition
Download SQL Express with SP1 for x86, x64, or EMT64 systems
Download SQL Server 2005 Express Edition with Advanced Services (includes SSMSE, MSXML 6.0, Reporting Services (SSRS), and full-text search)
Download SQL Server 2005 Express Edition Toolkit (includes SSMSE and Business Intelligence Development Studio (BIDS) for Reporting Services projects)
Download SQL Server Management Studio Express (SSMSE) for x86, x64, or EMT64 systems
Download Starter Kits for SQL Server 2005 Express
Review the SQL Server Express Edition Comparison page to determine which update file(s) to download
Read Managing SQL Server Express with SQL Server 2005 Management Studio Express Edition (March 2006 white paper)
Read "Migrate to SQL Server 2005 Express Edition" by Roger Jennings (Visual Studio Magazine, May 2005)
SQL Server Everywhere Edition
Get information about SQL Server Everywhere from Steve Lasker's blog
Read the "SQL Server 2005 Update from Paul Flessner," April 6, 2006
SQLCLR, CLR Integration
See the overview of CLR Integration on MSDN
Visit the CLR Integration Team Blog
Read "What's New With VS and Data" by Roger Jennings
Read "When To Use SQLCLR, And When Not To" by Roger Jennings
Language Integrated Query (LINQ)
Read "Test Drive VB9 and DLinq" by Roger Jennings
Read "Streamline Mapping With Orcas and LINQ" by Roger Jennings
Read "Cure Data Type 'Impedance Mismatch' With LINQ" by Roger Jennings
Read about LINQ on MSDN: Home page, and project overview
See the LINQ FAQ by Keith J. Farmer
Connecting Through JDBC
Microsoft .NET Framework Version 2.0 Redistributable Package (x86)
Microsoft .NET Framework Version 2.0 Redistributable Package (x64)
Microsoft SQL Server 2005 Express Edition
Microsoft SQL Server 2005 Express Edition Overview
Microsoft SQL Server 2005 JDBC Driver
Windows Installer 3.1 Redistributable (version 2)
About the Author
Written/compiled by the editors of Visual Studio Magazine.