Welcome to SqlServer-QA.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.

August 2008 - Posts

Cumulative Update 9 for SQL Server 2005 Service Pack 2 - another update package in line
In continuation to the CumulativeUpdate package posts here for SQL Server 2005 SP2 we have another set of cumulative update package no.9 ready for testing. TO obtain this read the notes from Microsoft: .... Apply it only to systems that are experiencing Read More...
How to handle PRAGMA AUTONOMOUS TRANSACTION mode within SQL Server?
The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration Read More...
Working with DateTime data types in SQL Server, guidelines and explanations!
Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it Read More...
SQL Server Auditing and Logging - SSIS Audit Transformation comes handy for you in database platform
If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial Read More...
SQL Server 2008 Books OnLine (BOL), latest and updated
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 Read More...