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 April 2005

  Current Issue: Windows IT Pro Magazine   Options
Practical Programming
Learn how to create a code library to use for many common data-access tasks, see 3 ways to win big with 64-bit, and check out a creative workaround to doing drillthrough on the fly. Also, don't miss our new Preparing for SQL Server 2005 column!
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


[Features]

Betting on 64-Bit
Although SQL Server 2000 (64-bit) has been available for 2 years, few organizations have been willing to put their money on it. Here are three scenarios that demonstrate that betting on 64-bit SQL Server can pay off--both now and in the long run.
 — Douglas McDowell


Create Your Own Code Library
ADO.NET developers often use T-SQL strings to retrieve data for applications, but poorly written strings can lead to errors. By learning a few techniques, you can provide developers with a code library to use for many common data-access tasks.
 — Rick Dobson


Drillthrough on the Fly
Drillthrough lets you look at the individual records in a cube, but you can't modify a drillthrough query on the fly. You can create a drillthrough report, then use a cell-level action to call the report and pass the parameters.
 — Craig Utley


[SQL Server Savvy]

Estimated Row Counts Affect Performance
The estimated number of row counts is incredibly important when Query Analyzer is choosing an execution plan.
 — Brian Moran


[Editorial]
Freedom to Choose
Unlike the other enterprise database vendors, Microsoft and SQL Server aren't tied to any of the popular enterprise ERP products--and that's good news for customers.
 — Michael Otey


[Inside SQL Server]

Something About Sysindexes
When you learn what information the sysindexes table has to offer, you'll be better able to work with your indexes and tables.
 — Kalen Delaney


[T-SQL Black Belt]

T-SQL Tiebreakers
Tiebreakers can make the difference between generally correct results and exactly the answer you need.
 — Itzik Ben-Gan


[New Products]
New Products, April 2005
Check out new and improved SQL Server-related products.
 — Dawn Cyr


[SELECT TOP(X)]

SQL Server Downloads
The bulk of Microsoft's SQL Server downloads aren't found on the SQL Server home page, but on the less specific downloads page. Here are the five most interesting SQL Server-related downloads available from Microsoft.
 — Michael Otey


[Preparing for SQL Server 2005]

Back to SQL Server's Future
SQL Server Senior Product Manager Matt Nunn reviews database evolution to help us understand the revolutionary nature of the new SQL Server 2005 features that make the database server an integral component of application architecture.
 — Matt Nunn


[Ask Microsoft]

Differential Backups Protect and Simplify
Microsoft's Patrick Conlan explains how differential backups fit into a reader's restore scenario.
 — Microsoft's SQL Server Development Team


SP3 Changes Debugging Functionality
Microsoft's Gert Drapers explains why a reader might be experiencing problems trying to debug T-SQL stored procedures.
 — Microsoft's SQL Server Development Team


[Hands On]

Tools Boost Confidence
A reader highlights his favorite products: Red Gate SQL Compare and SQL Data Compare.
 — Dawn Cyr

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