Try researching recovering the master database online and you will see countless references to having to have SQL at the same version and builld level as the backup of the master database. Since most folks probably don’t have a routine in place to record the version number each time SQL server is patched we need […]
SQL Server Login Auditing
In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed logins. It is simple enough to open SSMS, connect to the instance, right click on the server, chose properties, click on security and then check the proper radio button. When putting together or most recent […]
Increase SQL Server Error Log Files
Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance of SQL Server maintains. This is real simple to change. You can make the change via the GUI with a few simple steps or accomplish it with TSQL. To make this change with SSMS, open […]
RedGate SQL Index Manager BETA
I recently attended the first micro training event with Red Gate where Grant Fritchey demonstrated a BETA tool called SQL Index Manager. This tool is aimed at the accidental DBA or for those like me who are just lazy. 🙂 It is basically a nice GUI to return your index fragmentation level and makes a […]
When training is just that good!
I have the privilege of attending SQL Skills Immersion Event week one in Atlanta GA this week. My expectations were high since it is SQL Skills. Paul and Kimberly are two of the most respected SQL Server professionals in the business and have quite a few years under their belt with working with SQL Server. […]
First Blog Since the PASS Summit
The time following the PASS Summit has been absolutely crazy for me. Upon returning home I spent some much needed time with my wife and kids and returned to work on Monday. During my normal lunchtime activity of playing racquetball I sustained a very nasty injury to my eye. This put me out of commission […]
Summit Sessions Day Three
I started out day three after the keynote by attending Adam Machanic session on Query Tuning. I must say that I will need to watch this session again once I can stream it. There was way to much good information being given for me to remember it all and couldn’t take notes for fear of […]
Summit Sessions Day 2
Day two of sessions only had me attending three sessions. One of them was 3 hours. I started out after the keynote attending Klaus’s session on Advanced SQL 2008 troubleshooting. Klaus had a huge crowd and covered some really good information. I picked up a couple of new tips to apply when I get back […]