Archives: December 2010
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
We’re up to the seventh post on the in the plan cache series. This time we’ll be talking about the last of the possible children for the Statements elements – the StmtSimple element. StmtSimple, commonly referred to as statement simple, can contain… Read more
If you are in Minnesota and are looking for a new job, Digineer is hiring. Heck you can even be one of those that has been thinking – “I would love to move to Minnesota because I love the thought of their frigid winters” – and need that job to… Read more
It’s time to wrap up the year. I don’t have a resolutions or goals post from last year to re-cap so that leaves this post fairly open ended. At some point a couple years ago I read an article about not publicizing your resolutions to help keep you… Read more
A few posts ago in the plan cache series I discussed the children for the Statements element. I’ve gotten through two of the elements and in this post we’ll be looking at the StmtCursor and StmtReceive elements.
The SHOWPLAN XML schema defines both… Read more
Time for the third week of blogging about the things that I’m doing to study for the MCM exam. Last week wasn’t too spectacular – with the holidays and all I was pretty lazy on the studying. The formatting issues did get fixed, so if you see… Read more
A couple posts ago in the plan cache series I discussed the children for the Statements element. This next post will focus on the second of the five possible child elements – the StmtCond element. You might want to call this the “Statement… Read more
The last post in the plan cache series discussed the children for the Statements element. As I noted in that post, there are five possible children. This post will focus on StmtUseDb. Or as little children sometimes say “Statement Use Database”
As the… Read more
Time for the second week of blogging about the things that I’m doing to study for the MCM exam. It seemed to go pretty good last week except for the whole screwing up the TweetMeme and ShareThis plugins on my blog. As I mentioned in the first… Read more
In the last couple plan cache posts, I talked about a couple items that are available within the SHOWPLAN XML for an execution plan. These posts looked at how to find execution plans that utilized parallelism or contained information on missing indexes Read more
Want to learn some stuff about SSIS? Want to do it from the couch and not have to get up for the whole morning?
If so or if the two opening questions intrigued you enough to get this far – then I have the answer for you. SSWUG… Read more
Just in time for Christmas, SQL Server 2005 Service Pack 4 has RTM’d. If you are using SQL Server 2005 make sure you take a look at this and the Microsoft SQL Server support lifecycle to see that you have the coverage that you need.
As… Read more
Below are the two sessions that I submitted. Hopefully they will appeal… Read more
A client asked a co-worker to take a look at a query for reviewing RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. He remembered that I’ve recently had a thing for XQuery and asked me to take a look at it.
To play around with the output of this query, generate… Read more
Ever think to yourself, “hmm, I wish I could generate me some RING BUFFER_OOM errors”? This request happened to come up tonight.
Of course, the person asking for this was myself, but an answer was found nonetheless. Below are a couple scripts that can be used… Read more
Some details if you are on the unawares – SQLRally is a 3-day SQL Server conference that will occur in Orlando, FL. Unlike the PASS… Read more
Fast forward a couple… Read more
Happy holidays and seasons greetings!
Don’t forget, PASSMN meeting is today. As I’ve said before, we’ve teamed up with the new Minnesota PowerShell user group to put together this month’s meeting.
Date and Time:
- December 14, 2010, 5:00 PM CST
- 8000 Norman Center Drive,…
If you’re reading this, it must be Monday morning. Oh dear, that means I am officially starting my public studying for the Microsoft Certified Master (MCM) exam. I’ve already failed this exam once and am not really up for failing again. To help prevent this, I figured… Read more
Happy holidays and seasons greetings!
Let PASSMN put a little SQL and PowerShell in your stocking this week. On Tuesday, Minnesota’s new PowerShell user group and PASSMN will be having a combined meeting.
The topic will, of course, cover both PowerShell and SQL Server. The… Read more