SQL Server Magazine

Get a free copy of the new Quest DMV Poster!

Find out about a popular free SQL Server DMV poster and the accompanying webcast.

What Makes a Useful Poster?

Kevin wonders what would motivate a SQL Server professional to put a poster up on their cube or office wall.

New and Useful White Papers

Kevin points out three new and useful white papers on security, Oracle interoperability, and running SQL2008 on Windows 2008.

Great Giveaways in SQLMag and at TechEd 2008

Kevin tells you about some freebies and free software given away in the magazine and at the conference.

SQL Server Internals Viewer

Use the four main interfaces provided by this free tool to see how SQL Server stores data.

WHY ISN'T AUTO_UPDATE STATISTICS RUNNING?

Kevin points to some reasons why this important preventative maintenance process might not be running when you think it should.

SOS_SCHEDULER_YIELD

Kevin describes an unusual load condition and how to troubleshoot it.

MIRRORING THROTTLES BACKLOG

Kevin discusses how mirroring can impact a SQL Server's workload backlog.

SSMS Tools Pack: 6 Tools That Help You Do More with SSMS

The SSMS Tools Pack provides features, such as a query logging tool, that enhance SQL Server Management Studio’s functionality.

NUMA AND TCP PORT AFFINITY

Kevin describes confusing information on the TPC site describing how SQL Server works with NUMA.

Implementing a Hash Partition on SQL Server 2005

Kevin gives a tip about writing a hash function that serves as the backbone for hashed partition.

NASTY RUMORS ABOUT MAXDOP

The Publishing Industry Takes Another Hit

March Omnibus

Kevin discusses a number of websites and blogs he's been scanning for good tips.

March Omnibus

Speaking in London in early March

SQLQueryStress

You can use this tool to quickly and easily test how a query will affect your system performance.

What's Exciting about SQL Server 2008?

Kevin has released a new white paper about his favorite features in SQL Server 2008.

SQLPing

This free tool can help you find SQL Server and MSDE installations that need to be secured.

SQL Server SWAG Smackdown

Kevin's been in the SQL Server business for a long time and accumulated a LOT of swag over the years. Have you got more?