Welcome to SSQA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » clustering   (RSS)
Install cumulative update package 7 on a SQL Server Cluster?
IN continuation to the post Rollback_of_CumulativeUpdate-hotfix-ServicePack I was asked about any procedure or steps on installing Cumulative update package 7 for SQL Server 2005 Service Pack 2 on Active node SQL 2005 cluster. The simple answer is all Read More...
SQL Server 2005 Failover Clustering on Windows Server 2008 - webcast
Windows Server 2008 is on full fledged wave now after it has been launched in February and it is obvious that many questions will be flying around about supportability & manageability for existing SQL Server versions such as 2005 at the moment. Think Read More...
Get SQL Server Clustering information with DMVs and SELECT statements
Few counters and gotchas for you to look for when you are installing SQL Server clusters, also using SELECT statements & DMVs to get SQL instance information. Such as: Do not install SQL Server on a compressed drive, by default the installation will Read More...
SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb
Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgradeTags posts. Here in this post I would like to go with few FAQs that Read More...
All about SQL Server with 32bit to 64bit cluster migration - steps to take care
An interesting cross-post from SSP Blog - read thisblog for more information. Read More...
SQL Server MSDTC service - do you need it or not?
MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent Read More...