We are offering two all-day pre-conference sessions on 2/5/16 at Hyland Software. Tickets are $125 (plus EventBrite fees).
Everything You Never Wanted to Know About Extended Events
Let's cut to the chase: it's time to start using Extended Events (XE). We know you have your reasons for avoiding them, but it's time to leave SQL Trace and Profiler behind and enter the new world of XE. This full-day pre-conference session leaves nothing out.
In order to be ready to fully use Extended Events when you walk back into the office after PASS Summit, we'll provide a full day of training where you will learn what Extended Events are, how they work, and how to create XE sessions that capture the data you need while minimizing the impact on system performance.
In addition, we'll step through complex issues using advanced troubleshooting so you can see how XE will help you solve problems that you couldn't with Trace. This is your opportunity to learn exactly what you need to start using Extended Events in your SQL Server 2012 and 2014 environments.
Presenter: Jonathan Kehayias
Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification and has been a SQL Server MVP for many years. Jonathan is heavily involved in the SQL community; including being the top answerer on the MSDN Database Engine forum, writing deep technical content on his blog (plus his old blog), and answering questions as @SQLPoolBoy on Twitter.
Jonathan is the world authority on Extended Events—he wrote the definitive whitepaper on Extended Events for Microsoft, authored the Extended Events Manager SSMS add-in for versions prior to SQL Server 2012, which won the PASS 2008 SQL Hero contest, and blogged a month-long series on Extended Events that illustrates many practical uses for Extended Events. He has a thirst for knowledge and digging into the innermost workings of SQL Server that is truly inspiring. Jonathan constantly impresses us with how much he knows and how quickly he adds new areas of expertise to his already impressive repertoire.
Building a Scalable SQL Server
Almost anyone can install SQL Server, really. It is pretty darn easy. Too easy!
What takes knowledge and experience is setting up SQL Server in a way that promotes scalability.
Parallelism, Memory Management, Recompilation, Fragmentation…these are all things that can make or break scalability. There is a big difference between SQL Server “out of the box” and a SQL Server that can effectively run a mission critical business platform.
This full day pre-con will provide you with critical information, knowledge, examples, a workbook and take home scripts specific to the installation, setup and mechanisms within SQL Server that most directly affect scalability.
The session will cover:
- Virtualization Considerations for a Scalable SQL Server
- Windows OS - How to maximize the Windows platform for SQL Server
- SQL Server Configuration Options
- Trace Flags to Add and Consider
- TempDB (Placement, File Quantities, Sizing, Contention Detection)
- Data Structures (File Groups, Files, Data Types)
- I/O (Spinning Disk & RAID, Random vs Sequential IO, SSDs, SAN/NAS)
- Indexes (Clustered, Non Clustered, Unique, Covering, Included Columns)
Attendees are encouraged to bring their own laptop with an instance of SQL Server installed.
This is a beginner to intermediate course. Prior SQL Server Administration experience is helpful. This class is geared toward those with 1-5 years of SQL Server Administrative experience.
Presenter: Mindy Curnutt
Mindy Curnutt is a SQL Server MVP and has been actively involved in the SQL Server Community since 2000. She has presented at her local North Texas SQL Server User Group (2002, 2003, 2015), SQLPASS Summits (2005, 2006, 2012, 2013), and numerous SQLSaturday events (2013-2015). She was a SME for both the SQL 2012 and 2014 Certification Exams and is an MSPress Books co-author. Mindy works for Trimble Navigation/TMW Systems as a distinguished engineer and the director of database architecture.
The SQL Saturday planning team has secured room blocks with discounted rates at the Hampton Inn and Marriott Courtyard hotels. Please find the hotel information below:
Hampton Inn Cleveland Westlake
29690 Detroit Road
Westlake, OH 44145
Booking Instructions: Call (440) 892-0333 and mention "SQL" to make a reservation with the discounted rate of $98 per night, before taxes and fees.
Courtyard Cleveland Westlake
25050 Sperry Drive
Westlake, OH 44145
Booking Instructions: Call (440) 871-3756 and mention "SQL Saturday Cleveland" to make a reservation with the discounted rate of $87 per night, before taxes and fees.