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
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
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In the lead in to this post, I talked about how the plan cache can be a gold mine of information. There are a number of places that one can … Continue reading Can You Dig It? – Parallelism in the Plan Cache
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In this new series of posts, I plan to investigate the SQL Server plan cache. We’ll start with a little introduction of the plan cache and move into ways in … Continue reading Can You Dig It? – The Plan Cache
Strate SQL 