SQL Server

SQL Server is an end-to-end data management and analysis solution that helps you build, deploy, and manage enterprise applications.

Featured Resources		Downloads More...
Cumulative Update 7 for SQL Server 2005 Service Pack 2 This package contains all of the SQL Server 2005 hotfixes that have been released since the initial release of SQL Server 2005 SP2. Microsoft Mon, 14 April 2008 11:39:33 -0800 SQL Server 2008 CTP (February 2008) Is Now Available Download the latest release of SQL Server 2008 Community Technology Preview (CTP) and discover new capabilities to help support your mission-critical platform. This CTP continues to improve functional... more Microsoft Thu, 21 Feb 2008 17:40:19 -0800		SQL Server 2005 Books Online The September 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released.

		Select "How Do I" Library and Troubleshooting Articles More Troubleshooting...
		Read about deployment, administration and other tactical guidance in these Library articles. Technical Articles SQL Server 2005 Tutorials SQL Server Security

Blogs from the SQL Server team

More...

SQL Server TechNet and MSDN Web Updates

Moving on...
<last post> One thing that is constant at Microsoft is change and I am moving on to support a different web site here on TechNet, so I... more
Tue, 22 Apr 2008 21:31:00 GMT

Euan Garden

Unit Testing for Silverlight...
Jeff has a follow up post to the demos from Mix here. The silverlight unit test framework is based o... more
Fri, 21 Mar 2008 02:54:06 GMT

Buck Woody - DBA

Real World DBA Episode 12 – SQL Server Features –SSIS
http://edge.technet.com/Media/Real-World-DBA-Episode-12--SQL-Server-Features-SSIS/ This week: In the... more
Fri, 16 May 2008 13:56:00 GMT

SQL Server Security

SQL Server 2005 Encryption – Encryption and data length limitations (feedback page)
We have received some feedback regarding the “SQL Server 2005 Encryption – Encryption and dat... more
Tue, 04 Mar 2008 03:39:00 GMT

Microsoft SQL Server Development Customer Advisory Team

What you should know if you are using Logical IOs to measure query plan quality
One of the presenters at recent SQL Server Open World conference in Denmark (http://www.miracleas.dk... more
Thu, 10 Apr 2008 14:36:00 GMT

Jamie MacLennan

What's a book without a cover - redux
Three years ago next month I posted on our first book and now we can peek at what's to come! I gu... more
Mon, 21 Apr 2008 17:21:32 GMT

PSS SQL Server Engineers

SQL Server 2005 SP3 and Self-Service Hotfixes
If you have not seen or heard the news, we have announced our plans to release a service pack for SQ... more
Fri, 25 Apr 2008 16:18:45 GMT

SQL Server User Education

Tagging SQL Server documentation
If you've ever happened to find a SQL Server documentation topic that you were looking for and wante... more
Fri, 18 Apr 2008 17:26:00 GMT

SQL Server Manageability Team Blog

Where is SAC tool?
Surface Area Configuration (SAC) tool will be removed in SQL 2008 release. This tool exposed two maj... more
Fri, 29 Feb 2008 23:55:00 GMT

Select SQL Server Forums

SQL Server 2008 CTP Database Engine

Resource Governor - multi-core box
I configured a small test to try out resource governor. I'm on a AMD dual proc, dual core box, so t... more
Tue, 06 May 2008 04:00:07 GMT

SQL Server Reporting Services

How to enable Remote Erros on Report Server 2005?
hi, all When i tried to access a report via URL and I got an error page like: Reporting Services Err... more
Tue, 17 Jan 2006 07:48:18 GMT

Getting started with SQL Server

How to find trigger assosiated with a table ?
Hi, How to find triggers assosiated with a tables for triggers having text like '%GLPAudit%' Act... more
Thu, 15 May 2008 03:39:44 GMT

SQL Server Integration Services

Query for IBM Db2 in Script Task
Hi All, I am using IBM DB2 provider in my SSIS. In Script Task when i want to use query retrievi... more
Fri, 16 May 2008 04:56:34 GMT

SQL Server Database Engine

out of ideas
I have some performance issues which I can not explain; The database it is running on on a dedic... more
Fri, 16 May 2008 02:03:56 GMT

Transact-SQL

SQL job fails after 4 failed Exec() calls
I am running the code below in a sql job. Exec (@SQL) errors every time but after 4 failures the jo... more
Wed, 16 Apr 2008 09:55:57 GMT

SQL Server Analysis Services

SSAS memory problem in querying
A question about memory management in querying an SSAS server. It so happens that users make huge... more
Wed, 14 May 2008 02:09:13 GMT

SQL Server Setup and Upgrade

Install errror in SQLServer 2005 SP1
I have a error instaling SP1 for SQLServer 2005 Standard Edition Spanish. The log is the following: ... more
Wed, 26 Apr 2006 08:38:53 GMT

View all SQL Server and SQL Server 2008 TechNet Forums

MVP Blogs About SQL Server

More...

	Andrew Kelly New England SQL Users Group & Craig Freedman Adam Machanic has already blogged about Craig's visit to New England coming up on May 8th bu... more Tue, 06 May 2008 19:50:23 GMT
	Adam Machanic [New England] NESQL Special Meeting, Featuring Craig Freedman Next Thursday, May 8, the New England SQL Server Users Group will have a special meeting, featuring... more Fri, 02 May 2008 17:38:00 GMT
	Linchi Shea SQL Server 2008 Page Compression: Performance impact on inserts Before I begin, let me be very clear that the results I report in this post were obtained with SQL S... more Tue, 13 May 2008 02:49:00 GMT
	Kalen Delaney Did You Know? I have a question for you on DBA Blunders! A good friend of mine is putting together a presentation on the top DBA Blunders from the view point... more Fri, 16 May 2008 03:29:00 GMT
	Tibor Karaszi The SQL Server script repository How come I've missed this? I don't know, but I'm writing this blog post so to bookmark this site. Y... more Mon, 03 Mar 2008 20:18:00 GMT
	Kevin Kline SOS_SCHEDULER_YIELD You might encounter a situation, under a very heavy workload, where processing for certain transacti... more Wed, 14 May 2008 16:06:00 GMT
	Hugo Kornelis Let's deprecate UPDATE FROM! I guess that many people using UPDATE … FROM on a daily basis do so without being aware that they ar... more Sun, 09 Mar 2008 23:38:00 GMT