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