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.
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.
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.
Let's talk about things related to time and data. We will touch upon concepts such as process mining, lean, six sigma, process datawarehousing, relational temporal theory and SQL 2016 temporal
If you have an AlwaysOn Availability Group, then come learn about the new enhancements shipped with SQL Server 2012 Service Pack 3 and above which allows you to troubleshoot failovers in your Availability Group and understand reasons for latency.
Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
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.
• Dark Data
• Probability calculations
This session will compare Microsoft’s options for deploying highly available SQL Server data platforms in mid-2016.
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 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.