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.

Tuesday, March 27, 2007 - Posts

SQL Server,SSIS, WIKI - strange coincedence
SQL Server Books Online aka BOL has got various chapters that can help the users even the experienced ones to elevate their knowledge when there is any requirement, for me that is no doubt. Recently I have been going through the information for SSIS under Read More...
SQL Server 2005 on VMWare?
Recently one of my colleague has asked the question that can we install SQL Server version 2005 on VMware? This is required for a consolidation exercise to reduce the data center space! The answer is yes you can, you can install required SQL instances Read More...
Suggested SSIS best practices and naming convention
I was looking for few notes and information for SSIS due to a recent development at a client's site. Bingo, great SSIS Best Practice Post. Jamie Thomson has posted a great blog post about SSIS development best practices. See here what I'm talking about Read More...
Hotfix for slow query performance - x64 & Itanium based systems
To know more about refer to this KBA that is applicable for SQL Server 2005 Enterprise Edition on X64 & Itanium based systems. Read More...
Error: Connect to SSIS Service on machine "<computer_name>" failed:
Recently I have had problem in connecting to a SSIS service on the SQL Server instance, instantly I was checking the SQL error log to see what is the problem behind error. Nothing found and I was baffled, then found the relevant KBA to resolve the issue Read More...