SQL Server 2008 (SSQA.net)

New SQL Server 2008 Experience web site launched

SQL Master — Thu, 02 Oct 2008 07:50:00 GMT

A new website about SQL Server 2008 is released by Microsoft development team, SQL Server 2008 Experience web site. Read more from Data_Platform_Insider blog post....(read more)

Cumulative Update Package 1 for SQL Server 2008

SQL Master — Wed, 01 Oct 2008 21:26:00 GMT

First one in the series of SQL Server 2008 version, here it comes Cumulative Update package 1! What kind of fixtures are available in this CU1 package? Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed...(read more)

Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008

SQL Master — Mon, 29 Sep 2008 07:15:00 GMT

In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans? blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking...(read more)

SQL Server Web Edition - What is this new edition?

SQL Master — Fri, 26 Sep 2008 07:27:00 GMT

If you remember about editions of SQL Server from 2000 onwards you will see Enterprise, Standard, Personal & Desktop Edition (MSDE) and when it comes to 2005 version Enterprise, Standard, Workgroup, Express & Express Advanced Services. So what's...(read more)

SQL Server 2008 - Business Intelligence resources and product evaluation

SQL Master — Thu, 25 Sep 2008 21:13:00 GMT

Have you tested or downloaded the SQL Server 2008 Evaluation edition to know about new features? Say if you need to determine which edition of SQL Server 2008 is suitable it is best to download Enterprise Evaluation Edition to test the application, based...(read more)

SQL Server 2008 Performance Data Collection and Analysis, how best you can take advantage?

SQL Master — Thu, 11 Sep 2008 07:11:00 GMT

How many tools (new and enhanced) are available within SQL Server 2008 when you have a need to monitor the performance of queries that are executing/generated? The initial ones you remember is PROFILER and PERFMON (SYSMON) tools, even further few will...(read more)

Installation gotchas and guidelines - SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1

SQL Master — Mon, 01 Sep 2008 08:02:00 GMT

You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage. No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present? issues...(read more)

SQL Server 2008 Feature Pack, don't forget to install them as well

SQL Master — Mon, 18 Aug 2008 07:46:00 GMT

Its over 2 weeks that SQL Server 2008 RTM is released and no doubt in stating that many DBAs might have performed downloads from their MSDN/Technet subscription to install within their environment. Remember feature pack download for SQL Server 2005 couple...(read more)

Visual Studio 2008 SP1 available now for SQL Server 2008 installations

SQL Master — Wed, 13 Aug 2008 08:05:00 GMT

In continuation to SQL Server 2008 installation when Visual Studio 2008 is/isn't present? post that you might be aware that one of the issues with the SQL Server installation was a dependency on Visual Studio 2008 SP1. Though it is not a complete show...(read more)

SQL Server 2008 installation when Visual Studio 2008 is/isn't present?

SQL Master — Mon, 11 Aug 2008 08:01:00 GMT

In continuation to the SQL2008-InstallationVows on Windows Server 2008 there was a brief notes on pre-requisite of Visual Studio 2008 Service Pack when you are trying to install the SQL setup. The release notes were bit confusing that you have got with...(read more)

SQL Server 2008 installation vows on Windows Server 2008

SQL Master — 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!

SQL Master — 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)

SQL Server 2008 RTM is released, its official now!

SQL Master — Wed, 06 Aug 2008 18:40:00 GMT

Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease : . ..announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence...(read more)

SQL Server Data Encryption and Backup - any guidelines to follow?

SQL Master — Mon, 04 Aug 2008 08:00:00 GMT

When it comes to the data encryption within SQL Server 2008 you would think about Transparent data encryption (TDE) which is a new encryption feature. It sounds good that this is a high level security feature you can deploy to secure the data, and a catch...(read more)

RC0 reporting services product samples - SQL Server 2008 and 2005

SQL Master — Wed, 30 Jul 2008 15:01:00 GMT

Until SQL Server 2000 the sample databases or files are installed along with binaries & program files, since version 2005 this has been changed and they are available from Microsoft download site and SQL Server Reporting Services (SSRS) has no exclusion....(read more)