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?
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.
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.
„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.
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.
Automate SSRS management using Microsoft's PowerShell module
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.
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?
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
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
Learn what Azure Analysis Services is, when to use it and how to build Tabular models for it
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.
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.
Get the most from Data Catalog with patterns and practices.
Let’s understand the role of this hyper-scale two tier big data technology and how to harness its power with U-SQL, the offspring of T-SQL and C#. We’ll cover everything you need to know to get started developing solutions with Azure Data Lake.
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.
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 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.
Learn about the component of Power BI and best practices for implementations