SqlServer-QA.net

What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of all aspects of that upgrade tasks. Documented information of upgrade path and ...

SQL Server 64 bit edition, a primer to address the requirements surrounding applications and data are growing in complexity and size. Many applications running on 32-bit platforms today are approaching or have exceeded the limits of the platform, specifically regarding the number of processors and addressable memory. Not only for data explode ...

Another set of Cumulative Update package is ready for review on SQL Server 2008 - this package contains hotfixes for the issues that have been fixed since the release of SQL Server 2008. Earlier posting on Cumulative Update Package 1 for SQL 2008 one of the user asked me how to find out how many update packages were released after SQL Server 2008 ...

          Date: Wednesday, August 20, 2008*     Time: 4 PM Eastern | 3 PM Central | 1 PM Pacific     Speaker: SQL Server MVP, Hilary Cotter     Attend and win! Find out how!     *Want to attend ...

Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as the current installation is latest and updated. MSDN Developer Center page provides wide range ...

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 of years ago, in the same situation you have to be aware about such pack of ...

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 stopper to continue the installation of SQL Server 2008, few ...

As you may be aware all the Technical information roll-up on MSDN & Technet is sent out in email format, in this regard I wanted to share the important and interested links for you on SQL Server arena. Downloads   Source Code Analyzer for SQL Injection Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for ...

For every new user in SQL Server world and experienced users to get used to newer version of SQL Server, having sample kit will definetly help out. In this scenario I often get emails asking about any samples or documentation (procedures) to get more about the latest release of SQL Server, in the same fashion thanks to Microsoft learning that ...

As in continuation with the latest release of SQL Server  2008 that is Release Candidate, I strongly recommend you update your local copies of SQL Server Books ONline aka BOL. Here is the link to download the latest copy of SQL Server 2008 RC0 BOL - Link_to-Download and also I recommend the SQL Server 2008 ...