SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : 2008

SQL Server 2008 features that work only in Enterprise Edition

Tue, 03 Nov 2009 13:18:00 GMT

One of the new features available in SQL Server 2008 is compressed backup which takes backup of a database with mimimum possible size. The syntax is backup database db_name to disk = 'backup_path' with init , compression But this works only in...(read more)

SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

Thu, 20 Aug 2009 14:21:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports...(read more)

Happy first anniversary for SQL Server 2008 RTM

Mon, 17 Aug 2009 13:47:00 GMT

It is over 1 year and first anniversary for SQL Server 2008 RTM, last year the RTM is released on August 06th 2008 re. http://sqlserver-qa.net/blogs/sql2008/archive/2008/08/06/4727.aspx post. HAPPY first anniversary.... and kudos to SQL Server Development...(read more)

Here you go to test and install another Feature Pack for SQL Server 2008, april 2009 update!

Thu, 16 Apr 2009 07:35:00 GMT

I have received a good feedback about number of blogs posted about SQL Server Feature Pack, in this regard recent post about Do you know how many tools are included in SQL Server 2008 Feature Pack? here is another update for you to test & deploy the...(read more)

Troubleshooting SQL Server 2008 Performance Problems

Sun, 12 Apr 2009 20:26:00 GMT

A new whitepaper covering the topic of performance troubleshooting in SQL Server 2008 has now been released. You can download the paper from the following link: http://msdn.microsoft.com/en-us/library/dd672789.aspx...( read more ) Read More......(read more)

Performance Dashboard Reports for SQL Server 2008

Wed, 18 Feb 2009 14:20:00 GMT

During a recent visit to Seattle for a Microsoft TechReady conference, I learned from a colleague that it's possible to run the SQL Server 2005 Performance Dashboard reports on SQL Server 2008, with a couple of slight modifications. There is a great...(read more)

CU #3 for SQL Server 2008 Released

Tue, 20 Jan 2009 06:39:00 GMT

On January 19, 2009 Microsoft shipped the Third Cumulative Update for SQL Server 2008 RTM. This CU represents 36 Resolved Issues and 30 Unique Customer Requests. More details and download details can be found here: http://support.microsoft.com/kb/960484...(read more)

SQL Server 2008 Upgrade Technical Reference Guide Released

SqlServer-QA.net — Wed, 26 Nov 2008 10:11:00 GMT

The SQL Server 2008 Technical Reference Guide has just been released, covering the essential steps and best practices to upgrade existing 2000 and 2005 instances to 2008. There is also a list of other upgrade resources available at http://msdn.microsoft...(read more)

Cumulative Update #2 for SQL Server 2008 Released

SqlServer-QA.net — Tue, 18 Nov 2008 11:09:00 GMT

Cumulative Update package 2 has now been released for SQL Server 2008. See the following KB article for full details: http://support.microsoft.com/kb/958186/en-us...( read more ) Read More......(read more)

Scottish Area SQL Server User Group

SqlServer-QA.net — Thu, 06 Nov 2008 23:53:00 GMT

I'm happy to announce that the next Scottish SQL Server User Group will be hosted at Microsoft Edinburgh on the evening of the 13th November. Full details of the agenda and how to register can be found on the UK Server User Group site here: http:...(read more)

SQL Server 2005 Multi-Site Clustering with Windows Server 2008

SqlServer-QA.net — Sun, 02 Nov 2008 16:20:00 GMT

I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build...(read more)

Updated: Support Policy for SQL Server on Virtualised Platforms

SqlServer-QA.net — Wed, 08 Oct 2008 15:48:00 GMT

The support policy for SQL Server running on virtualised platforms has now been updated to include support for SQL Server 2005 running on Hyper-V http://support.microsoft.com/?id=956893 Microsoft provides technical support for SQL Server 2005 and for...(read more)

SQL Server 2008 installation vows on Windows Server 2008

SSQA.net — Fri, 08 Aug 2008 09:23:00 GMT

After I knew about the SQL 2008 RTM release news I have blogged SQL2008RTM-official here and as usual I have attempted to download the setup media from Technet which took a while (3 hours) to download the file, due to the obvious reasons of MSDN/TEchnet...(read more)

Its time to change the blog as SQL Server 2008 RTM is available now!

SSQA.net — Thu, 07 Aug 2008 10:52:00 GMT

Ok, SQL Server 2008 is RTM'd now and its time to change the section of this blog section as 'SQL Server 2008' without any tags! SQL Server 2008 - RC0/CTP (SSQA.net) to SQL Server 2008 (SSQA.net) Yes it is....( read more ) Read More......(read more)

SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages

SSQA.net — Thu, 31 Jul 2008 08:10:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages...(read more)

How to troubleshoot SQL Server 2008 Setup issues

SSQA.net — Wed, 30 Jul 2008 08:09:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications How to troubleshoot SQL Server 2008 Setup issues http://support.microsoft.com/kb/955396...(read more)

Get ready for SQL Server 2008 RTM release!

SSQA.net — Mon, 14 Jul 2008 14:56:00 GMT

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 is set to RTM'd during the month of August 2008, as per Bob...(read more)

Reporting Services 2008 additional features, other than SQL Server Reporting Services 2005

SSQA.net — Fri, 11 Jul 2008 09:38:00 GMT

SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know...(read more)

SQL Server 2008 - Performance Studio

SSQA.net — Fri, 20 Jun 2008 16:50:00 GMT

I've been looking at this new feature of SQL Server 2008 in order to demo it to customers, and I have to say it's pretty cool ! Along with Resource Governor and compression, it's one of my favourite new features and a good reason to consider...(read more)

Feedback: Specify SQL Server services restart message when TEMPDB system database is moved to new path

SSQA.net — Wed, 11 Jun 2008 17:30:00 GMT

With regard to the Connect site feedback on Vote your feedback on SQL Connect site: Specify SQL Server services restart message when TEMPDB system database is moved to new path information, received following feedback: Thanks for pointing this out. Given...(read more)