Toggle navigation
FAQ
Sponsors
Sessions
Training Days
Tuesday
Wednesday
Thursday
Friday
Saturday
Login
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Home
Sessions & Content
Sessions & Content
Tags
data warehousing
(73)
Content Type
Slide Deck
33
OtherSample
9
Video
57
Search
Conference
SQLBits I
0
SQLBits II
1
SQLBits III
2
SQLBits IV
2
SQLBits V
5
SQLBits VI
2
SQLBits VII
1
SQLBits VIII
5
SQLBits IX
8
SQLBits X
9
SQLBits XI
2
SQLBits XII
4
SQLBits XIV
5
SQLBits XV
7
SQLBits XVI
3
SQLBits XVII
6
SQLBits XVIII
10
SQLBits XX
1
When and how to migrate to Azure Synapse?
The session is for everyone who knows the data warehousing concept and wants to broad theirs horizons with modern capabilities of processing the data at scale.
A dive into the architecture that is Azure SQL DW Gen2
A technical overview of Azure SQL Data Warehouse Gen 2. SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data.
Biml Tips and Tricks: Not just for SSIS packages!
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
Different types of many-to-many relationships in Power BI
Clarify differences between many-to-many and weak relationships in Power BI
Disposable Dev environments with Azure DevOps and AzureRM
Using Azure DevOps and Azure RM templates to created isolated environments for testing PaaS solutions.
Learn how to build a real-time analytics solution
In this session we will learn which processes are required to build a real-time analytical model along with batch-based workloads, which are the foundation of a Lambda architecture.
Modern Data Warehousing with SQL DW and Databricks
SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. Azure Databricks is a fast, easy and collaborative Apache Spark-based analytics service that can be used for big data analytics and artificial intelligence (AI) solutions. This session will cover the architecture patterns for using the two in synergy.
Profiling Your Data
What data profiling is & why you should do it.
SentryOne Tools for Productivity and Performance
This quick vendor session demonstrates the spectrum of SentryOne's best-of-breed products for the Microsoft Data Platform, from Task Factory, to Plan Explorer, to DOC xPress, to the SentryOne monitoring platform, and beyond.
The Future of Data Warehousing
Learn about how to future-proof your modern data warehousing environment to meet the needs of the business for the long term; as well as how to overcome common data warehousing challenges, the related must-have technology solution.
Using Change Tracking to build a Live Data Warehouse
How to build a Live Data Warehouse using Change Tracking capabilities
Advanced Techniques for Cleaning Data using SQL Server 2017
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.
Azure SQL Data Warehouse Optimizing and Maintaining
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.
Deep Dive into SSIS 2017 and Beyond
We will showcase the latest feature of SSIS 2017 such as connectors for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), SSIS Scale-Out at package level for the box product as well as the SSIS package execution on Azure Data Factory
DevOps, CI and the Data Warehouse
DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse
Maximise compute performance with Azure SQL Data Warehouse
Learn about the new compute optimized performance tier in SQL Data Warehouse and how to maximize your performance through improved table design and columnstore optimization.
What is the Azure SQL Datawarehouse?
In this session we will discuss about the Azure SQLDW and how we can use it to help on our day to day.
‘Out of the box’ advanced analytics & data warehousing
Pyramid Analytics BI Office’s Enterprise BI Platform and PrecisionPoint’s data warehousing solution for MS Dynamics ERP systems combine to deliver simplified access to key Business and Financial data.
Get Near Realtime ETL with Service Broker
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.
Review ColumnStore Index in SQL 2016 and Azure SQL DB
This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016 and Microsoft Azure SQL Database
<<
1
2
3
4
>>