SQLSaturday #492 Phoenix–Jason Brimhall

Jason Brimhall, SSG Principal Consultant and a Microsoft Certified Master, presented SQL topics at the Phoenix SQLSaturday on April 16.

His topics were:

Bare Naked Skinny on SQL Server

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

Working with Object Compression in SQL Server

“SQL Server 2008 introduced object compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What you might not know boils down to some subtleties of compression. For example, not all page compressed objects are entirely page compressed. Many pages can be uncompressed or just row-compressed.

This session shows you how to reach into the database and discover compression states at the page level. At the lower level, this session also shows how to determine compression settings of objects in the database. You can use both some undocumented and more commonly known commands to derive some interesting information from the database engine.

Visit the Phoenix SQLSaturday site for full event details.

 
 
Loading Map....

Date/Time
Date(s) - 04/16/2016
8:30 AM - 6:00 PM

Location
Grand Canyon University

Categories No Categories