SQL Server


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.

Using Data Integrity

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

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.

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.

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.

Introduction to Data Mining

This session introduces you to the possibilities of data mining and predictive analytics. Learn about the data mining process, what you need to know to mine your data, and the specific mining capabilities offered in SQL Server 2005.

Advancements in Data Access

Learn about new technologies that allow for more powerful, more efficient data access.

SQL Server 2005 Upgrade Advisor

Upgrade your existing SQL Server systems painlessly with expert help from Jennifer Perret.

AQtime 4.8, More

Take a look at the latest VS.NET add-ins, including a component that helps you present, select, and manage dates and times.

Say Goodbye to BBAs

Browser-based applications suck, one reader puts it simply. A properly architected and developed Win Forms application (or other smart client) can do anything a BBA can, and more.

Video From Windows Tools Launch

EDITOR'S NOTE: THESE VIDEOS ARE NO LONGER AVAILABLE.

What's New With Visual Studio 2005

S. ''Soma'' Somasegar, corporate VP of Microsoft''s Developer Division, talks about the different skews available to Visual Studio 2005 developers. Read Part 1 of this interview.

Convert C# Code

Check out the latset add-ins to Visual Studio, including a product that helps you convert C# code to C++ at the project, folder, file, and snippet levels.

Subscribe on YouTube