SQL Server Magazine December 2006
[Focus]
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]
Manage user Web sessions (and minimize security risks) without cookies, using SQL Server stored procedures, a GUID generator, and URL parameters.
By Susan Perschke
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]
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]
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]
Check out new and improved SQL Server-related products.
By Blake Eno
[Tool Time with Kevin Kline]
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]
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]
This Analysis Services product is feature-rich enough for experienced business analysts yet easy for beginners to navigate.
By John Green
[Buyer's Guide]
By Sue Tibbetts
[Industry Briefings]
Our editors share insights from their conversations with Oracle and Business Objects.
By Editors
|
