SQL Server Magazine March 2006

    Options
BI Storage Revolution
Learn how a prototype running Windows 2003 x64, SQL Server 2005 x64, 32 GB RAM, and direct-attached 7200 RPM SATA disks competes with megaservers costing ten to twenty times more. Microsoft's Rich Johnson reveals how to radically lower storage cost. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

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


[Focus]

Pare Down and Power Up

Today’s large business intelligence implementations require servers that deliver tremendous capacity and bandwidth. Check out this low-cost solution that could rock the database server market.
By Rich Johnson 



[Features]

Putting Together Your High Availability Puzzle

In SQL Server 2005, Microsoft not only added database mirroring to achieve higher availability but also substantially improved existing availability features.
By Kalen Delaney  , et al.

Zip Your Data

Add compression capabilities to SQL Server 2005 by leveraging the Common Language Runtime (CLR) and taking advantage of the new varbinary(max) data type.
By John Paul Cook  , et al.



[Lab Reports]

Tableau Software 1.5

Tired of using pivot tables to analyze and graph your data? Tableau is quick and easy to use with great features and graphing display options.
By Michael Otey 



[Editorial]

Time to Move On

There's no better time to move from VB 6.0 to VB 2005. You’ll stay ahead of the technology curve and may find new features you can’t live without.
By Michael Otey 



[Inside SQL Server]

Searching for a Trace

SQL Server 2005 includes a new default trace enabled option. Just what does this mysterious option do?
By Kalen Delaney 



[T-SQL Black Belt]

Custom Aggregations: The Cursor Technique

This four-part series about custom aggregation solutions kicks off with an evaluation of the cursor technique.
By Itzik Ben-Gan 



[New Products]

New Products, March 2006

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



[Ask Microsoft]

How Not to Use USE This article is only available to registered users. Sign up now and get instant access!

Microsoft’s Gert Drapers provides a script for retrieving table information.
By Microsoft's SQL Server Development Team 

Using the CLR with C# DLLs This article is only available to registered users. Sign up now and get instant access!

Microsoft’s Patrick Conlan explains how C# DLLs will work with the CLR in SQL Server 2005.
By Microsoft's SQL Server Development Team 

What’s a Snapshot? This article is only available to registered users. Sign up now and get instant access!

Microsoft’s Patrick Conlan gives a brief explanation of database snapshots.
By Microsoft's SQL Server Development Team 



[From the Casebook of B.I. Powers, Consulting Detective ...]

The Case of the Multitudinous Dates

A date with a fig lands B.I. Powers in an investigation of a mysterious fruit theft. Can Powers help the nutty culprit create a time dimension?
By Brian Larson 



[Exploring SQL Server 2005]

Get Out the Big Guns

Some SQL Server 2005 features could change the way you think about database systems, but these features might take some work. Take a look at some of the changes you’ll see when you use the SQLCLR and Service Broker.
By Matt Nunn 



[Vendor Briefs]

Vendor Briefs, March 2006

Our editors share insights from their conversations with NetEx, TimeSpring Software, Stone Bond Technologies, and InterCerve.
By Editors