By Michael Otey, 03/22/2006
Instead of migration, I've decided to cover one of the fastest growing trends in the IT industry: the rising tide of complexity.
By Brian Moran, 03/22/2006
There's variance in how the Enhanced Read-ahead and Scan option works on the SQL Server 2005 Standard and Enterprise Editions, which can result in performance differences.
By Richard Pless, 03/22/2006
Microsoft Visual SourceSafe is a great tool to use to centrally manage file version control. It also helps to simplify common tasks such as code reviews, project management, ...
By Michelle A. Poolet, 03/22/2006
Data modeling lets you optimize database performance, share your schema, and archive and track database changes. But often, this important basic design step is left out. See how ...
By Microsoft's SQL Server Development Team, 03/22/2006
Microsoft’s Gert Drapers explains how to execute statements in the context of a user database.
By Brian Moran, 03/22/2006
Find out how to enable the SQLCLR tool and set the appropriate permissions before running .NET applications on your server.
By Warren Thornthwaite, 03/22/2006
Dimensional modeling helps us consistently give business users the usability and performance they need. But misconceptions about dimensional modeling often trip people up.
By Itzik Ben-Gan, 03/22/2006
Some DBAs and developers look at the SQLCLR as a dangerous weapon, but when it’s used wisely, the CLR can greatly improve performance. Here’s how to know when to use the CLR--and ...
By Warren Thornthwaite, 03/22/2006
SQL Server 2005--and especially Analysis Services 2005--embraces industry-standard dimensional modeling like a long-lost friend. Learn how you can build dimensions that ...
By Itzik Ben-Gan, 03/22/2006
Follow these steps to build and deploy a CLR project for use with the author's provided code examples.
By Anne Grubb, 03/22/2006
This up-and-coming technology is one to watch. We analyze its benefits and drawbacks.
By Blake Eno, 03/22/2006
Check out new and improved SQL Server-related products.
By Matt Nunn, 03/22/2006
Peer-to-peer transactional replication is the direct descendant of SQL Server 2000’s bi-directional transactional replication. But this newer version of the technology provides ...
By Kalen Delaney, 03/22/2006
Compare the SQL Server 2000's functionality to SQL Server 2005's new options for determining a running process's actions and execution environment.
By Editors, 03/22/2006
Our editors share insights from their conversations with Asigra, MiraLink, SPI Dynamics, and TimeSpring.
By Michael Otey, 03/22/2006
Is your company running multiple builds and betas of SQL Server 2005? You can't always distinguish between the prerelease versions and the final release—but this list of build ...
By Dawn Cyr, 01/22/2004
When you transfer a lot of data from a universal database to a computer that's running SQL Server 7.0 with Service Pack 4 (SP4), an access violation might occur.