SQL Server Magazine

Upgrading to Hyper-V RTM

Virtualization Shootout: Hyper-V vs. ESX Server 3.5

Find out how these two virtualization products compare in architecture, performance, and price.

SQL Server Compact Edition FAQs

SQL Server Compact Edition 3.5 is Microsoft’s smallest full relational database—check out these FAQs to learn more.

Virtualizing SQL Server with VMware or Hyper-V

Tests of server virtualization products VMware ESX Server 3.5 and Windows Server 2008 Hyper-V, plus SQL Server running four virtual machines (VMs) indicate that SQL Server running in a VM is ready to handle production workloads.

SQL Server Compact Edition FAQs

Guest VM Audio Support under Hyper-V

Guest VM Audio Support under Hyper-V

What Readers Want SQL Server to Include

Take a look at which features our readers believe should be in the next version of SQL Server.

SQL Server Data Services

SQL Server Data Services is the database version of Microsoft’s Software Plus Services strategy--and it could prove helpful for data storage and access. Here are five things to know about SQL Server Data Services.

HP ProLiant DL 160

Use this HP product as a virtualization server? No, but as a Web server the 1U 64-bit HP ProLiant 160 is perfect.

SQL Server Data Services

Hyper-V Synthetic Devices

Learn about Hyper-V's synthetic and emulated devices

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.