Sessions & Content

Tags
Search
Conference
Debugging common DAX and Model performance issues
In this session, we will explore real world DAX and Model performance scenario's. These scenarios range from memory pressure to high CPU load. Watch as we will dive into the model and improve performance by going through concrete examples.
From adaptive to intelligent: query procesing in SQL 2019
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?
Identify opportunities for In-Memory OLTP
The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.
Performance Tuning SQL Server on Crappy Hardware
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.
Probelm Solving Using The In-Memory Engine
The in-memory OLTP engine has been around since version 2014 of the database engine, do you need to be a SaaS provider processing billions of transactions a day to use this ?, the short answer is absolutely not and this session will show you why.
Python Pipeline Primer: Data Engineering with DataBricks
Azure DataBricks is a PaaS offering of Apache Spark, which allows for blazing fast data processing! How can data engineers harness the in-memory processing power? Azure DataBricks can be your data ingestion, transformation and curation tool of choice
Using AI to write session submission to SQLBits.
Deep Neural Networks, Long Short Term Memory Models, Data Science, AI, Fun for all the family. Using SQLBits data to write new sessions. Deep technincal but light and fun.
What Else Can Indexes Do?
No pictures of phone books, here. We're gonna look at the way indexes change query behavior for better... and worse.
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.
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.
DirectQuery in Power BI and Analysis Services
DirectQuery best practices in Analysis Services and Power BI
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.
Understanding the Power BI data model
In this session we will look at all the important topics that are needed to get your Power BI modelling skills to the next level. We will cover the in memory engine, relationships, DAX filter context, DAX vs M and DirectQuery.
Benchmarking & Testing In-Memory Performance
Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. This session gives you the details you need.
Benchmarking like a PRO
In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system.
Designing for Concurrency
SQL Server normally relies on concurrency models in order to maintain the Isolation in ACID. As systems scale, this method can go from being a benefit to a hindrance, limiting the concurrency for our applications and hurting performance.
Enhancements that will make your SQL Server roar-SP1 Ed.
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions.
Real world learnings from SQL Server 2016 Migrations
SQL Server 2016 is a class leading Tier One product but how do you get customers to upgrade and migrate? How can you address the "so what" SQL does everything I need to do now?
SQL Server Internals and Configuration for R
Learn how to configure SQL Server 2016 for running R. The individual components and executables installed with R on SQL Server will be explored to understand the internal interactions and processes involved.
Accelerating Business with Mission Critical Intelligence
Join Joseph for a fascinating look into SQL Server 2016 and its unmatched innovation across on-premises and the cloud to help you turn data into intelligent action
<<1234>>