I am planning on visiting Salt Lake City for SQL Saturday in October. Exploring the TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server Using SSRS reports to analyze SQL Server health
I added 2 new reports Top Cache Queries and Top CPU Queries into the Server Health Reports. Here is a screen shot of the latest report, the Top CPU Queries report: Enjoy….
I spent the day today at SQL Saturday in Vancouver BC. I met some fabulous SQL Server professionals, and presented 2 sessions. The first Session was on Unleashing Common Table Expressions in SQL Server. This was the second time that I presented this one, the first was at a SQL Saturday, the first time was SQL Saturday 108 in …
In preparation for my presentation at SQL Saturday in Vancouver BC tomorrow, I have updated the SQL Server Health Reports. As I was preparing for my presentation I discovered a few areas that I wanted to improve on the layout, sorting and overall presentation. Too late for the presentation tomorrow, but I started on the next new report to add …
The SQL Server Health Reports have been updated. As part of preparing for my SQL Saturday 114 presentation next weekend in Vancouver BC, I have updated the SQL Server Health Reports one more time. The latest update included lots of minor UI fixup making the reports look better. Including more summary detail on the main Health Report. Also, additional details …
Part of SQL Server running queries is that once a query is analyzed, parsed and compiled, that compiled plan is kept in memory so that it can be quickly re-used in the future. If you are using proper parameterized queries, most of your queries will get kept around and re-used saving lots of CPU and memory on SQL Server. If …
As I have been working on my SQL Server Health Reports for my presentation at SQL Saturday 114 in Vancouver on March 17th, I have changed the way that I do things several times. After attending a SSRS class “SSRS Beyond the Basics ” at SQL Saturday 108 in Redmond presented by @sqlbelle I learned a few tricks to help make this happen. …
Top IO Report
After my CTE presentation at SQL Saturday 108 in Redmond, I was asked many questions, and received several great suggestions from people. Based on that feedback, I am updating my presentation for SQL Saturday 114 in Vancouver to include some additional content. One question was how does the performance compare between a recursive CTE to generate a hierarchical tree path …
WOW, what a great day at SQL Saturday 108 in Redmond. I started out with a keynote presentation from Buck Woody. Then I delivered my presentation on Common Table Expressions. Which I think went well. There were some great questions and I look forward to refining my presentation to include some of the questions that I was asked at the …