We introduce the concept of aggregation, we show several examples of their usage understanding the advantages and the limitations of aggregations, with the goal of building a solid understanding on how and when to use the feature in data models.
In this session, we’ll look at the different options within the Cognitive Services suite, show you how to connect to the APIs using Python code, walk through a live bot demo, and build an Azure Cognitive Search index. You should leave this session feeling like you’ve had a jump start to further your AI developer skill set.
Based on real life scenarios, an audience interactive session.
The video is not available to view online.
SQL Server provides a wealth of tools in the box to help you spot troublesome queries. We'll explore those and examine how they can best be used.
Start your database off right so you can scale when you need to
Everyone that has been involved in Software Development can notice how huge the impact of a bug can be, and Databases are not the exception. In this session, you will learn how to test your SQL Server projects using Visual Studio and SQLUnitTesting.
The video is not available to view online.
Getting better performance from your ETL
The video is not available to view online.
This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. Learn tips and tricks on how to reduce IO,relieve memory pressure, and reduce blocking.
The video is not available to view online.
Learn about the metadata features in SQL Server that describe your database and how they can make documentation, tuning, and maintenance much easier.
Learn to extract meaning from SQL Server performance data
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds, reducing operational costs.
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
Introducing the ROC curve and its use in Azure ML.
For anyone frustrated by column-hoarding users and developers
Session will be aimed at Database Administrators\Developers who have not previously implemented partitioning within an OLTP database and is designed to give a overview into the concepts and implementation.
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
Azure SQL Database built-in intelligence features will help you improve performance and security of your database and dramatically reduce the overhead of managing thousands of databases.