Posts Categorized: DBA

Webcam

Webcast Follow-Up: Introduction to Clustered Indexes and Heaps

Posted by & filed under , , , .

Last month, I presented a session for Pragmatic Works Training on the T’s titled Introduction to Clustered Indexes and Heaps.  I’d meant to get the Q&A and session materials posted earlier, but somehow getting this post out got a bit “corrupted”, but at least it is finally coming out.  In the session, I discussed the differences between […]

Webcam

Webcast Follow-Up: The Flavors of Non-Clustered Indexes

Posted by & filed under , , , .

Earlier today, I presented a session for Pragmatic Works Training on the T’s titled The Flavors of Non-Clustered Indexes.  In the session, I discussed non-clustered indexes and some of the options available for building them.  It’s a topic I talk about often but is always an important one. The abstract for the sessions is: A non-clustered […]

Webcam

Webcast Follow-Up: Necessary Evils, Building Optimized CRUD Procedures

Posted by & filed under , , , .

Earlier today, I presented a session for Pragmatic Works Training on the T’s titled Necessary Evils, Building Optimized CRUD Procedures.  In the session, I discussed some of the issues surrounding the use of CRUD-based stored procedures and the applications that use them.  Providing a number of tips for identifying performance issues and resolving them. The abstract […]

Webcam

Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?

Posted by & filed under , , , .

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 […]

Webcam

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

Posted by & filed under , , , .

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 […]

Webcam

Webcast Presentation Materials: Building Security Audits with Extended Events

Posted by & filed under , , , .

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 […]

Securing_SQL_Server_Second_Edition

Security Questions: Recommended Security Book

Posted by & filed under , , , .

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 […]