Sessions & Content

Search
Content Type
Conference
Tags
SQL Server Table partitioning – DOs and DON’Ts Margarita Naumova
When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?
Modeling data and best practices for Azure Cosmos DBs SQL API Theo van Kraay
In this session, we will discuss the strategies and thought process one should adopt for modeling and partition data effectively in Azure Cosmos DB. We will also briefly cover related topics such implementing optimistic concurrency control, transactions with stored procedures, batch operations, and tuning queries + indexing
Partitioning Party James C Yarrow
Database Partitioning has been around for a while but is always being updated and enhanced. In today big data volume world, we to think how we are going to support these large tables.
Scalable real-time insights with Azure Stream Analytics Microsoft
Azure Stream Analytics is a fully managed serverless offering that enables customers to perform real-time data transforms and hot-path analytics using a simple SQL language. In this session, we will show how to combine SQL reference data to augment data coming from devices and create real-time alerts, leverage partitioning to write data to SQL at high speed, and create real-time dashboards.
Understanding Gremlin and Azure Cosmos DBs Graph API for SQL Professionals Dave Lusty
Azure Cosmos DB has many use-cases, and not all of them are clear to Azure Cosmos DB newcomers. If you're a relational expert and have been wondering about graph, how you'd survive without a schema, and scale out databases this session can help.
Introduction to partitioning Andrew Pruski
Session will be aimed at Database Administrators\Developers who have not previously implemented partitioning within an OLTP database and is designed to give a overview into the concepts and implementation.
A Deep Dive Into Data Lakes Ust Oldfield
Learn the ins and outs of Azure Data Lake in this deep dive
Effective Indexing with Partitioning and Compression Neil Hambly
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.
The video is not available to view online.
Designing a database to best support multidimensional OLAP Dr John Tunnicliffe
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
Query Optimizer: What’s New in SQL Server 2014 Benjamin Nevarez
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.
The video is not available to view online.
Superscaling SQL Server 2014 Parallel Insert Chris Adkin
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.
When good SQL design goes bad Bob Duffy
In this humorous session I’ll be contesting many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down.
Effective Index Partitioning, Compression Strategy Neil Hambly
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression
Patterns & Practices for Scaling Windows Azure SQL Database Scott Klein
This session will discuss the recommended approaches and best practices for partitioning and scaling Windows Azure SQL Database, allowing you to fully leverage the managed relational database service and take advantage of massive scale-out scenarios.
Incremental processing of SSAS Multidimensional databases Dr John Tunnicliffe
Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.
Scaling Out SSIS With Parallelism Chris Adkin
An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.
A Deep Dive in SQL Server 2012 Data Warehousing Dejan Sarka
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
T-SQL Brush-up:The Best Things You Forgot You Knew About SQL Jennifer McCown
Sometimes some piece of T-SQL slips by, or falls out of memory.Come and revisit old favorites, and brush up on new T-SQL features and enhancements.This session is chock full of code examples, including before-and-after demos and how-to illustrations.
SQL Storage for the real world Brett Roux
With a myriad of options available, choosing the most appropriate storage solution for your company can be challenging. This session will give you a brief introduction to the technologies available, and what to focus on when making the decision.
The video is not available to view online.
28 Weeks later - How to scale-out your MS Business Intelligence environment Sascha Lorenz
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
Expose the power of Recency Frequency analytics to your data using SQL Tony Rogerson
The technique of Recency Frequency Intensity/Monetary is a powerful analytical technique for identifying data patterns as well as business performance. An introduction to the technique will be given, however the main focus of the session will be on demonstrating on how RFI/M can be performed using a number of SQL features such as Data Windowing, the OVER clause and PARTITION BY, CROSS APPLY and Common Table Expressions and how you can nest the table expressions. The session should be of benefit to both inexperienced and experienced SQL coders and analysts, each construct will be explained as well as the query plans produced. Demo's will be done on AdventureWorks which we actually discover is going out of business!
Extreme scaling with SQL Azure Martin Schmidt
SQL Azure is Microsoft’s new strategy for storing your data in the cloud, but what to do when you exceed the 10/50GB limit. This is where sharding or partitioning comes into play – this session shows you how it can be done in an OLTP system and show you some of the common pitfalls of SQL azure as we have discoverd in analyzing SQL Azure as an alternative to onsite SQL Server instances at different clients.
I/O! I/O! It’s off to disk we go... James Rowland-Jones
I/O! I/O! It’s off to disk we go...
The video is not available to view online.
Advanced SSIS Allan Mitchell
Loading Partitions directly Consuming a package in SSRS Using a DM algorithm in the pipeline to see if the new customer meets criteria Fuzzy Grouping for deduplicating
The video is not available to view online.
Partitioning in the Real World Hue Holleran
Partitioning in the Real World
The video is not available to view online.
<<1>>