The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
SQL Server Magazine highlights its second annual salary survey. Our editors show you results in IT pros’ compensation and job satisfaction. Find out if you’re surviving or thriving in the IT community.
By Itzik Ben-Gan
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 Kalen Delaney
Internal and external fragmentation have a fascinating, dependent relationship.
By
Microsoft's Patrick Conlan offers two ways to rotate a table in SQL Server.
Microsoft’s Gert Drapers shows how to use T-SQL to check a database’s memory usage.
By Dawn Cyr
Regardless of whether respondents felt empowered by their daily challenges or overwhelmed by them, they all acknowledged the challenges exist. Here are some of the job stresses that keep you up at night.
Despite facing ongoing gender-related challenges in their traditionally male-dominated careers, women report a high level of job satisfaction.
By Diana May
Our second annual salary survey shows you the face of the typical database professional.
This year’s survey respondents reveal what makes database pros happy, what challenges they face, and how they see IT roles changing.
By Jason Bovberg
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 Brian Moran
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.
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.
This month’s puzzle is a geometrical one. Based on a rectangle within a circle, calculate the length of the circle’s radius.
A reader highlights his favorite product: Audit DB.
By Michelle A. Poolet
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 Roman Rehak
Follow the instructions for SQL Server 2000 or for SQL Server 2005 when you install and set up the demo application and sample reports for SQL Server Reporting Services.
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.
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 Michael Otey
SQL Server 2005 makes a good showing in its first round of TPC-C testing.
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 Matt Nunn
With SQL Server 2005, some of the coolest features are available immediately, with little or no effort from you!
Check out new and improved SQL Server–related products.
advertisement