sqlsathistory

Nr: 809

Back to Main list

SQLSaturday #809 - Wellington 2019

Start Time (24h) Speaker Track Title
10:00:00 Sandy Winarko Information Delivery, Analytics and Visualization Embrace and Extend: First-Class Activity and 3rd Party Ecosystem for SSIS in ADF
10:00:00 Warwick Rudd Database Development, Administration DevOps SQLOpsStudio Vs SSMS - There can be only one
10:00:00 David Alzamendi Data Architecture Design Business Intelligence On-Premises or in the Cloud?
10:00:00 Charles Sterling Data Science and Artificial Intelligence A look at Microsoft Data Flows with Charles Sterling
11:00:00 Craig McGregor Database Development, Administration DevOps Let's do the DbaOps: Creating automated, testable installations of SQL Server
11:00:00 Matt Allington Information Delivery, Analytics and Visualization DAX as a Query Language
11:00:00 Mohammad Hafizullah Data Architecture Design Lets graph it!!!
11:00:00 Leila Etaati Data Science and Artificial Intelligence AI in Power BI Service: Data Flow and Machine Learning
11:00:00 Reza Rad Information Delivery, Analytics and Visualization Unleash Row Level Security Patterns in Power BI
11:00:00 Amit R S Bansal Database Development, Administration DevOps Real-World Query Tuning Examples
12:00:00 Hamish Watson Database Development, Administration DevOps Test Driven Development in SQL Server – how to deploy code safer
12:00:00 Indira Bandari Information Delivery, Analytics and Visualization Top 10 tips every Power BI developer should know
12:00:00 Ken Puls Information Delivery, Analytics and Visualization BI in Modern Excel: The value is in the Refresh
12:00:00 Martin Catherall Database Development, Administration DevOps SQL Developer Tips and Tricks
13:45:00 Craig Bryden Information Delivery, Analytics and Visualization SSRS and Power BI Report Server - What's New
13:45:00 Ondrej Aubrecht Data Architecture Design Can really Naming Convention and standards save your environment
13:45:00 Manohar Punna Information Delivery, Analytics and Visualization Bridging the gap between SSRS and Power BI
13:45:00 Adrian Sullivan Database Development, Administration DevOps A wild SQL server appears - Real world SQL server triage.
13:45:00 Anupama Natarajan Data Science and Artificial Intelligence Introduction to Azure Cognitive Services
14:45:00 Vinod Kumar M Database Development, Administration DevOps Back to School: SQL Server Security Unknown, Unplugged
14:45:00 Phillip Seamark Information Delivery, Analytics and Visualization Creative DAX
14:45:00 Patrick Flynn Database Development, Administration DevOps GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects
14:45:00 Dave Dustin Database Development, Administration DevOps Beyond Devops - Introducing Data Reliability Engineering

SessionID: 85217

Embrace and Extend: First-Class Activity and 3rd Party Ecosystem for SSIS in ADF

Back to calendar

Event Date: 23-02-2019 - Session time: 10:00:00 - Track: Information Delivery, Analytics and Visualization

Speaker: Sandy Winarko

Title: Embrace and Extend: First-Class Activity and 3rd Party Ecosystem for SSIS in ADF

Abstract:

This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR). We will first show you how to provision Azure-SSIS IR - dedicated ADF servers for lifting shifting SSIS packages - and extend it with custom/3rd party components. You can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/execute/monitor your SSIS packages in the cloud just like you do on premises. Next, we will guide you to trigger/schedule SSIS package executions as first-class activities in ADF pipelines and combine/chain them with other activities, allowing you to inject/splice built-in data transformations in your ETL/ELT workflows, provision Azure-SSIS IR on demand/just in time, etc. And finally, you will learn about the licensing model for ISVs to develop paid components/extensions and join the growing 3rd party ecosystem for SSIS in ADF.

SessionID: 85705

SQLOpsStudio Vs SSMS - There can be only one

Back to calendar

Event Date: 23-02-2019 - Session time: 10:00:00 - Track: Database Development, Administration DevOps

Speaker: Warwick Rudd

Title: SQLOpsStudio Vs SSMS - There can be only one

Abstract:

SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS?

In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.

SessionID: 87444

Business Intelligence On-Premises or in the Cloud?

Back to calendar

Event Date: 23-02-2019 - Session time: 10:00:00 - Track: Data Architecture Design

