Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


Windows IT Pro Magazine December 2006

  Current Issue: Windows IT Pro Magazine   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 | Product Reviews | Code Library


[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

Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing