Tech Outbound

Current Events

SQL Cruise Sessions

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.

 


Tech Outbound Alaska 2018

August 4 - August 11, 2018

Description

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..

Map

Itinerary



Tech Outbound Alaska 2018 Abstracts

Itzik Ben-Gan

Logical query processing defines the conceptual interpretation of SQL queries based on the SQL standard and the relational model. To me, it’s the most important topic that any T-SQL practitioner should know. A good understanding of this topic will help you write correct and robust queries. You will also learn about common misconceptions, including common bugs that stem from an incorrect understanding of the language.
T-SQL window functions allow you to perform data analysis calculations like aggregates, ranking, offset and more. When compared with alternative tools like grouping, joins and subqueries, window functions have several advantages that enable solving tasks more elegantly and efficiently. Furthermore, window functions can be used to solve a wide variety of T-SQL querying tasks well beyond their original intended use case, which is data analysis. This session introduces window functions and their evolution from SQL Server 2005 to SQL Server 2017, explains how they get optimized, and shows practical use cases.

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.

Buck Woody

Today’s Data Professionals’ job responsibilities are edging closer to those of the future of Data Science than the past days of pure Database Administration. Buck Woody from Microsoft Research will cover an overview of Advanced Data Analysis and Visualization, Machine Learning, and Artificial Intelligence, with a learning plan for each. Buck will de-mystify the terms and show you when and how you can use each – and what you need to learn to implement these features.
To advance and thrive as a valuable Data Professional in the modern workplace it’s essential to understand both how to administer data repositories as it is to understand how Developers access those same sources of data. In this session Buck will cover the basics of the Python Language, how it works in SQL Server, and where you can go to learn more. Requires SQL Server 2017 or later, or Python v. 3.5 or higher.
Buck Woody from Microsoft Research will cover the basics of the R Language, how it works in SQL Server, and where you can go to learn more. Now integrated into the latest versions of SQL Server, R is rapidly gaining importance as the main conduit for Data Scientists to access sources of data. Understanding the access methods and code is vital to the growth of today’s modern Database Administrator. Requires SQL Server 2016 or later, or Microsoft Open R.

Jes Borland

The opportunity for getting in on the ground floor of new technologies happens once in a blue moon. In 2017, Microsoft introduced Cosmos DB, a "globally distributed, multi-model database service". It offers multiple APIs, multiple consistency models, automatic indexing, and guaranteed performance. This revolutionary database system is changing how developers store and work with their data. Jes Borland of Microsoft will cover the features, use cases, and case studies for Cosmos DB. Gain a competitive edge by learning about this emerging technology… Now!
SQL Server Database Administrators have been told for years that their jobs are changing and the biggest culprit may be the newly announced Azure Managed Instances. Azure SQL Database provides for automatic backups, built-in high availability, and easy scaling. SQL Server on prem is your current option for native backup and restore, cross-database queries and transactions, SQL Server Agent, and more. With Azure Managed Instances, you get both! In this class, you'll learn what this Azure PaaS offering supports; how to migrate existing instances and databases; and how to tune, scale, and troubleshoot them. Maintain your technical advantage by attending this session aboard Tech Outbound SQL Cruise.
You need a data platform that can accelerate the decisions for your business to maintain advantages over the competition. Microsoft is developing many new features, and improving existing capabilities within SQL Server to create an intelligent database. Automatic tuning, adaptive query processing, and operational analytics are transforming the relational database you know; while new features are continually introduced into Azure SQL Database. Join Jes Borland from Microsoft to gain an insider’s perspective on investments being made to make your SQL Server databases smarter: enabling your company gain an intelligent edge.

Jason Hall

SentryOne offers an array of performance monitoring and event management tools that empower the Microsoft Data Professional to achieve breakthrough performance with the Microsoft Data Platform.

That sounds like something I would want, but we all know that most great things are often easier said than done. Is it the same with SentryOne? What will I really need to do with these tools in order to unlock the magic that will allow me to become more proactive about managing performance in my data platform?

Jason Hall, VP of Product - SentryOne, provides a pragmatic tour of the tools available from SentryOne, and how they can be used to go from reactive to proactive in as short a time as possible. Whether you manage 5 SQL Server instances, or 500, you will learn how to quickly get a handle on, and ahead of, what's happening day to day.

