I attended my first SQLskills event in December 2011. Due to a big project at work I was able to work in week three of the Immersion Events which is HA/DR “High Availability and Disaster Recovery”. Although I am taking the training out of sequence my hope is to be able to attend IE2 later […]
SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able to attend this event and demo a couple of favorite tools of mine. SQL Prompt and SQL Compare. Being the PASS regional mentor for this area made me want to attend and show support even […]
Idera ACE Program
On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was included in the list. http://bit.ly/ABedR0 March 9th could also be deemed the day twitter blew up my iPhone. The congratulations from the SQL Community was truly amazing. The Idera ACE program is something that has […]
Find the version of the Master DB from a backup
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. […]