Browse by Tags

SQL Server 2008 installation vows on Windows Server 2008

Published 8 August 8 4:23 AM | SSQA.net

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...

Filed under: sql server, blogs, community, windows, 2008, development, installation, firewall

SQL Server 2008 Resource Governor FAQ

Published 25 February 8 1:36 AM | SSQA.net

Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...

Filed under: sql server, performance, memory, dba, i/o, disk, 2008, development, cpu, best practice, capture, resource governor

New feature in SQL Server 2008 - compression how it works?

Published 3 October 7 9:42 AM | SSQA.net

Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and...

Filed under: sql server, microsoft, team, features, 2008, development, data capture, compression, backups, FAQ

Next installment of SQL Server 2008 July CTP is available for download from Connect site

Published 1 August 7 2:51 AM | SSQA.net

Here it is, next installment of SQL 2008 CTP which is July CTP of SQL Server 2008 is now available for download on the SQL Connect site (you need to have a passport login to download). There are few enhancements to the Reporting services, introduction...

Filed under: sql server, microsoft, beta, 2008, ctp, deprecated, development, connect, july

Deprecated features highlights in SQL "Katmai" 2008 release

Published 10 June 7 5:52 PM | SSQA.net

SQL 2008 books online confirms the deprecated features that are not supported with the release of RTM, those few lists are as follows: SP_DBCMPTLEVEL is replaced with ALTER DATABASE .. SET COMPATIBILITY_LEVEL SP_HELPDEVICES is replaced with sys.backup_devices...

Filed under: sql server, microsoft, features, 2008, deprecated, development

Notes to take care before you test SQL Server 2008 within your development environment?

Published 10 June 7 5:43 PM | SSQA.net

First of all I would like to remind the users to install the SQL 2008 CTP on their Virtual Server environment rather than mixing with current test or development (physical) environment. Once the SQL 2008 CTPs are more stable and if you are planning to...

Filed under: sql server, 2008, development, environment, test