|
|
||||||||||||||||||||||||||
Windows IT Pro Magazine December 2006
[Focus] What Makes YOU an Expert? 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. — 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. — 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. — 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. — 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. — Itzik Ben-Gan [New Products] New Products Check out new and improved SQL Server-related products. — Blake Eno [Tool Time with Kevin Kline] Ascmd 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. — 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. — 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. — John Green [Buyer's Guide] SQL Server Middleware — Sue Tibbetts [Industry Briefings] Industry Briefings Our editors share insights from their conversations with Oracle and Business Objects. — Editors |
|||||||||||