Opis warsztatu In this workshop, you will be introduced to the Microsoft Azure Cognitive Services, a range of offerings you can use to infuse intelligence and machine learning into your applications without needing to build the code from scratch. We will cover pre-trained AI APIs, such as computer vision and text analytics, that are accessed…
Opis warsztatu If you’ve wondered how SQL Server works in the Microsoft Azure cloud, then this hands-on workshop is for you! You will learn all available options for running SQL Server databases in Azure. More importantly, you will work with Azure SQL Database yourself hands-on in cloud-only and hybrid cloud contexts. Azure Pass vouchers will…
Opis warsztatu Failing to deliver a well-designed Power BI Report is a common reporting pitfall. High-quality data models lose meaning if presented in a poorly designed report. Well-designed reports should convey information accurately and efficiently to a non-technical user by telling a story with the data. Data stories are told by leveraging key performance indicators,…
Opis warsztatu I’m Erik Darling, and I want to make you a better performance tuner. No more getting lost in query plans, creating the wrong indexes, or having the same problems come back over and over again. You’re going to learn how to approach query tuning and get results like a pro. Whether you need…
To get to the next level of understanding your database, to reach an intimacy with query plans so that you really know what’s going on, to be able to address performance issues with confidence, you need to picture things differently. This workshop will demonstrate database internals without a computer, helping you learn what happens when…
Query tuning within SQL Server can be a tough skill to master. The new tooling released with SQL Server 2016 and 2017 changes how you identify poorly performing queries, troubleshoot their behavior, and tune the queries, all a little easier. This workshop teaches new techniques for tuning queries using all the new tools introduced in…
I’ve been immersed in the world of our favorite data platform as an end user, developer, DBA, and performance analyst since 1997. I have observed, developed, and broken countless bad habits and discovered many best practices through numerous experiments, trial and error, community interaction, and direct access to the product team at Microsoft. In this…
Itzik-BenGan This seminar covers advanced aspects of T-SQL querying and programming with a performance-centric focus. The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. The seminar also covers the newest additions to T-SQL in SQL Server 2016 and 2017, and some of the…
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…
Niko Neugebauer Learn practical Columnstore Indexes tips and tricks such as which type to use, how and when to use Disk-Based vs. In-Memory or Clustered vs. Nonclustered, how to load data into Columnstore in the most efficient way, and how to get the best performance possible out of the Batch Execution Mode. With a nod…
