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.
Come to this session to see how you can create a more efficient database development platform by integrating your VCS with SQL Server. In real-time, you’ll see how versioning, branching, merging, and the other manual tasks you hate can fade away with
Join Joseph for a fascinating look into SQL Server 2016 and its unmatched innovation across on-premises and the cloud to help you turn data into intelligent action
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.
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.
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.
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.
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.
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.
Join this session on moving a legacy enterprise organisation into the modern BI world using the power of positive disruption and the Attunity tool set. This real world case study will explore Zurich Insurance’s journey featuring both the challenges and successes they faced.
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
Buck Woody will lead you around the Cortana Intelligence Suite showing you how to create intelligent actions from data.
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.
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.
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you face in your daily SQL Server life.
Lindsey Allen will peel back the curtain on SQL Server 2016 new feature Operational Analytics. We continue to invest heavily in in-memory technology and have now introduced one of the more important features we are releasing as part of SQL Server.
Learn from a real customer how they developed and deployed a series of BI Office solutions to support various business functions including: Finance, Web Analytics Supply, Pricing.
An introduction with worked examples of the new Data Lake storage platform in Azure.
This session looks at the two main techniques to efficiently implement searches where users 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.
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.
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.
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.
These two Microsoft analytic platforms share lots of technologies and users can import and model data in any one of the environments and use the results across both.
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, we will introduce a step-by-step approach to adopting the technology, aimed at beginners who are interested in how it can fit into their own environments.
BI systems are increasingly mission critical, but they’re only as good as the quality of data they contain. Learn how you can use SQL Server MDS and Profisee’s Master Data Maestro to ensure data quality and improve BI value.
Come to this session to learn how to turn your existing applications into intelligent applications using the R integration into the SQL Server engine.
Azure SQL DB can automatically make apps run faster and more cost-effectively, based on workload telemetry from millions of customers. Come and see live demos about what the service can do
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!
This presentation will give you an overview on U-SQL, why we decided to build a new language, what its core philosophical underpinnings are as well as show the language in its natural habitat, development tooling and language capabilities
Have you ever looked at an execution plan that performs a join between 2 tables, and wondered what a "Left Anti Semi Join" is? Joining 2 tables in SQL Server isn't the easiest part!
Learn how BI Office from Pyramid Analytics can turn your company into a data driven organisation heading for the stars, whilst combining the best of PowerBI on Premises.
In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning. Using both free and paid tools from SQL Sentry, you’ll learn tips and tricks you can immediately apply to your SQL code, not to mention the free tools!
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.
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.
  1 to 50 of 854 first 1 2 3 4 5 6 7 8 9 10  next last  Show 10 25 50 100 sessions per page