Is your SQL Server Linked Server Query running slow? Check your permissions. Maybe this is old news to you but it wasn’t for me –>
It was a good day. We had finally migrated onto brand new hardware (and saw a 250% improvement in run times of most warehouse jobs). I had finally cleaned up the [...]
Archive | Best Practices RSS feed for this section
Linked Server Query Running Slow?
Hey Software Vendors – Get a Clue!
Psst. Hey Vendor – DBAs are secretly plotting against you! We hate what your products do to our environments. Sometimes we even work to get you replaced by someone else who makes a product in the same space but is “DBA-Approved”….
What’s that? You want the DBA stamp of approval?
I write this blog to help folks [...]
5 Things SQL Server Should DROP
When I picture Paul Randal, I picture a guy who likes to run up to a bees nest at a crowded picnic and give it a good couple whacks. You know what I mean, it’s that laughing picture in his twitter profile. Or maybe it’s the devil’s advocate style he has. Maybe it’s his controversial [...]
What Service Pack Are Your Client Tools At?
So you have a plan to apply service packs to your SQL instances. You test them out and try to keep a regular schedule to ensure they are up to date. That is great.
What About SQL Server Management Studio?
What about the copy of SSMS that a developer is using to create scripts? This is spring [...]
Bill Clinton Wasn’t Impeached For…
Yes, he was impeached, by the house and acquitted by the Senate. Not the point of my post today, forget the politics. He wasn’t impeached for all of that business with Monica Lewinski. Was it unethical? Yes. Was it immoral? Well to me it is. Was that activity an impeachable offense? No. Why was he [...]
How do -you- install SQL Server? (Part 3)
Welcome to part 3 in this series on a thought process around SQL Server Installation. In Part 1, we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Part 2 discussed security, playing around before doing a first install and smoke testing afterwards.
Today we’ll [...]
Follow Straight Path
Recent Comments