By Matt Nunn, 11/20/2006
This month Matt follows up his discussion on setting up baselines and creating a set of unit tests by explaining the steps for building a reliable set of data.
By Tyler Chessman, 11/20/2006
Are you wondering about alternatives for providing reports in a non-Windows–authenticated environment? One effective approach is the use of the Report Server Web service. Here are ...
By David Pruden, 11/20/2006
Free yourself! Follow this five-step process for using Active Directory to implement secure, automated, user-managed Reporting Services subscriptions.
By Dawn Cyr, 11/20/2006
Our annual salary survey respondents tell us how they acquire the knowledge that sets them apart from the average DBA. We also highlight how your salary stacks up with your peers ...
By Editors, 11/20/2006
Our editors share insights from their conversations with Oracle and Business Objects.
By Susan Perschke, 11/20/2006
Manage user Web sessions (and minimize security risks) without cookies, using SQL Server stored procedures, a GUID generator, and URL parameters.
By Itzik Ben-Gan, 11/20/2006
Table expressions and dynamic SQL are handy tricks for making SQL Server 2005's PIVOT operator more useful in crosstab queries.
By John Green, 11/20/2006
This Analysis Services product is feature-rich enough for experienced business analysts yet easy for beginners to navigate.
By Blake Eno, 11/20/2006
Check out new and improved SQL Server-related products.
By Sue Tibbetts, 11/20/2006
By Kevin Kline, 11/20/2006
This handy utility gives you the same kind of functionality that sqlcmd does—but for Analysis Services. Use it to perform such sticky tasks as automating the processing of ...
By Kalen Delaney, 11/20/2006
SQL Server 2005 optimizes the use of version-store data with triggers, but you'll need to watch tempdb's size when using triggers combined with snapshot isolation.
By Itzik Ben-Gan, 11/20/2006
What logic must each soldier in a platoon use to determine on which side of a row he or she belongs, depending on whether the soldier's hat has a square or circle on it?
By Sue Tibbetts, 11/20/2006
Find out how your salary compares with those of other SQL Server professionals and which factors have the most influence on compensation.
By Sue Tibbetts, 10/25/2006
Here's how we carried out the SQL Server Magazine Salary Survey.