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,411 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,589 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,284 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,955 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,371 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,450 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,966 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,598 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,152 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
An SSIS Upgrade
Comments posted to this topic are about the item An SSIS Upgrade
Question of the Day
Encoding URLs
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers