SQL Server


It's All in the Cache

There are advantages and disadvantages to today's application-tier caching techniques. Consider your data caching options for improving data-intensive application performance.

Download Hotfix for Latest SQL Service Pack

Less than a month after shipping SP2 for SQL Server 2005, Microsoft issues a hotfix to prevent maintenance plan cleanup tasks from removing data before the specified cleanup interval.

Get Yer Hot New Downloads

There's too much going on in the Visual Studio space for any one developer to keep track of it all?so we're going to do it for you. New downloads available include Visual Studio SP1 and the latest Orcas CTP.

Service Pack 2 for SQL Server 2005 Fixes Bugs, Adds Features

Microsoft plans to ship service pack 2 (SP2) of its SQL Server 2005 database this quarter.

Sharp Words with Microsoft's Erik Meijer

The architect for the Microsoft SQL Server Group is interviewed about the various research Sharp languages and their impact on future software development and programming.

Microsoft Ships SQL Server 2005 SP2

SP2 provides support for Windows Vista and Office 2007, while also offering new data compression, business intelligence, and security capabilities.

The Rich Web Experience -- And Beyond

Scott Guthrie recently sat with VSM to discuss Microsoft's ASP.NET AJAX and the status of other Web-related projects.

OLAP App Dev With ADO MD.NET: An API Smorgasbord

Discover an array of OLAP APIs for developing top-notch dedicated OLAP applications.

SQL Server Integration Services: Patterns and Practices for the Real World

Learn how you can apply Integration Services to the ETL paradigm in your business.

Save Time With LINQ Queries

See how the LINQ syntax, specifically DLinq and XLinq, can increase your productivity and reduce the possibility for error.

SQL Server 2005 Mobile Edition Goes Everywhere

A forthcoming Win32 upgrade to SSM joins SSE with SSX and Jet in Microsoft's new triumvirate of freely distributable database engines.

What''s So Good About SQL Server 2005 OLAP?

Understand the business imperative for SQL Server 2005''s new OLAP capabilities as well as how to implement them.

VSLive! FL 2007: Reporting Innovations in SQL Server and Visual Studio 2005

Check out the new reporting tools in SQL Server 2005 and Visual Studio 2005.

Tricks for Processing SQL Scripts

Discover how SQL Server 2005's SQLCMD tool can enhance your scripting processes.

Report Builder: An Approach to Consuming Cubes and Relational Data

With SQL Server 2005''s Report Builder, users have the ability to consume both multidimensional and relational data.

Integrate XML Into Your Reporting Environment

You'll find several areas of interest regarding XML usage in SQL Server Reporting Services.

Secure Your Data With SQL Server

Learn how defining levels of database access, for both nonsensitive and sensitive data, can help protect you from system failure.

Using Data Integrity

Ensure that your data is accurate, and find undetectable bugs in your applications with SQL Server's Data Integrity feature.

Database Dev a Cinch With DDL

Database Definition Language (DDL) makes maintaining changes between your databases easier.

SQL Server Resources

Check out these publications, tools, SDKs, and community sites for additional information about SQL Server.

Subscribe on YouTube