SQL Server Magazine December 2005
[Focus]
We like to know whether we're being compensated fairly, but how can you tell? Our annual salary survey reveals what your peers are making and correlates it with industry, region, certification, and gender.
By Jason Bovberg
This year’s survey respondents reveal what makes database pros happy, what challenges they face, and how they see IT roles changing.
By Dawn Cyr
Our second annual salary survey shows you the face of the typical database professional.
By Diana May
[Features]
Learn about long-awaited SQL Server Reporting Services, and download a demo application that shows how to easily integrate report management, viewing, and rendering into your applications.
By Roman Rehak
[SQL Server Savvy]
Don’t assume that using a SAN is always the best course. Find out how using DAS is often an easier and more cost-effective solution.
By Brian Moran
[Editorial]
SQL Server 2005 makes a good showing in its first round of TPC-C testing.
By Michael Otey
[Inside SQL Server]
SQL Server’s dynamic new sys.dm_db_index_physical_stats() function can give you information about any SQL Server 2005 object that needs physical storage. Find out how you can use this rich resource.
By Kalen Delaney
[Solutions by Design]
SQL Server 2005 won't change things much for data modelers, but make sure your CASE software supports the new database version's new features.
By Michelle A. Poolet
[T-SQL Black Belt]
Sometimes, using SQL Server's auto-numbering mechanism makes sense; in other cases, an independent sequencing mechanism is better. Learn limitations of and alternatives to IDENTITY.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Dawn Cyr
[SELECT TOP(X)]
Sharing code is one of the most common productivity techniques for developers, and MSDN has some great places to grab code bits for your programs.
By Michael Otey
[Preparing for SQL Server 2005]
With SQL Server 2005, some of the coolest features are available immediately, with little or no effort from you!
By Matt Nunn
[T-SQL 2005]
Itzik shows you T-SQL and CLR methods for checking whether a given string can be converted to an integer--handy additions to T-SQL's data-manipulation capabilities.
By Itzik Ben-Gan
[Ask Microsoft]
Microsoft's Patrick Conlan offers two ways to rotate a table in SQL Server.
By Microsoft's SQL Server Development Team
Microsoft’s Gert Drapers shows how to use T-SQL to check a database’s memory usage.
By Microsoft's SQL Server Development Team
[Hands On]
A reader highlights his favorite product: Audit DB.
By Dawn Cyr
|
