sqlsathistory

Nr: 781

SQLSaturday #781 - Columbus, GA 2018

Start Time (24h)	Speaker	Track	Title
09:00:00	Ed Watson	BI Platform Architecture, Development Administration RM 101	A Beginner's Guide to Power BI
09:00:00	Elizabeth Noble	Application Database Development	Source control, now. Peace through database lifecycle management.
09:00:00	Senthil Raghavan	Enterprise Database Administration Deployment RM 201	Supporting a very large environment
09:00:00	Chris Hyde	BI Platform Architecture, Development Administration RM 101	SQL Server R Services in SQL 2016 and 2017
10:15:00	Thomas Norman	Enterprise Database Administration Deployment RM 201	Database Project Makes Deployment Consistent
10:15:00	Jon Boulineau	BI Platform Architecture, Development Administration RM 101	Introducing Hadoop to SQL Server Pros
10:15:00	Aaron Nelson	BI Platform Architecture, Development Administration RM 101	PowerShell for BI Pros: Automating SSIS, SSRS, SSAS, and Power BI
10:15:00	Amy Herold	Enterprise Database Administration Deployment RM 201	PowerShell for the DBA
11:30:00	Samir Behara	Application Database Development	DevOps, Continuous Integration Automated Testing: Rule them all
11:30:00	Kathi Kellenberger	Application Database Development	Introduction to T-SQL Windowing Functions
11:30:00	Paul LaGrone	BI Platform Architecture, Development Administration RM 101	2017 SSIS Scale Out: How and Why
11:30:00	Steven Cush	Enterprise Database Administration Deployment RM 201	A Beginner’s Guide to the Query Store
12:30:00	Tim Radney	Other RM 202	LUNCH
13:30:00	Eric Flamm	Enterprise Database Administration Deployment RM 201	Intro to SQL Operations Studio
13:30:00	Jeff Reinhard	Application Database Development	Agile Database Development and Zero Downtime Deployments
13:30:00	Kathi Kellenberger	BI Platform Architecture, Development Administration RM 101	Azure Machine Learning 101
14:45:00	Steven Cush	Enterprise Database Administration Deployment RM 201	Lessons learned for optimum performance and up-time
14:45:00	Chris Hyde	BI Platform Architecture, Development Administration RM 101	Detecting and Capturing Change for Data Warehousing
14:45:00	Mike Lawell	Cloud Application Development Deployment RM 102	Cosmos DB: Planet Earth Scale

SessionID: 80349

A Beginner's Guide to Power BI

Back to calendar

Event Date: 13-10-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration RM 101

Speaker: Ed Watson

Title: A Beginner's Guide to Power BI

Abstract:

Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.

SessionID: 80873

Source control, now. Peace through database lifecycle management.

Back to calendar

Event Date: 13-10-2018 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Elizabeth Noble

Title: Source control, now. Peace through database lifecycle management.

Abstract:

Database source control can be challenging and tricky to implement. This session will be a discussion on setting up a good foundation to implement source control. During this session we will go over getting buy-in for source control, managing database changes, and avoiding common pitfalls.

SessionID: 84059

Supporting a very large environment

Back to calendar

Event Date: 13-10-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment RM 201

Speaker: Senthil Raghavan

Title: Supporting a very large environment

Abstract:

This sessions introduces to the participants a slice in the life of a DBA managing and supporting a very large environment. It covers the differences between mid and large environment, key aspects to focus on and tips tricks to manage a very large environment.

The session will provide some insight about CMS and PBM to the participants. Few techniques that can be implemented using CMS will be explored, along with some automation ideas. The audience would leave the session with a different mindset when they think of a very large environment. The presentation style being drafted will ensure that the participants stay engaged from start till the finish, as many interesting real life examples will be shared with the audience.

SessionID: 85108

SQL Server R Services in SQL 2016 and 2017

Back to calendar

Event Date: 13-10-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration RM 101

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016 and 2017

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 82238

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 13-10-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment RM 201

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

SessionID: 82401

Introducing Hadoop to SQL Server Pros

Back to calendar

Event Date: 13-10-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration RM 101

