The Scary DBA
Avoiding Bad Query Performance
There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:
That’s certainly not the hairiest execution plan I’ve seen. In some ways, it’s not all that horrible. But it sure is evidence that someone was down in a hole and they… Read more
4 comments, 147 reads
Posted in The Scary DBA on 7 February 2012
Meme Monday: Deadlines
Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.
Some people hate deadlines. Some people love deadlines. But when you have one, there’s a good chance you need to really meet that deadline or there could be repercussions. Read more
0 comments, 130 reads
Posted in The Scary DBA on 6 February 2012
Learning, Networking & Wine
Let’s say, you want to spend a couple of days learning about SQL Server. You also want to spend some time networking with others. And, it just so happens, you’re a bit of a wine connoisseur. I have the event with you in mind.
It’s the first ever, SQL Excursion Read more
0 comments, 193 reads
Posted in The Scary DBA on 1 February 2012
Tech on Tap v1.1 Wrap-up
The first ever Tech on Tap event was held on Saturday, January 27th, 2012 at the Stone Cellar Brewpub in Appleton, WI. If you weren’t there, well, you missed it. Notice that keyword in that earlier sentence, Brewpub. Yes, the Tech on Tap events (and there will be more) are… Read more
0 comments, 208 reads
Posted in The Scary DBA on 31 January 2012
Execution Plans, What Do I Look At?
The question came up, what are the top 3-5 things that you look at in a query. I realized then that I hadn’t really written them down. There are some areas that let me know pretty much immediately where problems lie within a plan. You don’t necessarily know the answer… Read more
6 comments, 243 reads
Posted in The Scary DBA on 30 January 2012
Deadlock Monitoring
There are four different ways you can get information about deadlocks in your system. These are:
- traceflag 1204
- traceflag 1222
- trace events
- extended events
For years I’ve been pushing traceflag 1222 as the best of the lot. Well, that’s over. I’ve been learning more and more about extended events and… Read more
5 comments, 1,529 reads
Posted in The Scary DBA on 23 January 2012
Stop PIPA & SOPA
I’m not going to black out my blog, because, let’s face it, who’s going to notice? But for all six of you who read this (and, of course, you Mom), I do want to point out that these are horrific bad bills. They are sponsored by Democrats and Republicans, so… Read more
6 comments, 382 reads
Posted in The Scary DBA on 18 January 2012
Friday SQL Nugget #1
Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like you.
We have a tagging theme started by Ted Krueger (blog|twitter) who I also used to like.
The theme is: Deciding that… Read more
2 comments, 492 reads
Posted in The Scary DBA on 13 January 2012
Database Backups: Things You Need To Do Now
I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written about backups before?
Why, yes. Yes I have.
Aaand… you’re doing it again because?
Have you noticed the shocking number of questions that come up on SQL Server Central… Read more
9 comments, 2,979 reads
Posted in The Scary DBA on 11 January 2012
PASS Summit 2012 Evaluation Results
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not indifferent), feedback is a wonderful gift. Any time you appreciate a speaker, give them feedback. Any time you think a speaker could improve, give them feedback. Any time you hate… Read more
2 comments, 655 reads
Posted in The Scary DBA on 19 December 2011
SQL Saturday #104: Colorado Springs
I’ll be presenting at the Colorado Springs SQL Saturday on January 7th of 2012. The session is called Seven Ways to Fix Bad Parameter Sniffing. Please, if you’re in the area, register and come to the event. There are going to be some truly excellent speakers there. There is… Read more
0 comments, 741 reads
Posted in The Scary DBA on 14 December 2011
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT… Read more
10 comments, 2,558 reads
Posted in The Scary DBA on 12 December 2011
#sqlfamily
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a single better cause to throw some support behind. Not one. They’re going to donate money based on posts about #sqlfamily.
3 comments, 717 reads
Posted in The Scary DBA on 9 December 2011
SQL Connections Fall 2011 Speaker Evaluations
In keeping with the past, I’m going to go ahead and post my evals for the two sessions I did at Connections in Vegas back in November. It was a mixed conference for me. The first session I had ~80 people. The second session I had 9. Yeah, weird. But… Read more
1 comments, 749 reads
Posted in The Scary DBA on 6 December 2011
Resolutions: Outcome
Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked by Jen McCown (flat out, one of my favorite people, blog|twitter). It was supposed to be about resolutions, but I just don’t make those. I make plans.… Read more
1 comments, 793 reads
Posted in The Scary DBA on 5 December 2011
PASS Board Elections
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look these people over, weigh them, and vote well. Things are running a little different this year. The elections are being held between the 6th and the 20th of December. Read more
1 comments, 802 reads
Posted in The Scary DBA on 30 November 2011
Installing SQL Server 2012 RC0
Very short informational post.
If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server Denali, uh, I mean 2012, then the news about the release of RC0 is pretty exciting stuff… until you realize that you’re going to have to tear down your… Read more
0 comments, 830 reads
Posted in The Scary DBA on 21 November 2011
Thank you
I somehow made the Top 10 Community Choice Bloggers in the SQL Server Magazine 2011 awards (keep scrolling to the bottom). This was evidently a write-in list and some of you who read my rambling attempts to understand this SQL Server stuff thought enough to actually write down this blog.… Read more
0 comments, 803 reads
Posted in The Scary DBA on 18 November 2011
Meme Monday: SQL Family
Tom LaRock’s (blog|twitter) question this month: What does #sqlfamily mean to me?
Wow…
Geez Tom, couldn’t you ask a hard question for once?
Hmmm…
Just saying #sqlfamily and a whole series of images of people flashes through my head. And those images are accompanied by all… Read more
0 comments, 802 reads
Posted in The Scary DBA on 7 November 2011
Book Review: Guerilla Leader, T.E. Lawrence and the Arab Revolt
As part of my commitment to read and review 12 books in an effort to be active in my own personal development, a commitment made on the SQL Cruise back in June, I’ve completed another book, Guerrilla Leader: T. E. Lawrence and the Arab Revolt by James J. Schneider.
This… Read more
0 comments, 809 reads
Posted in The Scary DBA on 7 November 2011




Subscribe to this blog