SqlServer-QA.net

As promised by SQL Server Developmen team about SQL Server 2005 SP3 the public beta is now available for your action and set of tasks for your 2005 environment. So what this public beta provides, this is a rollup Quick Fix Engineering that will have all the work including from SP2 as well as addresses critical issues reported through the SQL ...

In the past week SQL Server 2008 RC0 has been made available for early download by MSDN and TechNet Plus subscribers. RC0 is the final step before SQL Server 2008 RTMs in Q3 of this year. After logging into their respective accounts, subscribers can view Product Keys and download SQL Server 2008 RC0 from the following links: MSDN subscribers: ...

It is 1 year (first anniversary) that SQL Server 2008 Community Technology Preview is released, I have seen many good things and few peeves about this new version of SQL Server. Not to mention about largest conference is lined up for the users aka 'Tech-ed 2008' which is a huge learning opportunity too. So what you have learned from last 4 ...

Have you ever seen or used the PowerShell? If so have you worked on PowerShell within SQL Server 2008, it has 2 kinds of snap-ins that are called as Powershell Provider and set of Cmdlets. The provider will enables the simple navigation mechanism similar to file system paths, within that associated to SQL management object model and ...

In continuation to this February CTP: SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems thread here the referred bug has been identified and closed:   Summary: ·         The window of ...

You may be aware that MVPs have the advantage of getting to know about the product information before it is let to the user community, that is the main advantage (I feel) to make the most of MVP award experience, Microsoft keeps MVPs informed of award benefits, updates, news about their peers, and events that are occurring in their region and ...

It has been a 'very busy' month sofar, in particular to Microsoft world and sub-domains of Windows Server, Virtual Server & SQL Server and you know why from here. Not a 'real' launch for SQL Server folks out there, but a concession to their grief that SQL 2008 CTP6 is available to download and next question will be what's new. ...

Continuing from this SQL2008CTP blog post it seems there is a confusion on the SQL 2008 CTP downloads page The technet link  851664 refers that Evaluate Microsoft SQL Server 2008 today page was published: November 12, 2007 and further after registering the interest on this SQL2008CTP download it refers February 2008. Whatever, the next ...

Its nearly 90 days from SQL Server 2008 November CTP and as per the CTP release cycle (90 days) the next instalment of SQL 2008 may be ready by end of this month. I feel that may be the last one before the RTM or as per the communication from Microsoft product development team feedback, but looking at the recent release ...

In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log all such activites? As you may be aware that logging the data related activites is a 'must' ...