Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload

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

Q&A From “5 Ways to Improve Performance through Indexing”

A few weeks back spoke at a Pragmatic Works Training on the T's on indexing that was titled 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 session, we’ll look … Continue reading Q&A From “5 Ways to Improve Performance through Indexing”

September 2013 – Monthly SQL Server Checklist

It's the first Monday of September and it's time to check up on your SQL Servers.  In truth, it's the second Monday, but for my peers here in the United States, it's the first Monday workday of the month.  The end result, though, is this reminder post is coming a week later than usual for … Continue reading September 2013 – Monthly SQL Server Checklist

Webcast Presentation Materials: Building Security Audits with Extended Events

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

August 2013 – Monthly SQL Server Checklist

I can't believe it's already August.  I had planned to get to the lake more this year, spend more time on the deck, and countless other things that have already slipped by this summer.  It's an easy trap to fall into.  Just make a deal with yourself that, I'll go to the lake next weekend, … Continue reading August 2013 – Monthly SQL Server Checklist

Security Questions: Recommended Security Book

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Recommended Security Book

Webcast Presentation Materials: 5 Amazing Reasons DBAs Need to Love 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

Security Questions: Granting Access with Jobs

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Granting Access with Jobs

Webcast Presentation Materials: 5 Ways to Improve Performance through Indexing

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

Security Questions: Difference Between db_datawriter and db_ddladmin?

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Difference Between db_datawriter and db_ddladmin?