Learn how to use Query Diagnostics in Power BI. See how to record traces, diagnose steps, and get performance information, as well as how to look for what folded and visualize performance.
Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straight¬forward as one may wish, but it is marred with inconsistencies and surprises. This session starts off by displaying the some of the surprises you can encounter, both when you use TRY-CATCH and when you don’t. The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling “fancy”, although it may seem to be a good idea in theory. The session also covers a few things to think of on client level.
Putting machine learning into production remains a challenge even though the algorithms have been around for a very long time. Here are some blocks: – the choice of programming language – the difficulty of scaling – fear of black boxes on the part of users Azure Machine Learning is a new service that allows to control the deployment steps on the appropriate resources (Web App, ACI, AKS) and especially to automate the whole process thanks to the Python SDK. This session offers an end-to-end demonstration.
Customers and users increasingly demand more personal and prompt communication from companies and brands with which they interact. How can data professionals help fill that need? The incredible power and instant accessibility of the Azure Cognitive Services Language and Speech APIs, combined with other Azure services, put the power in our hands. From translating between languages to make communication more efficient to analyzing support communications to ensure customers are happy, Azure Cognitive Services allows data professionals to enhance a brand’s interaction with and impression in the customer community. This demo-heavy sessions walks through practical applications of these APIs that you can apply at home or at work immediately after the session.
Security nowadays is just a buzzword. Even so, by joining this session, we discover together what are the most important security best practices that you need to have in mind when you work inside the cloud – inside Microsoft Azure.
Indexing in SQL Server is both - art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes. In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.
Deep Dives into the Storage and Data Pools in SQL Server 2019 Big Data Cluster