sqlsathistory

Nr: 710

Back to Main list

SQLSaturday #710 - Edmonton 2018

Start Time (24h) Speaker Track Title
09:45:00 Kevin Feasel Strategy and Architecture Much Ado About Hadoop
09:45:00 Scott Stauffer BI Platform Architecture, Development Administration Power BI for the Faint of Heart - Understanding On-Prem, Hybrid and Pure Cloud Scenarios
09:45:00 Chris C Application Database Development Introduction to Object-Relational Mapping for DBAs
09:45:00 Mohit Gupta Enterprise Database Administration Deployment SQL Server Internals - Performance Troubleshooting Hands on Approach
11:00:00 Randolph West Application Database Development Back to the Future with Temporal Tables
11:00:00 Patrick Flynn Enterprise Database Administration Deployment DBATools! The reason to finally start learning and using Powershell
11:00:00 Brent Flesher Enterprise Database Administration Deployment SQL vulnerability assessment
11:00:00 Melody Zacharias Strategy and Architecture Azure Data Catalog – Turning Unused Assets into Usable Knowledge
13:30:00 Kevin Feasel Analytics and Visualization R For the SQL Server Developer
13:30:00 William Wolf Application Database Development Blue Collar SQL Tricks - Make Standard Edition Work for you.
13:30:00 Doran Douglas Application Database Development SSIS Sucks!
13:30:00 Mohit Gupta Enterprise Database Administration Deployment DevOps - Desired State Configuration
14:45:00 Sepand Gojgini BI Platform Architecture, Development Administration Columnstore Index Primer
14:45:00 Ian Chamberland Application Database Development Modernizing your legacy database integration points
14:45:00 Evin Fenton Other SQL Unmasked: Effective Tools, Tricks Fundamentals
14:45:00 Janice Gerbrandt Application Database Development Automated tests in your database: tSQLt
16:00:00 Scott Stauffer BI Information Delivery Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
16:00:00 Patrick Flynn Enterprise Database Administration Deployment DBA Checklists: Reliable, Repeatable, Automated.
16:00:00 Melody Zacharias Professional Development Confidence: The fuel for action
16:00:00 Brian Gale Application Database Development Troubleshooting Service Broker
16:00:00 Randolph West Enterprise Database Administration Deployment What’s New In SQL Server 2017

SessionID: 70256

Much Ado About Hadoop

Back to calendar

Event Date: 05-05-2018 - Session time: 09:45:00 - Track: Strategy and Architecture

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: 74043

Power BI for the Faint of Heart - Understanding On-Prem, Hybrid and Pure Cloud Scenarios

Back to calendar

Event Date: 05-05-2018 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Scott Stauffer

Title: Power BI for the Faint of Heart - Understanding On-Prem, Hybrid and Pure Cloud Scenarios

Abstract:

Power BI v1. Started off in Excel. Today Power BI v2 has Excel capabilities, a free desktop app for development, native mobile apps for consuming on all devices, and a cloud service to distribute your data visualizations at scale. Let's look at some common architectures for pieces and how they can deliver value to your business.

SessionID: 74085

Introduction to Object-Relational Mapping for DBAs

Back to calendar

Event Date: 05-05-2018 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Chris C

Title: Introduction to Object-Relational Mapping for DBAs

Abstract:

This talk introduces DBAs to Object-Relational Mapping (ORM) from the point of view of a software developer creating a simple website. Aside from introducing ORM I'll explain why developers like to use them, their strengths and weaknesses, and how DBAs and ORM developers can work together in perfect harmony.

SessionID: 75746

SQL Server Internals - Performance Troubleshooting Hands on Approach

Back to calendar

Event Date: 05-05-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mohit Gupta

Title: SQL Server Internals - Performance Troubleshooting Hands on Approach

Abstract:

Where do you look when you are having performance problems? What tools you have available? In this session I'll share with everyone a troubleshooting methodology that can help you identify and focus your search. In addition, we'll walk through some hands on scenarios to fix performance issues.

SessionID: 70379

Back to the Future with Temporal Tables

Back to calendar

