We are pleased to offer 3 full-day workshops on Friday, April 13th:
Architecting a Data Lake - Melissa Coates
This full-day session on Friday, April 13, 2018, will focus on principles for designing and implementing a data lake. There will be a mix of concepts, lessons learned, and technical implementation details. This session is approximately 70% demonstrations: we will create a data lake, populate it, organize it, query it, and integrate it with a relational database via logical constructs. You will leave this session with an understanding of the benefits and challenges of a multi-platform analytics/DW/BI environment, as well as recommendations for how to get started.
Linux Power Pre-Con For The DBA - Kellyn Pot'vin-Gorman
In this pre-con, attendees will arrive with their laptops with Docker and the Linux image of SQL Server 2017 ready to go. The image and instructions can be found at https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker.
We'll use Docker and the newest SQL Server 2017 image to go from the A to Z of Linux, learning how to navigate, manage and manipulate Linux. We'll learn best practices surrounding file systems, security and database management.
Once we've become comfortable with the basics, we'll move onto more advance features and tools that have become the savior of DBAs working on Linux/Unix system for decades.
SQL Server Internals For Performance - Kalen Delaney
We all know that the answer to almost any SQL Server tuning question is “It Depends!”
In this seminar, I’ll tell you what you need to know in order to figure out what it actually depends on! How can you answer these “It Depends” questions in your own environment? We’ll look at what kinds of tuning changes can be made to enhance your system or application performance, and what areas of SQL Server Internals you need to understand to make the best choice for you when trying to answer the following questions:
1. Should we build a clustered, nonclustered or columnstore index?
2. Is reusing cached query plans a good thing?
3. Should Read Committed Snapshot Isolation be enabled?
4. How many files should tempdb be configured with?