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.
Azure SQL Database is on a roll with a blockbuster set of new features. Attend this session to understand the big changes and investments with Azure SQL Database
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.
Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
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.
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.
Joseph and Shawn will update the audience on the latest for SQL Server 2016, Cortana Analytics and other possible pleasant surprises from the Data Platform Group.
The typical performance bottleneck in your data warehouse is using SSIS to insert massive amount of data into SQL Server. In this session, you will learn how to improve the load performance with SSIS into SQL Server.
Azure offers many great tools and services, but how to they fit together and what are your options when trying to architect an end to end Azure BI platform?
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you faced in your daily SQL Server life.
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 and greatest SP and why you should install them.
Rohan Kumar will peel back the curtain on SQL Server 2016 new feature Operational Analytics. We continue to invest heavily in our in-memory technology and have now introduce one of the more important features we are releasing as part of SQL Server.
This session looks at the two main techniques to efficiently implement searches where uses can select between a large set of search conditions.
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.
Scale higher for a roaring performance and troubleshoot faster with your SQL Server database engine.
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.