The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Handle complex queries and retrieve multi-dimensional data with the new ADOMD.NET. You can quickly integrate these queries into your custom applications.
By Shaunt Khaldtiance
Here's a T-SQL stored procedure that you can use to identify tables without indexes, indexes that aren't being used, and indexes that aren't being used efficiently.
By
Check out new and improved SQL Server–related products from PROPHIX Software, AVIcode, Panorama Software, and Embarcadero Technologies.
By Tyler Chessman
Use Business Intelligence Development Studio (BIDS) to customize package logging.
By Eli Leiba
Use this password-cracking tool to check the complexity of the passwords being used for SQL Server database logins.
By Michael Otey
This product can improve the performance of your SQL Server systems if they're constrained by network bandwidth.
By Anne Grubb
Sound off about what cloud computing means for your SQL Server career and share your insights about improving database application performance.
By Andrew J. Kelly
In creating a server-side trace, your goal is to capture the events you're interested in and store them in on a locally attached disk on the server. Use these T-SQL commands to accomplish that goal.
Reduce the stress of performing a system restore—follow these SQL Server best practices.
How can you help your organization choose the edition of SQL Server 2008 it needs? Michael Otey takes a quick tour through the options that are available.
By Pinalkumar Dave
Pick up 7 basic query analysis rules from Dave.
By Kevin Kline
Find and organize your server connections using this open-source remote connections manager.
By Bill McEvoy
T-SQL offers three types of built-in functions, including scalar functions. Scalar functions let you perform a wide variety of operations, such as retrieving dates and replacing strings, with only a few lines of code.
By William Sheldon
Draw upon your ADO.NET skills to start using ADOMD.NET
Take advantage of your T-SQL skills to learn MDX query basics.
By Itzik Ben-Gan
Learn how to handle temporal data in SQL Server queries despite limited support.
See how to build an MDX query against a cube.
By Michael K. Campbell
See why the author gives a thumbs-up to the new version.
By Richard Ding
Use this custom solution to check error logs in a mixed SQL Server 2005 and SQL Server 2000 environment.
You can use the TOP clause to limit the transaction size, but there's a trick to using it: You need to keep track of which rows have already been updated so that you don’t update them a second time. Here's how to keep track of the rows.
advertisement