SQL Server Magazine December 2006

    Options
2006 Salary Survey: What Makes YOU an Expert?
In our third annual salary survey, we highlight how database professionals like you acquire the knowledge that sets them apart from other DBAs. Find out how your skills and salary stack up against your peers for this year. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

Browse Archived Articles By: Issue | Author | Subject | Department |


[Focus]

What Makes YOU an Expert? This article is only available to registered users. Sign up now and get instant access!

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 for this year.
By Dawn Cyr 



[Features]

Cookies Crumbling?

Manage user Web sessions (and minimize security risks) without cookies, using SQL Server stored procedures, a GUID generator, and URL parameters.
By Susan Perschke 

Self-Service Subscriptions

Free yourself! Follow this five-step process for using Active Directory to implement secure, automated, user-managed Reporting Services subscriptions.
By David Pruden 



[Inside SQL Server]

Triggers and the Version Store

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 Kalen Delaney 



[T-SQL Black Belt]

Enhancing PIVOT for Crosstab Queries

Table expressions and dynamic SQL are handy tricks for making SQL Server 2005's PIVOT operator more useful in crosstab queries.
By Itzik Ben-Gan 



[New Products]

New Products This article is only available to registered users. Sign up now and get instant access!

Check out new and improved SQL Server-related products.
By Blake Eno 



[Tool Time with Kevin Kline]

Ascmd This article is only available to registered users. Sign up now and get instant access!

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 partitions and dimensions from a third-party tool.
By Kevin Kline 



[Exploring SQL Server 2005]

Data You Can Rely On

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 Matt Nunn 



[Review]

ProClarity Analytics 6.2

This Analysis Services product is feature-rich enough for experienced business analysts yet easy for beginners to navigate.
By John Green 



[Buyer's Guide]

SQL Server Middleware


By Sue Tibbetts 



[Industry Briefings]

Industry Briefings This article is only available to registered users. Sign up now and get instant access!

Our editors share insights from their conversations with Oracle and Business Objects.
By Editors