The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Forget trial and error! Learn from the lessons of Microsoft's IT department. CIOs and VPs Ron Markezich and Stuart Scott detail SQL Server 2005 implementation, and IT Development Manager Frank Schneider shares advice for deploying Reporting Services 2005.
By Kalen Delaney
New Dynamic Management Views in SQL Server 2005 provide insight into the effects of row-level versioning.
By Blake Eno
Check out new and improved SQL Server–related products.
By Itzik Ben-Gan
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
Our editors share insights from their conversations with Embarcadero, AMD, Norb Technologies, and NEC Solutions.
By Karen Forster
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 Michael Otey
Learn what databases LINQ supports, how you'll create object mappings with LINQ, and when DLinq will be available.
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.
Learn where to download LINQ beta code.
You need to return the details of customers who made orders, which should be customers A and B, but you get back all customers—even those who made no orders. Why?
Try these productivity tips for the Visual Studio 2005 IDE and save precious development time.
Microsoft's Richard Waymire explains a truncating feature in SQL Server 2000.
In this tasty challenge, see whether you can cut this special cake so that you end up with two equally sized, frosted portions.
Microsoft's Gert Drapers provides statements for finding an individual database log file.
By Michelle A. Poolet
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.
Michael Otey reviews AVIcode's Intercept Studio 2.3, an application monitoring tool.
Microsoft's Gert Drapers and Patrick Conlan provide a couple of ways you can use SQL-DMO to check code syntax.
By Brian Larson
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 Morris Lewis
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 Brian Moran
Find out how to troubleshoot performance problems between two servers when everything seems the same but performance differs.
advertisement