http://www.sqlservercentral.com/Articles tagged News, SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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. http://www.sqlservercentral.com/articles/News/3036/2008/05/29http://www.sqlservercentral.com/articles/News/3036/What's going on with SQL Server? Quite a few problems with patches reported lately. Steve Jones comments on what he sees happening. http://www.sqlservercentral.com/articles/News/2958/2008/04/09http://www.sqlservercentral.com/articles/News/2958/We recently ran a survey at SQLServerCentral.com and got over 600 responses. Here are the results and some commentary from Steve Jones http://www.sqlservercentral.com/articles/News/2943/2008/03/28http://www.sqlservercentral.com/articles/News/2943/Service Pack 2 for SQL Server 2005 has been updated to fix the maintenance plans issue. http://www.sqlservercentral.com/articles/News/2906/2008/03/10http://www.sqlservercentral.com/articles/News/2906/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. http://www.sqlservercentral.com/articles/News/theclrinsqlserver2005/1847/2008/01/25http://www.sqlservercentral.com/articles/News/theclrinsqlserver2005/1847/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. http://www.sqlservercentral.com/articles/News/3036/2008/05/29http://www.sqlservercentral.com/articles/News/3036/If you haven't seen it, I highly recommend all SQL Server administrators check out the post from Microsoft detailing the post-SP2 fixes. http://www.sqlservercentral.com/articles/News/2968/2007/04/16http://www.sqlservercentral.com/articles/News/2968/What's going on with SQL Server? Quite a few problems with patches reported lately. Steve Jones comments on what he sees happening. http://www.sqlservercentral.com/articles/News/2958/2008/04/09http://www.sqlservercentral.com/articles/News/2958/We recently ran a survey at SQLServerCentral.com and got over 600 responses. Here are the results and some commentary from Steve Jones http://www.sqlservercentral.com/articles/News/2943/2008/03/28http://www.sqlservercentral.com/articles/News/2943/Service Pack 2 for SQL Server 2005 has been updated to fix the maintenance plans issue. http://www.sqlservercentral.com/articles/News/2906/2008/03/10http://www.sqlservercentral.com/articles/News/2906/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. http://www.sqlservercentral.com/articles/News/learningsqlserver2005/1845/2006/09/08http://www.sqlservercentral.com/articles/News/learningsqlserver2005/1845/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. http://www.sqlservercentral.com/articles/News/comparisonofsqlserver2005editions/1768/2006/09/01http://www.sqlservercentral.com/articles/News/comparisonofsqlserver2005editions/1768/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. http://www.sqlservercentral.com/articles/News/dontoverdoitsqlserver/2389/2006/05/22http://www.sqlservercentral.com/articles/News/dontoverdoitsqlserver/2389/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.http://www.sqlservercentral.com/redirect/articles/2404/2006/05/04http://www.sqlservercentral.com/redirect/articles/2404/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. http://www.sqlservercentral.com/articles/News/exceptionhandlinginsqlserver2005/2237/2006/02/02http://www.sqlservercentral.com/articles/News/exceptionhandlinginsqlserver2005/2237/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. http://www.sqlservercentral.com/articles/News/theclrinsqlserver2005/1847/2008/01/25http://www.sqlservercentral.com/articles/News/theclrinsqlserver2005/1847/How many people are getting ready to upgrade to SQL Server 2005? Why are they upgrading? Why not? Edgewood Solutions conducted a survey and the results are in. Read on for the executive overview and learn how to get a complete copy of the results. http://www.sqlservercentral.com/articles/News/sqlserver2005adoptionrates/2139/2005/11/02http://www.sqlservercentral.com/articles/News/sqlserver2005adoptionrates/2139/Confidential until the official release at 9:00am Pacific Time today. Check back after that time to get the big news! http://www.sqlservercentral.com/articles/News/bigsqlserver2005news/2087/2005/09/14http://www.sqlservercentral.com/articles/News/bigsqlserver2005news/2087/Ongoing now, the SQL Server 2005 Roadshows in conjunction with PASS. Read Robert Pearl's notes from the show and if you are in Dallas or Houston or Europe, there is still time to attend on of these events. http://www.sqlservercentral.com/articles/Administering/sqlserver2005roadshows/1888/2005/05/10http://www.sqlservercentral.com/articles/Administering/sqlserver2005roadshows/1888/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. http://www.sqlservercentral.com/articles/News/theclrinsqlserver2005/1847/2008/01/25http://www.sqlservercentral.com/articles/News/theclrinsqlserver2005/1847/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. http://www.sqlservercentral.com/articles/News/insidesqlserverdevelopment/1861/2005/04/26http://www.sqlservercentral.com/articles/News/insidesqlserverdevelopment/1861/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. http://www.sqlservercentral.com/articles/News/learningsqlserver2005/1845/2006/09/08http://www.sqlservercentral.com/articles/News/learningsqlserver2005/1845/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. http://www.sqlservercentral.com/articles/News/theaprilctpishereandnobeta3/1854/2005/04/19http://www.sqlservercentral.com/articles/News/theaprilctpishereandnobeta3/1854/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.http://www.sqlservercentral.com/redirect/articles/1812/2005/04/07http://www.sqlservercentral.com/redirect/articles/1812/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. http://www.sqlservercentral.com/articles/News/helpimproveyukonsetup/1799/2005/03/18http://www.sqlservercentral.com/articles/News/helpimproveyukonsetup/1799/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. http://www.sqlservercentral.com/articles/News/comparisonofsqlserver2005editions/1768/2006/09/01http://www.sqlservercentral.com/articles/News/comparisonofsqlserver2005editions/1768/The highly anticipated Beta 2 of SQL Server 2005 aka Yukon, was released today (Monday, July 26). http://www.sqlservercentral.com/articles/News/sqlserver2005beta2isout/1453/2004/07/26http://www.sqlservercentral.com/articles/News/sqlserver2005beta2isout/1453/A week ago, we solicited readers to let Microsoft know which of the SQL Server 2005 announced features mattered most to them. We had a great response, with 890 of you answering the survey in three days. The answers were pretty interesting. The full results can be seen at the bottom of this article. http://www.sqlservercentral.com/articles/News/sqlserver2005surveyresults/1317/2004/03/22http://www.sqlservercentral.com/articles/News/sqlserver2005surveyresults/1317/Microsoft confirmed today that it has delayed Yukon yet again. It also announced that Yukon has an official name and will have another beta added to the development cycle. Get all the info here and share with Microsoft your thoughts about what features are important to you. http://www.sqlservercentral.com/articles/News/yukon/1311/2004/03/11http://www.sqlservercentral.com/articles/News/yukon/1311/