SqlServer-QA.net

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

SQL Server User Education blog on MSDN has this update about SQL Server 2000 BOL Update - Don't forget to update your local version copy with this latest release. You can download the updated SQL Server 2000 Books Online from the Microsoft Download Center. .

SQL Server version 2005 Books Online aka BOL has been updated by SQL Development Team in September 2007 and not available for download yet. As usual they are awaiting customer feedback from the BOL or via MSDN/Technet pages. Refer in their words: In the past, our processes for building the Books Online downloads have been faster than the ...

As you may be aware SQL Server installation (70 & 2000) will automatically install the sample databases pubs and northwind, if you aren't using them or not a training institute then simply drop them. Whereas this behaviour is changed in SQL Server 2005 as the Northwind and pubs sample databases are not installed by default in ...

Yet another update to SQL Server 2005 Books Online, though it states May 2007 update that was released on June 06th 2007! During February 2007 with the release of Service pack 2 Microsoft has updated the BOL content to reflect the changes with SP2. For this one: The May 2007 update to Books Online contains new material and fixes to ...

You might have observed or not there is a change in the MSDN documentation User Interface (UI) and the way it is connected with regard to the feedback from the user. Well SQL Server TechCenter has been given a new look with an UI face-off  in addition to the cosmetic changes within the MSDN Library and TechNet Library pages. ...

You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that there is a change in behaviour between SQL 2000 and 2005 versions. The problem here is ...

Microsoft has invested fair amount of time in providing 'sensible' documentation or references since last few years as compared to the initial windows days. Recently with the Trustoworthy Computing intiative has made the product documentation a lot better, but this is not applicable on the SQL Server 2005 x64 bit edition! You have to search a lot ...