Archives: January 2012
On January 19th, I published a post about the Dedicated Administrator Connection. I spoke very briefly of the system base tables in that article. Today, I want to dive into these tables a little bit more.
By now you must have heard of the SQL Slammer worm. It was quite an infectious little nuisance. The harm it caused came largely due to unpatched, unprotected SQL Servers.
We are now 9 years out from the initial discovery of this worm. The worm has made its way… Read more
Do you recognize this person?
If you are from the Colorado Springs area, you probably do. This is:
Troy Ketsdever (twitter)
Troy will be presenting to the Las Vegas SQL User Group on February 9, 2012 @ 6:30 Pacific. Here is his bio:
Troy… Read more
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that those functions were in some DMOs and that you could get at them through the resource database.
Today I found myself learning more about the resource database. Due to what… Read more
What more can I say. I disagree with the kind of legislation that is being presented via SOPA and PIPA.
In support of the community, my site will be dark 18 Jan 2012 between 10:30 and 21:30 GMT-8.
Normal services will return after that.
You can see support of… Read more
I found myself perusing an execution plan the other day. I know, big surprise there. This execution plan showed me some interesting things I had never really paid much attention to in the past. When I started paying attention to these things, I found myself jumping down a rabbit hole. Read more
Twitter and Your Career
- Why should average Jane or Joe professional consider using twitter?
- What benefit have you seen in your career because of twitter?
But… Read more
SQL Server has means built into it to track possible missing indexes. This used to be found through the use of the Index Tuning Wizard. The process has improved over time (you can sort of see that from my April Fools post).
As luck would have it, I was… Read more
We are now just a few days away from our first meeting of 2012. We have some good content lined up. Check it out here.
I am looking forward to the presentation on XML and would really love to be able to bring Josh back to finish out the… Read more
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or maybe a bad thing or maybe a non-discussion at all. I guess it really depends on the person. For me, I would have been rushing the post so I am… Read more
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a year ago as a gift – but it was on my list of books to read because Jorge recommended it.
I have finally finished reading it… Read more