sqlsathistory

Nr: 826

Back to Main list

SQLSaturday #826 - Victoria 2019

Start Time (24h) Speaker Track Title
09:00:00 Kellyn Pot'Vin-Gorman Cloud Be Part of the Solution with Automation
09:00:00 Angela Henry BI What is Power BI?
09:00:00 Patrick Flynn Admin DBA Checklists: Reliable, Repeatable, Automated.
09:00:00 Rick Lowe Admin SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?
09:00:00 Anthony Bulk BI Instant insights, automation and action with Power BI, Power Apps, Flow and Azure Machine Learning
09:00:00 Sanil Mhatre Cloud Text Mining Sentiment Analysis made easy
10:15:00 Daniel Glenn BI Using Your On-prem Data in a Cloud World
10:15:00 Thomas Grohser Admin Shaving off Microseconds
10:15:00 Matthew Roche BI Introduction to Power BI dataflows
10:15:00 Yana Berkovich BI Governance in PowerBI - Enjoy your Power Responsibly
10:15:00 Argenis Fernandez Other SQL Server 2019: What's New, What's Great, What's Amazing
10:15:00 Gail Shaw Dev Effective Indexing
11:30:00 Uwe Ricken Admin Analyze and solve common wait stats scenarios
11:30:00 Melody Zacharias Cloud Introduction to Azure AI - The Art of the possible
11:30:00 Satya Jayanty Cloud Big Data with Azure: where to begin? Concepts and best practices
11:30:00 Ben Miller Admin SQL Server Encryption
11:30:00 Sepand Gojgini BI New Era of Data Warehouse Design
11:30:00 Michael Johnson Other Taking back control of your work using Kanban
12:45:00 Anthony Bulk BI BoF Session: Power BI
12:45:00 Hamish Watson Dev BoF Session: Development DevOps
12:45:00 Patrick Flynn Admin BoF Session: Database Administration
12:45:00 Todd McDermid Admin BoF Session: Data Warehousing, Analytics Reporting
12:45:00 Kevin Feasel Cloud BoF Session: Big Data, Data Science AI
13:30:00 Andrew Boudreau Cloud DataBricks, modern data transformation
13:30:00 Frank Geisler Dev Use Docker to Deploy SQL Server Applications
13:30:00 Steve Stedman Admin Basics of Database Corruption Repair
13:30:00 John Miner Dev Basic Database Design
13:30:00 Kathi Kellenberger BI Azure Machine Learning 101
13:30:00 Ken Puls BI Introduction to Dimensional Modeling for the Excel/Power BI Pro
14:45:00 Kevin Feasel Other Much Ado About Hadoop
14:45:00 Joseph Yeates BI Predictive Analytics with R in Power BI
14:45:00 Oliver Engels BI Data Quality matters! Go for a quality roundtrip in the MS data platform (2019 Version)
14:45:00 Randolph West Admin Managing and monitoring SQL Server on Linux from the command line
14:45:00 Gabi Münster BI Continuous Integration for Analysis Services?
14:45:00 Scott Stauffer Dev Can Scott create a mobile app in an hour using PowerApps?
16:00:00 Christopher Docherty BI Architecture for AGILE and DevOps
16:00:00 Mitchell Bottel Admin Tips, Tricks and Secrets for the SQL Professional
16:00:00 Warwick Rudd Admin Azure Data Studio – The New Frontier
16:00:00 Hamish Watson Admin SQL Server on Linux and Containers changes everything for the better!!
16:00:00 Todd McDermid BI The Science of Success: Building Faith in a Data Warehouse
16:00:00 Kathi Kellenberger Other Women Talk Tech

SessionID: 86700

Be Part of the Solution with Automation

Back to calendar

Event Date: 16-03-2019 - Session time: 09:00:00 - Track: Cloud

Speaker: Kellyn Pot'Vin-Gorman

Title: Be Part of the Solution with Automation

Abstract:

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.

SessionID: 86796

What is Power BI?

Back to calendar

Event Date: 16-03-2019 - Session time: 09:00:00 - Track: BI

Speaker: Angela Henry

Title: What is Power BI?

Abstract:

You’ve heard all the buzz about Power BI, but you have no idea what it is and how it works. This session explains what Power BI is, who can use it and why you would want to. It’s an introductory session that gives you the information you need to determine if Power BI is right for you and your organization.

