SQLSaturday #330 Raleigh–Randy Knight, Jason Brimhall, Wayne Sheffield
Randy Knight, Jason Brimhall, and Wayne Sheffield, Microsoft Certified Masters and Principal Consultants at SSG, all presented at the SQLSaturday event in Raleigh, N.C. on Sept. 6.
Understanding Transaction Isolation Levels
SQL Server offers several isolation levels beyond the default “READ COMMITTED”. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inappropriate) use cases for each.
Locks, Blocks, and Deadlocks Oh My!
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Crazy Things That Developers Do
Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it’s bad to the database server (or your career)… and alternatives that can be used instead. Trust me… your DBA will love you for making these changes.
Windowing Functions in SQL Server 2012
SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.
Jason’s topic: SQL 2012 Table Compression
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
Date(s) - 09/06/2014
8:00 AM - 5:00 PM
Wake Tech Northern Campus