SQL Server Magazine

Express Essentials: The Finished Report

Michael Otey wraps up the SQL Server Express Reporting Services report he's worked on in his series of articles and shows how to deploy it.

Jump Start: SET NOCOUNT ON

Disabling the SQL Server row-count feature can help optimize T-SQL stored procedures and batches.

Check It Out: Making IT Work

Check out Michael Otey's new blog for tips about working with Windows, Microsoft SQL Server Express, and more.

Welcome to Making IT Work

Welcome to Michael Otey's new blog, where he covers not only SQL Server Express and T-SQL, but Windows Server 2008, Vista, Hyper-V, VMware ESX Server, and more.

What If You Had a Benchmark and Nobody Came?

Michael looks at some of SQL Server 2008's benchmark scores and discusses why the TPC-E benchmark currently isn't useful for comparing database platforms.

SQL Server 2005 Client Network Libraries

Client network libraries are vital in SQL Server, enabling the communications link between client applications and the SQL Server system. This list will help you get acquainted with SQL Server 2005’s client network libraries.

Express Essentials: Using the Report Design Layout Tab

Report Designer is pretty good at generating a layout based on the data you select, it doesn't automatically update that layout when you change the data. You need to manually update the layout. Here's how.

Jump Start: Tracking Transactions

Michael Otey responds to reader questions about how transactions work, when and where the data is written, and whether the data is put into the database before the transaction is committed.

Check It Out: SQL Server Compact 3.5

Writing apps for a mobile device or Smartphone? Check out this small database that runs on Windows Mobile devices.

Jump Start: Tracking Transactions

Express Essentials: Using Report Designer's Data Tab

Reporting Services sets SQL Server Express apart from other "lite" database products. Michael Otey continues his Reporting Services tutorial by explaining how to remove unnecessary columns from a report.

Jump Start: Using Transactions

Transactions are essential for complex systems that update multiple related tables. Rolling back a transaction rolls back the entire group of updates, and that just might save your bacon if you encounter an error.

Check It Out: Windows Vista SP1

Are you running Windows Vista? If so, you'll want to check out the improvements that SP1 provides.

Jump Start: Using Transactions

SQL Server 2008 Webcasts

While SQL Server Magazine can give you info on SQL Server 2008, Microsoft's Webcasts also assist. Here are some links to our favs.

The Next Generation: Visual Studio 2008

Take a tour of the new features and functionality in Visual Studio 2008.

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.

MySQL: Sun's Billion Dollar Baby

Find out how Sun Technologies' acquisition of MySQL means for the database market.

MySQL: Sun's Billion Dollar Baby