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

Tuesday, March 5, 2013

SQL Server Version Numbers and Build List

Hello everyone,

Ever need a quick place to find out the versions/build numbers for any SQL Server?
Try this link: http://sqlserverbuilds.blogspot.ca/ which is a Microsoft blog. The site have all the versions and links to each service pack and cumlative patch you will ever need.

Its very handy!

Rudy
Posted by at No comments:

Thursday, February 7, 2013

Locate Dangerous SQL Server Setting


Hello everyone,

After view some information regarding dangerous SQL Server settings; I decided to write a script that will check your current SQL Server settings and point out any dangerous configurations. There are many settings that should not be used unless you are directed by Microsoft support, Executing this script will help you determine if any of the danerous settings are present.

If any of the dangerous settings are detected, an explaination is provided as to why it is dangerous to use the setting(s)

Enjoy!

Rudy

Download script here: https://docs.google.com/file/d/0B07PMQYOhF2DdzI2UlF6X3U3Q2M/edit?usp=sharing
Posted by at No comments:
Subscribe to: Posts (Atom)