Big SQL Server 2005 News
Confidential until the official release at 9:00am Pacific Time today. Check back after that time to get the big news!
2005-09-14
18,861 reads
News
SQL Server 2000 Service Pack 4
It's now available!! Find out what's in there and where you can get it.
2005-05-09
16,992 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,077 reads
Inside SQL Server Development
After the announcement last week by Microsoft that there would be no Beta 3 for SQL Server 2005 and that the CTP process would take over, Steve Jones had the opportunity to interview Thomas Rizzo and Allan Ros from the SQL Server development team about the CTP process and testing the SQL Server builds.
2005-04-26
5,669 reads
Learning SQL Server 2005
Everyone wants to get ahead of the curve with SQL Server 2005, but many people don't have the time or desire to dig through a Google search. Steve Jones has gotten quite a few requests for resources, so here is a compiled list of some places that might help you get started.
2006-09-08 (first published: 2005-04-21)
44,933 reads
The April CTP is Here and No Beta 3
SQL Server 2005 is on everyone's mind, especially with SQL Server 2000 almost 5 years old. On Monday, April 18, Microsoft made an announcement that the April CTP was available, but there would be no Beta 3. Read Steve Jones take on this announcement as well as a few more details.
2005-04-19
5,909 reads
SQL Server 2005 Editions and Integration Services
The SQL Server 2005 product family has now been announced, so with four editions available, what does this mean for SQL Server Integration Services? Starting from the bottom we have the free edition known as Express, and the entry level Workgroup edition, and neither include the full IS product. They have the Import/Export capabilities, but nothing more, so for simple loading and extraction of data this should suffice, but you will not be able to build packages.
2005-04-07
4,009 reads
Help Improve Yukon Setup
SQL Server 2005 is coming soon and the setup team is looking for some feedback on their process. If you can spare a few minutes for a survey, they would greatly appreciate the time. And you will be helping others avoid the problems in the Betas.
2005-03-18
3,043 reads
Comparison of SQL Server 2005 Editions
On February 24th, 2005, Microsoft announced the new editions and pricing of SQL Server 2005. There have been quite a few changes and MVP Brian Knight has put down a comparison as well as details about which features are included with each. Read about the 4 new additions and see which one might be right for your next project.
2006-09-01 (first published: 2005-02-28)
62,196 reads
A list of the bugs that are fixed in SQL Server 2000 SP 4 Beta
This article contains information about the bugs that are fixed by Microsoft SQL Server 2000 Service Pack 4 Beta. (SP4).
2005-01-06
6,292 reads
Blogs
Database Fundamentals #22: Using the Join Operator, CROSS JOIN
While the CROSS JOIN is not used much, and, depending on the size of...
Automate Your SQL Notebooks with Two New Options
By Aaron Nelson
There are two new options for automating your SQL Notebooks with your SQL Servers....
Debugging techniques (focusing on T-SQL)
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems....
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Log_Reuse_wait_Desc 'AVAILABILITY_REPLICA'
I have a very small DBs (3 GB) but I noticed that the size...
Publishing article revision updated intro comment date in article forum
I recently revised an article, https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-2-sample-stored-procedure-and-function , and just noticed that, in the article-specific forum...
Ask SSC