SQLServerPedia Syndication
Log Shipping Without Maintenance Plans
I have this crazy idea spinning around in my head–setting up log shipping without using a maintenance plan. It’s either stupid, crazy, or brilliant. It’s probably a combination of the three. I’m working with a company that hosts a database application for clients. In this environment, we’re growing quickly. I need a DR solution that [...]
Cancel Your Plans
I have a confession to make. I’m not a fan of maintenance plans on SQL Server. Sure, they’re easy to set up and they work well in small environments. But what happens when you migrate from one server to the next? What happens when your company is rapidly growing and you find yourself adding new [...]
Speaking Epiphany
The more I think about it, the more I realize that presenting at SQL Saturday was good for me. You see, I was actually doing myself a disservice. Over the past two years, I had met some really amazing people who know tons about SQL Server. What’s wrong with that, you might ask? I was [...]
Thank you @SFSSUG #sqlsat79
Saturday was SQL Saturday 79 South Florida held just outside of Fort Lauderdale. It was an absolutely incredible day. When I submitted to speak at the event, I got brave and submitted three sessions, thinking they’d accept one or two of them. I really had no expectation of giving three presentations in one day. Imagine [...]
Top Ten Presentations #sqlsat79
Today is SQL Saturday 79 in South Florida! I have two “Top Ten” presentations I’m giving. Here are my bullet points. And the slide deck is attached below. Mike’s Top Ten Rules for Managing a Production Environment: Best practices that will keep you sane Developers don’t touch production. Ever. Limit Access to SA and Service Account [...]
Cool Things Your MSDB Database Will Tell You (If You Ask) #sqlsat79
Another presentation I’m giving at SQL Saturday 79 is Cool Things Your MSDB Database Will Tell You (If You Ask). This is a new presentation for me, and it’s different from my other two in that it’s less heavy on the Power Point and more heavy on the demonstrations. This blog post contains the scripts I [...]
I Blame Brent Ozar
Yes, I blame Brent Ozar. A little more than two years ago, I started following a few people on Twitter who knew about SQL Server. I must have been looking for answers to some particular problem. One of those people was Brent Ozar (twitter | blog). The other was Tom LaRock (twitter | blog). And [...]
Look for me at #sqlsat79
On Saturday, August 13, I will be presenting at SQL Saturday 79 in South Florida. It sounds like this is going to be a pretty amazing event. I will admit that I’m a little nervous. When I submitted three sessions, my expectation was that they’d accept one, maybe two. Little did I know that they [...]
Interview Questions
I’ve mentioned that I’m going to be moving on in my career. My company has started the search for my replacement. Just in case I’m not able to interview potential candidates for my job, I’ve prepared a list of interview questions for my boss. He’s not a database guy, so I thought I’d give him [...]
DROPping all Databases on an Instance
I’m doing a testing my database restores. Notice that I say I’m testing the restores. If the backups don’t work, neither will the restores. Part of my process is to drop the existing databases in the restore target instance. It’s really the only place I can ever imagine this script seeing the light of day. [...]