Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. Join Microsoft Certified Master of SQL Server, Amit Bansal, and find your way out from the dungeon. In this webinar you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. This webinar will be an eye-opener for you. Assured.
SQL Server Integration Services (SSIS) has been a known ETL tool for enterprises to transfer data from one data source to another. Azure Data Factory (ADF) is a managed service on the cloud providing the ability to transfer data from one data source to another irrespective of whether the data source is on-premises or on the cloud. ADF v1 release provided the ability to build datasets, activities and pipelines for data movement. With ADF v2 (preview) release, now we can lift and shift on-premise SSIS packages to run on Azure. In this webinar you will learn about: (a) Introduction to Azure Data Factory (b) Components of Azure Data Factory (c) ADF v1 vs. ADF v2 (preview) Features (d) Lift and Shift on-premises SSIS package to Azure
You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you. In this webinar Hamish will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration & Continuous Delivery. Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team. It also involves automating tests around the integrated work Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments. Database migrations/changes are an area that may not be typically automated or utilize Continuous Delivery. Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Power BI helps you build appealing visualizations of your data. With ever growing footprint of data it is equally important to get real-time insights into your data. It can be as simple as monitoring a single metric or viewing real-time sales performance across multiple locations. Power BI real-time streaming enables you to stream data and update dashboards in real-time. Any time sensitive data can be a source of streaming data set like IoT sensor devices, social media sources, service usage metrics etc. In this webinar (1) I will dive deep into real-time analytics with Power BI. (2) How to build streaming tiles in Power BI Dashboards. (3) Demo using Power BI REST APIs. (4) Demo using Azure Event Hub and Azure Stream Analytics.
Automatic Tuning and Adaptive Query Processing are perhaps the two key features of SQL Server 2017 and Azure SQL Database which would influence query optimizer's plan choices. This webinar will provide an overview of the features and explain how it can help to address performance issues like parameter sniffing, plan regressions, lack of indexes or too many indexes without any manual intervention and change of code.