Have you ever tried to restore a backup over an existing database and receive an error stating the tail of the log for the database has not been backed up? Many times if you are just restoring a database into a development environment you don’t care so you just restore WITH REPLACE and move on. […]
Category: SQLServerPedia Syndication
SQL Saturday 112 Recap
I had the pleasure of attending SQL Saturday 112 this past weekend. This was my second time speaking at a SQL Saturday in Birmingham. I was selected to present two sessions again this year in the first and second time slot. I started off with “Getting Involved and Getting Ahead”. This session is all about […]
Becoming the dumbest guy in the group
“Why I joined Linchpin People as a Teammate” It was announced publicly this past weekend at SQL Saturday #111 that I have joined Linchpin People as their first teammate. My friend Andy who is also a Chief Servant Officer of Linchpin made the announcement during the speaker dinner and gave me an official Linchpin dress […]
I am speaking at #sqlsat111 on TEMPDB.
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 […]
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 […]