Speaker: David Alzamendi

Title: Business Intelligence On-Premises or in the Cloud?

Abstract:

If you are hesitating between choosing a Business Intelligence Solution in the cloud or on-premises, this session will provide you with the different options on-premises as well in Azure to take into account regarding your Business Intelligence architecture.

During the past few years we have been experiencing vast changes in the Business Intelligence space, not only related to data analytics, data modelling or applications, but also the importance of infrastructure.

In this presentation, I will explain how to get the best from both worlds.

SessionID: 88370

A look at Microsoft Data Flows with Charles Sterling

Back to calendar

Event Date: 23-02-2019 - Session time: 10:00:00 - Track: Data Science and Artificial Intelligence

Speaker: Charles Sterling

Title: A look at Microsoft Data Flows with Charles Sterling

Abstract:

Preparing and defining ETL for insights is significant challenge for businesses today—ingestion, cleansing, transformation, and enrichment are labor-intensive and time-consuming tasks, which require deep technical skills. Power BI now introduces advanced data prep with dataflows—a suite self-service low-code/no-code features and capabilities for business analysts to easily process and unify their data and store it in Azure-based data-lake storage. With these new capabilities, Power BI offers a solution for any business need—whether you want to prep your data with ease, using a familiar built-in Power Query experience, or to leverage the full Azure stack for more advanced use-cases. Join this session to learn how to easily prep your data, leverage Microsoft’s standardized schema, improve time-to-value, eliminate data silos, and create one source of truth for your organizational insights. This session will also finish with a look at some of the AI features that will be coming soon!

SessionID: 86118

Let's do the DbaOps: Creating automated, testable installations of SQL Server

Back to calendar

Event Date: 23-02-2019 - Session time: 11:00:00 - Track: Database Development, Administration DevOps

Speaker: Craig McGregor

Title: Let's do the DbaOps: Creating automated, testable installations of SQL Server

Abstract:

Do you know if your development, test and production environments created were equally?

How many SQL instances are you responsible for? Do you know if they are installed and configured consistently? If a dog ate your SAN, could you rebuild them 'by lunchtime'?

In this presentation we'll walk through a live demo using reusable community resources to automatically install, configure and verify the installation of SQL Server(s) that implement best practices using Powershell Desired State Configuration, dbachecks.io and other community resources.

SessionID: 86578

DAX as a Query Language

Back to calendar

Event Date: 23-02-2019 - Session time: 11:00:00 - Track: Information Delivery, Analytics and Visualization

Speaker: Matt Allington

Title: DAX as a Query Language

Abstract:

Many people (business and IT) already use Power Pivot, Power BI and SSAS Tabular to produce reporting and analytics tools. But did you know that these tools also have their own query language? In traditional databases such as SQL server, it is possible to extract data into a new table. The same is possible using DAX as a query language with a tabular data model.

In this session, Matt will introduce the topic and show how you can use DAX Studio to connect to a data model. Once connected, DAX studio can be used to write queries over the tabular data model to start to interrogate the data itself (as opposed to simply aggregating the values into a pivot table or a Power BI report). The learning can then be used to write more complex DAX measures or alternatively it can be used to extract tabular data directly into a table for further analysis.

SessionID: 87588

Lets graph it!!!

Back to calendar

Event Date: 23-02-2019 - Session time: 11:00:00 - Track: Data Architecture Design

Speaker: Mohammad Hafizullah

Title: Lets graph it!!!

Abstract:

SessionID: 87977

AI in Power BI Service: Data Flow and Machine Learning

Back to calendar

Event Date: 23-02-2019 - Session time: 11:00:00 - Track: Data Science and Artificial Intelligence

Speaker: Leila Etaati

Title: AI in Power BI Service: Data Flow and Machine Learning

Abstract:

There is a possibility to do Machine Learning in Power BI Service. This feature has been added recently to Power BI service. In this session, first, some concepts regarding machine learning and AI will be provided. For instance, the audience will learn what is Classification, Regression, Clustering, and Forecasting will be presented. Next, how we able to get data in Data Flow in Power BI service from blob storage, how to use Data Flow to clean the data, then how to apply machine learning to cleaned data will be provided.

SessionID: 88222

Unleash Row Level Security Patterns in Power BI

Back to calendar

Event Date: 23-02-2019 - Session time: 11:00:00 - Track: Information Delivery, Analytics and Visualization

