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
Drill into SQL Server 2016 Operation Analytics
Lindsey Allen will peel back the curtain on SQL Server 2016 new feature Operational Analytics. We continue to invest heavily in in-memory technology and have now introduced one of the more important features we are releasing as part of SQL Server.
Effective Indexing with Partitioning and Compression
We all know that correct indexing is king when it comes to achieving high levels of performance in SQL Server. When indexing combines with the enterprise features partitioning and compression, you can find substantial performance gains.
Enhancements that will make your SQL engine roar #1
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Enhancements that will make your SQL engine roar #2
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
How to start with In-Memory OLTP?
In this session, we will introduce a step-by-step approach to adopting the technology, aimed at beginners who are interested in how it can fit into their own environments.
Leveraging Memory With The Database Engine
An advanced look into how memory works in modern servers, on modern processors and how to leverage it with SQL Server.
Optomizing SQL Server Performance in a Virtual Enviroment
In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.
SQL Server 2016 Hero Features in a Customer Scenario
This sessions covers the SQL Server 2016 Hero Features and you will see a real customer scenario demo showcasing the Full Lifecycle of Financial Data.
SQL Server 2016, New Features & Enhancements
SQL Sever 2016 is just around the corner and with it come some great new features and enhancements to existing capabilities, in this session we will look at some of these and understand how they might make us change the way that we look at designing
Building an Operational Data Store using SQL Server in Azure
This presentation will focus on techniques and practices for using memory optimized tables in SQL Server to build “warm” data stores from a variety of application data sources (logs,traces, performance statistics)
Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit
This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites
In-Memory OLTP, how to use it
We have all heard about In-memory OLTP and how fast it can go, but just how do you use it? In this session we will look at how to migrate a system to use this new capability.
Life saver-Resource Governor for applications & reporting
There are still environments which serve one single SQL Server database for both critical applications & reporting. Budgeting issues and infrastructure bottlenecks kill the application to be better managed and maintained. What could be the solution?
My top 5 new features in SQL Server 2014
SQL server 2014 is one of their measure releases. Where Microsoft has done a superb job. There are so many enhancement we have in SQL Server 2014. In my session I will show you my top 5 features.
Query Optimizer: What’s New in SQL Server 2014
This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. Topics include Hekaton, the new cardinality estimator and incremental statistics.
Scaling the DVD Store from 100 to a million TPM
Come along to see us attempt to optimise and redesign the “Dell DVD Store” sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.
SQL Server 2014 In-Memory OLTP Deep Dive
Hekaton is the Greek word for 100 - the goal of In-Memory OLTP in SQL Server 2014 is to improve query performance up to 100 times. In this session we will look under the cover of Hekaton and the Multi Version Concurrency Control (MVCC) principles.
SSAS Tabular from the Trenches
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
Stored Procedures vs Ad-Hoc SQL: Performance Showdown!
Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail!
Superscaling SQL Server 2014 Parallel Insert
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.
Troubleshooting the Memory of SQL Server
Memory is one of the most confusing and least understood topics for SQL Server. In this session, we will discuss and demonstrate tools and techniques for memory related problems that can occur with the SQL Server Database Engine.
Understanding & Solving Columnstore Problems
Dive deep into Columnstore Indexes and discover their advantages and some of the limitations. Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode & Query Processing with another depth.
Latches, Spinlocks, and Lock Free Data Structures
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
SQL 14 In-memory OLTP : Architecture to Implementation
What is In-Memory OLTP? How is it architected? Where can I use in-memory technology in my solutions? Learn this and more from the Microsoft team
SQL Server In-Memory OLTP and Flash
Learn how flash storage accelerates In-Memory OLTP performance. We will also cover limitations with SQL Server In-Memory OLTP.
Optimizing SQL Server Performance in a Virtual Environment
In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.
Real World Data Movement with Attunity Replicate
In this lunchtime session, Attunity will highlight real customer implementations of Attunity Replicate and the Microsoft BI technology stack that enabled them to achieve competitive advantage.
SQL Server 2012 Memory Management
SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one, discover all these important changes
Troubleshooting the most difficult SQL Server problems
Do you have enough from "normal" performance tuning sessions? You can't hear anything about Indexing and Execution Plans anymore? Then you are right in this session!
Analysis Services 2012 Tabular Mode Best Practices
In this session we'll understand the best practices of using this new technology. What exactly is it good for? When to use it and when NOT to? Migration, Security, Administration and other tips and tricks.
<<12>>