SQL Server Magazine February 2008
[Focus]
This update to the original DBA Repository solution adds support for SQL Server 2005, support for SQL Server authenticated domains, support for server location, information for reports and ad-hoc queries, and an enhanced SQL Server Agent job schedule.
By Rodney Landrum
[Features]
Forget the complicated self-joins. Thanks to new Crystal Reports support in Visual Studio 2005, reporting on hierarchical data has never been easier.
By Asif Sayed
Server backup doesn’t have to be complex. With these simple commands you can perform full, transaction log or incremental, differential, and file backups. Plus you’ll learn commands for recovering files and when to do a tail-log backup.
By Pinalkumar Dave
PerformancePoint Server 2007 might be in your future, especially if your users find out about its BI features. Get the lowdown before they do about the 3 parts of PerformancePoint Server, what it needs to run, and what exactly it delivers.
By Craig Utley
[Editorial]
Find out what Michael says is missing from SQL Server 2008 and what Microsoft should include in its next release.
By Michael Otey
[Reader to Reader]
It's not uncommon for MDX programmers to create an elegant calculated member, only to discover that it's so slow that it can't be used in queries against a full data set. Learn why performance problems can occur and ways to work around those problems.
By Paul Goldy
Using SQL Server Management Studio (SSMS) to document job schedules involves a lot of mouse-clicking and cutting and pasting. You can avoid all that hassle by using the sp_ShowJobSchedules stored procedure.
By Bill McEvoy
[Inside SQL Server]
Column statistics—statistics on unindexed table columns—complement index statistics and give the optimizer additional information to use in determining the most efficient query plans.
By Kalen Delaney
[Solutions by Design]
You can manage rapidly changing monster dimensions by splitting the stable and hot attributes or by creating non-overlapping value ranges for each rapidly changing attribute.
By Michelle A. Poolet
[T-SQL Black Belt]
Under both Read Uncommitted and Read Committed isolations, updates running during an index-order scan can result in reading the same row multiple times or skipping rows.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server-related products from Acronis, Dundas, ISC, and TulaSoft.
By Editors
[SELECT TOP(X)]
YouTube.com offers many SQL Server videos—some by SQL Server Magazine authors and Microsoft executives--on topics such as performance tuning, disk optimization, backup types, and the life of a DBA.
By Michael Otey
[Tool Time with Kevin Kline]
This free tool can help you find SQL Server and MSDE installations that need to be secured.
By Kevin Kline
[Review]
If you’re running virtual machines in a production environment and are experiencing performance problems, check out DXtreme for Windows Enterprise, which can enhance your virtual machine performance.
By Michael Otey
This monitoring and management product can help you diagnose database performance problems so that you can quickly resolve them.
By John Green
|
