SQL Server


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.

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.

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.

SQLCLR for the .NET Developer

Learn about SQLCLR, writing database objects in managed code, and configuring SQL Server to use code located within .NET assemblies.

Install SP-1 for SQL Server 2005 and Express

Microsoft posted on April 18, 2006 the RTM version of Service Pack 1 for SQL Server 2005 Developer, Workgroup, Standard, Enterprise, and Express editions. Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express.

Test Drive VB9 and DLinq

The January 2006 Language Integrated Query (LINQ) preview for the next ("Orcas") version of Visual Basic enables automating SQL Server object-relational mapping for DLinq and enhances XLinq syntax for literal XML and late binding.

Subscribe on YouTube