SQL Server 2000 SP3a Support is Ending
Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.
2007-07-05
3,413 reads
News
The Journey to Katmai
With the next version of SQL Server due to release in 2008, Steve Jones takes a look of some of the more interesting features available in the June 2007 CTP and that should be ready for release next year.
2007-06-21
8,596 reads
The Differences Between SQL Server 2000 and 2005 - Part 2
Steve Jones continues with his look at how SQL Server 2005 differs from SQL Server 2000, this time tackling the differences from a developer perspective.
2008-05-29 (first published: 2007-05-31)
37,301 reads
Post SP2 Fixes Explained
If you haven't seen it, I highly recommend all SQL Server administrators check out the post from Microsoft detailing the post-SP2 fixes.
2007-04-16
3,957 reads
Quality Control with SQL Server
What's going on with SQL Server? Quite a few problems with patches reported lately. Steve Jones comments on what he sees happening.
2008-04-09 (first published: 2007-04-06)
4,376 reads
SQL Server 2005 Adoption Survey Results
We recently ran a survey at SQLServerCentral.com and got over 600 responses. Here are the results and some commentary from Steve Jones
2008-03-28 (first published: 2007-03-28)
5,452 reads
Service Pack 2a
Service Pack 2 for SQL Server 2005 has been updated to fix the maintenance plans issue.
2008-03-10 (first published: 2007-03-07)
11,971 reads
Don't Overdo It, SQL Server
With the release of SQL Server 2005, it is more of challenger to Oracle than ever before. Guru Haidong Ji takes a quick look at how these two products compare and gives a few words of wisdom for the next version of SQL Server.
2006-05-22
10,605 reads
SQL Server 2005 Books Online Update
Download an updated version of Books Online for Microsoft SQL Server 2005, the primary documentation for SQL Server 2005. The April 2006 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to "New and Updated Books Online Topics" for a list of topics that are new or updated in this version. Topics with significant updates have a Change History table at the bottom of the topic that summarizes the changes.
2006-05-04
3,226 reads
Exception Handling in SQL Server 2005
SQL Server 2005 brings us a number of enhancements, but the most important to T-SQL developers may be the changes to error and exception handling. The addition of the TRY CATCH structure is an important change and Raj Vasant brings us a look at this enhancement.
2006-02-02
23,179 reads
Blogs
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Forums
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
whats that ssis analyzer product that documents lineage
hi, a few years ago was at a very large company that bought a...
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers