SQLServerCentral.com Content tagged News

Passing a Table to a Stored Procedure

Fri, 13 Feb 2009 07:00:00 UT

SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.

The Differences Between SQL Server 2000 and 2005 - Part 2

Thu, 29 May 2008 06:00:00 UT

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.

Quality Control with SQL Server

Wed, 09 Apr 2008 06:00:00 UT

What's going on with SQL Server? Quite a few problems with patches reported lately. Steve Jones comments on what he sees happening.

SQL Server 2005 Adoption Survey Results

Fri, 28 Mar 2008 06:00:00 UT

We recently ran a survey at SQLServerCentral.com and got over 600 responses. Here are the results and some commentary from Steve Jones

Service Pack 2a

Mon, 10 Mar 2008 06:00:00 UT

Service Pack 2 for SQL Server 2005 has been updated to fix the maintenance plans issue.

The CLR in SQL Server 2005

Fri, 25 Jan 2008 07:00:00 UT

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.

Date and Time in SQL Server 2008

Wed, 24 Oct 2007 06:00:00 UT

SQL Server 2008 is well on its way to being complete and released with the release of the second CTP recently. There aren't a tremendous number of changes, but one of the more interesting ones is the changes to date and time handling in this new platform. The time and date datatypes have been separated and longtime SQL Server author Vincent Rainardi brings us a short look at how there can be used.

Four cool new features slated for SQL Server 2008

Tue, 25 Sep 2007 06:00:00 UT

SQL Server 2008 (code named Katmai) is scheduled to launch in February of next year, and the code isn't slated to be released to manufacturing until Q2 2008. But database gurus don't have to wait to get a sense of what's to come because Microsoft recently released SQL Server 2008 to the community for preview.

Passing a Table to a Stored Procedure

Fri, 13 Feb 2009 07:00:00 UT

What’s new in SQL 2008 Part 1

Wed, 15 Aug 2007 06:00:00 UT

SQL Server 20008 will be released approximately February of 2008, along with a new version of Visual Studio and Windows. This article will highlight some of the new features and benefits found in SQL Server 2008.

The July CTP is Out

Thu, 02 Aug 2007 06:00:00 UT

The second CTP for Katmai has been released and is available for download.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

SQL Server 2008 Launch Date

Wed, 11 Jul 2007 06:00:00 UT

Yesterday at it's Worldwide Partner Conference, Microsoft announced the launch date for SQL Server 2008 along with Windows 2008 and Visual Studio 2008.

SQL Server 2000 SP3a Support is Ending

Thu, 05 Jul 2007 06:00:00 UT

Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.

The Journey to Katmai

Thu, 21 Jun 2007 06:00:00 UT

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.

The Differences Between SQL Server 2000 and 2005 - Part 2

Thu, 29 May 2008 06:00:00 UT

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.

Post SP2 Fixes Explained

Mon, 16 Apr 2007 06:00:00 UT

If you haven't seen it, I highly recommend all SQL Server administrators check out the post from Microsoft detailing the post-SP2 fixes.

Quality Control with SQL Server

Wed, 09 Apr 2008 06:00:00 UT

What's going on with SQL Server? Quite a few problems with patches reported lately. Steve Jones comments on what he sees happening.

SQL Server 2005 Adoption Survey Results

Fri, 28 Mar 2008 06:00:00 UT

We recently ran a survey at SQLServerCentral.com and got over 600 responses. Here are the results and some commentary from Steve Jones

Service Pack 2a

Mon, 10 Mar 2008 06:00:00 UT

Service Pack 2 for SQL Server 2005 has been updated to fix the maintenance plans issue.

A Bit About 64-bit

Fri, 08 Dec 2006 07:00:00 UT

64-bit SQL Server is coming!! Are you ready for this new technology? Chances are most of you are like us in that you've never had a 64-bit machine around and you likely don't remember the transition from 16-bit to 32-bit. Do you even want to make the transition? Is it worth it? New author Robert Pearl brings us a first look at how the 64-bit version of SQL Server will differ from the 32-bit version.

Learning SQL Server 2005

Fri, 08 Sep 2006 06:00:00 UT

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.

Comparison of SQL Server 2005 Editions

Fri, 01 Sep 2006 06:00:00 UT

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.

Don't Overdo It, SQL Server

Mon, 22 May 2006 06:00:00 UT

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.

SQL Server 2005 Books Online Update

Thu, 04 May 2006 06:00:00 UT

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.

Exception Handling in SQL Server 2005

Thu, 02 Feb 2006 07:00:00 UT

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.

The CLR in SQL Server 2005

Fri, 25 Jan 2008 07:00:00 UT

SQL Server 2005 Adoption Rates

Wed, 02 Nov 2005 06:00:00 UT

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.

Big SQL Server 2005 News

Wed, 14 Sep 2005 06:00:00 UT

Confidential until the official release at 9:00am Pacific Time today. Check back after that time to get the big news!

SQL Server 2005 Roadshows

Tue, 10 May 2005 06:00:00 UT

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.

SQL Server 2000 Service Pack 4

Mon, 09 May 2005 06:00:00 UT

It's now available!! Find out what's in there and where you can get it.