Sessions & Content

Search
Content Type
Conference
Tags
A Beginner’s Guide to Cloud Computing and SQL Azure David Postlethwaite
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.
The video is not available to view online.
A Practical Approach to Version Control Steve Jones
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
The video is not available to view online.
Accelerating Business with Mission Critical Intelligence Joseph Sirosh
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
The video is not available to view online.
Advanced MDX Tips And Tricks Chris Webb
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.
The video is not available to view online.
Advanced Topics for Azure SQL Data Warehouse James Rowland-Jones
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.
The video is not available to view online.
AlwaysOn Availability Group Troubleshooting Ninja Amit Banerjee
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.
The video is not available to view online.
An End-to-End Troubleshooting Checklist for SQL Server Kevin Kline
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.
The video is not available to view online.
Analytics Master Class-more exotic patterns in data Mark Whitehorn
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
The video is not available to view online.
Are failover clusters ready for extinction? Gavin Payne
This session will compare Microsoft’s options for deploying highly available SQL Server data platforms in mid-2016.
The video is not available to view online.
Automate Your ETL with SSIS and PowerShell Allen White
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.
The video is not available to view online.
Azure Data Factory vs SSIS Reza Rad
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.
The video is not available to view online.
Azure DocumentDB: Advanced Features for Large-Scale Apps Andrew Liu
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.
The video is not available to view online.
Azure SQL Database Security - Microsoft product team Ron Matchoro
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.
The video is not available to view online.
Biml for Beginners: Speed up your SSIS development Cathrine Wilhelmsen
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.
The video is not available to view online.
Cardinality Estimates in Microsoft SQL Server Thomas LaRock
Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
The video is not available to view online.
Case Study: Attunity Compose in Agile Enterprise BI Dave Kay
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.
The video is not available to view online.
Continuous Integration and the Data Warehouse Dr John Tunnicliffe
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
The video is not available to view online.
Cortana Intelligence Suite - from a guy on the team Buck Woody
Buck Woody will lead you around the Cortana Intelligence Suite showing you how to create intelligent actions from data.
The video is not available to view online.
Cut the R learning curve Steph Locke
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.
The video is not available to view online.
Data Modelling For Beginners Emma Zambonini
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 video is not available to view online.
Debugging made easier using Extended events Amit Banerjee
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you face in your daily SQL Server life.
The video is not available to view online.
Drill into SQL Server 2016 Operation Analytics Lindsey Allen
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.
The video is not available to view online.
Driving operational transformation and analytics Ian Macdonald
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.
The video is not available to view online.
Dumping data into Azure Data Lake with Data Factory Andrew Fryer
An introduction with worked examples of the new Data Lake storage platform in Azure.
The video is not available to view online.
Dynamic Search Conditions Erland Sommarskog
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
The video is not available to view online.
Effective Indexing with Partitioning and Compression Neil Hambly
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.
The video is not available to view online.
Enhancements that will make your SQL engine roar #1 Pedro Lopes
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.
The video is not available to view online.
Enhancements that will make your SQL engine roar #2 Pedro Lopes
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.
The video is not available to view online.
Essential Architecture for Bi in a Virtual Environment Joey D'Antoni
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.
The video is not available to view online.
Excel and Power BI-Better Together Dany Hoter
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.
The video is not available to view online.
Handling Relationships in DAX Alberto Ferrari
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.
The video is not available to view online.
How customers are using R in SQL Server 2016 Sanjay Mishra
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.
The video is not available to view online.
How to Bully Your Query Execution Plans Kendra Little
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.
The video is not available to view online.
How to start with In-Memory OLTP? Murilo Miranda
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.
The video is not available to view online.
Improve Data Quality: Drive BI Value through Master Data Dave Lawrence
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.
The video is not available to view online.
Intelligent Applications with SQL+R in SQL Server 2016 Tobias Ternstrom
Come to this session to learn how to turn your existing applications into intelligent applications using the R integration into the SQL Server engine.
The video is not available to view online.
Intelligent Database as a Service Vladimir Ivanovic
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
The video is not available to view online.
Introducing the SQL Server 2016 Query Store Enrico van de Laar
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!
The video is not available to view online.
Introducing U-SQL: Big Data Processing made easy Michael Rys
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
The video is not available to view online.
Joins in SQL Server - as easy as ABC? Klaus Aschenbrenner
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!
The video is not available to view online.
Keeping Power BI on the ground but reaching the stars Ian Macdonald
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.
The video is not available to view online.
Kicking bad code to the touchline Richard Douglas
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!
The video is not available to view online.
Leveraging Memory With The Database Engine Chris Adkin
An advanced look into how memory works in modern servers, on modern processors and how to leverage it with SQL Server.
The video is not available to view online.
Lightning Talks Various Speakers
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
The video is not available to view online.
Lock, Block and Two Smoking Barrels Mark Broadbent
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.
The video is not available to view online.
Locking and Blocking Kalen Delaney
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.
The video is not available to view online.
Machine Learning demystified: ask the right questions Bianca Furtuna
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.
The video is not available to view online.
Migrating databases to Azure Justin Langford
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?
The video is not available to view online.
Modeling Data in a Document-Oriented NoSQL Database Andrew Liu
In this talk, you will get an overview on what to think about when storing data in a document database.
The video is not available to view online.
New T-SQL capabilities in SQL Server 2016 & Azure Aaron Bertrand
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.
The video is not available to view online.
<<12>>