A while back I submitted an item over at Microsoft Connect regarding the fact that users were allowed to include an auto-shrink task inside of their maintenance plans. I was very polite in asking: “Please remove the ‘Shrink Database’ option for maintenance plans. Or, rename it to ‘auto fragment’, so that the implications of its … Read more
I’m going to tell you something I want you to remember: Next week I am having a webinar regarding memory. On June 16th at 2PM ET I will be presenting “Advanced SQL Server Memory Management Troubleshooting”, and you can register here. For a description of the talk, read this: “Join Sr. SQL Server DBA Thomas … Read more
The other day I was sitting in my home office, contemplating what it would be like if I had a zebra and enjoying some music while consuming my lunch. I was also reviewing some T-SQL for a client and was going down a mental checklist of the bad T-SQL habits I was seeing. And that’s … Read more
I am in Atlanta this week for Tech-Ed…right after I watch the launch of the Space Shuttle on Monday morning. Despite my commitments to both of those events I cannot ignore my SQL University duties, so here is this week’s post. We are going to talk about the internals of SQL Server, a topic that … Read more
I may be at SQL Rally this week but that doesn’t excuse me from my SQL University duties. Today we are going to talk about SQL Server Analysis Services. While most nearly everything in the BI stack is outside my comfort zone I should remind you all that I stayed at a Holiday Inn Express … Read more
With SQL Rally right around the corner I thought now would be a good time to get my preview posted. Since the event is in Orlando and just a few miles away from my most recent #NASATweetup experience, I thought it was best to tie the preview to a movie with a space theme. Karen … Read more
