SQLSaturday 473

Cleveland, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Feb 06 2016 at Hyland Software, 28500 Clemens Rd., Cleveland, Ohio, 44145, United States

Register Now

Welcome to SQLSaturday

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.

Parking & Venue Maps

Pre-Conference Sessions

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.

Recommended Hotels

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:

Hilton Option:

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.

Marriott Option:

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.

Event Location

Event news

No Event News entered. Please come back later and check again


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids