SQL Server Magazine March 2007
[Focus]
For the many shops still using SQL Server 2000, this extensible, data-driven utility can cure a wealth of date-formatting headaches.
By Susan Perschke
[Features]
Sometimes you need creative solutions to Reporting Services’ limitations when working with Analysis Services. Here’s a three-part fix that uses in-the-box features to create a solution that resides entirely in the report presentation layer.
By Paul Goldy
Many options exist for delivering BI data to end users. Here are some important considerations to keep in mind as you choose the delivery tools for the various users you serve.
By Craig Utley
Certain discrepancies between SQL Server's physical processing of queries and ANSI SQL's logical query-processing order could impede queries—but you can use workarounds to avoid such failures.
By Itzik Ben-Gan
[Editorial]
In the development world, many powerful forces work to push out software before it's ready, but waiting to release complete, well-tested software is really best for both the customer and the developer.
By Michael Otey
[Reader to Reader]
The showViolatingRows procedure automates the tedious task of finding rows that violate check and foreign-key constraints.
By Eli Leiba
The sp_ListTriggers stored procedure lets you list all the triggers in the current database or the triggers in a specific table.
By Bill McEvoy
[Inside SQL Server]
Investigate the metadata that SQL Server 2005 dynamic management objects provides about missing indexes and use that information to improve query performance.
By Kalen Delaney
[Solutions by Design]
Wouldn’t it be wonderful to create a graphic representation of your business rules? A Fact Model approach can help database pros extend their thinking about data beyond the boundaries of traditional data modeling.
By Michelle A. Poolet
[T-SQL Black Belt]
This second part of a series about datetime challenges and calculations focuses on techniques for calculating a certain period's start and end datetime values and calculating a language-independent weekday.
By Itzik Ben-Gan
[Letters]
By Editors
[New Products]
Check out new and improved SQL Server-related products.
By Blake Eno
[SELECT TOP(X)]
Got SQL Server connection problems? Keep in mind these 7 symptoms and solutions to speed up the troubleshooting process.
By Michael Otey
[Tool Time with Kevin Kline]
A reader question about the ascmd utility gets a response directly from Microsoft--and invites your input.
By Kevin Kline
SQLdiag, a native diagnostics-collection tool in SQL Server 2005, has some cool undocumented features.
By Kevin Kline
[Review]
If you need to manage jobs across multiple servers or on both the SQL Server and Oracle platforms. Event Manager for SQL Server can be an essential tool.
By Michael Otey
[Buyer's Guide]
If you're currently seeking out a database backup and recovery solution for the first time, or simply want to make a change to your current solution, take a gander at the list of solutions in this buyer's guide.
By Blake Eno
[Industry Briefings]
Senior Editor Dawn Cyr shares insights from her conversations with Heroix, Network Applications, Inc., and Texas Memory Systems.
By Editors
|
