About Me - Who is DR DBA?

Hello. My name is Rudy Panigas and I am a Production Senior Microsoft SQL Server Database Administrator (DBA) with over 14 years of experience. Have published articles with SQL Central, am a leader for the my local PASS chapter in Toronto (TORPASS) and love to automate anything SQL including disaster recovery. I created this blog to share my views, knowledge and to discuss Microsoft SQL server in order to help out others in this field. Please test these scripts before using. I do not warranty and do not take any responsibility for it, its misuse or output it creates. You can reach me at this email address: sqlsurgeon@outlook.com

Thursday, August 8, 2013

SQL Server Diagnostic Information Queries

Good Day!

Since I didn't have this great link before, I would like to share it with you now. If you need to perform some diagnostics on your SQL Server, Glenn Berry has created an excellent SQL scripts that will help you out. There are versions for each version of SQL Server.

Here is the link: http://sqlserverperformance.wordpress.com/?s=Diagnostic+Information+Queries

I highly recommend you try them out now before you actually need them. Check the site regularly as he updates the scripts as needed.

Enjoy!

Rudy

Who is Active on the SQL Server

Hello everyone,

It's been a while but I'm back.

Today I would like to share a link to Adam Machanic's blog page that has a very cool SQL script.

The script is called sp_WhoIsActive and what it shows is everything you wanted to know about who is doing what on your SQL Server. I highly recommend it and you should try it for yourself, on a development server. 

Look at the link here: http://sqlblog.com/files/folders/release/tags/who+is+active/default.aspx

Enjoy!

Rudy