Learn the ins and outs of Azure Data Lake in this deep dive
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at the design considerations for clustered indexes and for nonclustered indexes and see how queries use them.
Containers are a new and exciting technology but what does it mean for DBAs? This session will give an introduction into SQL Server running in containers and what options are available.
Continuous Integration has not yet been fully integrated into our BI standards and methods. Tool support is still somewhat unsatisfactory. Let’s look into requirements for a SSAS solution and on ways to approach your self-made solution.
With the latest release of SQL Server Reporting services, more and more organizations are adopting it as an organizational reporting solution. Join this session as I explain how to architect and deploy a scalable and highly available solution.
An example of how Azure Data Catalog lets users understand and consume data sources.
We’ll share in the session best practices of designing highly available SQL Databases in the context of cross region deployment; how to make your application robust to handle transient connectivity issues.
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.
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.
Come to this session to learn about AzureSQL DB migration approaches, challenges, and solutions from SQLCAT. We will present practical migration guidance and learnings from our engagements with high scale and complex customer migrations
In this session you will learn how to use Extended Events and Dynamic Management Views (DMVs) to build a performance-monitoring system for your database environment.
Demonstrating an end to end IoT solution providing real-time sensor data from a Raspberry Pi into an Azure IoT Hub, through Stream Analytics, then with outputs to Power BI and SQL DB. Learn how to build this simplified IoT solution from scratch.
A practical look at the components of Cortana Intelligence Suite.
Have you ever considered a situation where Columnstore Index can be quite the opposite of what one expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources ...
Columnstore Engine killed OLAP ... or did it really ?
Learn how to use this fantastic package in R for high-speed, low-code table wrangling.
Data architects and DBAs have debated database design best practices for decades. Join us for some great debates and laughs.
In this session we will review the new enhancement to SQL Server security available in SQL Server 2016 and Azure SQL DB.
The Analysis Services model used in both Power BI Desktop and SSAS allows solving of very complex modelling issue. In this session we will look at solving several complex modelling problems like many-to-many and RLS.
A session to understand the available functionality of SSISDB Catalog
Temporal Tables as a new technology in Microsoft SQL Server makes the implementation and management of data histories so easy. In this session, discover ALL the secrets of System Versioned Temporal Tables.
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.
Make the right career move impressing your CEO and C-Level suite executives! Meet their specific needs with the right metrics and data visualisation. Power BI can help to bring clarity & predictability to the CEO to make strategic decisions.
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions.
A look inside SQL Server distribution statistics
  1 to 25 of 930 first 1 2 3 4 5 6 7 8 9 10  next last  Show 10 25 50 100 sessions per page