SQL Server Magazine October 2008
[Focus]
Draw upon your ADO.NET skills to start using ADOMD.NET
By William Sheldon
[Features]
Use this custom solution to check error logs in a mixed SQL Server 2005 and SQL Server 2000 environment.
By Richard Ding
Pick up 7 basic query analysis rules from Dave.
By Pinalkumar Dave
Use Business Intelligence Development Studio (BIDS) to customize package logging.
By Tyler Chessman
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 Bill McEvoy
[Editorial]
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 Michael Otey
[Reader to Reader]
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 Shaunt Khaldtiance
Use this password-cracking tool to check the complexity of the passwords being used for SQL Server database logins.
By Eli Leiba
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.
By Readers
[T-SQL Black Belt]
Learn how to handle temporal data in SQL Server queries despite limited support.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products from PROPHIX Software, AVIcode, Panorama Software, and Embarcadero Technologies.
By Editors
[SELECT TOP(X)]
Reduce the stress of performing a system restore—follow these SQL Server best practices.
By Michael Otey
[Tool Time with Kevin Kline]
Find and organize your server connections using this open-source remote connections manager.
By Kevin Kline
[Review]
See why the author gives a thumbs-up to the new version.
By Michael K. Campbell
This product can improve the performance of your SQL Server systems if they're constrained by network bandwidth.
By Michael Otey
[PTO for the Rest of Us]
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.
By Andrew J. Kelly
[Sqlmag.com Community Dialog]
Sound off about what cloud computing means for your SQL Server career and share your insights about improving database application performance.
By Anne Grubb
|