SessionID: 87306

DBA Checklists: Reliable, Repeatable, Automated.

Back to calendar

Event Date: 16-03-2019 - Session time: 09:00:00 - Track: Admin

Speaker: Patrick Flynn

Title: DBA Checklists: Reliable, Repeatable, Automated.

Abstract:

Now that SQL Server loves PowerShell and Microsoft loves open source, it is even easier to automate even your most time-consuming, repetitive, mundane or burdensome tasks.

Using the DbaChecks PowerShell module released at the SQLBits 2018 conference we can: Track SQL Server instance configurations Promptly provide required information to managmement, change configuration or developers Deftly respond to audit change requirements across your entire estate (and impress your auditor with PowerShell;) Restore SQL Servers to their correct state prior and post deployment Test everything from configuration to permissions, SQL service account share access to sysadmins, Agent Jobs to SPNs

This session will look at how to install and use this module . With multiple examples we will look at both running the checks and viewing the data in the supplied PowerBI reports.

Pre-requisites Some basic knowledge of PowerShell and DBA

SessionID: 88141

SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?

Back to calendar

Event Date: 16-03-2019 - Session time: 09:00:00 - Track: Admin

Speaker: Rick Lowe

Title: SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?

Abstract:

Amazon web services offers a befuddling number of of different services. Among these are the two major options for running SQL Server on AWS - Elastic Compute Cloud and Relational Database Services. Why would one be picked over the other? What are the limitations and trade offs? We will discuss these questions among others while working through the process of restoring a sample database under both services.

SessionID: 88666

Instant insights, automation and action with Power BI, Power Apps, Flow and Azure Machine Learning

Back to calendar

Event Date: 16-03-2019 - Session time: 09:00:00 - Track: BI

Speaker: Anthony Bulk

Title: Instant insights, automation and action with Power BI, Power Apps, Flow and Azure Machine Learning

Abstract:

In todays hyper accelerated pace of business there is a massive demand for insights, intelligence and automation delivered at the speed of business.

In this session I will demonstrate and explain how you can integrate Power BI, Power Apps, Flow, Azure Machine Learning and Dynamics 365 to rapidly build a functioning system which allows users to analyze, insert, automate and action customer data.

I will show you how you can use the tools listed above to rapidly build a system that will allow sales reps to instantly analyze and segment customers based on their purchases in real-time, enabling them to better serve their customers.

SessionID: 89714

Text Mining Sentiment Analysis made easy

Back to calendar

Event Date: 16-03-2019 - Session time: 09:00:00 - Track: Cloud

Speaker: Sanil Mhatre

Title: Text Mining Sentiment Analysis made easy

Abstract:

Does your Enterprise data include from social media posts, product reviews and survey results with free form text ? Feel like you need a Data Scientist, equipped with Tools like R, text mining sentiment lexicon to unlock the value of that data ? Not anymore ! Thanks to our friends at Microsoft, a developer or analyst can leverage Azure Cognitive services and PowerBI to easily analyze text data and create effective visual dashboards.

This session will walk through how to use text analytics APIs in Azure cognitive services, to analyze free form text responses to survey questions . We will learn how to parse key phrases, derive sentiment scores and how to effectively use Power BI visualizations like Word Cloud, Gauge, Histograms , etc to create a Dashboard for effectively analyzing this data. We will browse through performing similar analysis in R.

Session Goals Understand how to use Azure Cognitive Services APIs for analyzing text data Learn how to load and prepare your

SessionID: 86787

Using Your On-prem Data in a Cloud World

Back to calendar

Event Date: 16-03-2019 - Session time: 10:15:00 - Track: BI

Speaker: Daniel Glenn

Title: Using Your On-prem Data in a Cloud World

Abstract:

Microsoft Power BI, Flow, and PowerApps are powerful cloud tools that can take your on-premises data to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy.

In this session, we will discover the benefits of using the cloud tools, how those benefits translate to being on-prem, and how we can use the data in Office 365 as well. We will setup a data gateway, connect to on-prem data sources, and use that data in Office 365 and SharePoint Server 2019.

SessionID: 86800

Shaving off Microseconds

Back to calendar

Event Date: 16-03-2019 - Session time: 10:15:00 - Track: Admin

Speaker: Thomas Grohser

