SQLSaturday #314 Providence–Randy Knight and Jason Brimhall
Randy Knight, President of SSG and a Microsoft Certified Master, and Jason Brimhall, a recently designated SQL Server MVP and also an MCM, participated at the SQLSaturday event in Providence on Oct. 18.
Randy had two presentations:
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.
Jason’s topic was Murder They Wrote
Jason will examines numerous database design and coding implementations he has seen over the years. He’ll explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy. This is the solo version of the joint version normally done as an all-day precon.
Find full event details on the Providence SQLSaturday event site.
Date(s) - 10/18/2014
8:30 AM - 5:30 PM
Categories No Categories