4th - 7th May 2016

Liverpool

Sessions & Content

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. We’ll cover: • Dark Data • Probability calculations • RFI
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.
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.
Azure SQL DB can automatically make customer apps run faster and more cost-effectively, based on analyzed workload telemetry from millions of customer databases. Come and see live demos about what the service can do for customers today
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.
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
Security is one of the top topics for the new release of SQL Server. A total of 3 completely new features are coming to us: Always Encrypted, Dynamic Data Masking and Row Level Security.
Windows failover clustering is the foundation for clustered instances and availability groups. To be successful, a DBA needs to understand the underlying Windows portion of clustering. This session will show what you really need to know.
This session will explain how the Query Optimizer uses column statistics to determine which operators to use and the operator costs. We'll also look at the changes to the Cardinality Estimator in SQL Server 2014.
You’ve mastered the basics of SSRS, but you know there’s more to it. I'll take you through a number of ways you can build upon what you already know, to make your reports even more awesome.
Everyone tests that code, but most people use ad hoc, non-repeatable testing with simple queries. This session will show you how to begin implementing testing into your development process, giving you a growing library that improves code quality.
The Internet of Things starts with your things. It's a great time to take a look at game changing technologies you can use today to make your IoT ideas stand out from the rest using Microsoft Azure. Welcome to the Internet of Your Intelligent Things!
Learn about keys and how to get them right.
This session is going to examine how to successfully a modern data architecture on the Microsoft Azure cloud platform. Using a canonical IoT application example, we will focus on design tenants for efficient, scalable and resilient data processing.
An introduction to Machine Learning and where it fits into the world of BI.
SQL Server 2016 introduces the Query Store. The Query Store will change how you tune queries. Come to this session to learn everything you'll need.
This session explains how to unit test your SQL source code, why you would do this and what tools you can use.
What are these DATA Scientists upto? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?
This session looks at building time series analysis with AzureML in R
In this session, you will learn about various anti-patterns and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits.
T-SQL user-defined functions may appear to be a good tool for code encapsulation and reuse, but they can have a dramatic impact on performance. In this session, you'll see why they slow down your queries, and how you can avoid this performance hit.
Tired of Bar Charts? We'll build out a custom PowerBI Visual and show the power of PowerBI whilst going into a deep dive on how this is achieved.
Learn in just a bit over an hour how to use CISL (open source Columnstore Indexes Library) for getting deep insights on the Columnstore Indexes and how to use its maintenance solution for keeping Columnstore Indexes performing at their maximum speed.
R extends statistical and mathematical capabilities of SQL Server 2016.
Data Warehouses are changing. This session will run through the architecture of the modern warehouse, from structured/unstructured Azure Data Lakes to platform as a service Azure Data Warehouse and bringing the two together.
In this session, we will look at Predictive Analytics using SQL Server 2016 and R, using our boozy day at the Guinness factory as a backdrop to understanding why statistical learning is important for analytics today. Drinking Guinness is optional!
Nowadays many companies don't have dedicated developer positions. Therefore the most of the SQL code has been written by application developers. In this session we will cover the most important things they need to know about SQL Server.
In this session you will get a brief introduction to the basic principles of Master Data Services, together with an overview of all the new features brought to you with Master Data Services 2016.
Learn about Excel and PowerBI from the Excel team.
​In this Session we will delve into the need to deploy and manage SQL Server Configurations using PowerShell Desired State Configuration and the immediate benefits that this can and will bring to your deployment and administration duties.
In an easy introduction to machine learning and predictive analytics, we'll use AzureML to analyse the Titanic dataset and predict whether different audience members would have survived the disaster.
Enterprise Edition is crazy expensive but the features are crazy cool. How can you achieve the same effect without having to buy Expensive Edition? Come and find out.
Learn about 7 SQL and NoSQL databases: how they work, when to use them, and how they form a modern data architecture
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW?
PolyBase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and Windows Azure Storage Blobs (WASB). See it in action.
This session will show you what is possible in the Power BI Offering of Microsoft in relation to Data Governance
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at guidelines for index creation
Indexes are the best instrument for query optimization. But what kind of indexes and on what columns? The key to answering those questions is understanding how indexes are stored and used by SQL Server. And that is exactly what this session is about.
A fun session showing some amazing things you can do with Power BI
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.
This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance.
In this session we will look in detail into some of the features for the Power BI designer and take it for a spin and investigating some of the new capabilities it has to offer for different relationships and new DAX formulas.
This session introduces SQL Server 2012 and 2014 text mining capabilities.
There are some little-known but very useful ways of extracting information from data. This session will cover: • Monte Carlo simulations • Nyquist’s Theorem • Simpson’s paradox • Benford’s Law These will rock your world (they certainly rocked mine).
Azure stream analytics is a new Azure service for analyzing streaming data.
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practise your deployments using continuous integration before you ever get near production
Azure Machine Learning is a fully managed cloud service for predictive analytics. In this 1hour session, we will run through; ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.
Sometimes don't want our data in the cloud, but that doesn't mean we can't use the cloud at all.
A SSAS MDX Deep Dive session covering the implementation of a business requirement to identify rogue behaviour over time and within SCD organisation groups.
A journey from dev to production. This talk covers best practices for developing and deploying Visual Studio Database Projects targeting multiple environments. We will cover using composite projects, pre and post deployment scripts and other optionst
Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well
The session starts with a brief overview of the operator and it
Everyone wants a dream job that they enjoy going to each week. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself in today's competitive world.
Alberto will show you some common techniques to use when building a budget model with Power Pivot and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on non-existing products
Learn how to write Powershell that will use Remoting to run scripts parallel on any number of servers. We'll talk about remoting, background jobs and how to collect and report on the results
This all demo session build around a real life case study from one of the largest organizations in the world. will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you.
See how to use Power Query to build a detail-level reporting solution
  1 to 100 of 835 first 1 2 3 4 5 6 7 8 9 last  Show 10 25 50 100 sessions per page