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
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
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server Microsoft Certified Master. Second, I failed said exam. While that might be a circumstance for pity, we should all be glad. Where’s the bar? First off, the exam is tough. Anyone that thought that the … Continue reading Cry, Baby, Cry! Failing the MCM Test
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft Certified Master (MCM) Program. The MCM program is Microsoft’s upper tier database administration certification. It is aimed at providing a validation of skills and knowledge for those with 5 or more years experience with SQL … Continue reading The SQL Server MCM Training Has Changed
Last week, a new white paper was released that discusses supportability roadmaps for ISVs. The white paper is Testing and Developing Supportability Roadmaps for Independent Software Vendor Applications. What a mouthful… aren’t you glad you aren’t working at an ISV? Well, even if you aren’t I’d recommend reading this white paper because it applies to … Continue reading White Paper of Supportability Roadmaps
Conference Time! The SSWUG Fall 2010 Virtual Conference is starting today. It’ll go on from today through Friday – if might be getting late but you can still attend the conference. It doesn’t matter if you are in the comforts of your living room, office, or couch. You can still sit back where ever you … Continue reading SSWUG Fall 2010 Virtual Conference Starts Today!
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week. On October 20-22, you can attend a conference from the comforts of your living room, office, or couch. And while you are at it you’ll get to sit in on some incredible presentations, interaction with speakers, and chat with other attendees. All … Continue reading SSWUG Fall 2010 Virtual Conference This Week
Strate SQL 