SQL Server Magazine February 2006
[Focus]
An informal chat with some Microsoft executives (namely, Ron Markezich, Stuart Scott, and Frank Schneider) for an inside look at deploying and using Reporting Services 2005.
By Karen Forster
[Features]
The beta release of Microsoft’s new LINQ technology gives you a glimpse at the future of development. Michael Otey takes a look at how the technology works with SQL Server and shows you what you can expect.
By Michael Otey
Table and database-file fragmentation are performance-killers that require ongoing vigilance to keep them in check. Learn about one DBA's creative methods for troubleshooting and fixing these problems.
By Morris Lewis
[Lab Reports]
Michael Otey reviews AVIcode's Intercept Studio 2.3, an application monitoring tool.
By Michael Otey
[SQL Server Savvy]
Find out how to troubleshoot performance problems between two servers when everything seems the same but performance differs.
By Brian Moran
[Inside SQL Server]
New Dynamic Management Views in SQL Server 2005 provide insight into the effects of row-level versioning.
By Kalen Delaney
[Solutions by Design]
Michelle Poolet explores recent proposals promoting all-in-one lookup tables and how that design stacks up to the more traditional approach of using multiple tables.
By Michelle A. Poolet
[T-SQL Black Belt]
SQL Server’s DATEDIFF() function doesn’t make it easy to correctly calculate differences between two datetime values. See how to work around this challenging problem and how to encapsulate the logic in a handy function.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Blake Eno
[SELECT TOP(X)]
Try these productivity tips for the Visual Studio 2005 IDE and save precious development time.
By Michael Otey
[Ask Microsoft]
Microsoft's Richard Waymire explains a truncating feature in SQL Server 2000.
By Microsoft's SQL Server Development Team
Microsoft's Gert Drapers provides statements for finding an individual database log file.
By Microsoft's SQL Server Development Team
Microsoft's Gert Drapers and Patrick Conlan provide a couple of ways you can use SQL-DMO to check code syntax.
By Microsoft's SQL Server Development Team
[From the Casebook of B.I. Powers, Consulting Detective ...]
Mysterious security-log entries put B.I. Powers on the trail of a time traveler. Can Reporting Services’ history snapshots save the culprit from performing unnecessary work?
By Brian Larson
[Vendor Briefs]
Our editors share insights from their conversations with Embarcadero, AMD, Norb Technologies, and NEC Solutions.
By Editors
|
