We are excited to announce our sessions for SQL Cruise Alaska 2018. Since 2010 and our first SQL Cruise event our Technical Leaders consist of Leaders in the SQL Server Community; Microsoft Certified Masters, Microsoft SQL Server Most-Valuable Professionals, VMware V-Experts and Microsoft SQL Server Maestros. Furthermore the structure of SQL Cruise means that you’ll never have a Student to Leader ratio greater than 4:1. You’ll never receive this amount of attention from, or exposure to, instructors of this caliber in any other training platform centered around the Microsoft SQL Server platform. Our former Cruisers assert that the core benefit of SQL Cruise is the informal time spent outside of classes – in one-on-one time with fellow Cruisers and Technical Leaders as well as in structured Office Hours periods used for digging deeper into the sessions presented on the cruise or in resolving issues being faced back in your office. However this does not mean we don’t provide structured class time. Most of those structured sessions for 2017 have now been selected and their abstracts are provided below. We will update this page as additional details are finalized.
Join us on Norwegian Cruise Line’s brand new Alaskan flagship: The NCL Bliss as we depart from Seattle, WA with Alaskan stops in Ketchikan, Juneau, and Skagway. Enjoy training as we pass glaciers and remote mountain peaks. A glacier tour, two days at sea through the majestic Inside Passage, and a final stop in Victoria on Vancouver Island also are on tap. Learn while at sea. Network, explore, and relax at night and on land. Two tracks aimed at Data Professionals and Application Developers will be offered..
Itzik Ben-Gan
Handling date and time data using T-SQL is an important area for T-SQL practitioners to know. Almost every table in your database has date and time data, and almost every piece of T-SQL code that you need to write has to deal with date and time data. There are many challenges and complexities when working with date and time data related to writing both correct and efficient code. This session covers date and time types and functions, challenges and best practices, system versioned-temporal tables, and querying tasks.
Skilled SQL professionals know that the SQL Server query optimizer uses a multi-step process to produce execution plans. But what about deeper components like the parser, the binder, and the algebrizer? This session will teach you advanced techniques for query tuning as well as surprising behaviors of the query optimization process that can have a dramatic impact on performance, with special attention paid to the processes controlled by the algebrizer, including associative, commutative, and transitive transformations. We will examine a variety of everyday queries whose performance can be greatly improved by apply a deeper understanding of these internal behaviors. Lots of examples and demos!
You have an OLTP database application sustaining lots of read and write transactions. Performance was fine for a long time, but it is not meeting your needs now that it must scale much higher workloads. What should you do? In this real-world case study, you’ll learn about a series of technologies that provide unprecedented scalability, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes. We will walk you through a chronology of the application and database architecture, its changes over time, and the degree of performance improvement achieved with each new SQL Server feature applied. This session will teach you all about planning and implementing advanced SQL Server performance features and how each one impacts your system performance for applications with 100’s or 1000’s of concurrent users. Here’s what you’ll learn in this session:
Join us on Norwegian Cruise Line’s Escape as we depart from Miami with port stops in Jamaica, The Cayman Islands two stops in The Bahamas. Enjoy training as we travel through the deep blues of the Caribbean Sea. Seven days packed with training, networking, and consulting by our Technical Leads as well as plenty of fun while on land are on deck. As always we get back to the training and our deep dive Office Hours when the ship leaves port at the end of the day. Due to our active hurricane season we will only have two sea days on our revised itinerary so we will also have class for a half day while in Nassau, The Bahamas. This will be our first dual track event with tracks specifically for Data Pros and Application Developers.
Join us on Norwegian Cruise Line’s Pearl as we depart from Seattle, WA with Alaskan stops in Ketchikan, Juneau, and Skagway. Enjoy training as we pass glaciers and remote mountain peaks. A glacier tour, two days at sea through the majestic Inside Passage, and a final stop in Victoria on Vancouver Island also are on tap. Learn while at sea. Network, explore, and relax at night and on land.t