Event Date: 05-05-2018 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Randolph West

Title: Back to the Future with Temporal Tables

Abstract:

SessionID: 71104

DBATools! The reason to finally start learning and using Powershell

Back to calendar

Event Date: 05-05-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Flynn

Title: DBATools! The reason to finally start learning and using Powershell

Abstract:

Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008.

In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low.

With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment.

In this session we will look how to download, install and begin using the power within both this module and Powershell.

No prior experience with Powershell required!

SessionID: 74444

SQL vulnerability assessment

Back to calendar

Event Date: 05-05-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Brent Flesher

Title: SQL vulnerability assessment

Abstract:

Enjoy a fun filled adventure through the landscape of data and information security options available within SQL Server as we explore the promises, perils, and pitfalls of CRUD, Data Masking, Row Level Security, Transparent Data Encryption, and Always Encrypted.

SessionID: 75771

Azure Data Catalog – Turning Unused Assets into Usable Knowledge

Back to calendar

Event Date: 05-05-2018 - Session time: 11:00:00 - Track: Strategy and Architecture

Speaker: Melody Zacharias

Title: Azure Data Catalog – Turning Unused Assets into Usable Knowledge

Abstract:

Data is today’s currency. Azure Data Catalog (ADC) is a relatively unknown resource in the IT community. This is an unfortunate state since ADC is an incredibly useful tool that is easy to implement and use. Companies that are able to leverage their data have seen the greatest gains in growth and market capitalization. The reason for this is simple: We live in the information age. Being able to leverage the data you gather is the invitation you need just to compete in information age.

ADC is an indispensable tool that helps companies organize and make sense of the mountains of data they collect every day. By walking participants through an implementation of ADC, I will introduce them to the product, and show how easy it is to use. By presenting concrete examples of how ADC is used, I will demonstrate its importance. Participants should leave this session determined to introduce ADC to their team and resolute in their intention to implement it within their company.

SessionID: 70255

R For the SQL Server Developer

Back to calendar

Event Date: 05-05-2018 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: R For the SQL Server Developer

Abstract:

R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

SessionID: 71219

Blue Collar SQL Tricks - Make Standard Edition Work for you.

Back to calendar

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

Speaker: William Wolf

Title: Blue Collar SQL Tricks - Make Standard Edition Work for you.

Abstract:

You want Enterprise Edition of SQL Server? Not gonna happen! When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.

In this session, we will review some of the limitations that Standard has. Then review items such as basic normalization and High Availability options available to Standard. You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.

Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!

SessionID: 74656

SSIS Sucks!

Back to calendar

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

Speaker: Doran Douglas

Title: SSIS Sucks!

Abstract:

If you are involved in data warehouse development using the Microsoft technology stack, then you have been introduced SSIS. The question you will have asked yourself many times as you develop is: "What the #%@ were they thinking?". This session is dedicated to providing an overview to some of the items that just drive you nutz using this tool in an enterprise environment, and having a laugh while we learn.

From tiny windows designed for a 640x480 monitor, to clicky-clicky-clicky madness, to the tool being anti-agile. Developing and maintaining code with SSIS is enough to turn your hair gray early. But it sure looked "snazzy" when your boss got a demo of it, so now it is your problem.

So if you are a seasoned developer come on out and commiserate with the community, and if you haven't used to tool yet you can find out what your boss is asking you to get involved with.

Either way this will be a fun presentation that I am hoping you won't soon forget.

SessionID: 75742

DevOps - Desired State Configuration

Back to calendar

Event Date: 05-05-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Mohit Gupta

Title: DevOps - Desired State Configuration

Abstract:

Desired State Configuration (DSC) is PowerShell add-on released with PowerShell 4.5 update and updated with PowerShell 5.0. In this session we'll look at how DSC can be used to deploy monitoring for configuration drift using industry standard approach.

SessionID: 70120

Columnstore Index Primer

Back to calendar

Event Date: 05-05-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sepand Gojgini

Title: Columnstore Index Primer

Abstract:

Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each release. We will explore how data is organized differently in Columnstore and its impact on query performances. We would cover some of best practices when using this new technology and pitfalls to watch out for when designing your system.

