SQL Server Magazine

		Options
SQL Server Pros: Surviving or Thriving? How does your pay stack up against your peers'? Our 2004 salary survey issue looks at where the best-paying jobs are, who has them, and what keeps you up at night. We also give you two paging solutions for any needs, share handy indexing tools, and more!		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Masters of Multitasking

The typical SQL Server pro, according to SQL Server Magazine's 2004 salary and industry survey, is a white male in the 30- to 39-year-old age range working as a DBA on the East Coast. See how you compare to this profile of survey respondents.
By Jessica Heckathorn 

SQL Server Pros: Surviving or Thriving?

SQL Server pros love their work--but their jobs can be tough to take. Survey respondents speak out about what makes them happy in their careers and the challenges they face.
By Dawn Cyr 

Who Makes What?

Find out how your pay stacks up against your peers', where the best-paying jobs are--and who has them.
By Suzanne J. Cone 

Beware: Using sp_configure to change a Value Involves DBCC FREEPROCCACHE

When you call sp_configure to set a value for any option, SQL Server issues a DBCC FREEPROCCACHE command, which invalidates all stored procedure plans currently cached and requires recompilation of new plans.
By Brian Moran 

Choosing a Secure Authentication System

Are you deciding between SQL Server Authentication and Windows Authentication? Find out which method provides better security.
By Brian Moran 

Running Profiler on a Busy Server

SQL Server Profiler is your most important tool in your SQL Server tuning arsenal. But like any powerful tool, Profiler can cause problems.
By Brian Moran 

Varying Event Durations Can Point to Compilation Problems

Generally speaking, the difference between a SQL:BatchCompleted event's duration time and a SQL:StmtCompleted event's duration time is how long each event takes to parse and compile a query.
By Brian Moran 

The 64-Bit Tidal Wave

With the advent of 32-bit-compatible x64 chips, the 64-bit computing wave is about to break. If you’re considering a SQL Server system upgrade in the next year, one of these 64-bit platforms should be on your short list.
By Michael Otey 

Digging Up the Dirt on Indexes

Use these tools to find everything you ever wanted to know about your indexes--and then some.
By Kalen Delaney 

The Search Path Less Traveled

Keyword arrays are common but hurt database performance by forcing table scans. Here's how arrays hurt and how you can help.
By Michelle A. Poolet 

Implementing Paging

When the query results are too big for one screen, you need to set up your application for paging. Take a look at these two solutions to fit any paging needs.
By Itzik Ben-Gan 

New Products, December 2004

Check out the latest SQL Server-related products.
By Dawn Cyr 

Techniques from Code Complete, Second Edition

Here are five techniques for writing better code from Steve McConnell’s new book, Code Complete, Second Edition (Microsoft Press, 2004).
By Michael Otey 

New Locking Functionality: Snapshot Concurrency Coming in SQL Server 2005

Microsoft's Richard Waymire reports that a new Yukon feature will let users read data that another user is updating.
By Microsoft's SQL Server Development Team 

Returning Only the Numeric Part of a String

Microsoft's Patrick Conlan explains techniques for stripping letters out of a string.
By Microsoft's SQL Server Development Team