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 is offering a half day virtual conference … Continue reading SSWUG Free SSIS Expo
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 I mentioned a few months back, it is important … Continue reading SQL Server 2005 Service Pack 4 RTM
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of those people submitting a session. I’m not going to be a pot calling the kettle black. Below are the two sessions that I submitted. Hopefully they will appeal to enough people that I’ll get a … Continue reading SQLRally Session Submissions
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 some RING_BUFFER_OOM messages in the sys.dm_os_ring_buffer. This can … Continue reading Viewing RING_BUFFER_OOM Errors
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 to generate RING_BUFFER_OOM errors in sys.dm_os_ring_buffers. Setup For RING_BUFFER_OOM … Continue reading Generating RING_BUFFER_OOM Errors
Go SQL! Go SQL! It’s the last day and the last chance (last dance?) to submit a session for the upcoming SQLRally! 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 Summit, SQLRally will be capped to 500 people. … Continue reading Last Call SQLRally Call for Presenters
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt When I started using XQuery to dig into the plan cache, it was just searching for some parallelism and I really wasn’t aware that I was using XQuery. I just … Continue reading Can You Dig It? – Missing Indexes
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 studying through my blog and noting the things … Continue reading MCM Live Blog – Week December 13
It's a map! Have you been looking for something inside the system views of SQL Server 2007 R2 and haven’t known where to look? Tired of trying to figure out how to tie all of the system views together? Need a great new colorful way to spruce up your cube? If these or other questions … Continue reading SQL Server 2008 R2 System View Map
If you've been trying to come to the blog lately, you may have noticed a few errors connecting. Resources not available issues or content just not showing up. It appears that running a WordPress blog on a GoDaddy Windows server has some issues. It works for a while and then it just doesn't. And the whole … Continue reading Blog Under Some Repairs
Strate SQL 