Sessions & Content

Tags
Content Type
Search
Conference
"But It Worked in Development!" 3 Hard Performance Problems
You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation?
"Start Small and Grow Big" with Power BI and Azure AS
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.
0 to Hero: Troubleshooting SQL Server Performance Made Easy
Take charge of any performance issue coming your way. "SQL Server is hurting!" Turn feelings to symptoms, and become the hero that saved the day.
50 ways to show your data
„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.
60 Reporting Tips in 60 Minutes
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.
Adaptive query processing in SQL databases
Come learn about the new adaptive query processor in SQL Server 2017 and Azure SQL Database. We will discuss how this feature works, how it can benefit your application and queries, and the future of intelligent query processing.
Administrating SSRS without boring web based clicks
Automate SSRS management using Microsoft's PowerShell module
Advanced Techniques for Cleaning Data using SQL Server 2017
If your organisation doesn't have dirty data, it's because you are not looking hard enough. Join this session to see what you can do to clean up your data properly, using SQL Server 2017.
Advanced-On-Prem SSRS 2017 For Non-Ad Users
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?
Advice and guidance on becoming a speaker or volunteer
Want to become a community speaker or involved in the SQL Community? Don't feel confident enough to try? Need some advice and guidance? We want to help you, we will help you
An End-to-End Approach to App and DB Security
Learn about the methodology to increase security related development practices, backed by real world examples. Including securely accessing a database, properly encrypting data, using SSL/TLS, etc
An introduction to HDInsight
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
An Introduction to Machine Learning
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.
An introduction to SQL Server for data scientists
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
Analyzing real-time data using Azure Streaming Analytics.
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
Apache Cassandra for the SQLServer DBA
A tour of Cassandra, a popular NoSQL DBMS
Azure and SQL Server: Getting the best out of the cloud
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.
Azure Cosmos DB: design patterns and case studies
Come learn about the business goals and technical challenges faced by real-world customers, why they chose Azure Cosmos DB, and the patterns they used to deliver highly available, globally distributed experiences.
Azure Data Catalog Adoption Patterns and Best Practices
Get the most from Data Catalog with patterns and practices.
Azure SQL Data Warehouse Optimizing and Maintaining
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.
Azure SQL Database vs. Cosmos Db. How do you choose?
Focusing on the micro-service / OLTP domain, this talk approaches the challenge of choosing between Azure SQL Database and Cosmos Db (Document Db) by using solution use cases to test each storage's offering for appropriateness.
Back to the future with Temporal Tables
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean.
Best pratices for Power BI on implementation and monitoring
Learn about the component of Power BI and best practices for implementations
Boosting SSAS productivity with Tabular Editor
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+
Breathe Life Back into your MS SQL Server Systems And Cloud Apps With a Much Needed Parallelism Boost
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.
Building a Data Delivery Solution in the Cloud
Case study on using all of the Azure Data Platform and how to build out your optimal architecture.
Chatbots for Dummies
Learn how to build, debug and deploy a chatbot using the Azure Bot Service and the Microsoft Bot Framework.
Confidential computing with Always Encrypted using enclaves
Always Encrypted using enclaves enables rich queries on encrypted data.
Containers and Clones: giant databases on tiny HDDs
Provision dev databases quickly and easily using containers and clones
Creating complex labs from start to finish with Lability
Introduction on how to use the Powershell library Lability to create complex SQL Server based test labs.
Data Overview and Manipulation – T-SQL, R, Python
Before doing any analysis, you have to prepare the data properly.
Data Science For The DBA – Get Started Now
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.
Database Continuous Delivery with SSDT and VSTS
Using SSDT and VSTS to reliably build, test, and deploy SQL Server databases in the cloud and in the datacentre.
DAX Best Practices
Best bractices in DAX formulas from real world experience.
DAX Optimization Examples
In this session we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.
Deep Dive into SSIS 2017 and Beyond
We will showcase the latest feature of SSIS 2017 such as connectors for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), SSIS Scale-Out at package level for the box product as well as the SSIS package execution on Azure Data Factory
DevOps and Data
Learn about data management and DevOps for the modern business.
DevOPS for DBAs-Where is your magic wand?
DEVOPS - a buzzword in IT and how beneficial it is to include within your DBA activities
DevOps, CI and the Data Warehouse
DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse
Dimensional Modeling: Beyond the Basics
In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and also review approaches to creating rich hierarchies that simplify complex reporting.
Dont cross the streams, a closer look at Stream Analytics
This session takes a closer look at Azure Stream Analytics, and how you can make it work in your Projects.
DWH and Microsoft BI in an Online Games Company
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!
Efficiency Tips and Tricks for Multi-Platform Data Client DBAs
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.
Enhancing relational models with graph in SQL Server 2017
This session explores SQL Server 2017's Graph processing to better understand interconnectivity and behaviour in your data.
Evaluating Models: Get Ready to ROC
Introducing the ROC curve and its use in Azure ML.
Execute your custom code in Python/.Net/R @ Scale with U-SQL
In this session, I will showcase how you can bring your Python, R, and .NET code to Azure Data Lake and apply it at scale using U-SQL.
Experience SQL Server 2017: The Modern Database Platform
Looking to upgrade your SQL Server? This session will discuss all the new features and capabilities of SQL Server 2017 including SQL Server on Linux, Docker Containers, Graph Database, Python, Adaptive Query Processing, Automatic Tuning, and HADR.
Experience SQL Server on Linux and Containers
SQL Server 2017 is all about choice. Choice for developers to run on Windows, Linux, or Containers. In this session we will show you the experience of running SQL Server on Linux and Containers including a behind the scenes of how we built it.
Exploring Execution Plans
Learn the details behind how to read execution plans.
Extending Power BI With Your Own Custom Visual
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.
GDPR-How did the Microsoft SQL team approach it
GDPR is affecting any business that stores data including the SQL Server product group. Come and listen to how the Microsoft SQL Team approached the GDPR challenge for the SQL and SQL Azure business.
Graph Data Processing in SQL Server, the “Relationship” db
A look at how the Graph engine introduced with SQL Server 2017 and Azure SQL Database can help you generate insights from your highly connected data
How to Architect Azure for Insights & Analytics
Selecting the right PaaS components in Azure
How to do DevOps for your Data Platform.
Data DevOps is seen as hard. We've been doing it at scale for many years and will walk through the lessons we've learnt, which will enable you to successfully apply DevOps to your Data Platform.
How to get your DB DevOpsd
Resolve the common problems with building an automated DevOps release process. In one hour we will build a deployment pipeline to ensure reliable releases with controls in place. We will show you the techniques we use to make database DevOps possible
Hybrid Data Solutions-how to have you cake and eat it!
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.
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers
Inside the classic machine learning algorithms
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.
Introduction to Graph Processing with SQL Server 2017
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.
Introduction to partitioning
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.
Introduction to Pester-TDD for PowerShell
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
Investigate TempDB like Sherlock Holmes
Learn how to investigate the mysterious case of SQL Server performance problems in TempDB.
Is the DBA Dead?... or Alive (and Preparing for the Future)?
DBAs are living in a world of constant flux. This session analyses research on the how the role is evolving, the concerns facing DBAs today and valuable insights on the DBAs path to career success. Learn how the megatrends of our industry and are shaping the role of the DBA today.
Its Here! The Newly Remodeled SQL Server Reporting Services
Learn about the new features of SSRS 2016 and 2017
Kick Start! SQL Server 2016/2017 Performance Tips and Tricks
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.
Kicking & Screaming: Replacing Profiler with Extended Events
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.
Laying the Foundation for GDPR
GDPR is coming, no matter where you are if you are handling data on European data subjects. Laying a solid foundation of data security practices is vital to avoid the potential fines and damage to reputation that being non-compliant can bring.
Level Up Your Biml: Best Practices and Coding Techniques
Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code, simplify logic, and create your own C# classes and methods. Improve your code and level up your Biml in no time!
Lightning Talks
A series of 5 minute sessions
Man vs Machine: Adaptive query processing and auto tuning
Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL 2017. Adaptive query processing, auto tuning and few other features added into the product.
Maximizing the Query Performance with Columnstore Indexes
Common performance issues with clustered columnstore index experienced by customers and strategies to address them.
Modernizing ETL with Azure Data Lake
Modernizing ETL with Azure Data Lake: Hyperscale, Multi-format, Multi-platform, & Intelligent
Oh SNAP! Who’s got my bak?!?
This session will dive deep into snapshotting of SQL databases
Optimizing your SSDT Deployments v2.0
Ever wondered if you can optimize your sql projects so you don't have to do unnecessary work? Take a look at how I've optimized SSDT Deployments by use case.
Parallel Database Maintenance with 24/7 Systems and Huge DBs
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.
Performance Monitoring Using Extended Events, DMVs & Query S
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.
Performance Tuning for the BI Professional
Come learn how to make your BI projects perform at their max!!
Persistence is Futile-Implementing Delayed Durability
In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput.
Pitch Perfect-Presenting Ideas That Win Executive Support
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?
Power BI deployment strategy for publishing and maintenance
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.
Power BI Premium Embedded
Microsoft announced the retirement of Power BI Embedded and recommended that everyone migrate to Power BI Premium and embed those reports. Unfortunately the documentation on doing this is "light" to say the least. This session will enlighten you
Power BI Report Server: A Deep Dive
So, you think you know everything you need to know about the Power BI Report Server because you use traditional SQL Server Reporting Services. Well, don’t believe it!
Power BI security deep dive
One hot topic with Power BI is security, in this deep dive session we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored andleverage additional Azure services to secure it even more.
Power BI: Adam and Patrick Unplugged
Microsoft's Patrick and Adam answer a lot of questions on Power BI, SSAS and other tech. Those questions result in videos on their YouTube channel. In this session they are going to show a few. Don’t miss out, there is a little something for everyone.
PowerBI-Model Designs
Building effective PowerBI reports and dashboards requires a well-designed data model with the right relationships and measures, this session tackles those challenges your encounter during the design phase and where to get training required for this.
Preparing your business for data science
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!
Pyramid 2018. The Analytics OS.
See the Magic of high-end analytics on any device, on any data source, using any database. Built in machine learning makes sophisticated analytics simple. Collaborate across the enterprise with easy implementation and real self-service analytics.
Query Execution: Expectation-Reality
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
Query Store without SQL 2016 = Open Query Store
Query Store was the cool new feature in SQL 2016, but what about those of us stuck on older versions of SQL Server? Introducing: Open Query Store! This session will explain what OQS is and how it can help you take control of your query plans.
Regressions, neurons and decisions. Oh My!
Linear regression, neural networks and neural networks are three of the foundational algorithms in machine learning. In this session, we'll look at how they work and how they generate the results that they do.
Row Level Security-A real world example
Row Level Security based on related tables
Run your DBA morning checklist with Policy Based Management
In this session you will learn how you can perform your DBA morning checklist with Policy Based Management to evaluate your servers and how I configured my setup.
Scalable deep learning model training with Azure Batch AI
Deep learning is an essential component of an analytical toolbox. There are considerable challenges in training deep learning models and this presentation explores how to overcome these using Microsoft’s scalable ML offering, Azure Batch AI.
Securing your Data is Easier than ever with Azure SQL DB
Securing your Data is Easier than ever with Azure SQL Database: A Walk Around the Security Toolset. This will be a demo-heavy overview of the latest security capabilities available, including the newest intelligent data protection features.
Simplifying XEvents Management with dbatools
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Solving ETL bottlenecks with SSIS Scale Out
Do you have large-scale SSIS platforms which experience bottlenecks due to the number of packages or volumes of data that need to be processed? Yes! Then you need to explore SSIS scale out.
SQL Intelligence excels your tuning and security expertise
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.
SQL Operations Studio: the state of the art and future
Microsoft SQL Operations Studio is a new light-weight, free and multi-os tools for SQL Server, Azure SQLDB and DW running anywhere.
SQL Server Administration on Linux
Come learn how to set up a production-grade SQL Server on Linux environment!
SQL Server and Continuous Integration
Continuous Integration is a method of working with source control that is designed to ease the process of merging code. You will see how a CI approach to database development can reduce the time to go from an idea to production.
<<123456789>>