One of the last technical challenges of cloud adoption is right security configuration. This session focuses on Azure Sql PaaS, covers governance, risk management and compliance and provides 8-step process for securing public cloud.
This talk will address how to add the unit testing framework tSQLt to the database deployment pipeline. The purpose is to reduce the cost of validate every change in the database with a fully automated pipeline.
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.
Within Azure we have a rich ecosystem of AI services that can be leveraged to gain new insights into your data. This session will give you an easy to digest breakdown of the key services that matter and how to approach each one. Cognitive Services, Bot Framework, Azure Machine Learning Studio, Databricks, Notebooks, the Azure ML SDK for Python and the Azure ML Service
This session will take a look at better Unicode support, query processing improvements for row store tables, secure enclaves, and other neat things you'll find useful as a modern database administrator or developer.
A walk-through on what is possible analyzing your data with the "R" language.
Tabular Editor, an open source tool for authoring Tabular Models, makes it easier for teams of developers to work on the same model simultaneously. It also provides functionality for automated build and deployment. In short, DevOps for SSAS Tabular.
Azure offers a comprehensive set of big-data solutions that help you gather, store, process, analyse and visualise data of any variety, volume or velocity, so you can discover new opportunities and take quick action. In this overview session, we’ll look at the various components within Azure that make up the Modern Data Warehouse, enable Real-Time Analytics, and support Advanced Analytics scenarios. You should leave with a high level understanding of the capabilities and limitations of each of the products within the Azure Analytics portfolio.
We will review this new feature of ADFv2, do deep dive to understand the mentioned techniques, compare them to SSIS and/or T-SQL and learn how modelled data flow runs Scala behind the scenes.
Azure Databricks support both Classic and Deep Learning ML Algorithms to analyse Large DataSets at scale. The Integrated Notebook experience gives the Data Scientists and Data Engineers to do exploratory Data Analysis, also feels like native to Jupyter notebook users. In this session we will extract intelligence from Higgs Dataset (Particle Physics) by running Classic and Deep Learning models using Azure Databricks. We will also peek into AMl service's integration with Azure Databricks for managing the end-to-end machine learning lifecycle.
Managed Instances can make your cloud migrations simpler, but have their own nuances. Learn about what you need to know to manage this new platform.
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
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.
This session looks at creating a SQL test lab on your workstation. We start by selecting a hypervisor, look at building a virtual machine and then creating a domain controller, a Windows failover cluster and a couple of SQL Servers.
Based on real life scenarios, an audience interactive session.
Learning DAX can be tricky, especially if you have a background in SQL.
In this session we'll look at ETL metadata, use it to drive process execution, and see benefits quickly emerge. I'll show how a metadata-first approach reduces complexity, enhances resilience and allows ETL processing to become self-organising.
In this hour long session we will attempt to include lots of advice and guidance on how to develop code that will easily get approved by your DBA prior to release to production.
Using Azure DevOps and Azure RM templates to created isolated environments for testing PaaS solutions.
Power BI Premium and Analysis Services enable you to build comprehensive, enterprise-scale analytic solutions. This session will deep dive into exciting new and upcoming features.
Various topics will be covered such as management of large, complex models, connectivity, programmability, performance, scalability, management of artifacts, source-control integration, and monitoring. Learn how to use Power BI Premium to create semantic models that are reused throughout large, enterprise organizations.
Step back through the ages and explore how database teams have approached creating environments for dev and test. Learn how, in the new age of provisioning, databases are delivered safer, faster, and more efficiently
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.
SQL Server 2019 includes new query processing features such as batch mode on rowstore, memory grant feedback, approximate query processing, and more. How do these work? Are they as good as Microsoft wants us to believe?
Real-time decisions enabled by massively scalable distributed event driven systems with embedded analytics are re-shaping our digital landscapes. But how do you know which technology to choose? We'll cover the fundamentals of streaming systems, how and why they can deliver value to your business, and a look at options for streaming analytics in Azure
Start your database off right so you can scale when you need to
Graph databases – Origins, how they work, strengths and weaknesses
Let’s dive deep into the Kubernetes Architecture and learn how it works under the hood!
SQL Server 2019 expands on the Polybase feature from SQL Server 2019 by providing a robust data virtualization solution to reduce the need for ETL and data movement. Come learn how new data connectors work with sources like Oracle, MongoDB, CosmosDB, Terradata, and HDFS.
Containers are the new virtual machines. They present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work, how SQL Server runs in them, and how they work in environments such as Kubernetes
The new SQL Server tool designed to help manage your estate
Learn how dataflows can be used to load data in Power BI.
In this session, attendees learn about how to create PowerApps solutions, how to use PowerApps as data entry application for Power BI. How to integrate PowerApps in Power BI and Power BI in PowerApps.
In this session we will learn which processes are required to build a real-time analytical model along with batch-based workloads, which are the foundation of a Lambda architecture.
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.
In this session, you'll learn about the various prebuilt AI/ML models that are available for your consumption through Microsoft's Cognitive Services. Additionally, you'll see examples of how these prebuilt services can be leveraged with SQL Server 2019.
In this session, we will discuss the strategies and thought process one should adopt for modeling and partition data effectively in Azure Cosmos DB. We will also briefly cover related topics such implementing optimistic concurrency control, transactions with stored procedures, batch operations, and tuning queries + indexing
Learn in this session how you can package any database- or server-level permission in a stored procedure with help of certificate signing or EXECUTE AS and why one method is to prefer over the other.
Getting better performance from your ETL
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.
PowerShell loves Power BI. In this session we will take a look at how to manage your datasets, security, monitor licensing and more, all through the ultimate administration interface: PowerShell!
What data profiling is & why you should do it.
Are you curious about Azure Cosmos DB? This is the session for you! Join us to find out what it is, how it compares to other database platforms, and what all the hype is about!
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
Machine Learning is a popular buzzword, but what does it actually look like, and how can we use it? This session will show a number of high level examples of using ML to do some useful and fun stuff, including training a model to play a game
Running SQL Server in containers has huge benefits for Data Platform professionals but there are challenges to running SQL Server in stand alone containers. This session will cover what those challenges are and how Kubernetes overcomes them.
With GDPR and the number of data breaches we see in the news, encrypting sensitive data is incredibly important. In this talk we start with the basics of encryption, moving on to look at the ways we can encrypt data in SQL Server and Azure SQL DB.
Learn how Machine Learning Services in SQL Server is a powerful end-to-end ML platform for customers, on both Windows and Linux. Come learn about the unique value proposition of doing your entire machine learning pipeline in-database – right from data pre-processing, feature engineering, and model training to deploying ML models and scripts to production in secure and compliant environment without moving data out. 
I'll share what I've learned so you can successfully manage SQL Server on Linux!
Learn about the metadata features in SQL Server that describe your database and how they can make documentation, tuning, and maintenance much easier.
With a strong focus on the algorithms used in Machine Learning, we will explore the maths involved to gain a deeper understanding. Using practical examples, with Databricks to consume a dataset and Python scripts to execute the models.
This session is about using the Business Intelligence Markup Language (Biml) to monitor and control your orchestration patterns. By automatically analyzing the results in ETL logs, we’ll be able to automate our staging orchestration!
Have you wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy.
Relationships are present in any data model. Multiple relationships between the same tables and bidirectional filters increase the complexity of this topic. In this session, we discover the complexity behind relationships in complex models.
How to build a Live Data Warehouse using Change Tracking capabilities
Ever wondered how you can add the power of ML to your existing SQL estate without the need to invest in new services? Come to this session to learn about running Python and R workloads in SQL, the PREDICT function, and how to operationalise models in Azure SQL Database
You want to use all the new and sexy cloud based data services like PowerBI, Flow and hosted SSAS, but your data remains strictly on premise. Come along to see how to use the data gateway to connect Azure to your on-premise data.
This session will focus on the new features and capabilities that help you meet compliance and security needs with SQL Server on-premises as well as in Azure SQL Database. This includes the new Static Data Masking, new authentication capabilities, new functionalities in Vulnerability Assessment and Threat Detection as well as Always Encrypted. If you want to know about the latest developments in SQL Security, this session is for you.
Learn to extract meaning from SQL Server performance data
In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then evolve it into a fully scalable Azure BI solution.
„A picture is worth a thousand words“ - compelling visualizations beyond the usual bar, line or scatter plots, produced with the help of the ggplot2 package and friends.
This is a session for the all of you with short attention spans (like me!) In this session, we will rapid fire tip after tip to help you be a better report author. We'll use the popular Microsoft tools, SSRS and Power BI.
Automate SSRS management using Microsoft's PowerShell module
There has always been a challenge of publishing an on-prem developed reports to external clients (non-AD users). Is this achievable with the latest SQL Server 2017 with RLS enabled?
Are you still asking yourself, what is big data? What is HDInsight and how can I benefit from it? which type of HDInsight Cluster should I use? come to this session and find an answer
Learn how to build an Azure Machine Learning model, how to use, integrate and consume the model within other applications, and learn the basic principles and statistics concepts available in the different ML algorithms.
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
Businesses today require real-time information to make better-informed decisions, this requires a new set of tools. In this session you will learn about Azure Stream analytics and how it can help address real-time data scenarios
A tour of Cassandra, a popular NoSQL DBMS
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.
Get the most from Data Catalog with patterns and practices.
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.
Tabular Editor is an open source offline editor experience for SSAS Tabular, which offers lots of features in a simple UI that can vastly improve your productivity when developing Tabular Models at compatibility level 1200+
Mike Prince, Senior Technical Consultant and Independent User of MaxParallel™ reveals how it worked for Ultima Business Solutions and details the levels of performance enhancements they now achieve.
Learn how to build, debug and deploy a chatbot using the Azure Bot Service and the Microsoft Bot Framework.
If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you an end-to-end Data Science project covering the core technologies in Microsoft Data + AI stack.
Best bractices in DAX formulas from real world experience.
This session takes a closer look at Azure Stream Analytics, and how you can make it work in your Projects.
How does Big Data with Hadoop, Cloud Computing in Azure, Self Service BI and “classic” BI with SQL 2016 interact with each other to build a modern enterprise BI architecture at InnoGames? Watch my talk and you will know!
Real-world scenarios and stories of a DBA who has to deal with different database platforms and their constant battle with efficiency. This session will offer neat solutions, demos, and tools to make your job more pleasant.
Introducing the ROC curve and its use in Azure ML.
Microsoft Power BI supports custom visuals from the Office Store (store.office.com). In this session I will demonstrate what is needed for starting building your own.
Selecting the right PaaS components in Azure
We live in a cloud first World, but many organisation still run largely on-premise. This session covers how these organisations can begin their journey and leverage Azure data services.
For anyone frustrated by column-hoarding users and developers
Algorithms like Neural Nets, Deep Learning, SVM and KNN are dominating the Machine Learning world. You don’t need to know the maths behind them but you do need to know how they work in order to use them effectively. This talk will explain just that.
Hierarchies and graphs are the bread and butter of most business applications. SQL Server 2017 comes now with a different approach: Graph Database. You will learn best practices, have fun and will leave with handy scripts.
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.
Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures. I will take you on a journey from nothing to a complete function
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 was released with SQL Server 2008, and almost 10 years later, many data professionals are still clinging to Profiler. It's time to move forward, and in this session I'll show you how.
Combining Always ON Availability Groups and Powershell will make your life easier
Session deals with the database maintenance problems (like defragmentation) in situation of 24/7 system. As we walk through the basic maintenance we keep in mind that our database is big and it takes a lot of time to do the proper maintenance.
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.
You want to make your IT organization better, new software or hardware, new team process, or other significant change? Is you organization’s management are prone to saying ‘No’ to things like this in the past. How do you move forward successfully?
It takes minutes to create and share Power BI reports and users who has relevant Power BI access can do many things in the PBI service. In this session, Prathy will show how having a deployment strategy helps maintaining Power BI service.
So you're thinking about doing implementing data science project in your business? If you fail to plan, you plan to fail, so come to this session to help you construct your data science plan to help you succeed!
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
Row Level Security based on related tables
<<123456>>