Sessions & Content

Search
Content Type
Conference
Tags
"But It Worked in Development!" 3 Hard Performance Problems Brent Ozar
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 Rui Romano
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 Pedro Lopes
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 Thomas Hütter
„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 Ike Ellis
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 Bob Ward
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 Cláudio Silva
Automate SSRS management using Microsoft's PowerShell module
Advanced Techniques for Cleaning Data using SQL Server 2017 Jennifer Stirrup
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 Dr. Subramani Paramasivam
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 Rob Sewell
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 Mladen Prajdic
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 Edinson Medina
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 Alex Whittles
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 Gavin Payne
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. Michael Johnson
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 Richard Munn
A tour of Cassandra, a popular NoSQL DBMS
Azure and SQL Server: Getting the best out of the cloud Murilo Miranda
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 Andrew Liu
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 Matthew Roche
Get the most from Data Catalog with patterns and practices.
Azure SQL Data Warehouse Optimizing and Maintaining Robin Lester
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? James Duggan
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 Randolph West
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 Bent Nissen Pedersen
Learn about the component of Power BI and best practices for implementations
Boosting SSAS productivity with Tabular Editor Daniel Otykier
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
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 Joey D'Antoni
Case study on using all of the Azure Data Platform and how to build out your optimal architecture.
Chatbots for Dummies José Mendes
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 Jakub Szymaszek
Always Encrypted using enclaves enables rich queries on encrypted data.
Containers and Clones: giant databases on tiny HDDs Alex Yates
Provision dev databases quickly and easily using containers and clones
Creating complex labs from start to finish with Lability Andre Kamman
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 Dejan Sarka
Before doing any analysis, you have to prepare the data properly.
Data Science For The DBA - Get Started Now Manohar Punna
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 Gavin Campbell
Using SSDT and VSTS to reliably build, test, and deploy SQL Server databases in the cloud and in the datacentre.
DAX Best Practices Marco Russo
Best bractices in DAX formulas from real world experience.
DAX Optimization Examples Alberto Ferrari
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 Jimmy Wong
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 Grant Fritchey
Learn about data management and DevOps for the modern business.
DevOPS for DBAs-Where is your magic wand? Satya Jayanty
DEVOPS - a buzzword in IT and how beneficial it is to include within your DBA activities
DevOps, CI and the Data Warehouse Dr John Tunnicliffe
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 Jason Horner
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 Johan Ludvig Brattås
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 Raúl Jiménez Aguilera
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 Pinal Dave
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 Terry McCann
This session explores SQL Server 2017's Graph processing to better understand interconnectivity and behaviour in your data.
Evaluating Models: Get Ready to ROC Emma Zambonini
Introducing the ROC curve and its use in Azure ML.
Execute your custom code in Python/.Net/R @ Scale with U-SQL Michael Rys
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 Bob Ward
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 Bob Ward
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 Grant Fritchey
Learn the details behind how to read execution plans.
Extending Power BI With Your Own Custom Visual Jan Pieter Posthuma
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.
<<123>>