Browse by Tags

SQL Server Security & Compliance - webcast by IDERA

Published 18 January 8 8:58 AM | SSQA.net

"SQL Server Security & Compliance" Sponsored by Idera : SQL Server security and compliance go hand in hand. With the changes in legislation and new requirements to ensure that database platforms such as SQL Server are secure we will take...

Filed under: sql server, management, webcast, security, tools, dba, manager, idera, third party, architect

SQL Server: How do I identify the queries that are worth tuning?

Published 16 November 7 7:2 AM | SSQA.net

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...

Filed under: sql server, performance, management, microsoft, blogs, technet, dmv, dba, best practice, slow query

Dedicated Administrator Console (DAC) - saved an important day for a DBA

Published 4 August 7 9:9 AM | SSQA.net

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to...

Filed under: sql server, performance, management, analysis, blocking, dba, dac, sac, investigation

How to find list of DMVs & DMFs?

Published 31 May 7 9:22 AM | SSQA.net

As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism...

Filed under: sql server, performance, management, microsoft, dmv, dba, dmf