Sessions & Content

Tags
Content Type
Search
Conference
Near real-time IoT Analytics of Pumping Stations in PowerBI
An IoT analytics solution addressing real-life issues with SCADA data from a network of 600 Waste Water Treatment Plants and 100s of Pumping Stations. An end-to-end solution with Azure Data Warehouse, Azure Data Factory, Azure Analysis Services and PowerBI
Operational Machine Learning: MS Tech for Data Science
Discover the Microsoft technologies that enable end-to-end data science, including SQL Server and Azure PaaS Services, along with practical scenarios and demos.
A Beginner’s Guide to Cloud Computing and SQL Azure
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.
Advanced MDX Tips And Tricks
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.
Advanced Topics for Azure SQL Data Warehouse
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.
AlwaysOn Availability Group Troubleshooting Ninja
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.
Analytics Master Class-more exotic patterns in data
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
Automate Your ETL with SSIS and PowerShell
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 vs SSIS
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 DocumentDB: Advanced Features for Large-Scale Apps
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.
Azure SQL Database Security - Microsoft product team
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.
Biml for Beginners: Speed up your SSIS development
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.
Cardinality Estimates in Microsoft SQL Server
Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
Continuous Integration and the Data Warehouse
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
Cortana Intelligence Suite – from a guy on the team
Buck Woody will lead you around the Cortana Intelligence Suite showing you how to create intelligent actions from data.
Cut the R learning curve
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.
Data Modelling For Beginners
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.
Debugging made easier using Extended events
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you face in your daily SQL Server life.
Dynamic Search Conditions
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
Enhancements that will make your SQL engine roar #1
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.
Enhancements that will make your SQL engine roar #2
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.
Essential Architecture for Bi in a Virtual Environment
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.
Excel and Power BI-Better Together
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.
Handling Relationships in DAX
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.
How to start with In-Memory OLTP?
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.
Introducing the SQL Server 2016 Query Store
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!
Lock, Block and Two Smoking Barrels
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
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.
Machine Learning demystified: ask the right questions
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.
Modeling Data in a Document-Oriented NoSQL Database
In this talk, you will get an overview on what to think about when storing data in a document database.
New T-SQL capabilities in SQL Server 2016 & Azure
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.
Optomizing SQL Server Performance in a Virtual Enviroment
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.
Permy, Contractor or Freelance?
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.
Recovery Models Made SIMPLE
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.
Responding to Extended Events in near real-time
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.
Running Totals
This session covers practical applications of running total computations.
SQL Server 2016 Hero Features in a Customer Scenario
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.
SQL Server 2016 Performance and Scalability Improvements
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.
SQL Server 2016-Security Obscurity and Encryption
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.
SSMS and the SQL Client Tools Renaissance
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.
Testing T-SQL Made Quick and Easy
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 Intelligence of your Things
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 Key to Keys
Learn about keys and how to get them right.
The Modern Intelligent Application
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 Query Store and Query Tuning in SQL Server vNext
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.
Top 5 Automated Database Deployment Gotchas
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.
Using R in SQL Server 2016 Database Engine and SSRS
R extends statistical and mathematical capabilities of SQL Server 2016.
Warehouse of the Future: Lakes Vs Marts
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.
What Application Developers Should Know About SQL Server?
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.
What’s New in Excel 2016
Learn about Excel and PowerBI from the Excel team.
SQL CLR Demystified
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
“SQL Attack…ed” – SQL Server under attack: SQL Injection
In this purely demo-based session, I will show several real-life attacks, from mere reading up to disrupting service availability via various types of manual and automated SQL Injection, including a broadly unknown elevation of privileges attack.
A Comedy of Errors
Error handling in T-SQL stored procedures
A Look at 3 Big Data Tools
This session will look at SQOOP, PIG and HIVE. Three tools which are essential in your Big Data Toolbox. We'll look at what they do, how they do it and why you would want to use them
Advanced Modeling with Analysis Services Tabular
This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional
Advanced Reporting Techniques & Managing Reports
What are the techniques to implement linked reports, subscriptions, report history, snapshot options, editing report using browser based Report Builder? Find out in this session.
Azure SQL DB - Running a cloud database service at scale
In this talk, I will share my experience in creating and running Azure SQL Database, a large cloud scale service powered by SQL Server technologies. This presentation will provide an outline of the scenarios and requirements for a database service.
BI Tips and Tricks with SQL Server Reporting Services
Impress the boss and your colleagues by delivering Dashboards, KPIS, maps and Scorecards wrapped in a tablet-ready interface with SSRS
Branding Yourself for a Dream Job
Everyone wants a job they enjoy and look forward to working at each day. This session will present practical techniques for improving your brand and giving you the chance to interview for the job you want.
Building Your Myth Busting Lab With Power BI
Information Workers and Data Analysts do “myth busting" on corporate performance and forecasts on regular basis. This session uncovers ways to take advantage of Power BI as Software as a Service (SaaS) for a "myth busting" lab you can try at home!
Building Your T-SQL Tool Kit: Window Function Fundamentals
Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.
Cardinality Estimates in Microsoft SQL Server 2014
Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
Column Store Index and Batch Mode Scalability Deep Dive
A deep dive into batch mode scalability with column store index and SQL 2014.
Continuous Delivery for Data Warehouses and Marts
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Data Security – In a Post Snowden World
Everyone knew how to keep data safe and secure, right up until Edward Snowden revealed this error. Learn how to keep the data secure, by identifying and quantifying the risks. Take away practical tips and advice to apply immediately.
DAX Patterns
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
Deep-Dive to Analysis Services Security
This session targets SSAS developers that are already dealing with complex security solutions on a regular basis and want to get more insights on what actually happens inside SSAS when the different kinds of security are applied to their model.
Designing quality SQL Server 2014 solutions
This session shows how you can use SQL Server 2014’s features to meet your solution’s non-functional requirements and ensure operational success.
Dive into the Query Optimizer-Undocumented Insight
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
Effective Index Partitioning, Compression Strategy
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression
ETL Patterns with Clustered Columnstore Indexes
Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!
Fasten your seat belt and look at the Data Steward
In this session we will discuss Data Governance around Power BI and on-prem platforms. How to avoid dataset-hell. What are the best practices for sharing queries? Who is the famous Data Steward ?
Getting Started Reading Execution Plans
Learn where to start reading execution plans and how to interpret them in order to understand how to tune poorly performing queries.
Hadoop: Big Data or Big Deal?
Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
How to Pick SQL Server Hardware
You don't buy a lot of servers, but you're about to deploy SQL Server, and you only get one chance to make it right. Brent Ozar will boil down everything you need to know into just a few simple decisions including SQL Edition, sockets, and RAM.
Inside Ola Hallengrens Maintenance Solution
In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.
Intro to R
R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about.
I've Got A SQL Database, Now What?
So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it. I've got some of the answers here in this session for you.
Latches, Spinlocks, and Lock Free Data Structures
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
MDX 101
In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so no previous experience necessary.
Microsoft Analytics: The Next Wave
Come to this session to learn about the next wave of Microsoft’s analytic capabilities. Big data opens up great possibilities but do you have the right skills as a data scientist? Learn what Microsoft is doing in the analytics space
Monitoring Databases in a Virtual Environment
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
Monitoring Windows Azure SQL Server VMs and SQL Databases
Once you've decided to move to Azure with any of your databases, you're going to need to know how they're performing, this session shows you.
Optimizing & Analyzing DAX Query Plans
Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues
Optimizing database access and diving into .Net SqlClient
Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader()
Optimizing Temporal Queries
Writing efficient queries with temporal predicates is finally not a problem anymore.
Performance Tuning SQL Server Integration Services (SSIS)
In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS).
Power Query in Modern Corporate BI
Explore Power Query features to import data from existing Corporate BI systems.
Power Query: Beyond The Basics
An in-depth session on advanced Power Query functionality and the M language
Query Optimizer Internals : Traceflag fun
The query optimizer is at the heart of SQL Server. Much of the its' internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags. This session will be a deep dive into the these internals.
Query Progress Tracking in SQL Server
It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. What should you do now?
Revenge: The SQL!
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
SAN eye for the SQL girl/guy
More and more senior roles require familiarity with SAN technologies - tricky for us, 'just' the DBA. This '90% practical' session will explore Hue's 2× different SAN in a box'es. Come and gain this much-needed exposure to Enterprise technologies.
T4 Templating within SSDT using SQL Server 2014
T4 templating will be a first class citizen in SSDT for SQL Server 2014. This session will show why you should use this technology for SQL code generation and how you can automate the process. The session will be demo rich.
The dangerous beauty of Bookmark Lookups
Join me in this session to get a basic understanding of Bookmark Lookups, and why they can be dangerous in SQL Server.
The secret to pain-free database deployments? Automation
Starting at version control, we’ll look at typical patterns and practices, how to tackle known challenges, and the safety checkpoints you should plan for as you work towards continuous delivery for databases, and painless deployments.
The SSDT way or the highway (sqlproj)
So you have heard of SQL Server Data Tools (SSDT), you have started using it but not entirely sure how to use it to it's full potential. This session is perfect for adopters of SSDT and how to get the most out of it.
Things You Can Find in the Plan Cache
The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system. In this session we will demonstrate ways the Plan Cache can help us identify performance problems.
Tim's Top Ten Templates
Management Studio Templates and Snippets make the DBA look like a superstar and in the process makes our lives easier through tapping into the mantra of Work Less - Do More. Join Tim as he shares his shortcuts for optimizing repetitive tasks
T-SQL : Bad Habits & Best Practices
Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.
  1 to 100 of 378 first 1 2 3 4 last  Show 10 25 50 100 sessions per page