I've wrapped up my session at my first session at this year's PASS Summit. My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313]. The session appears to have gone really well and the content has been uploaded to the PASS Summit for download. To provide access to the materials now, the slide deck … Continue reading PASS Summit Session Follow-up: The Plan Cache Whisperer
This past Tuesday, I got a chance to speak at the Minnesota SQL Server User Group. It was a great turn out and I wish I had more time to stay for the happy hour. I'll definitely need to make more meetings than I do, specially since I am traveling less now. My topic for … Continue reading PASSMN Presentation Follow-Up: Strategies for SQL Server Index Analysis
Earlier this month, I presented a session for Pragmatic Works Training on the T's on the selecting the clustered index for a table in a SQL Server database. In the session, titled How Do Non-Clustered Indexes Improve Performance?, in this session I discussed the patterns around non-clustered indexes and why you might choose which patterns for … Continue reading Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?
Earlier this month, I presented a session for Pragmatic Works Training on the T's on the selecting the clustered index for a table in a SQL Server database. In the session, titled Choosing Your Clustered Index, in this session I discussed the patterns around choosing clustered indexes and why you might choose one pattern over another. … Continue reading Webcast Follow-Up: Choosing Your Clustered Index
With today's SQL Server instances, there easily be anywhere from a dozen to a hundred databases on a single SQL Server instance. In fact, on my laptop, I currently have almost two dozen databases and these are just from working on projects. Setup a SharePoint server and add a few sites and you'll easily see … Continue reading Can You Dig It? – Find All Plans for a Database
Last Monday, I presented a session for Pragmatic Works Training on the T's on the Microsoft's Parallel Data Warehouse. In the session, titled Recognizing the Parallel Data Warehouse (PDW) Workload, I discussed the role for MPP and PDW in the enterprise and the types of workloads that it can assist with. The abstract for the sessions … Continue reading Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload
Earlier today, I presented a session for Pragmatic Works Training on the T's; which occur every Tuesday and Thursday. In the session, I talked about using SQL Audit (which is based on extended events) and building your own extended event sessions, titled Building Security Audits with Extended Events. In the session, I discussed the need for security … Continue reading Webcast Presentation Materials: Building Security Audits with Extended Events
If you are looking for a presentation that brings together bacon, unicorns, and lightsabers, then you should have seen my presentation this past Thursday for Pragmatic Works Training on the T's. The session was 5 Amazing Reasons DBAs Need to Love Extended Events. In it, I ran through a list of reasons on why extended events … Continue reading Webcast Presentation Materials: 5 Amazing Reasons DBAs Need to Love Extended Events
This past Tuesday, I delivered a presentation for Pragmatic Works Training on the T's. The session I delivered was 5 Ways to Improve Performance through Indexing. The abstract for the sessions is: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this … Continue reading Webcast Presentation Materials: 5 Ways to Improve Performance through Indexing
Seems I managed to make it through all of April without an update to the index analysis stored procedure. It wasn't for lack of using it with clients, but a lack of time to get the changes out the door. A few months back, I added the option to look at just duplicate index or … Continue reading Index Analysis May Update
Strate SQL 