by Jeff Jones – One of the most sought-after goals in data applications is end-to-end speed. You should look for a good balance of speed and development time to achieve this goal. I’ll show you how to create more efficient data shaping to make your hierarchical data as lean and as fast as possible.

by Drew Georgopulos – The sheer number of objects in a database makes keeping track of them difficult. As your system grows in complexity, identifying the objects’ dependencies and their purposes can quickly become confusing. Adopt a naming convention that limits the ambiguity and uncertainty surrou

By Lisa Vaas – NetIQ Corp. aims to make defragmenting tables in and general management of Microsoft Corp.’s SQL Server database easier with an update to its SQL Management Suite of tools.

By Maryann Tripp – When the Slammer worm hit last month, it choked large Internet service providers worldwide. Slammer exploited a vulnerability in Microsoft SQL Server and spread without the assistance of an e-mail attachment, the vehicle of choice for most worms. Instead, it used the SQL monitor p

Learn about the Data Transformation Services (DTS) programming techniques used in SQL Server Accelerator for Business Intelligence (BI Accelerator). Using these techniques, the Microsoft BI Practices team created an extensible data movement system for analytical applications that developers can exte

by Tim Landgrave – When bad client logic allows invalid data to make it to the database, only to be rejected on an insert or update operation, extra database calls are generated. This isn’t a problem when you’re developing applications for a small number of users in a connected environment. But in a

(Preethiviraj Kulasingham) This script will return one big string where the rows are seperated by commas. When getting a set of rows of a field (any string type field), this script could be used to find the field names seperated by commas. It works on SQL server 2000 and 7.0. (R)

Book by Sean Baird, et al – SQL Server System Administration assumes that you are familiar with the fundamentals of database administration and have worked with SQL Server in some capacity. This book focuses on the topic of interest to most administrators: keeping data consistently available to user

This article comes from Jeff Smith. Jeff writes “It can be difficult in a set-based language such as SQL to determine when a number of records in a row (when ordered by a unique key) have the same values in a particular field. For example, you may have a table of GameResults, with fields such as Gam

By Jarick Rager and John Burdett – SQL Server allows a myriad of options to establish replication and each is discussed in the SQL Server CE Books Online. The problem is determining where to find information suitable for a particular situation. This article describes some of the searches we made and