We are excited to announce our sessions for SQL Cruise Alaska 2017 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 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
Based on the successful 500 Level talk at the PASS Summit 2016, this session will provide an internals view of how In-Memory OLTP works for SQL Server 2016 and SQL Server vNext. Because this session is Advanced, it is intended for those who understand the basic fundamentals of In-Memory OLTP but want to learn how the “Hekaton” engine works behind the scenes to deliver the amazing 30x performance improvements seen from customers who have used In-Memory OLTP. This session will include a look behind the scenes at threads, data and index internals, transactions and concurrency, logging, storage, and natively compiled procedures. And since this will be an advanced level session, of course the demonstration of the looking at the Hekaton engine with the debugger is a must (and fun!)
Inside SQL Server Machine Learning Services: Database Intelligence at Scale You are a DBA of SQL Server deploying or considering SQL Server 2016 or SQL Server 2017. Your manager says that Data Science is the “new thing” and there are Data Scientists in your company that need your help. SQL Server 2016 introduced a new capability called SQL Server R Services and you need to evaluate whether this feature is something your company can trust to deploy in production for an enterprise environment. SQL Server 2017 expands this feature to include Python and what we now called SQL Server Machine Learning Services. We will explore and understand exactly how SQL Server Machine Learning Services works behind the scenes so you know how to install it, manage it, optimize it, and have confidence to use this in real prediction analytic workloads. We will use demos so you understand all the components and look at a real enterprise customer case study as part of this talk.
SQL Server on Linux. Can you believe it is happening? The only problem is that your background is Windows Server. You have spent your career understanding how to manage SQL Server in a Windows Server environment. So how will you learn to understand the important fundamentals of managing and troubleshooting SQL Server on a Linux Operating System? This session will cover common DBA troubleshooting scenarios on SQL Server on Linux. In this demo rich session, we will cover various every-day scenarios from troubleshooting startup and configuration to performance and bottleneck analysis. We will discuss existing and new tools that will enable you to effectively manage and troubleshoot SQL Server on Linux. As a bonus we will discuss some internals of the SQL Server Linux architecture as I’ll provide Q&A from interviews with Slava Oks and Robert Dorr (aka the smarter #bobsql), two of the architects and developers behind this exciting new journey for SQL Server.
Today’s attacks are getting smarter, sneakier, and more dangerous than ever. In this session we are going to discuss the different vectors the bad guys are using today to gain access to SQL Server environments. Credential theft (using Mimikatz, for example) are increasingly popular ways to hop onto servers you weren’t supposed to have access to. Pass the hash has certainly evolved, but it’s still a massive issue out there. After this talk, you’re probably going to want to have a chat with your Security team at work.
Whether you manage two servers or two thousand, more and more is expected of us in our daily jobs and the only way to keep on top of the demand is to automate. PowerShell allows you to do that across your Windows Server environment, including SQL Server. In this workshop we’ll introduce you to PowerShell and then cover how you can use it to manage your servers. We’ll spend the first half of the day focusing on PowerShell itself, covering objects (which are just encapsulated data), how to use the pipeline to get the information you need in a way that makes sense, how to write your own functions and modules, how to access and manage Azure VMs and how to use PowerShell remoting to run scripts against thousands of servers. The second half of the day we’ll cover how you can use PowerShell to manage SQL Server, covering SMO (Server Management Objects, the Management API for SQL Server), the SQL Server Provider, which allows you to navigate SQL Server as though it were a file system, the SQL Server-specific cmdlets which allow you to query, backup and restore SQL Server as well as the cmdlets you’ll use to set up and manage Azure SQL Databases.
Getting started reading execution plans is very straight forward. The real issue is understanding the plans as they grow in size and complexity. This session will show you how to explore the nooks and crannies of an execution plan in order to more easily find the necessary information needed to make what the plan is telling you crystal clear. The information presented here will better empower you to traverse the execution plans you’ll see on your own servers. That knowledge will make it possible to more efficiently and accurately tune and troubleshoot your queries.
The amount of data that we consume on a daily basis is growing by leaps and bounds. Techniques that worked fine for managing the data in the past are often not suited to the larger data sets of today. A different mindset is needed to properly manage a large database and still keep it useable for everyone. We will see how utilizing techniques that take advantage of minimally logged and bulk operations are crucial in this regard. Batching operations is also necessary in most cases as well. And utilizing the features such as Partitioning and Column Store Indexes are becoming the norm. We will cover the key aspects of these features and techniques that make it possible to properly manage large amounts of data and still keep performance where it needs to be.
Join us on Norwegian Cruise Line’s Escape as we depart from Miami with port stops in St. Thomas, USVI; Tortolla, BVI; and Nassau, The Bahamas. Enjoy training as we travel through the deep blues of the Caribbean Sea. Three sea 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. This will be our first dual track event with tracks specifically for Data Pros and Application Developers.
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..