I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend. I will be doing my session called “It’s TEMPDB, Why Should You Care”. In this session I cover the importance of TEMPDB and how best to configure TEMPDB in your environment. Not only do I cover a lot of material on […]
Category: SQLServerPedia Syndication
SQLSAT107
SQL Saturday 107
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 […]
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 […]
Final Summit Keynote – NoSQL = Not Only SQL
The keynote started out with Rob Farley and Buck Woody singing an awesome song about a slow running query. What a great way to start out the day. Next Wayne Snider was recognized. He spoke at his first summit in 1999. Both Wayne and Rick Heiges are rolling off the PASS board this year. Wayne gave […]
Day four of Summit – Keynote 2 #sqlpass
The keynote started out with Bill Graziano taking to the stage in a kilt and declaring that the second day of the PASS Summit is now officially SQL Kilt day. Bill asked everyone in a kilt to stand up. It had to be a record number of men in skirts today. Lori Edwards was recognized […]