The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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!
By Jessica Heckathorn
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 Dawn Cyr
Female survey respondents encouraged other women to choose IT careers.
By Suzanne J. Cone
Find out how your pay stacks up against your peers', where the best-paying jobs are--and who has them.
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 Michael Otey
Here are five techniques for writing better code from Steve McConnell’s new book, Code Complete, Second Edition (Microsoft Press, 2004).
By Itzik Ben-Gan
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.
Survey respondents reveal their most pressing work problems--and confess what makes them lose sleep.
By Brian Moran
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
Microsoft's Patrick Conlan explains techniques for stripping letters out of a string.
By Michelle A. Poolet
Keyword arrays are common but hurt database performance by forcing table scans. Here's how arrays hurt and how you can help.
SQL Server Profiler is your most important tool in your SQL Server tuning arsenal. But like any powerful tool, Profiler can cause problems.
Are you deciding between SQL Server Authentication and Windows Authentication? Find out which method provides better security.
By Kalen Delaney
Use these tools to find everything you ever wanted to know about your indexes--and then some.
Check out the latest SQL Server-related products.
Microsoft's Richard Waymire reports that a new Yukon feature will let users read data that another user is updating.
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.
advertisement