Nr: 620
SQLSaturday #620 - Dublin 2017
SessionID: 58054
Reports on the Run: Mobile Reporting with SQL Server 2016
Event Date: 17-06-2017 - Session time: 08:00:00 - Track: BI
Speaker: Peter Myers
Title: Reports on the Run: Mobile Reporting with SQL Server 2016
Abstract:
Based on the acquisition of Datazen, Reporting Services now includes a new engine enabling the delivery of mobile reports. In this session you will learn about this new capability delivered with SQL Server 2016, including the architecture of the engine and the development of reports.
This session will describe and demonstrate how to prepare data for mobile reporting, and also how to develop and publish mobile reports. In addition, it will describe the architecture of the engine, and how to manage mobile reports.
This session will be of interest to a full range of professionals, including analysts, report developers, IT managers, and data architects.
SessionID: 58133
Azure SQL Data Warehouse 101
Event Date: 17-06-2017 - Session time: 08:00:00 - Track: Cloud
Speaker: John Martin
Title: Azure SQL Data Warehouse 101
Abstract:
What is Azure SQL Data Warehouse, why and how should I use it? Here we will look at the fundamental basics to answer these questions and more, giving you the foundation knowledge to get started. This session will arm you with the core knowledge of how the DW engine differs to the traditional SQL Server database. Helping you understand key concepts such as Distributions and the Control/Compute structure, along with many others. Allowing you to be confident as you start to asses and use Azure SQL Data Warehouse.
SessionID: 59745
Query Plan Deep Dive
Event Date: 17-06-2017 - Session time: 08:00:00 - Track: Dev
Speaker: Kevin Boles
Title: Query Plan Deep Dive
Abstract:
SessionID: 60950
An introduction to SQL Server Containers
Event Date: 17-06-2017 - Session time: 08:00:00 - Track: DBA
Speaker: Andrew Pruski
Title: An introduction to SQL Server Containers
Abstract:
This session aims to give attendees an introduction into containers running SQL Server on Windows Server 2016.
Attendees will be taken through the following: -
Defining what containers are (benefits and limitations)
Configuring Windows Server 2016 to run containers
Installing the docker engine
Pulling SQL images from the docker respository
Running SQL Server containers
Committing new SQL Server images
Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)
This sessions assumes that attendees have a good background in SQL Server administration and a basic knowledge of
Windows Server administration
SessionID: 60951
Revenge: The SQL!
Event Date: 17-06-2017 - Session time: 08:00:00 - Track: DBA
Speaker: Rob Volk
Title: Revenge: The SQL!
Abstract:
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
SessionID: 59699
The Query Store and Query Tuning in SQL Server
Event Date: 17-06-2017 - Session time: 09:15:00 - Track: DBA
Speaker: Grant Fritchey
Title: The Query Store and Query Tuning in SQL Server
Abstract:
For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store.
This session will explore how the Query Store works and how it’s going to change the methods you use to tune and troubleshoot query performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need in order to put it to work with your own SQL Server 2016 tuning efforts, as well as your Azure SQL Databases.
SessionID: 59721
The RDBMS is Dead, Long Live the RDBMS!
Event Date: 17-06-2017 - Session time: 09:15:00 - Track: DBA
Speaker: Buck Woody
Title: The RDBMS is Dead, Long Live the RDBMS!
Abstract:
In the last 40 years, the “death” of the Relational Database Management System has been predicted over and over – and yet the platform survives. It has adapted, grown, improved and thrived. As a data professional, how does your career change as the platform changes? Which buzzwords are “real” – what do you need to learn, and what skills do you need to pursue? Come join Buck Woody, Microsoft’s “Real world DBA” and explore the history - and future - of the RDBMS.
SessionID: 66027
Introduction to Microsoft AI and Azure Bot Framework
Event Date: 17-06-2017 - Session time: 09:15:00 - Track: Big Data and Analytics
Speaker: Emma Reid
Title: Introduction to Microsoft AI and Azure Bot Framework
Abstract:
This session will provide an overview of Microsoft’s approach to Artificial Intelligence and will show you how you can quickly create a bot using the Azure Bot Framework with limited coding. From there you’ll learn how you can gain deep insights using Application Insights and Power BI
SessionID: 59307
Responding to Extended Events in near real-time
Event Date: 17-06-2017 - Session time: 10:30:00 - Track: DBA
Speaker: Gianluca Sartori
Title: Responding to Extended Events in near real-time
Abstract:
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, such as capturing and notifying deadlocks or blocking sessions.
SessionID: 59313
Using M for data access in Analysis Services Tabular v.next
Event Date: 17-06-2017 - Session time: 10:30:00 - Track: BI
Speaker: Chris Webb
Title: Using M for data access in Analysis Services Tabular v.next
Abstract:
SessionID: 59337
New T-SQL Capabilities in SQL Server 2016 and Azure SQL Database
Event Date: 17-06-2017 - Session time: 10:30:00 - Track: DBA
Speaker: Aaron Bertrand
Title: New T-SQL Capabilities in SQL Server 2016 and Azure SQL Database
Abstract:
Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS / DECOMPRESS, from AT TIME ZONE to DATEDIFF_BIG(), and from SESSION_CONTEXT() to new query hints like NO_PERFORMANCE_SPOOL and MIN / MAX_GRANT_PERCENT, as well as some other surprises, you’ll walk away with a long list of reasons to consider upgrading to the latest version or finally trying out Azure SQL Database.
SessionID: 60982
Event Date: 17-06-2017 - Session time: 10:30:00 - Track: Cloud
Speaker: André Kamman
Abstract:
In this session we will learn how to deploy Azure resources with (partial) Azure Resource Manager (ARM) templates and Powershell. There will be a very strong emphasis on the Data Platform. Learn how to create reusable templates so you can create Production/UAT/Test/Development environments, or create Proof of Concept environments with automated tests quickly.
SessionID: 61498
Lightning Talks
Event Date: 17-06-2017 - Session time: 10:30:00 - Track: Professional Development
Speaker: SqlSatDublin .
Title: Lightning Talks
Abstract:
Come along for some banter from celebrity judges award best lightning speaker and best new speaker.
The format is fast paces five minute lightning talks with anything goes topics across SQL Server and Data Platform
SessionID: 57947
Think work like a Data Scientist with SQL 2016 R
Event Date: 17-06-2017 - Session time: 11:45:00 - Track: Big Data and Analytics
Speaker: Dr. Subramani Paramasivam
Title: Think work like a Data Scientist with SQL 2016 R
Abstract:
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
SessionID: 59341
Investigate TempDB like Sherlock Holmes
Event Date: 17-06-2017 - Session time: 11:45:00 - Track: DBA
Speaker: Lord Richard Douglas
Title: Investigate TempDB like Sherlock Holmes
Abstract:
The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session, you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affects everybody on that instance.
You will leave this session prepared to create better architecture decisions and better code to improve the performance for all of your users.
SessionID: 60958
Taming the Open Source Beast with Azure for Business Intelligence
Event Date: 17-06-2017 - Session time: 11:45:00 - Track: Cloud
Speaker: Jen Stirrup
Title: Taming the Open Source Beast with Azure for Business Intelligence
Abstract:
Today, CIOs and other business decision-makers are increasingly recognizing the value of open source software and Azure cloud computing for the enterprise, as a way of driving down costs whilst delivering enterprise capabilities.
For the Business Intelligence professional, how can you introduce Open Source into the Enterprise in a robust way, whilst also creating an architecture that accommodates cloud, on-premise and hybrid architectures?
We will examine strategies for using open source technologies to improve existing common Business Intelligence issues, using Azure as our backdrop. These include:
- incorporating Apache projects, such as Apache Tika, for your BI solution
- using Redis Cache in Azure in as a engine as part of your SSIS toolkit
Join this session to learn more about open source in Azure for Business Intelligence. Open Source does not mean on premise.
Demos will provide practical takeaways in your Business Intelligence Enterprise architecture.
SessionID: 61278
Plan Cache Pollution: Dealing with Ad Hoc Madness
Event Date: 17-06-2017 - Session time: 11:45:00 - Track: Dev
Speaker: Kimberly Tripp
Title: Plan Cache Pollution: Dealing with Ad Hoc Madness
Abstract:
SessionID: 64906
Event Date: 17-06-2017 - Session time: 11:45:00 - Track: Dev
Speaker: Emanuele Zanchettin
Abstract:
SessionID: 66427
Scaling out SQL Server in Azure – Canadian Music Industry Case St
Event Date: 17-06-2017 - Session time: 13:00:00 - Track: BI
Speaker: John Corley
Title: Scaling out SQL Server in Azure – Canadian Music Industry Case St
Abstract:
This session will showcase a real world solution that scales out on premise SQL Server to Azure SQL dynamically based on peak workload.
The solution processes hundreds of millions of sales transactions from popular online music services such as iTunes, Spotify and YouTube.
Key processes that previously would have taken a number of weeks can now be completed in under a day.
SessionID: 58222
Problem Solving With The In-Memory Engine
Event Date: 17-06-2017 - Session time: 14:00:00 - Track: Dev
Speaker: Christopher Adkin
Title: Problem Solving With The In-Memory Engine
Abstract:
- Staging data as fast as possible
- Turbo charging scalar aggregate functions
- Implementing a scalable sequence
- Overcoming the performance limitations of temporary tables
- Making the critical path in your code base run faster
SessionID: 58271
Introduction to U-SQL and Data Lake
Event Date: 17-06-2017 - Session time: 14:00:00 - Track: Big Data and Analytics
Speaker: Alex Whittles
Title: Introduction to U-SQL and Data Lake
Abstract:
SessionID: 61377
Azure IoT, Windows 10 Core Raspberry PI (DIY)
Event Date: 17-06-2017 - Session time: 14:00:00 - Track: Cloud
Speaker: Jens Vestergaard
Title: Azure IoT, Windows 10 Core Raspberry PI (DIY)
Abstract:
This session will begin, with a high level introduction to Azure Internet of Things, Windows 10 Core and Raspberry PI. Once we have established the basics about the technology, we will be connecting the dots with a live demo on some of the parts. The focus during the demo, will mainly be on Azure IoT Hub, Windows 10 Core and the Raspberry PI and how to DIY. As visualization we will be using Power BI to present the data.
This session is not for the Enterprise rather has a more DIY approach.
SessionID: 61499
The 2017 Expert Panel
Event Date: 17-06-2017 - Session time: 14:00:00 - Track: Professional Development
Speaker: SqlSatDublin .
Title: The 2017 Expert Panel
Abstract:
Discuss what's moving and shaking in the Data World with our Expert Panel.
If you want to join in the expert panel discussion come along to the session at 14PM in Room 1 (Davis). Buck Woody is hosting the session along with a selection of his friends including Paul Randal, Kimberly Tripp, Chris Webb and Jen Stirrup.
Bring along any tough questions or some thing to start a discussion.
Submit your questions live on twitter via #SqlSatDublin or just come along.
SessionID: 66295
PowerShell ❤ SQL Server: Modern Database Administration with dbat
Event Date: 17-06-2017 - Session time: 14:00:00 - Track: DBA
Speaker: Chrissy LeMaire
Title: PowerShell ❤ SQL Server: Modern Database Administration with dbat
Abstract:
Join PowerShell MVP DBA Chrissy LeMaire and PowerShell Expert DBA Rob Sewell to learn how PowerShell can help improve your work/bacon life balance.
We will show you how to perform many DBA tasks easily and simply using PowerShell, from instance migrations to automated backup testing and more. Our session is aimed at DBAs, from junior to senior, who want to embrace the ease of automation and increase their toolset.
SessionID: 58268
Social Engineering: Hacking People
Event Date: 17-06-2017 - Session time: 15:15:00 - Track: Professional Development
Speaker: Mladen Prajdić
Title: Social Engineering: Hacking People
Abstract:
"It is much easier to trick someone into giving a password for a system than to spend the effort to crack into the system."
This is a common line of thought in today's world of increased cyber-security dangers.
In this interactive session we'll take a look at how social engineering works,
the psychology behind it and why is it still the most effective way to gain access to your company's secrets.
The best attacks happen when people don't even realize they are being attacked and
in this session we're going to try to fix that and educate you on how to realize when someone is trying to hack you.
SessionID: 59809
Advanced Data Recovery Techniques
Event Date: 17-06-2017 - Session time: 15:15:00 - Track: DBA
Speaker: Paul Randal
Title: Advanced Data Recovery Techniques
Abstract:
SessionID: 61504
Use Biml to Automate SSIS Design Patterns
Event Date: 17-06-2017 - Session time: 15:15:00 - Track: BI
Speaker: Andy Leonard
Title: Use Biml to Automate SSIS Design Patterns
Abstract:
Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.
In this session, you will learn:
- How to rapidly build multiple SSIS packages using Biml
- How to apply different SSIS Design Patterns using Biml
- How to automate SSIS Design Patterns using Biml
SessionID: 65062
Microsoft R Server 9.1 Update: Delivering Innovation in Data AI
Event Date: 17-06-2017 - Session time: 15:15:00 - Track: Big Data and Analytics
Speaker: Soren Johansen
Title: Microsoft R Server 9.1 Update: Delivering Innovation in Data AI
Abstract:
This presentation will give an update on all the new features in Microsoft R Server 9.1. We will see how we can do advanced Text mining (n-grams sentiment) and run deep learning networks for image recognition with a few lines of R code. Spark is the new in-memory frame-work for Machine Learning and we will see examples on how we easy it is to work in Spark compute context and utilize Spark for improving performance. Many customers have requirement for running "many models" e.g. Churn model per segment etc. Microsoft have develop new functions that enables the data scientist to apply these many models scenarios. This release includes significant innovations such as:
• New machine learning enhancements and inclusion of pre-trained cognitive models such as sentiment analysis image featurizers
• SQL Server Machine Learning Services with integrated Python in Preview
• Interoperability between Microsoft R Server and sparklyr.
• New machine learning models in Hadoop and Spark.
SessionID: 65851
Introduction to PESTER - TDD for PowerShell
Event Date: 17-06-2017 - Session time: 15:15:00 - Track: Dev
Speaker: Rob Sewell
Title: Introduction to PESTER - TDD for PowerShell
Abstract:
An introduction session for using Pester to test your PowerShell code
Pester provides a framework for running unit tests to execute and validate PowerShell commands from within PowerShell.
I will show you can get started using Test Driven Development for your PowerShell scripting.
We will examine Pester, the syntax and show plenty of demos and build a function that uses the Microsoft Cognitive Services Faces API to analyse Beards