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.
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.
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.
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.
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.
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.
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 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.
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.
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.
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.
Optomizing SQL Server Performance in a Virtual Enviroment Denny Cherry
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 video is not available to view online.
Permy, Contractor or Freelance? Alex Whittles
What are the pros, cons and gotchas of being a permy vs contractor or freelance consultant? We’ll look at what you need to think about from a logistics, financial planning, tax, marketing, career and skills development perspective.
The video is not available to view online.
Recovery Models Made SIMPLE Kalen Delaney
This session looks inside the transaction log to see exactly what is logged for minimally logged operations in each of the recovery models. We also look at other factors in our SQL Server operations that affect what is actually written to the log.
The video is not available to view online.
Responding to Extended Events in near real-time Gianluca Sartori
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.
The video is not available to view online.
Running Totals Itzik Ben-Gan
This session covers practical applications of running total computations.
The video is not available to view online.
SQL Server 2016 Hero Features in a Customer Scenario Marko Hotti
This sessions covers the SQL Server 2016 Hero Features and you will see a real customer scenario demo showcasing the Full Lifecycle of Financial Data.
The video is not available to view online.
SQL Server 2016 Performance and Scalability Improvements Marko Hotti
In this session we will cover the core database engine improvements that make SQL Server 2016 run faster than previous releases. We will also cover some new performance related features and how Windows Server 2016 will improve SQL Server performance.
The video is not available to view online.
SQL Server 2016-Security Obscurity and Encryption Andreas Wolter
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.
The video is not available to view online.
SSMS and the SQL Client Tools Renaissance Sanjay Nagamangalam
Join us in this session for a ‘behind the scenes’ look at the new foundation for SSMS, how we built what you see today and learn about how we will accelerate innovation for SQL client tools going forward.
The video is not available to view online.
Testing T-SQL Made Quick and Easy Steve Jones
Everyone tests their 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 video is not available to view online.
The Intelligence of your Things Amy Boyd
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.
The video is not available to view online.
The Key to Keys Karen Lopez
Learn about keys and how to get them right.
The video is not available to view online.
The Modern Intelligent Application Lara Rubbelke
This session will examine how to successfully design a modern data architecture on the Microsoft Azure cloud platform. Focusing on design tenants for efficient, scalable and resilient data processing
The video is not available to view online.
The Query Store and Query Tuning in SQL Server vNext Grant Fritchey
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.
The video is not available to view online.
Top 5 Automated Database Deployment Gotchas Simon D'Morias
Have you managed to implement, or are you struggling to implement, automated deployments for your databases, but keep hitting problems? Database deployments are complex - we look at the common problems.
The video is not available to view online.
Using R in SQL Server 2016 Database Engine and SSRS Dejan Sarka
R extends statistical and mathematical capabilities of SQL Server 2016.
The video is not available to view online.
Warehouse of the Future: Lakes Vs Marts Simon Whiteley
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.
The video is not available to view online.
What Application Developers Should Know About SQL Server? Milos Radivojevic
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.
The video is not available to view online.
What’s New in Excel 2016 Dany Hoter
Learn about Excel and PowerBI from the Excel team.
The video is not available to view online.
<<1>>