Speaker: Jon Boulineau

Title: Introducing Hadoop to SQL Server Pros

Abstract:

Finding any IT industry publication that does not frequently reference Hadoop and Big Data is nearly impossible. Even so, to many SQL Server professionals it remains a mystery. 'Introducing Hadoop to SQL Server Pros' bridges the gap between knowledge of SQL Server and Hadoop. The first half of the session describes how Hadoop works by comparing it to what you already know about SQL Server. The second half is a series of demonstrations of Hadoop functionality. If you've ever wondered how Hadoop works and how it may effect you as a data professional, this is the session to attend.

SessionID: 82961

PowerShell for BI Pros: Automating SSIS, SSRS, SSAS, and Power BI

Back to calendar

Event Date: 13-10-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration RM 101

Speaker: Aaron Nelson

Title: PowerShell for BI Pros: Automating SSIS, SSRS, SSAS, and Power BI

Abstract:

PowerShell has allowed DBAs to manage huge numbers of SQL servers, all automatically. Now BI practitioners can reap the same benefits of scale and automation. Scenarios that are normally extremely time consuming can be done quickly, all with a few lines of PowerShell.

This session will be filled with demos based on real-life scenarios and use-cases. We will demonstrate how to scale and automate your BI solutions, with a minimum of effort. In particular, we will be covering PowerShell cmdlets their integrations with SSRS, SSIS, SSAS, and Power BI. By the end of the session, you'll be able to accomplish in minutes what would normally take hours or days. You’ll know ways to quickly migrate and deploy hundreds of reports to multiple servers; or instantly identify and process stale SSAS dimensions. Additionally, you will also solve some pesky ETL tasks: deploying large-scale SSIS solutions, updating parameters for existing packages and streamlining data imports for Power BI Report Server

SessionID: 85635

PowerShell for the DBA

Back to calendar

Event Date: 13-10-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment RM 201

Speaker: Amy Herold

Title: PowerShell for the DBA

Abstract:

PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions. In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.

SessionID: 80362

DevOps, Continuous Integration Automated Testing: Rule them all

Back to calendar

Event Date: 13-10-2018 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Samir Behara

Title: DevOps, Continuous Integration Automated Testing: Rule them all

Abstract:

Do you want to make your deployments risk free? Do you want to deliver business values to your customers faster? Do you want to increase the efficiency of your Team? Are your application and database deployment separate processes? Do you encounter issues while deploying your database changes? Do you want to automate your testing process? Is your database slowing you down?

If the answer to any of the above questions is a Yes, then this presentation is for YOU. Come join me in this 60 min session to understand the problems with traditional database development, why organizations are moving towards achieving Continuous Integration and Database DevOps, the problems it tries to solve and learn about the toolsets which will assist you in this journey towards painless database deployments.

SessionID: 80767

Introduction to T-SQL Windowing Functions

Back to calendar

Event Date: 13-10-2018 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Kathi Kellenberger

Title: Introduction to T-SQL Windowing Functions

Abstract:

T-SQL windowing functions can simplify many complex queries. They are the best thing that has happened to the T-SQL language in years, but many database professionals and developers haven’t heard about them.

They were initially introduced with SQL Server 2005. In 2012, Microsoft added several new functions that let you do things like pull values from different rows without a performance penalty. Attend this session to learn how T-SQL windowing functions apply to many real world examples.

SessionID: 82459

2017 SSIS Scale Out: How and Why

Back to calendar

Event Date: 13-10-2018 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration RM 101

Speaker: Paul LaGrone

Title: 2017 SSIS Scale Out: How and Why

Abstract:

2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.

SessionID: 83670

A Beginner’s Guide to the Query Store

Back to calendar

Event Date: 13-10-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment RM 201

Speaker: Steven Cush

Title: A Beginner’s Guide to the Query Store

Abstract:

With the introduction of SQL 2016, Query Store has become a unique tool in the DBA toolkit for its almost surgical like performance adjustment capability for systems. This session will show how to use this feature in adjusting the performance of your SQL Servers in a much more granular way than the impact of using other performance tools that are available to the DBA - comparing and contrasting the Query Store with the traditional methods along the way. It will also show you how to monitor the impact of your changes, and the changes in the environment, from using Query Store. Finally the session will cover the basic architecture of query store, the reporting environment, and the DMVs that support query store.

