DBA

Webcam

Webcast Follow-Up: Getting Started with Windows Azure and SQL Databases

Late last month, I delivered a webcast for Pragmatic Works Training on the T’s.  The session was titled Getting Started with Windows Azure and SQL Databases.  In the session, I how data platform professionals can start looking at Microsoft Azure and some of the services and their benefits that are available. The abstract for the sessions is:…

Webcam

Webcast Follow-Up: Leveraging Cloud for the Modern SQL Developer

Similar the post earlier today, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month.  This was is titled Leveraging Cloud for the Modern SQL Developer.  In the session, I discussed how and where SQL developers can look to Microsoft Azure to help in development on data platforms.…

Webcam

Webcast Follow-Up: 5 SQL Server Indexing Myths

Similar to yesterday’s post, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month.  This was is titled 5 SQL Server Indexing Myths.  In the session, I discussed discussed five common indexing myths that I’ve come across over the years. The abstract for the sessions is: There are…

Webcam

Webcast Follow-Up: Introduction to Columnstore Indexes

Similar to yesterday’s post, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month.  This was is titled Introduction to Columnstore Indexes.  In the session, I discussed columnstore indexes and the value that they provide in SQL Server, both in 2012 and 2014. The abstract for the sessions…

Webcam

Webcast Follow-Up: Introduction to Clustered Indexes and Heaps

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

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

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?

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: Choosing Your Clustered Index

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.…

nose picking

Can You Dig It? – Find All Plans for a Database

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…