2007-08-02
1,854 reads
Uncategorized
SQL Server 2008 Launch Date
Yesterday at it's Worldwide Partner Conference, Microsoft announced the launch date for SQL Server 2008 along with Windows 2008 and Visual Studio 2008.
2007-07-11
15,729 reads
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,420 reads
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,605 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,322 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,963 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,383 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,457 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,978 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,628 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers