SQLSaturday 721

Raleigh, United States

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Apr 14 2018 at William Peace University, 15 E Peace Street, Raleigh, North Carolina, 27604, United States

Register Now

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?

Event Location

Event news

New Track Names Read More


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is SQLSaturday?

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, and most costs are covered by donations and sponsorships. At some events you will have the option to pay for lunch at the time of registration. Please register soon as seating is limited, and let friends and colleagues know about the event.

Back to Top