Speaker: Reza Rad

Title: Unleash Row Level Security Patterns in Power BI

Abstract:

Security is different from Sharing, Sharing is about sharing the entire content with others, security is about authorizing different views of the content to others. In this session we go through many different Row Level Security patterns; Static Row Level Security, Dynamic Row Level Security, and many variations of the dynamic RLS, such as giving manager access as well as employee access, you will learn about user profile security scenarios, and hierarchical access levels. This session shows you how DAX and Power BI security comes together to play an important part of a Power BI project lifecycle: Row Level Security. Session is full of demos and you will learn these concepts through many live demos.

SessionID: 90483

Real-World Query Tuning Examples

Back to calendar

Event Date: 23-02-2019 - Session time: 11:00:00 - Track: Database Development, Administration DevOps

Speaker: Amit R S Bansal

Title: Real-World Query Tuning Examples

Abstract:

Join Microsoft Certified Master of SQL Server, Amit Bansal, and learn some real-world query tuning examples. In this deep-dive session you will learn how you can re-write T-SQL queries using new constructs to improve performance. You will learn how you can tune indexes deal with statistics to improve query performance. This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured.

SessionID: 84442

Test Driven Development in SQL Server – how to deploy code safer

Back to calendar

Event Date: 23-02-2019 - Session time: 12:00:00 - Track: Database Development, Administration DevOps

Speaker: Hamish Watson

Title: Test Driven Development in SQL Server – how to deploy code safer

Abstract:

Test Driven Development (TDD) is a design approach which has enabled application developers to write cleaner code.

It is relevant for database development as it ensures that code produced using TDD and unit tests will be of higher quality which means interactions with data will be safer. TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code. In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery. A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code safer.

SessionID: 87167

Top 10 tips every Power BI developer should know

Back to calendar

Event Date: 23-02-2019 - Session time: 12:00:00 - Track: Information Delivery, Analytics and Visualization

Speaker: Indira Bandari

Title: Top 10 tips every Power BI developer should know

Abstract:

In this session, I will be sharing 10 tips that everyone should know. I am sure everyone will learn a few things that they didn't know. I will be going through webscraping tips, adding a few dynamic things to improve your reports etc.

SessionID: 88206

BI in Modern Excel: The value is in the Refresh

Back to calendar

Event Date: 23-02-2019 - Session time: 12:00:00 - Track: Information Delivery, Analytics and Visualization

Speaker: Ken Puls

Title: BI in Modern Excel: 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: 88219

SQL Developer Tips and Tricks

Back to calendar

Event Date: 23-02-2019 - Session time: 12:00:00 - Track: Database Development, Administration DevOps

Speaker: Martin Catherall

Title: SQL Developer Tips and Tricks

Abstract:

Martin has seen life from a few different sides of the database environment. Often the world of TSQL and DBA are seen from vastly different viewpoints – but it doesn’t have to be this way. Join Martin to find out some ways that these two groups can enhance each other’s life and work as efficiently as possible. We’ll examine a range of tip during this presentation that most SQL professionals should get value from.

SessionID: 85056

SSRS and Power BI Report Server - What's New

Back to calendar

Event Date: 23-02-2019 - Session time: 13:45:00 - Track: Information Delivery, Analytics and Visualization

Speaker: Craig Bryden

Title: SSRS and Power BI Report Server - What's New

Abstract:

In SQL 2016, SQL Server Reporting Services (SSRS) underwent massive changes with the addition of many new reporting features. Since that release, there have been many further developments, including the release of Power BI Report Server and subsequent SSRS versions. In this demo laden session, Craig will recap the changes that SSRS has undergone from SSRS 2016 onwards, as well as look at and discuss Power BI Report Server.This session will be valuable for anyone new to SSRS, or anyone who has not had an opportunity to work with the latest versions of SSRS.

SessionID: 87555

Can really Naming Convention and standards save your environment

Back to calendar

Event Date: 23-02-2019 - Session time: 13:45:00 - Track: Data Architecture Design

Speaker: Ondrej Aubrecht

Title: Can really Naming Convention and standards save your environment

Abstract:

Are you managing your "chaos" environment but still can't move forward to start improvements and automation successfully?

Do you really know how is your SQL instance, permissions and servers configured and why you are still missing strong and persistence naming structure and standards?

This session will be focusing on the Naming convention and standards in the infrastructure environment and how to apply it correctly, which also includes SQL Database objects.

