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.

Sunday, March 11, 2007 - Posts

Server Virtualization, is this a part of consolidation?
Well this was my first question when my manager asked me about shall we look at Server Virtualization. When evaluating file virtualization solutions, you must consider how you plan to use virtualization initially, as well as how it fits into the infrastructure Read More...
Clustered index, to be or not to be. A big question for every DBA!
I'm great fan of Kimberly (aka 'SQL Queen') on her detailed explanation on Concurrency and performance which is a hardcore topic to go through for every DBA. I have watching closely about the debate on Clustered Indecx on SQLSkills(Kimberley's) website Read More...
How to design a Maintenance plan from Command prompt and use a DTS package for the steps?
This is the question asked in MSDN forums, using SQLMAINT utility this can be achieved and also the output can be sent to a text file or HTML file. In case if the steps are defined in the DTS package then its best to use DTEXEC utility. Best to refer Read More...