The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
The CLR integration in SQL Server 2005 is perfect for some jobs, but other times you need a different tool. Itzik Ben-Gan explains which scenarios are best for CLR and which are still jobs for T-SQL.
By Anne Grubb
This up-and-coming technology is one to watch. We analyze its benefits and drawbacks.
By Kalen Delaney
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
Our editors share insights from their conversations with Asigra, MiraLink, SPI Dynamics, and TimeSpring.
By Blake Eno
Check out new and improved SQL Server-related products.
By Richard Pless
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, source-code change auditing, and backups.
By Warren Thornthwaite
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
Follow these steps to build and deploy a CLR project for use with the author's provided code examples.
By Brian Moran
Find out how to enable the SQLCLR tool and set the appropriate permissions before running .NET applications on your server.
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.
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 realistically represent how your business operates and change with your business.
Microsoft’s Gert Drapers explains how to execute statements in the context of a user database.
By Michelle A. Poolet
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 SQL Server's in-the-box data-modeling tool can get you started.
By Michael Otey
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 numbers can help.
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 when T-SQL is still the best choice.
By Matt Nunn
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 improved availability and scalability as well as simplified setup wizards.
Instead of migration, I've decided to cover one of the fastest growing trends in the IT industry: the rising tide of complexity.
By Dawn Cyr
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.
advertisement