By John Green, 09/20/2007
Want to optimize your SQL coding sessions? SoftTree Technologies offers some helpful coding features with SQL Assistant 2.5.
By Michael Otey, 09/20/2007
Connect your SQL Server system to the IBM System i and transfer data in a variety of ways, from BCP to linker servers and more, taking advantage of this relational database system ...
By Itzik Ben-Gan, 09/20/2007
In this early look at SQL Server 2008, you'll learn about the new version's implementation of grouping sets, which are useful for analyzing aggregated data.
By Karen Bemowski, 09/20/2007
The prerequisite for an efficient, high-performance database is a database design. Using one of these nine design tools will make you more productive and the resulting database ...
By Pinalkumar Dave, 09/20/2007
SQL Server often features several ways to do the same or similar tasks. To select the best technique for the job, you need to understand the differences.
By Jeff James, 09/20/2007
Check out new and improved SQL Server–related products.
By Kevin Kline, 09/20/2007
SQL Nexus is a powerful front-end visualization tool for detecting, analyzing, and troubleshooting problems on SQL Server 2005.
By Douglas McDowell, 09/20/2007
Don't build that cube! OLTP–based cubes are usually poorly designed for BI and contain dirty data. Still not convinced? There's more.
By Anne Grubb, 09/20/2007
Readers talk back to SQL Server Magazine authors, saying they're not ready for another upgrade so soon after the release SQL Server 2005.
By Karen Forster, 09/20/2007
We've redesigned SQL Server Magazine to sharpen our focus on content you want, such as business intelligence and SQL Server fundamentals, and to make it easier for you to read, ...
By Michelle A. Poolet, 09/20/2007
You just don't save significant space by normalizing hierarchies in a data warehouse.
By Readers, 09/20/2007
A reader's tests reveal that although various row-concatenation solutions produce the same results, the time it takes to get those results can vary significantly.
By Itzik Ben-Gan, 09/20/2007
Get the solution to September's puzzle "Probabilities in China," and prepare your mind for October's puzzle, which involves drunken mathematicians.
By Douglas McDowell, 09/20/2007
SSAS lets developers create OLAP cubes based on relational data models that aren't designed for BI. Does this mean you should build a cube? No, but here are some reasons why you ...
By Andrew J. Kelly, 09/20/2007
SQL Server's built-in DMV functionality offers all kinds of management potential. This month, we show you how to monitor wait stats on your SQL Server instance.
By Teo Lachev, 09/20/2007
Two approaches let you use MDX expressions to easily secure UDM data: storing security policies in a factless fact table and leveraging SSAS stored procedures to integrate UDM ...
By Michelle A. Poolet, 09/20/2007
As you plan and create your data warehouse, you'll need to decide the level of detail you want—how finely grained you want your dimensions to be—and you'll need to flatten ...
By Stacia Misner, 09/04/2007