SessionID: 85637

LUNCH

Back to calendar

Event Date: 13-10-2018 - Session time: 12:30:00 - Track: Other RM 202

Speaker: Tim Radney

Title: LUNCH

Abstract:

LUNCH

SessionID: 80353

Intro to SQL Operations Studio

Back to calendar

Event Date: 13-10-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment RM 201

Speaker: Eric Flamm

Title: Intro to SQL Operations Studio

Abstract:

"SQL Operations Studio (preview) offers a modern, keyboard-focused T-SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich T-SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand T-SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience."

And, it runs on a Mac (and Linux, and Windows, too). Similar to Visual Studio Code, SQL Operations Studio (still in pre-release form) lets you connect to and manipulate your databases without spinning up Visual Studio (or SSMS). We'll walk through how to get the bits and install them, then connect to and query a database (in Azure) - we might not even use a mouse! If time permits, we'll take a look at Code Snippets - a built-in capability to make your T-SQL coding super-productive!

SessionID: 80758

Agile Database Development and Zero Downtime Deployments

Back to calendar

Event Date: 13-10-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Jeff Reinhard

Title: Agile Database Development and Zero Downtime Deployments

Abstract:

Does your database development process match your agile front-end counterparts?

Is SQLServer Data Tools the right tool for an agile deployment methodology?

Join me in a fresh approach that will build deployments designed to be agile from the beginning, and also support the capability for zero down time deployments by supporting multiple states of the application, so database deployments can be made in advance, without breaking the application or requiring an outage.

We will touch on how about 35 different types of DDL changes can be prepared to support transition periods, so deployments can run against a live system with no disruptions to also support the next release of your application.

This approach is a new mindset, but with a few months of planning can be leveraged to turn a deployment from a feared event to showing off your true enterprise level DevOps skills. Some demonstrations will show how ReadyRoll can be used to build migrations that support transition periods.

SessionID: 80766

Azure Machine Learning 101

Back to calendar

Event Date: 13-10-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration RM 101

Speaker: Kathi Kellenberger

Title: Azure Machine Learning 101

Abstract:

You have probably heard the buzz about Azure Machine Learning, aka Azure ML, over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.

SessionID: 83731

Lessons learned for optimum performance and up-time

Back to calendar

Event Date: 13-10-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment RM 201

Speaker: Steven Cush

Title: Lessons learned for optimum performance and up-time

Abstract:

This interactive session will cover the lessons learned from the practical experience of a SAS provider as they went from 1 ½ 9s to 6 9s of availability concurrently expanding data volume from 500 GB to 5 PB while maintaining customer responsiveness . The session with cover all aspects of the processes used, design and evolution of the architecture, implementation strategies and processes used, monitoring, and the politics behind the availability.

SessionID: 85104

Detecting and Capturing Change for Data Warehousing

Back to calendar

Event Date: 13-10-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration RM 101

Speaker: Chris Hyde

Title: Detecting and Capturing Change for Data Warehousing

Abstract:

There are many ways of detecting and capturing changes to the data in your business system in order to populate your data warehouse. In this session we will compare and contrast several methods for loading slowly-changing dimensions in your ETL solutions, including SSIS design patterns, T-SQL code, change data capture (CDC) and temporal tables.

Attendees will gain a full understanding of the pros and cons of each of these solutions and become confident in choosing and implementing them in their own ETL solutions.

SessionID: 85654

Cosmos DB: Planet Earth Scale

Back to calendar

Event Date: 13-10-2018 - Session time: 14:45:00 - Track: Cloud Application Development Deployment RM 102

Speaker: Mike Lawell

Title: Cosmos DB: Planet Earth Scale

Abstract:

In this session you will be learn what Cosmos DB is and why it is the hottest thing in Azure. What does massively scalable, mullti-model, globally distributed, well-defined consistency models look like? Most important, who is going to be using it and why?

This site is open source. Improve this page.