Katmai Delayed
SQL Server 2008, Katmai, apparently won't ship in Q2. Looks like a Q3 possibility now.
2008-01-25
148 reads
Articles
NULL Versus NULL?
Dealing with NULL data is something that often confuses new SQL Server developers, but even experienced DBAs might not understand all the intricacies of NULL operations. In a follow up to his highly acclaimed Four Rules of Null article, Michael Coles brings us a few new
tricks with NULLs.
2008-01-25 (first published: 2007-02-26)
39,248 reads
The CLR in SQL Server 2005
Updated: Jan 2008. One of the big changes in SQL Server 2005 is the integration of the CLR into the relational engine itself. This is probably the biggest reason for the delays in completing the product and it is a controversial decision. Steve Jones spends a few minutes looking at the pros and cons of having the CLR integrated and possible implications for DBAs.
2008-01-25 (first published: 2005-05-02)
143,105 reads
Data Quality Solutions
This white paper describes how application developers can incorporate data quality into their Microsoft SQL Server 2005 Integration Services solutions.
2008-01-25
1,512 reads
Microsoft SQL Server 2008 - Change Data Capture – Part I
Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table.
2008-01-25
2,880 reads
Multi-Environment Deployments Using Team Edition for Database Professionals
In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.
2008-01-24
3,496 reads
SQL 2005: Enter XML
SQL Server 2005 has greatly expanded the capabilities of SQL Server in many different areas. One of those that has matured greatly is the integration of XML data inside SQL Server. Longtime writer and guru Michael Coles brings us the first part of a two part series on XML ion SLQ Server 2005.
2008-01-24 (first published: 2007-02-19)
13,198 reads
2008-01-24
50 reads
2008-01-24
56 reads
2008-01-24
64 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers