Nr: 725
SQLSaturday #725 - Victoria 2018
SessionID: 72105
KEYNOTE: IT and Development in the Next Five Years
Event Date: 03-03-2018 - Session time: 08:30:00 - Track: Other
Speaker: Richard Campbell
Title: KEYNOTE: IT and Development in the Next Five Years
Abstract:
SessionID: 71170
An Introduction to SQL Server 2017
Event Date: 03-03-2018 - Session time: 09:30:00 - Track: Admin
Speaker: Warwick Rudd
Title: An Introduction to SQL Server 2017
Abstract:
SQL Server 2017 being released brings to the table some new features and improvements in quick succession from SQL Server 2016. In this session we will look at a subset of the new /or improved features that SQL Server 2017 brings to the table.
From Analytics, Availability, Configuration and Performance there is something for everyone in this session to introduce you to the latest version of SQL Server.
SessionID: 71282
BI in Excel 2016: The value is in the Refresh
Event Date: 03-03-2018 - Session time: 09:30:00 - Track: BI
Speaker: Ken Puls
Title: BI in Excel 2016: The value is in the Refresh
Abstract:
2 text transaction files, a pivoted excel budget file, 20 Power Queries, 6 dimensional tables, and one interactive Excel dashboard = mind blowing awesomeness in under 60 minutes. But while the analysis is important, the real value in the refresh. Can your model pull in another 22 text files and next year's budgets in less than a minute? This model can.
Come and see how Excel 2016 gives us the ability to not only rapidly create business intelligence, but also allows us to build engaging and interactive models that can be quickly updated and shared via Power BI.
SessionID: 71570
Shaving of Microseconds
Event Date: 03-03-2018 - Session time: 09:30:00 - Track: Admin
Speaker: Thomas Grohser
Title: Shaving of Microseconds
Abstract:
This session is a compilation of extreme techniques I had to use over time to make very fast operations go a bit faster. It will cover multiple areas (indexing, table design, data access layer, schemas, object naming, datatypes, collations physical data placement and more. All examples given in this session are from real world cases of some of the most demaning workloads in the world.
SessionID: 71988
Educating yourself will make a SQL career more fulfilling
Event Date: 03-03-2018 - Session time: 09:30:00 - Track: Other
Speaker: Chris Wood
Title: Educating yourself will make a SQL career more fulfilling
Abstract:
Do you want to turn your SQL knowledge into a possible career?
This session will show you what options are available to learn about MS SQL Server and make you more knowledgeable about the product
This session will show the many different options available to learn MS SQL Server ranging from free events thru to international conferences
It will also show how to make any conference more affordable and justify the benefits
SessionID: 72072
Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints.
Event Date: 03-03-2018 - Session time: 09:30:00 - Track: Dev
Speaker: Rick Lowe
Title: Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints.
Abstract:
Most of us have heard that using the NOLOCK hint is not recommended. But why is this? What is it about NOLOCK that sends most DBAs into a tizzy? And how about other hints such as ROWLOCK and RECOMPILE - are they OK to use? Come hear a discussion on why exactly query hints cause problems when used excessively, and watch some demos of NOLOCK craziness in action.
SessionID: 72370
Introduction to Azure Cosmos DB
Event Date: 03-03-2018 - Session time: 09:30:00 - Track: Cloud
Speaker: Anthony Chu
Title: Introduction to Azure Cosmos DB
Abstract:
In this session, we'll get an overview of Azure Cosmos DB. And we'll see live demos of Cosmos DB in action, including its multi-model capabilities using MongoDB and Gremlin APIs.
SessionID: 72710
SQL Server on Docker
Event Date: 03-03-2018 - Session time: 09:30:00 - Track: Dev
Speaker: Frank Geisler
Title: SQL Server on Docker
Abstract:
SessionID: 71168
DevOPs and the DBA
Event Date: 03-03-2018 - Session time: 10:45:00 - Track: Admin
Speaker: Hamish Watson
Title: DevOPs and the DBA
Abstract:
You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you.
In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery.
Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work
Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.
Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.
Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
SessionID: 71172
Six Degrees of Sql Family? - An introduction to Graph Databases in SQL Server and CosmosDB
Event Date: 03-03-2018 - Session time: 10:45:00 - Track: Dev
Speaker: Patrick Flynn
Title: Six Degrees of Sql Family? - An introduction to Graph Databases in SQL Server and CosmosDB
Abstract:
In this Session we will look at the theory and use of a Graph Database and its implementation in SQL Server 2017 and CosmosDB
The session will cover
What is a Graph Database?
Why are they useful? What problems do they solve?
How are they implemented in SQL Server and Cosmos DB.
In particular we will take the Speaker Data from 700+ SQLSaturday events to investigate the Social Network that underlies SQLFamily. Just how connected is everyone in the Microsoft Data Community?
SessionID: 71265
Take P, R or U and Solve your Data Quality Problems
Event Date: 03-03-2018 - Session time: 10:45:00 - Track: BI
Speaker: Oliver Engels
Title: Take P, R or U and Solve your Data Quality Problems
Abstract:
In a demo driven presentation, we show what libraries you can use to build score matrices, to build standardization processes, to do deduplication in ADLA or to build a Data Quality Dashboard in Power BI. There are a lot of fantastic functionalities in the Microsoft Data Platform to curate data. You need just to know how...
SessionID: 71442
Backup and Restore your SQL Server Database
Event Date: 03-03-2018 - Session time: 10:45:00 - Track: Admin
Speaker: Randolph West
Title: Backup and Restore your SQL Server Database
Abstract:
The primary goal of a DBA is being able to restore a database when needed.
In this session you will learn about data files and transaction logs, RTO and RPO, and how to choose the right recovery model for your environment.
You will be able to go back to work on Monday with a better understanding of database backups, and how to automate any database restore task.
SessionID: 71871
Power BI and Azure Machine Learning
Event Date: 03-03-2018 - Session time: 10:45:00 - Track: BI
Speaker: Anthony Bulk
Title: Power BI and Azure Machine Learning
Abstract:
Do you want to develop a visually stunning and interactive report to show off the predictive power of your Azure Machine Learning Model? You can, with Power BI and R. In this session, you will learn how to develop a Power BI report that uses an R script to integrate Azure machine learning results into SQL Server and build a visually stunning report. This session will include an overview, live demo as well as a deep dive into the code so that you can learn to apply it yourself.
SessionID: 73015
Microservice-Pattern using Serverless-Architectur (Azure Functions)
Event Date: 03-03-2018 - Session time: 10:45:00 - Track: Cloud
Speaker: Sia Ghassemi
Title: Microservice-Pattern using Serverless-Architectur (Azure Functions)
Abstract:
Today there are microservices and all shapes and colors and one of the most favorite implementation of this pattern is by leveraging a containerized-architecture. There are many companies doing it already and there are a zillion blogs and online resources for this.
But since microservice is a pattern, it can actually be implemented using different architectures, like the serverless-architecture.
In this Session we’ll see how to implement this pattern using Azure Functions, Microsoft’s implementation of the serverless-architecture.
SessionID: 73670
Columnstore Introductional Session
Event Date: 03-03-2018 - Session time: 10:45:00 - Track: Admin
Speaker: Niko Neugebauer
Title: Columnstore Introductional Session
Abstract:
The world of Data Warehousing and Business Intelligence has changed drastically over the last years, with the introduction of the Columnstore Indexes,
by the most Database Providers (Relational and Non-Relational). This new type of the Indexes (Columnstore) and the way of working with data (Batch Mode),
allows to improve performance of the massive workloads in 10s of times.
Microsoft has introduced the Columnstore Indexes for the relational engines in their appliance Parallel Data Warehouse, and in SQL Server 2012 the first version became available for the general database market. Since that version, a huge number of changes has been made to ensure the capacity and the performance of the Columnstore Indexes would be on the top.
In this introduction session I will show how the Columnstore Indexes achieve this performance, what are their essential internal elements and how can you get the best performance out of them.
SessionID: 75804
Ready Set Cloud!
Event Date: 03-03-2018 - Session time: 12:30:00 - Track: Cloud
Speaker: Andrew Boudreau
Title: Ready Set Cloud!
Abstract:
Organizations are looking at the cloud for modernizing their data landscape. We will take a closer look at the services and paths to modernize with Azure. From Data, Big Data and AI, Microsoft's cloud offers endless storage and compute for any size workload.
SessionID: 76894
Bring More Power Productivity to your SSIS Development
Event Date: 03-03-2018 - Session time: 12:30:00 - Track: Dev
Speaker: KingswaySoft Inc.
Title: Bring More Power Productivity to your SSIS Development
Abstract:
Want to get more out of your SSIS development efforts? The SSIS Productivity Pack is a collection of premium SSIS components which enable an improved SSIS ETL development experience with greater potentials. These SSIS components for connectivity and productivity offer more features and bring new enhancements to SSIS to enable integration scenarios not once possible without custom scripting.
In this session we will introduce you to our collection of 150 SSIS components. We will demonstrate some of our most popular offerings including our JSON XML components for integrating with REST APIs, Premium Derived Column with over 225 functions, and unique components such as Duplicate Detector and Diff Detector.
In additional to performing advanced transformations you will also find codeless and feature-rich solutions for integrating with virtually any application or database system including leading enterprise applications such as Microsoft SharePoint, Dynamics 365 and more.
SessionID: 76992
Getting Started with the Azure Cognitive Services
Event Date: 03-03-2018 - Session time: 12:30:00 - Track: Cloud
Speaker: Anthony Bulk
Title: Getting Started with the Azure Cognitive Services
Abstract:
Are you interested in adding artificial intelligence to your apps but you are worried that you do not have the required skills within your organization? Have you heard about Microsoft Cognitive Services?
Come join us for this exciting presentation and demo in which you will learn about Microsoft Cognitive Services and see a live demo of Dynamics CRM enhanced with Facial Recognition and Power BI.
You will not be dissappointed.
SessionID: 76994
SQL Server and Pure Storage: Love Your Storage
Event Date: 03-03-2018 - Session time: 12:30:00 - Track: Other
Speaker: Argenis Fernandez
Title: SQL Server and Pure Storage: Love Your Storage
Abstract:
Please join former SQL Server MVP, vExpert and Microsoft Certified Master Argenis Fernandez for an eye-opening session on how the innovative, industry-disruptive tech in the Pure Storage's FlashArray and FlashBlade arrays help your business do everything faster, easier. Faster transactional workloads, analytics, backups and maintenance, all without the pain of having to tweak a thousand knobs to get things to work. Finally storage you can love to use, and be proud to own! Come see what the fuss is all about.
SessionID: 77015
Simplifying SQL Data Protection
Event Date: 03-03-2018 - Session time: 12:30:00 - Track: Admin
Speaker: Michael Fal
Title: Simplifying SQL Data Protection
Abstract:
When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn't want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it's not about backing up, it's about going forward!
SessionID: 71854
Dynamic SQL: Tables, Pivots, Parameters More
Event Date: 03-03-2018 - Session time: 13:15:00 - Track: Dev
Speaker: Steven Tidwell
Title: Dynamic SQL: Tables, Pivots, Parameters More
Abstract:
SessionID: 71934
13 reasons why my query is slow
Event Date: 03-03-2018 - Session time: 13:15:00 - Track: Dev
Speaker: Fabiano Amorim
Title: 13 reasons why my query is slow
Abstract:
1- There is a nonsargable filter
2- An index is missing
3- It is a query optimizer mistake
4- The subquery is unnecessary
5- Query join order is incorrect
6- A filtered statistic is missing
7- Scalar functions are running twice per each row
8- High number of reads on worktable
9- An unknown syntax could be used
10- Memory grant wasn’t enough
11- Distributed query doesn't look good
12- Residual predicates
13- Avoid window spool ondisk
SessionID: 72462
100 Percent Online Schema Migrations
Event Date: 03-03-2018 - Session time: 13:15:00 - Track: Admin
Speaker: Michael J Swart
Title: 100 Percent Online Schema Migrations
Abstract:
High availability is an important goal, not just for the database but for all software services. There's increasing pressure to keep those services online 24/7/365. But there's also pressure to deploy improvements frequently. How can developers change the database schema without interrupting the availability?
In this session, I introduce and describe the "blue-green" continuous delivery technique - a strategy for replacing system components without down time. I explain what it looks like for database changes without sacrificing availability or performance.
I'll also describe how we gradually modified our process in baby steps. Going from maintenance window deployments to fully online deployments.
SessionID: 72469
Azure Analysis Services - An important step for BI in the cloud? [DE / EN]
Event Date: 03-03-2018 - Session time: 13:15:00 - Track: BI
Speaker: Gabi Münster
Title: Azure Analysis Services - An important step for BI in the cloud? [DE / EN]
Abstract:
Since April 2017 another fascinating PaaS in the Microsoft Cloud reached general availability: Azure Analysis Services.
But why should you switch from your existing on-premise solution to the cloud or plan your new approach with it? What are the big advantages of Azure Analysis Services? And what actually are the differences to PowerBI? Why is Azure Analysis Services an important step to enhancing the possibilities for BI in the cloud?
This session offers answers to your questions and provides insight to support the positioning of Azure Analysis Services in your Business Intelligence strategy.
SessionID: 72576
The Nine Realms of Power BI
Event Date: 03-03-2018 - Session time: 13:15:00 - Track: BI
Speaker: Paul Turley
Title: The Nine Realms of Power BI
Abstract:
Planning a Power BI solution and want to understand your options and choices? There is much to consider as you discover your data super powers. Like the old story of the Four Blind Men and The Elephant, if you ask four people to describe Power BI; you are likely to get four different answers. Power BI makes it easy to get started but things can get complicated quickly. Should you import your data and use the cloud service?; or keep your data on-premises using the gateway? Should you use DirectQuery or direct access to Analysis Services, multidimensional or tabular, in Azure or on-prem? What is the best method to secure data and control user access? How will users access dashboards reports? Can it be embedded? How do you license all this? Where do we start and how do we get there?
From simple desktop and published reports, to enterprise-scale and highly-secured solutions; I will distill all these options into categories and provide a roadmap to conquer each realm; from Mi
SessionID: 72740
Introduction to Cortana – Turning Data into Intelligent Action
Event Date: 03-03-2018 - Session time: 13:15:00 - Track: Cloud
Speaker: Melody Zacharias
Title: Introduction to Cortana – Turning Data into Intelligent Action
Abstract:
SessionID: 72751
PowerShell for SQL Server DBAs
Event Date: 03-03-2018 - Session time: 13:15:00 - Track: Admin
Speaker: Rodrigo Crespi
Title: PowerShell for SQL Server DBAs
Abstract:
In this session you will fall in love for PowerShell!
Come to know how the PowerShell works, how to use the .NET Framework, WMI, several PowerShell modules and how to create your own module for administration tasks in mixed and distributed environments.
Based in my experience since 2008 and with a previous experience in Linux environments, the PowerShell is highly useful tool for admin SQL Server instances and databases.
See you then!
SessionID: 71187
If a machine can learn, why can't YOU learn Azure Machine Learning?
Event Date: 03-03-2018 - Session time: 14:30:00 - Track: BI
Speaker: André Melancia
Title: If a machine can learn, why can't YOU learn Azure Machine Learning?
Abstract:
Are you a DBA or Developer and would like to get started with AzureML the EASY WAY?
AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too...
Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.
SessionID: 71266
Get the Most Visual Power
Event Date: 03-03-2018 - Session time: 14:30:00 - Track: BI
Speaker: Yana Berkovich
Title: Get the Most Visual Power
Abstract:
Which visuals from the custom visuals free gallery can be the most useful and the prettiest to look at? What are the limitations?
When would we choose to create a custom visual? What would be the business case and how should I start?
Comparing the free solutions in the PowerBI visuals Gallery. Given in the PowerBI Vancouver user group (https://www.meetup.com/Vancouver-Power-BI-User-Group/events/240243704/), YouTube (https://www.youtube.com/watch?v=aigmvBp-uX4t=10s) the session assumes a basic understanding of PowerBI concepts. This session is targeted to business users, admins, BA's and everyone who enjoys the visual power of PowerBI.
SessionID: 71333
Essential Linux for the SQL Server DBA
Event Date: 03-03-2018 - Session time: 14:30:00 - Track: Admin
Speaker: Kellyn Pot'Vin-Gorman
Title: Essential Linux for the SQL Server DBA
Abstract:
Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for years to manage their databases on this valuable OS?
This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience. The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment.
We’ll learn:
- Linux history and concepts.
- Important differences between systems
- Crucial commands to get around
a. Navigating, searching and managing
b. Monitoring, tracing and updating
c. Editing and scripting
You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!
SessionID: 71824
When Things go Wrong - Error Handling in SQL Server
Event Date: 03-03-2018 - Session time: 14:30:00 - Track: Dev
Speaker: Erland Sommarskog
Title: When Things go Wrong - Error Handling in SQL Server
Abstract:
In an ideal world, we would not need any error handling, because there would be no errors. But in the real world we need to have error handling in our stored procedures. Error handling in SQL Server is a most confusing topic, because there are such great inconsistencies. But that does not mean that we as database developers can hide our head in the sand.
This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
SessionID: 71872
Modernizing your legacy database integration points
Event Date: 03-03-2018 - Session time: 14:30:00 - Track: Dev
Speaker: Ian Chamberland
Title: Modernizing your legacy database integration points
Abstract:
Legacy corporate applications that are built in-house can quite often be tightly coupled together. Either you have cross database connections, load jobs, linked servers, multiple copies of data, etc. These design patterns increase your technical debt and application changes will need to carefully consider the impact to the downstream applications. Tightly coupled databases can also make migration/upgrade projects more difficult, especially as you start to looking towards cloud based solutions.
What if your organization has started to implement newer design patterns and technologies like microservices, restful web integration or enterprise service buses? Do you have to re-write all of your legacy applications to use these new technologies?
This presentation will show a method that was used to update legacy applications to utilize an integration middleware platform without a major re-write of the application. We will then expand on this and show how your SQL Server database could
SessionID: 72060
Data Landscape on Azure
Event Date: 03-03-2018 - Session time: 14:30:00 - Track: Cloud
Speaker: Sepand Gojgini
Title: Data Landscape on Azure
Abstract:
SessionID: 71163
Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
Event Date: 03-03-2018 - Session time: 15:45:00 - Track: BI
Speaker: Scott Stauffer
Title: Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
Abstract:
You've heard about Power BI, and you've seen it, but you haven't yet rolled up your sleeves and got your hands dirty. It looks like it is really easy, but sometimes it helps to have someone step you through it the first time to help you hit the ground running. We will grab various public data sources, join them together in a model and build an interactive pièce de ré·sis·tance on the visual design surface!
SessionID: 72130
Hardening SQL Server in a legacy environment
Event Date: 03-03-2018 - Session time: 15:45:00 - Track: Admin
Speaker: Martin Stoller
Title: Hardening SQL Server in a legacy environment
Abstract:
Do you have a lot of legacy applications using your SQL servers? Do you still have to run older versions of SQL server, because the app vendors are slow to upgrade? Are you rightfully worried that one day, you too will suffer a malicious attack on your precious data?
This session covers the essentials on starting to harden your SQL servers so they can have a much better chance of withstanding attacks - such as the currently popular Ransom Ware wave.
We will be looking at the basic strategies of keeping your backups truly safe, how to successfully monitor for anomalies, and also how to incrementally implement basic in transit encryption (IPSEC).
SessionID: 72468
Using Microsoft Flow with Microsoft SQL
Event Date: 03-03-2018 - Session time: 15:45:00 - Track: Cloud
Speaker: Alec McCauley
Title: Using Microsoft Flow with Microsoft SQL
Abstract:
SessionID: 72492
Internet Of Things: Smart Mirror
Event Date: 03-03-2018 - Session time: 15:45:00 - Track: Dev
Speaker: Andrew Cook
Title: Internet Of Things: Smart Mirror
Abstract:
A look at the intersection of hardware, software, and internet. See what it takes to bring your next workshop project to life including stories about the success and failures of creating a Smart Mirror. We will take a look into hardware including that from the hardware store and the software required to make the magic happen.
SessionID: 72497
Magical Memory Moments
Event Date: 03-03-2018 - Session time: 15:45:00 - Track: Admin
Speaker: Arnie Rowland
Title: Magical Memory Moments
Abstract:
OR, How In-Memory Objects Can Supercharge Your Data And Bring About World Peace
OK, so you’ve been reading about, perhaps even testing out some of the ‘in-memory’ objects now available in SQL Server. Some of the claims are exciting, and some seem overly optimistic. And Yet, you want to know, experience more … Perhaps your situation doesn’t really call out for in-memory tables. But you should consider memory-optimized #Temp tables, memory-optimized table variables, and natively compiled stored procedures.It’s true. Using memory-optimized tables requires a little more fore-thought, a bit more care, even a few configuration tweaks.
• But what are the real advantages of memory-optimized objects?
• What are the memory-optimized objects you can use?
• How can you best use memory-optimized objects?
In this demo packed session, we will discuss the pros and cons of using memory-optimized objects in ways that will supercharge your SQL Server.
SessionID: 72656
Analyzing real-time data using Azure Streaming Analytics
Event Date: 03-03-2018 - Session time: 15:45:00 - Track: BI
Speaker: Michael Johnson
Title: Analyzing real-time data using Azure Streaming Analytics
Abstract:
SessionID: 73170
Multi-Tenant database using RLS – Case Study
Event Date: 03-03-2018 - Session time: 15:45:00 - Track: Dev
Speaker: Pat Jesson
Title: Multi-Tenant database using RLS – Case Study
Abstract:
At R2C Group we considered numerous approaches to supporting a multi-tenant environment for our legacy SQL database and application suite. After careful analysis and some prototyping we selected a design using the new at the time in MS-SQL 2016 Row Level Security (RLS) capability.
This presentation will discuss the analysis that went into the decision then jump right into the implementation. I'll share actual code used and demonstrate how it all works.