This is post is going to be very simple but it is something I come across ever so often and find myself having to look up the syntax most of the time. I guess it is one of those things that if you don’t use it often enough you don’t commit it to memory. So […]
Category: SQLServerPedia Syndication
SQL Saturday #97 – Austin TX
In less than a week I will make the trip out to Austin TX to speak at my 7th SQL Saturday this year. I am really excited about this trip. There are several speakers I am looking forward to hanging out with and getting to know better. This is perfect timing as the Summit is […]
KB2463332 failed to install
This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when one particular server was failing on patching the database engine itself. A quick google search revealed articles tips that someone may have deleted the c:windowsinstaller contents. That wasn’t my case. After reviewing the summary.txt file […]
SQL Saturday 89 has come and gone!
All the planning, stressing, and freaking out about SQL Saturday #89 came to and end this past weekend. We had a very successful event with 314 attendees, over 30 speakers, lots of volunteers, and some awesome sponsors. This was the ATL areas 4th SQL Saturday and the largest yet. The location of the event and […]
Speaking at SQL Saturday 89
With a late cancellation with one of our speakers a hole was opened on our speaker lineup. I reached out to a couple of the folks we couldn’t originally fit on our schedule but one couldn’t get a cheap enough flight and the other had schedule other plans. A third hasn’t responded back. With time […]
Shrinking Transaction Logs
I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space due to a very large transaction log. Post vary a bit on what the admin has tried but a common theme is that they have tried shrinking the file but it didn’t shrink and a […]
PASS Regional Mentor
Wow, how time flies by. It seems like just a month ago I was made the PASS Regional Mentor for South Central US and now I have given up that position to join Jorge and Adam as Regional Mentors for South East US. Being I live in GA, it is much easier for me to […]
Learning Transactional Replication
I have been working on a new skill this week and that is implementing transactional replication. I am of course doing all this testing and learning on a development system and thank goodness I am. I have found all kind of little nuances with getting this setup. A fun error I came across today after […]