Title: Shaving off 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 (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: 87434

Introduction to Power BI dataflows

Back to calendar

Event Date: 16-03-2019 - Session time: 10:15:00 - Track: BI

Speaker: Matthew Roche

Title: Introduction to Power BI dataflows

Abstract:

This fall Microsoft introduced Power BI dataflows, a powerful new feature for self-service data preparation powered by Azure Data Lake Storage gen2. Dataflows bring the familiar Power Query data prep experience to the Power BI service, and enable analysts and business users to define reusable data entities that can be shared and reused across workspaces and apps.

In this session, Power BI program manager Matthew Roche will introduce this exciting new capability, including an end-to-end demonstration of the Power BI dataflows experience. If you haven’t yet started to explore dataflows – or if you want to build on what you already know – this is the session for you.

SessionID: 87751

Governance in PowerBI - Enjoy your Power Responsibly

Back to calendar

Event Date: 16-03-2019 - Session time: 10:15:00 - Track: BI

Speaker: Yana Berkovich

Title: Governance in PowerBI - Enjoy your Power Responsibly

Abstract:

What is Governance?

Information Access Policy Groups/Workspaces Sharing vs Publishing Licensing Policy – Who is important enough?? Visual Governance Reporting the reports Including the exciting How to enforce/enable the policy? Best Practices and Lessons (already) Learned… Will include the latest and greatest updates in PowerBI, as presented in PASS 2018 and the developments since in the Governance area.

SessionID: 88662

SQL Server 2019: What's New, What's Great, What's Amazing

Back to calendar

Event Date: 16-03-2019 - Session time: 10:15:00 - Track: Other

Speaker: Argenis Fernandez

Title: SQL Server 2019: What's New, What's Great, What's Amazing

Abstract:

SQL Server has brought to market a new modern data platform including support for Linux, Docker Containers and rich features in intelligent performance, HADR, machine learning, and graph database. Come learn about the roadmap and new functionality planned for SQL Server including intelligent query processing, data virtualization, new features for mission critical security and HADR, and new scenarios for Linux and Docker Containers.

SessionID: 88754

Effective Indexing

Back to calendar

Event Date: 16-03-2019 - Session time: 10:15:00 - Track: Dev

Speaker: Gail Shaw

Title: Effective Indexing

Abstract:

Ever wondered what makes an index useful? Curious about why the optimizer picks the indexes that it does? Wondered what black magic goes into designing good indexes?

In this session, we'll look at design considerations for rowstore non-clustered indexes. We'll investigate what makes an index useful to SQL Server and what common mistakes make indexes useless. We'll go into the details of how various query predicates interact with indexes and what the primary driver is when designing indexes for any database application.

This session is aimed at people who are relatively new to SQL Server indexing.

SessionID: 87791

Analyze and solve common wait stats scenarios

Back to calendar

Event Date: 16-03-2019 - Session time: 11:30:00 - Track: Admin

Speaker: Uwe Ricken

Title: Analyze and solve common wait stats scenarios

Abstract:

SQL Server is a high frequently used piece of software which need to serve single requests and/or hundreds of thousands of requests in a minute. Within these different kinds of workloads Microsoft SQL Server has to handle the concurrency of tasks in a fashion manner. This demo driven session shows different scenarios where Microsoft SQL Server has to wait and manage hundreds of tasks. See, analyze and solve different wait stats due to their performance impact:

SessionID: 87917

Introduction to Azure AI - The Art of the possible

Back to calendar

Event Date: 16-03-2019 - Session time: 11:30:00 - Track: Cloud

Speaker: Melody Zacharias

Title: Introduction to Azure AI - The Art of the possible

Abstract:

According to the Economist magazine, data is the world’s most valuable resource. So, it makes sense that Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business. As data professionals, we need to know how these core pieces will affect what we do, and how we can use the Azure AI suite to help our clients. Microsoft’s AI suite is the central hub for learning and implementing each of these core pieces. Using an easy to follow example, I will show the flow from problem to solution. Multiple demonstrations of the different pieces will show use cases of the AI suite. This overview of Azure AI will use the various pieces like a puzzle which, when brought together, will form a seamless picture of the whole so that participants can see that the individual pieces were meant to work together.

SessionID: 88387

Big Data with Azure: where to begin? Concepts and best practices

Back to calendar

Event Date: 16-03-2019 - Session time: 11:30:00 - Track: Cloud

Speaker: Satya Jayanty

Title: Big Data with Azure: where to begin? Concepts and best practices

Abstract:

In order to ascertain the abilities of cloud computing platform, let us overview what is available offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.

SessionID: 88475

SQL Server Encryption

Back to calendar

Event Date: 16-03-2019 - Session time: 11:30:00 - Track: Admin

Speaker: Ben Miller

Title: SQL Server Encryption

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. We will also go over how Always Encrypted works as well. Master the concepts of SQL Server Encryption when you are done with this session.

SessionID: 89336

New Era of Data Warehouse Design

Back to calendar

Event Date: 16-03-2019 - Session time: 11:30:00 - Track: BI

Speaker: Sepand Gojgini

Title: New Era of Data Warehouse Design

Abstract:

Building and maintaining enterprise data warehouse is quite a daunting task; it takes months of planning and development and usually by delivery date the requirement and business goals have changed and process needs to start from scratch. This session is focused on new approaching on design and building data warehouse using latest innovation in SQL Server which allows faster time to market and delivery of value to business groups

SessionID: 89653

Taking back control of your work using Kanban

Back to calendar

Event Date: 16-03-2019 - Session time: 11:30:00 - Track: Other

Speaker: Michael Johnson

Title: Taking back control of your work using Kanban

Abstract:

Do you and your team feel overwhelmed by the amount of outstanding work? Are your clients constantly complaining because work is not being delivered? Do you think that despite throwing time and resources at every project very little seem to get done? Kanban may be for you.

Kanban is a method of managing work with a focus on continuous delivery, this means that there is a steady stream of completed work going out the door and resulting in more efficient use of developer time but more importantly happier clients.

You will be introduced to the concepts behind Kanban, finding that it is one of the most natural work methodologies to setup and scales well from one person teams through to large enterprises. While there are many tools, many of them free, you can still get going with nothing more than a few sticky notes and a whiteboard.

SessionID: 91406

BoF Session: Power BI

Back to calendar

Event Date: 16-03-2019 - Session time: 12:45:00 - Track: BI

Speaker: Anthony Bulk

Title: BoF Session: Power BI

Abstract:

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda. This is a chance to connect and share over lunch at an informal gathering. The speaker(s) listed are NOT presenting to the room, they're just there to join in.

Topic: PowerBI

SessionID: 91407

BoF Session: Development DevOps

Back to calendar

Event Date: 16-03-2019 - Session time: 12:45:00 - Track: Dev

Speaker: Hamish Watson

Title: BoF Session: Development DevOps

Abstract:

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda. This is a chance to connect and share over lunch at an informal gathering. The speaker(s) listed are NOT presenting to the room, they're just there to join in.

Topic: Development DevOps

SessionID: 91408

BoF Session: Database Administration

Back to calendar

Event Date: 16-03-2019 - Session time: 12:45:00 - Track: Admin

Speaker: Patrick Flynn

Title: BoF Session: Database Administration

Abstract:

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda. This is a chance to connect and share over lunch at an informal gathering. The speaker(s) listed are NOT presenting to the room, they're just there to join in.

Topic: Database Administration

SessionID: 91409

BoF Session: Data Warehousing, Analytics Reporting

Back to calendar

Event Date: 16-03-2019 - Session time: 12:45:00 - Track: Admin

Speaker: Todd McDermid

Title: BoF Session: Data Warehousing, Analytics Reporting

Abstract:

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda. This is a chance to connect and share over lunch at an informal gathering. The speaker(s) listed are NOT presenting to the room, they're just there to join in.

Topic: Data Warehousing, Analytics Reporting

SessionID: 91410

BoF Session: Big Data, Data Science AI

Back to calendar

Event Date: 16-03-2019 - Session time: 12:45:00 - Track: Cloud

Speaker: Kevin Feasel

Title: BoF Session: Big Data, Data Science AI

Abstract:

At Birds-of-a-Feather (BoF) sessions, attendees group together based on a shared interest and carry out discussions without any pre-planned agenda. This is a chance to connect and share over lunch at an informal gathering. The speaker(s) listed are NOT presenting to the room, they're just there to join in.

Topic: Big Data, Data Science AI

SessionID: 86912

DataBricks, modern data transformation

Back to calendar

Event Date: 16-03-2019 - Session time: 13:30:00 - Track: Cloud

Speaker: Andrew Boudreau

Title: DataBricks, modern data transformation

Abstract:

Learn the power of modern data transformation using DataBricks with Azure Data Factory. Take a look how to power transformations using R, Phyton, SQL, Scala and more. Utilize runtime job clusters to power through the biggest data. Integrate, deploy, schedule and monitor with Azure Data Factory.

SessionID: 87079

Use Docker to Deploy SQL Server Applications

Back to calendar

Event Date: 16-03-2019 - Session time: 13:30:00 - Track: Dev

Speaker: Frank Geisler

Title: Use Docker to Deploy SQL Server Applications

Abstract:

Docker can not only be used for testing purposes, but also for deploying applications. The big advantage for the customer of the application is that nothing has to be installed, there are no obstacles to the application running in the given environment etc. because the environment is defined by the developer. German Data Platform MVP Frank Geisler will show how all of this can be achieved by using docker. There will be plenty of demos in which all the necessary steps will be shown.

SessionID: 87111

Basics of Database Corruption Repair

Back to calendar

Event Date: 16-03-2019 - Session time: 13:30:00 - Track: Admin

Speaker: Steve Stedman

Title: Basics of Database Corruption Repair

Abstract:

Your database is running fine month after month with no problems. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error“, or something even scarier. Do you know what to do now? We will walk through 3 corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you can do to protect yourself when corruption strikes. Learn how to avoid making things worse, and how to protect your data if things do get worse. You will leave with a checklist of steps to use when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.

SessionID: 87898

Basic Database Design

Back to calendar

Event Date: 16-03-2019 - Session time: 13:30:00 - Track: Dev

Speaker: John Miner

Title: Basic Database Design

Abstract:

Abstract:

You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice.

This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up.

Topics are focused on data storage structures, security, and integrity. After this presentation, will be ready to meet that clients need.

Coverage:

1 - Files File Groups 2 - Logins Users 3 - Security using schemas 4 - Database roles for access. 5 - Table design via SSMS or TSQL. 6 - Default, Check, and NULL constraints 7 - Handling table relationships (PK vs FK). 8 - To index or not to index? 9 - Testing database integrity using DML.

SessionID: 88097

Azure Machine Learning 101

Back to calendar

Event Date: 16-03-2019 - Session time: 13:30:00 - Track: BI

Speaker: Kathi Kellenberger

Title: Azure Machine Learning 101

Abstract:

There are several ways to create a machine learning model. You can use R or Python or even other languages such as C#. Advanced coding skills are required no matter which language you choose. Once the solution is created, it’s often difficult to deploy.

Microsoft addresses those problems with Azure Machine Learning, or Azure ML. Azure ML has built-in transforms for cleansing and munging data. It also contains a variety of configurable machine learning models that can be used without coding. Deploying the model is easy, and users can link to it directly with Excel or a custom application can be written.

If you are experienced in machine learning but haven’t seen Azure ML or if you are curious about machine learning and data science, this session is for you.

SessionID: 89056

Introduction to Dimensional Modeling for the Excel/Power BI Pro

Back to calendar

Event Date: 16-03-2019 - Session time: 13:30:00 - Track: BI

Speaker: Ken Puls

Title: Introduction to Dimensional Modeling for the Excel/Power BI Pro

Abstract:

As an Excel user, you've probably been building Pivot Tables for years… but do you know the difference between a Fact and a Dimension? The reality is that PivotTables have done a great job of protecting us from needing to understand proper data modeling, but in modern Excel and Power BI that has changed.

In this session we will look at understanding the benefits of dimensional modeling in Power Pivot. We will define and review key terms and best practices, and show you how to use Power Query to reshape, split and combine tables into their proper tabular formats for a model.

SessionID: 86763

Much Ado About Hadoop

Back to calendar

Event Date: 16-03-2019 - Session time: 14:45:00 - Track: Other

Speaker: Kevin Feasel

Title: Much Ado About Hadoop

Abstract:

If you're interested in Hadoop but don't know where to begin, this session will give you an idea of what you can do with the open-source platform. We will see an overview of the Hadoop architecture, becoming familiar with the overall platform and its solutions for warehousing, ETL, streaming data ingest, in-memory processing, and more. We will compare Hadoop to SQL Server to help gain an understanding of when to deploy which technology.

SessionID: 86888

Predictive Analytics with R in Power BI

Back to calendar

Event Date: 16-03-2019 - Session time: 14:45:00 - Track: BI

Speaker: Joseph Yeates

Title: Predictive Analytics with R in Power BI

Abstract:

Power BI reports are typically used for descriptive analysis: a historical look of what has happened. But what if your report could visualize what is likely to happen and recommend what you can do about it now? This session will cover how to shift from descriptive to predictive analysis and leverage the power of machine learning to enhance your business intelligence solutions. The basics and best practices of predictive modeling will be introduced, and these concepts will be applied to create three predictive models in R using three different techniques. We will then walk through the three different ways to integrate the predictive power of these models into a Power BI report.

SessionID: 87083

Data Quality matters! Go for a quality roundtrip in the MS data platform (2019 Version)

Back to calendar

Event Date: 16-03-2019 - Session time: 14:45:00 - Track: BI

Speaker: Oliver Engels

Title: Data Quality matters! Go for a quality roundtrip in the MS data platform (2019 Version)

Abstract:

In the times of data explosion, a dazzling array of information streams and unbelievable possibilities of different techniques to manage data via the Microsoft Data Platform, this session asks the question: what about data curation?

We dive into the requirements of modern curation and show in examples, what the Microsoft Data Platform has to offer: Can SQL Server Master Data Service (MDS), Data Quality Services (DQS) and Integration Service (SSIS) especially with the integration in ADF help? Which options offers the Azure Data Catalog and how does the Microsoft Dataflows come into play? We also look at the potential of the new integrated languages in the Data Platform like R or Python via Azure Databricks. At the end of this session you will have an overview and understanding of the possibilities, that Microsoft Data Platform offers you to address your data curation requirements.

SessionID: 88443

Managing and monitoring SQL Server on Linux from the command line

Back to calendar

Event Date: 16-03-2019 - Session time: 14:45:00 - Track: Admin

Speaker: Randolph West

Title: Managing and monitoring SQL Server on Linux from the command line

Abstract:

When SQL Server arrived on Linux in 2017, Microsoft brought with it a database engine that works exactly the same as it does on Windows.

While you can manage and monitor SQL Server on Linux using existing tools designed for Windows, there are command line tools that will feel right at home to seasoned command-line and scripting veterans, including Oracle DBAs.

This session will cover mssql-conf (for configuring the server instance), mssql-cli (for connecting to the database engine), and dbfs (mounting a virtual file system) to query database management views (DMVs) using bash.

SessionID: 88498

Continuous Integration for Analysis Services?

Back to calendar

Event Date: 16-03-2019 - Session time: 14:45:00 - Track: BI

Speaker: Gabi Münster

Title: Continuous Integration for Analysis Services?

Abstract:

Continuous Integration (CI) and Continuous Deployment (CD) are well used methods in modern software engineering approaches and can help reduce workload, risks and therefore costs significantly. But Business Intelligence projects and amongst those especially Analysis Services projects offer certain challenges to the appliance of those methods. Comprehensive support by software vendors is definitely not given. So if you want to integrate those methods into your application life-cycle management (ALM) you probably will need to build your own solution. We will shortly recap definition and advantages of CI and CD. After a short analysis of the special challenges for BI projects we will dive into possible approaches. And let's try to find out if cloud services can be of significant importance.

SessionID: 90909

Can Scott create a mobile app in an hour using PowerApps?

Back to calendar

Event Date: 16-03-2019 - Session time: 14:45:00 - Track: Dev

Speaker: Scott Stauffer

Title: Can Scott create a mobile app in an hour using PowerApps?

Abstract:

Scott isn't a rocket scientist… far from it… he will shy away from .NET development ANY chance he can get! PowerApps, part of Microsoft's Power Platform, allow the knowledgeable information worker to develop in a "Low Code/No Code" environment. Sure, there are expressions to control logic in PowerApps, but if you can handle writing excel formulas, I'm sure you'll be just fine. Watch Scott sweat on stage as he builds a responsive application in the cloud and push it down to his iPhone, store and retrieve data from an enterprise data solution, and take a bow… (or scrunch up into a fetal position and never step on stage again… )

SessionID: 86626

Architecture for AGILE and DevOps

Back to calendar

Event Date: 16-03-2019 - Session time: 16:00:00 - Track: BI

Speaker: Christopher Docherty

Title: Architecture for AGILE and DevOps

Abstract:

Have you struggled to get BI off the ground, or had months or years of work overturned by a change in management?

In this talk we will discuss how we can set ourselves up for success with an AGILE data warehouse, and methods of utilising AGILE and DevOps in delivering business intelligence in a fast, effective, and user-centred method. Architecture of our warehouse, data flows, data security, user engagement and how it all fits together to build rapid value for the organisation and set yourself apart.

SessionID: 87773

Tips, Tricks and Secrets for the SQL Professional

Back to calendar

Event Date: 16-03-2019 - Session time: 16:00:00 - Track: Admin

Speaker: Mitchell Bottel

Title: Tips, Tricks and Secrets for the SQL Professional

Abstract:

Ever heard the term, "work smarter, not harder". A mantra to live by in my book. Over the years, I have seen, forgotten, seen again and forgotten again all of the shortcuts, tips and tricks we all take for granted. SO like a good DBA, I started to document and share all of these commands and shortcuts to share. Come see and learn many of the everyday shortcuts in SQL Server Management Studio (SSMS) that will help make your life easier on a daily basis.

SessionID: 87818

Azure Data Studio – The New Frontier

Back to calendar

Event Date: 16-03-2019 - Session time: 16:00:00 - Track: Admin

Speaker: Warwick Rudd

Title: Azure Data Studio – The New Frontier

Abstract:

Azure Data Studio is no longer the new kid on the block. How many of you have used Azure Data Studio?

          In this session we will take you on a journey introducing you to Azure Data Studio so that you can understand the ins and outs and when you should consider using Azure Data Studio in place of SQL Server Management Studio. In this demo heavy session we will look at how productive you can be with Azure Data studio and some of the features that are not available in SQL Server Management Studio.

SessionID: 88263

SQL Server on Linux and Containers changes everything for the better!!

Back to calendar

Event Date: 16-03-2019 - Session time: 16:00:00 - Track: Admin

Speaker: Hamish Watson

Title: SQL Server on Linux and Containers changes everything for the better!!

Abstract:

When Microsoft released SQL Server 2017 it allowed us to run SQL Server on Linux and native Linux containers. This radical change provides a wider and open platform that data professionals can choose how to deploy and run SQL Server.

This session will demonstrate what on SQL Server for Linux is familiar for the data professional and will also highlight some of the differences. We will look at how containers are a game changer for deploying and managing of SQL Server.

The session will also introduce how the Azure Kubernetes Service (AKS) is a scalable and highly available platform for SQL Server within containers.

DEMOs in this session will show how easy it is to install SQL Server on both Linux and containers and how Infrastructure as Code provides a mechanism to automate the installation of SQL Server, deploy databases and perform integration tests.

This session will show you the exciting future of SQL Server and how you can learn about it today.

SessionID: 90802

The Science of Success: Building Faith in a Data Warehouse

Back to calendar

Event Date: 16-03-2019 - Session time: 16:00:00 - Track: BI

Speaker: Todd McDermid

Title: The Science of Success: Building Faith in a Data Warehouse

Abstract:

For data professionals, understanding why a data warehouse doesn't get adopted immediately and broadly in an organization can be difficult. Data in your warehouse is arguably of better quality and in a more usable form than what's in the systems you source your data from… so where does this reluctance come from, and how do you overcome it?

Despite our broad expertise of data tools, the robotic consistency of the computational resources they leverage, and the immutable GIGO law - presenting a reasoned and thorough validation process often isn't enough. Trust isn't given instantly, it has to be earned - by involving SMEs, letting them make the rules, and proving daily consistency. Learn how to leverage your tooling expertise in SSIS and SQL to build a dead-simple framework to build faith in data. Leverage analyst and business user questions and angst into repeatable, consistent proof of correctness - that's part of the science of success for a data warehouse.

SessionID: 91276

Women Talk Tech

Back to calendar

Event Date: 16-03-2019 - Session time: 16:00:00 - Track: Other

Speaker: Kathi Kellenberger

Title: Women Talk Tech

Abstract:

Celebrate International Women’s Day by joining in as leaders from the Data Platform community talk about working in tech. These amazing women are Angela Henry, Gabi Münster, Gail Shaw, Kellyn Pot'Vin-Gorman, Melody Zacharias, Pam Lahoud, and Yana Berkovich. The session will be hosted by Kathi Kellenberger, leader of the PASS Wit Virtual Group.

This site is open source. Improve this page.