We may have just wrapped up SQLSaturday Jacksonville, but we're already planning for SQLSaturday New York City! Several of our consultants will be presenting on topics ranging from Azure to Performance Tuning in the Big Apple in just a couple of weeks.
When: Saturday, May 30, 2015
Where: 11 Times Square, Microsoft New York Metro District Office, New York, NY 10036.
Additional precon sessions will be held at the Times Square Microsoft Office on Friday, May 29, 2015.
Welcome to your opportunity to learn all about SQL Server! Come join SQL Server MVP Bradley Ball for a full day of Performance Tuning. This session will cover baselines, waits and queues, extended events, hardware, pre- and post-configuration checklists, OS patching, query optimizer, plan cache, locking, blocking, deadlocks and more!
In this session, you will learn how to create a data factory to copy data from an Azure Blob to a SQL database. After working through that solution, you will look at how to use the Data Factory with HDInsight on Azure and Machine Learning activities.
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap.
In this session, we're gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we'll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.
In this session, you will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works. This is the first step in learning how to use the Optimizer's rules to make your queries faster!
Plan on attending #SQLSatNYC? Tweet and let us know! @PragmaticWorks