SessionID: 74652

Modernizing your legacy database integration points

Back to calendar

Event Date: 05-05-2018 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Ian Chamberland

Title: Modernizing your legacy database integration points

Abstract:

Legacy corporate applications that are built in-house can quite often be tightly coupled together. Either you have cross database connections, load jobs, linked servers, multiple copies of data, etc. These design patterns increase your technical debt and application changes will need to carefully consider the impact to the downstream applications. Tightly coupled databases can also make migration/upgrade projects more difficult, especially as you start to looking towards cloud based solutions.

What if your organization has started to implement newer design patterns and technologies like microservices, restful web integration or enterprise service buses? Do you have to re-write all of your legacy applications to use these new technologies? This presentation will show a method that was used to update legacy applications to utilize an integration middleware platform without a major re-write of the application. We will then expand on this and show how your SQL Server database could

SessionID: 77178

SQL Unmasked: Effective Tools, Tricks Fundamentals

Back to calendar

Event Date: 05-05-2018 - Session time: 14:45:00 - Track: Other

Speaker: Evin Fenton

Title: SQL Unmasked: Effective Tools, Tricks Fundamentals

Abstract:

Optimize SQL Server from the roots. Through demonstrations this session will teach the intermediate user diverse, solid and rounded fundamentals that SQL Server offers. Explore the Master database to retrieve records for improved database administration. Learn how to query the Report Server database for essential information. Use Begin… END with TRY… CATCH: to Drop or Truncate tables with Set Operators. The goal of this presentation is to expose how fundamentals of SQL Server can be applied in ways that may be overlooked and how to enhance query performance optimization. Pick up a trick or two along the way.

SessionID: 77183

Automated tests in your database: tSQLt

Back to calendar

Event Date: 05-05-2018 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Janice Gerbrandt

Title: Automated tests in your database: tSQLt

Abstract:

tSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt is ideal for the database developer because tests are written in TSQL and is easy to use.

In this session you’ll learn how to use tSQLt to add automated tests to your database to ensure your code produces desired results even after modifications.

SessionID: 74044

Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!

Back to calendar

Event Date: 05-05-2018 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Scott Stauffer

Title: Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!

Abstract:

You've heard about Power BI, and you've seen it, but you haven't yet rolled up your sleeves and got your hands dirty. It looks like it is really easy, but sometimes it helps to have someone step you through it the first time to help you hit the ground running. We will grab various public data sources, join them together in a model and build an interactive pièce de ré·sis·tance on the visual design surface!

SessionID: 75752

DBA Checklists: Reliable, Repeatable, Automated.

Back to calendar

Event Date: 05-05-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

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: 75772

Confidence: The fuel for action

Back to calendar

Event Date: 05-05-2018 - Session time: 16:00:00 - Track: Professional Development

Speaker: Melody Zacharias

Title: Confidence: The fuel for action

Abstract:

Confidence is the fuel for action. How often have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try? The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?” Come explore this exciting topic with me, and we will see what we can accomplish together!

SessionID: 77038

Troubleshooting Service Broker

Back to calendar

Event Date: 05-05-2018 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Brian Gale

Title: Troubleshooting Service Broker

Abstract:

Restoring service broker from a live system to a test system can give you strange results. From messages that refuse to send to messages that appear to send but never arrive. We will be troubleshooting using SQL profiler and some DMV’s to see what goes on in the background when service broker is misbehaving. Nothing more worrying than performing a disaster recovery and having service broker messages not send. We will also be doing a quick overview of what Service broker does and what is required for a service broker setup. Once we have shown the profiler method of diagnosing problems, I will show a quicker and easier way to find and resolve service broker issues.

SessionID: 77831

What’s New In SQL Server 2017

Back to calendar

Event Date: 05-05-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Randolph West

Title: What’s New In SQL Server 2017

Abstract:

SQL Server 2016 and 2017 introduced a number of features and improvements over previous versions. This session will take you through them at a high level, and help you decide on an appropriate upgrade path from older versions of SQL Server. I think this will work

This site is open source. Improve this page.