The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Michael Otey
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 Blake Eno
Check out new and improved SQL Server–related products.
By Brian Larson
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 Itzik Ben-Gan
This four-part series about custom aggregation solutions kicks off with an evaluation of the cursor technique.
By Tyler Chessman
Add compression capabilities to SQL Server 2005 by leveraging the Common Language Runtime (CLR) and taking advantage of the new varbinary(max) data type.
Separate a deck of cards into two piles so that each pile contains the same number of face-up cards. Sound easy? How about if you’re blindfolded?
You try to run a SELECT query and sp_who in the same batch, but only the SELECT query returns results. Find the bug.
If you're embarking on a solution for compressing data, you'll find this compression overview helpful.
By Ron Talmage
In SQL Server 2005, Microsoft not only added database mirroring to achieve higher availability but also substantially improved existing availability features.
By Kalen Delaney
SQL Server 2005 includes a new default trace enabled option. Just what does this mysterious option do?
By Rich Johnson
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
Microsoft’s Patrick Conlan explains how C# DLLs will work with the CLR in SQL Server 2005.
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.
Microsoft’s Patrick Conlan gives a brief explanation of database snapshots.
By Matt Nunn
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.
Microsoft’s Gert Drapers provides a script for retrieving table information.
Our editors share insights from their conversations with NetEx, TimeSpring Software, Stone Bond Technologies, and InterCerve.
advertisement