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.
SSMS is a great management tool but lacks the serious development features and benefits that SSDT has. SSDT has a learning curve so this talk aims to help people get started with SSDT quickly.
Tabular offers only one-to-many relationships on a single column: it seems poor when compared with Multidimensional. However, with DAX, you can handle any relationship. We analyze and solve scenarios with calculated, virtual and complex many-to-many.
With R in SQL Server 2016, data engineers (DBAs, developers) are expanding their horizons and deriving more value for the business from their data. Come see how this is brining people in business together.
Sometimes bad execution plans happen to good queries. In this session you'll learn the pros and cons of using hints, plan guides, and the new Query Store feature in SQL Server 2016 to manipulate your execution plans.
In this session the In-Memory OLTP technology will be briefly introduced and a step-by-step approach will be shown on how to start using this new technology, explaining the basics.
In this session we will take a deep dive into one of the, in my opinion, most exciting new feature in SQL Server 2016, the Query Store. Learn all about the inner workings of the query store and how it can help you analyse query performance!
Do you have ever looked on an execution plan that performs a join between 2 tables, and you have wondered what a "Left Anti Semi Join" is? Joining 2 tables in SQL Server isn't the easiest part!
An advanced look into how memory works in modern servers, on modern processors and how to leverage it with SQL Server.
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
Ever deployed reports that that worked perfectly well with one user on the development server, only to find that it doesn’t scale on production? Come along to see how to replay workloads at scale on SSRS to help with tuning and scalability
Enter the world of SQL Server concurrency to experience the age old problem of Locking, Blocking and Deadlocking. Let's investigate pessimistic isolation and whether optimistic concurrency could be the answer to all our problems or the last resort.
Locking and blocking is SQL Server’s default method of managing concurrency in a multi-user environment. In this session we’ll look at the three main aspects of locking, including when locks cause blocking and also examine ways to minimize blocking.
In this session, we are going to look at a typical machine learning process and how to apply it to real world data. We are going to use Azure Machine Learning to transform data and ideas into models that are production ready in minutes.
Running databases in SQL Servers in your office or data centre? Considering moving them to Azure? Want to know what options and benefits of Infrastructure as a Service and Platform as a Service?
In this talk, you will get an overview on what to think about when storing data in a document database.
Learning SQL is easy, mastering it is hard. In this session you’ll learn simple but effective tricks to design your database objects better and write more optimized code.
Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS/DECOMPRESS, from SESSION_CONTEXT() to DATEDIFF_BIG(), and new query hints.
Contrary to popular belief, Third Normal Form is NOT good enough, and higher Normal Forms are NOT hard. This session gives a clear and easy to understand overview of higher Normal Forms. No serious database developer can afford to miss this session.
In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.
The quickest way to migrate your on-premises OLTP database to Azure is to "Lift & Shift".
In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc.
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems.
This session covers practical applications of running total computations.
Come to hear about lessons learned from early customer deployments of SQL Server security features: Row level security, Always Encrypted, Data Masking, Auditing, etc.
Do you get involved in the creation of Business Intelligence solutions within your organisation? This session will show you the new features of SQL Server 2016 Business Intelligence components.
SQL Sever 2016 is just around the corner and with it come some great new features and enhancements to existing capabilities, in this session we will look at some of these and understand how they might make us change the way that we look at designing