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
Analytics
(4)
Azure
(13)
BI
(8)
data warehousing
(5)
DAX
(2)
DBA
(2)
ETL
(2)
memory
(5)
performance
(15)
Power BI
(5)
Power Pivot
(2)
PowerShell
(2)
R
(3)
security
(2)
SSAS
(3)
SSDT
(4)
SSIS
(4)
SSRS
(2)
Synapse Analytics
(2)
Content Type
Slide Deck
48
Search
Conference
SQLBits XV
48
A Beginner’s Guide to Cloud Computing and SQL Azure
This talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages along with what Microsoft Azure has to offer.
Advanced MDX Tips And Tricks
Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
Advanced Topics for Azure SQL Data Warehouse
This session covers the more advanced aspects of development for Azure SQL Data Warehouse. Areas such as data movement, workload concurrency and resource management will all be covered during this intense 60 minute session.
AlwaysOn Availability Group Troubleshooting Ninja
If you use AlwaysOn Availability Groups, then come learn about the new enhancements shipped with SQL Server 2012 SP3 and above which allows you to troubleshoot failovers in your AG and understand reasons for latency.
Analytics Master Class-more exotic patterns in data
Analytics is all about having a good set of analytical tools. Last year at Sqlbits I outlined 4 such tools, this session will expand on that set. We’ll cover Dark Data, Probability calculations, RFI
Automate Your ETL with SSIS and PowerShell
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
Azure Data Factory vs SSIS
Azure Data Factory and SSIS are both data movement tools, but built for different purposes. In this session you will learn pros and cons of using each technology, and best practices of using each in real world scenarios.
Azure DocumentDB: Advanced Features for Large-Scale Apps
Let's talk about how you can get the most out of Azure DocumentDB. In this session we will dive deep in to the mechanics of DocumentDB and explain the various levers available to tune performance.
Azure SQL Database Security - Microsoft product team
Join me for an overview of how Azure SQL DB customers can simply secure their data using our most advanced features to-date including Always Encrypted, Transparent Data Encryption, Dynamic Data Masking and SQL Threat Detection.
Biml for Beginners: Speed up your SSIS development
SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Learn how to speed up your SSIS development by using Biml and BimlScript.
Cardinality Estimates in Microsoft SQL Server
Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
Continuous Integration and the Data Warehouse
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
Cortana Intelligence Suite - from a guy on the team
Buck Woody will lead you around the Cortana Intelligence Suite showing you how to create intelligent actions from data.
Cut the R learning curve
There's base R, modern R, the Hadleyverse, R in SQL, and more - understanding where to begin can be an exercise in frustration and cost you valuable time. This session takes you through the R you need to be productive quickly.
Data Modelling For Beginners
In this session we will talk through the process of gathering user requirements to provide a good starting point for your data model. We will use the Sun Modelling technique to aid us in this.
Debugging made easier using Extended events
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you face in your daily SQL Server life.
Dynamic Search Conditions
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
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.
Essential Architecture for Bi in a Virtual Environment
Virtualization has had a major impact on computing. While data professionals have adjusted to this for database servers, many BI workloads have moved there as well. Learn about the impact of virtualization on BI.
<<
1
2
3
>>