SessionID: 88268

Bridging the gap between SSRS and Power BI

Back to calendar

Event Date: 23-02-2019 - Session time: 13:45:00 - Track: Information Delivery, Analytics and Visualization

Speaker: Manohar Punna

Title: Bridging the gap between SSRS and Power BI

Abstract:

Traditionally, SSRS is used for paginated reports which gives flexibility like drill through reports, subscriptions and print formatting. With Power BI the reports are now more interactive and dynamic. There are still few gaps between these two platforms which are built to purpose. This gap is getting smaller as features are ported between these two platforms. In this session I will be going through various features which are bridging these gaps and point out the differences. These are significant and can affect your decision in choosing the right platform which will fit your needs.

SessionID: 88372

A wild SQL server appears - Real world SQL server triage.

Back to calendar

Event Date: 23-02-2019 - Session time: 13:45:00 - Track: Database Development, Administration DevOps

Speaker: Adrian Sullivan

Title: A wild SQL server appears - Real world SQL server triage.

Abstract:

Finance is crying, a random SQL server is running slow, and now it's your problem.

How do you now go about looking for what the likely cause of the bad behavior might be? You are an accidental/junior/mid-level DBA and now the pressure is on. In this session we will look at Triage – where is it hurting, and how much is it hurting. We will touch on some techniques, tools and quick fixes that will buy you some more time and maybe even resolve the problem.

SessionID: 90484

Introduction to Azure Cognitive Services

Back to calendar

Event Date: 23-02-2019 - Session time: 13:45:00 - Track: Data Science and Artificial Intelligence

Speaker: Anupama Natarajan

Title: Introduction to Azure Cognitive Services

Abstract:

Azure Cognitive Services are APIs available to develop Intelligent applications. In this session you will get to know about the catalog of Azure Cognitive Services and learn how Cognitive Services makes it easy for developers to get started infusing AI into their applications.

SessionID: 85081

Back to School: SQL Server Security Unknown, Unplugged

Back to calendar

Event Date: 23-02-2019 - Session time: 14:45:00 - Track: Database Development, Administration DevOps

Speaker: Vinod Kumar M

Title: Back to School: SQL Server Security Unknown, Unplugged

Abstract:

When it comes to security, we assume we know everything and have covered every aspect. But a lot of security implementations and nuances are not known by many. Come into this session to know the tips and tricks that you will need to know working with SQL Server Security.

SessionID: 86834

Creative DAX

Back to calendar

Event Date: 23-02-2019 - Session time: 14:45:00 - Track: Information Delivery, Analytics and Visualization

Speaker: Phillip Seamark

Title: Creative DAX

Abstract:

Did you know the DAX language is far more capable than merely running a SUM over a column, or counting rows in a table? DAX sits on top of one of the fastest databases around, and this session will explore some unusual and creative scenarios that you previously would have thought as not possible using just DAX.

The session will aim to reset your understanding of what is possible in DAX by walking through some interesting code highlights from a recent series of games built using DAX (Blackjack, Sudoku , Tic Tac Toe , Hangman Minesweeper). Each game pushes and explores different boundaries in DAX and will attempt to show just where those lines are.

The session will hopefully inspire you to add some creative and exciting techniques to your own DAX based data models.

SessionID: 87303

GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects

Back to calendar

Event Date: 23-02-2019 - Session time: 14:45:00 - Track: Database Development, Administration DevOps

Speaker: Patrick Flynn

Title: GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects

Abstract:

In the last few years the requirement to understand and use distributed Source control systems has become an increasing part of a Data Professionals life.

With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!

In this session we will investigate the setup and use of GitHub and Git for source control. Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!

Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github

SessionID: 88350

Beyond Devops - Introducing Data Reliability Engineering

Back to calendar

Event Date: 23-02-2019 - Session time: 14:45:00 - Track: Database Development, Administration DevOps

Speaker: Dave Dustin

Title: Beyond Devops - Introducing Data Reliability Engineering

Abstract:

Today’s database professionals must be engineers, not just administrators. We build things. We create things. As engineers practicing devops, we are all in this together, and nothing is someone else’s problem. As engineers, we apply repeatable processes, established knowledge, and expert judgment to design, build, and operate production data stores and the data structures within. As database reliability engineers, we must take the operational principles and the depth of database expertise that we possess one step further.

Guiding Principles of the DBRE