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
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
This past Monday, I presented at TechEd North America for the first time. The session presented was Indexing Fundamentals for Microsoft SQL Server. Indexing is such a huge topic, that it was hard to boil down the fundamentals to a 75-minute presentation, but based on responses I think the resulting session was pretty good. If … Continue reading My TechEd Presentation: Indexing Fundamentals for Microsoft SQL Server
Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work's Training on the T's. A video of the session is available at the Pragmatic Works website. As a part of that session, I received a couple dozen questions about security that we didn't have a chance to go over during … Continue reading SQL Server Security Webcast Questions – Series Introduction
I'm a little late getting the information from my Fargo SQL Saturday session posted, titled "Discovering the Plan Cache". But it's better a little late that never. Even though it was the end of the day, the session had great turnout and lots of good questions. Reviewing my session evals, I saw quite a few high … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat175
Last Thursday, I delivered a presentation for Pragmatic Works Training on the T's. The session for last week was Introduction to SQL Server Security, a part of last month's series of introductory presentations. The abstract for the sessions is: One of the most often overlooked feature sets of SQL Server is it's security features. The focus … Continue reading Webcast Presentation Materials: Introduction to SQL Server Security
We are down to the last few days before first SQL Saturday in Fargo. It's been some work pulling it all together, but with the help of Ted Krueger (Blog | @Onpnt), Sarah Strate (Blog | @DanceM0m), and Jes Borland (Blog | @grrl_geek), we are almost ready for the weekend. The question I have for you is... … Continue reading Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
Strate SQL 