Learn best practices for proactive issue detection, preventative configuration, automated remediation, task automation, alerting and response, automated maintenance, query tuning, and indexing strategy using SentryOne tools and features.
SentryOne provides much more than performance and event monitoring. Join Jason Hall from SentryOne to learn advanced automation features. We will be making heavy use of PowerShell, Advisory Conditions, Event Chains, and more. As we demonstrate and discuss the inner workings of these features, there will be something to learn even if you don't use SentryOne.
In partnership with SQLskills.com, SentryOne has hosted a visualization for Paul Randal's online wait stats library for the past year. We've used both site and database analytics to uncover the top 10 wait types viewed by visitors. This discussion covers each wait type, with demos where possible, and discusses what should or should not be done to reduce them on your SQL Servers.

Kevin Kline

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!

  • Goal 1: Learn advanced and undocumented methods to see the steps of parsing, binding, algebrizing, and query optimization.
  • Goal 2: Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer.
  • Goal 3: Walk through several examples of SQL queries whose behavior can be greatly improved when you apply what you’ve learned about the algebrizer and query optimizer.

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:

  • Goal 1: Learn how to plan, prepare for, and implement advanced features on SQL Servers, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes.
  • Goal 2: See the performance impact of each of the major feature implementations as they relieve performance bottlenecks.
  • Goal 3: Learn about the trade-offs in applying major new features, tips and tricks, and other advice for achieving enterprise scale in your SQL Server applications.

completed

Tech Outbound Caribbean 2018

February 10 - February 17, 2018

Description

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.

Map

Itinerary



Tech Outbound Caribbean 2018 Abstracts

Argenis Fernandez

  • Linux 101: An Introduction
  • The Storage Landscape in 2018

Tim Ford

Grant Fritchey

  • Disaster Recovery and High Availability in Azure SQL Database
  • Introducing Azure SQL Managed Instances

Joseph Guadagno

  • C# 7
  • Entity Framework Core 2.0
  • ASP.NET Core MVC
  • ASP.NET Core Web API
  • Client-side Development with ASP.NET Core
  • Security and Identity
  • Testing
  • Debugging and Performance
  • Hosting and Deployment
  • Migrating from.NET Framework
  • Docker and Containers
  • ASP.NET Core and the Cloud

Kevin Kline

  • Pitch Perfect: Presenting Ideas That Win Executive Support
  • Getting to Peak Performance: Proactive Database Optimization for DBAs and Developers

Steph Locke

  • Using R to solve ETL Pain Points
  • Data Science Fundamentals – A Hands On No-Maths Approach
  • The Non-Coding Side of Doing Data Science

John Martin

  • Availability Groups with SQL Server on Linux
  • Getting to Peak Performance: Proactive Database Optimization for DBAs and Developers

Chris Woodruff

  • C# 7
  • Entity Framework Core 2.0
  • ASP.NET Core MVC
  • ASP.NET Core Web API
  • Client-side Development with ASP.NET Core
  • Security and Identity
  • Testing Debugging and Performance
  • Hosting and Deployment
  • Migrating from.NET Framework
  • Docker and Containers
  • ASP.NET Core and the Cloud

2017 SQL Cruise Alaska

August 12 – August 19, 2017

Description

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

Map

Itinerary



2017 SQL Cruise Alaska Speakers & Abstract Titles

Bob Ward

  • Inside SQL Server In-Memory OLTP
  • Inside SQL Server Machine Learning Services: Database Intelligence at Scale
  • DBA Scenarios for SQL Server on Linux

Argenis Fernandez

  • Modern Security Attack Vectors against SQL Server Environments
  • SQL Server Faster: All-Flash Arrays for Database Professionals

Allen White

  • You Will Be More Efficient with PowerShell and SQL Server
  • Troubleshooting and Tuning Query Performance with SQL Sentry and Plan Explorer
  • SentryOne Product and Tools Deep Q&A

Grant Fritchey

  • Exploring Execution Plans
  • DevOps and Data
  • Manage Your Azure Databases Using Powershell
  • How to Leverage Redgate SQL Clone for Success

Andrew Kelly

  • Managing Large Volumes of Data
  • Getting a Handle on Your System Performance
  • Query Store – Soup to Nuts

2018 Corporate Sponsors

Thank you to our 2018 Sponsors. We could not do it without your support!

gold ptnrs Gold Sponsors
Sentryone
Redgate
silver ptnrs Silver Sponsors
Kallen Web Design
bronze ptnrs Bronze Sponsors
Mindy Curnutt & Associates Consulting