sqlsathistory

Nr: 808

Back to Main list

SQLSaturday #808 - Oregon 2018

Start Time (24h) Speaker Track Title
08:30:00 Warwick Rudd DBAdmin SQLOpsStudio Vs SSMS - There can be only one
08:30:00 Cathrine Wilhelmsen Prof Dev Uhms and Bunny Hands: Tips for Improving Your Presentation Skills
08:30:00 Thomas Norman DBDev Encrypting Data within Sql Server
08:30:00 Frank Gill DBDev The SQL Server Transaction Log for Developers
08:30:00 Steve Wake BI Design Data Modeling and Prototyping in Power BI Desktop [VIDEO]
08:30:00 Rob Sewell DBAdmin Administrating SQL Server with PowerShell dbatools
08:30:00 Michael Johnson BI Arch/Admin Power BI data preparation with Dataflows [VIDEO]
08:30:00 Je'Anna Lanza-Abbott Prof Dev Performance Tuning for Salary Negotiations [VIDEO]
08:30:00 Michael Curry Essentials The Big Picture: SQL Overview -Getting the Most of SQL Saturday
08:30:00 Misc Speakers Lightning Talks: Session One
10:15:00 Chris Wood Prof Dev Educating yourself will make a SQL career more fulfilling
10:15:00 Thomas Grohser Essentials Establishing a SLA form
10:15:00 Janis Griffin DBAdmin Everything You Need to Know About SQL Server Indexes
10:15:00 Jason Horner BI Arch/Admin Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
10:15:00 James McGillivray BI Design Power BI Report Design for the aesthetically challenged
10:15:00 Randy Knight DBAdmin Locks, Blocks, and Deadlocks, Oh My!
10:15:00 Pat Phelan DBAdmin Relational Data Architecture 101
10:15:00 Ben Miller DBDev Be Friendly to SQL Server with TSQL Best Practices [VIDEO]
10:15:00 Angela Henry DBDev Data Types Do Matter [VIDEO]
10:15:00 Misc Speakers Lightning Talks: Session Two
11:45:00 Jeff Honsowetz Essentials 3D printing at HP and spreadsheets; how HP broke free of data bottlenecks.
11:45:00 Diane Schuster BI Arch/Admin CozyRoc: Dynamic Data Flows in SSIS Without Programming
11:45:00 Amie Mason Data Science Azure Intelligent Services
11:45:00 Jared Karney DBDev Game, Set, Match: Set Theory for Beginners [VIDEO]
11:45:00 Victor Isakov DBAdmin Successfully Virtualizing and Maintaining SQL Server on VMware vSphere [VIDEO]
11:45:00 Andy Yun DBAdmin Going Beyond Monitoring With SentryOne
11:45:00 Kendra Little DevOps 3 tips for getting executive buy-in for DevOps
11:45:00 Richard Waymire Cloud Data Running SQL Server on Amazon Web Services
11:45:00 Trent Mera DBAdmin Real-time monitoring and detailed workload analysis with Spotligh
11:45:00 Craig Allen DBAdmin Maximum performance for SQL with Dell EMC
13:00:00 Lowry Kozlowski DBAdmin SQL Server Take Over:  Establishing a Baseline
13:00:00 Chris Hyde BI Design Detecting and Capturing Change for Data Warehousing
13:00:00 Bob Pusateri Cloud Data Select Stars: A SQL DBA's Introduction to Azure Cosmos DB
13:00:00 Kathi Kellenberger Essentials Indexing for Beginners [VIDEO]
13:00:00 Peter Kral BI Arch/Admin SSIS Deployment Smackdown! Package vs. Project!
13:00:00 Ben Thul DBAdmin Intermediate Security Topics in SQL Server
13:00:00 Jean-Pierre Voogt DBDev What is Temporal Tables
13:00:00 Vern Rabe DBDev T-SQL Habits and Practices That Can Kill Performance
13:00:00 Misc Speakers Lightning Talks: Session Three
14:45:00 Ned Otter DevOps Containerized databases: SQL Server and DevOps
14:45:00 James Phillips Cloud Data How to Migrate your in house data to the cloud [VIDEO]
14:45:00 Erland Sommarskog DBDev Don't Use Cursors or Why You Maybe Should Use a Cursor After All
14:45:00 Joseph Yeates Data Science Predictive Analytics with R in Power BI [VIDEO]
14:45:00 Hugo Kornelis Essentials Execution plans ... where do I start? [VIDEO]
14:45:00 Ted Stathakis BI Design Introduction to SQL Server Reporting Services [VIDEO]
14:45:00 Amy Herold DBAdmin PowerShell for the DBA
14:45:00 Martin Catherall DBDev What is DevOps? - and why should I care?
14:45:00 Misc Speakers Lightning Talks: Session Four
16:15:00 Jamey Johnston Data Science Code Like a Snake Charmer - Intro to Python! [VIDEO]
16:15:00 Armando Lacerda DBAdmin DBA vNext
16:15:00 Glenn Berry DBAdmin High Availability/Disaster Recovery 101
16:15:00 John Martin Cloud Data Introduction to Managed Instances [Video]
16:15:00 Hamish Watson DBDev Test Driven Development in SQL Server – how to deploy code safer [VIDEO]
16:15:00 Rob Long BI Design Data Testing Integrity – BI Edition
16:15:00 Brian Grant BI Design Building Your Own Power BI Image Generating Measures
16:15:00 Rob Volk Essentials Tame Your Unruly Data With Constraints
16:15:00 Misc Speakers Lightning Talks: Session Five

SessionID: 84533

SQLOpsStudio Vs SSMS - There can be only one

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: DBAdmin

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

Uhms and Bunny Hands: Tips for Improving Your Presentation Skills

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Prof Dev

Speaker: Cathrine Wilhelmsen

Title: Uhms and Bunny Hands: Tips for Improving Your Presentation Skills

Abstract:

Are you considering becoming a speaker, but feel nervous about getting on stage for the first time? Have you already presented a few sessions and want advice on how to improve? Do you learn more from seeing examples of what you should NOT do during a presentation instead of reading a list of bullet points on how to become a better speaker?

Don't worry! I have made plenty of presentation mistakes over the years so you won't have to :)

In this session, we will go through common presentation mistakes and how you can avoid them, as well as how you can prepare for those dreaded worst-case scenarios. Don't let those "uhms" and "uhhs" dominate your presentation, help the audience focus on the key message you're delivering instead of making them read a wall of text in your slides, recover gracefully from any demo failures, and stop distracting your attendees with floppy bunny hands.

All it takes is a little preparation and practice. You can do this!

SessionID: 84541

Encrypting Data within Sql Server

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: DBDev

Speaker: Thomas Norman

Title: Encrypting Data within Sql Server

Abstract:

Data breaches abound! SQL Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and SQL Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data and learn about my experiences implementing Always Encrypted.

SessionID: 84591

The SQL Server Transaction Log for Developers

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: DBDev

Speaker: Frank Gill

Title: The SQL Server Transaction Log for Developers

Abstract:

SQL Server tracks all changes to a database's data and schema in the transaction log. This makes it the most important file in any database. Understanding transaction log architecture and behavior will help you develop code that will maximize performance and minimize resource consumption. Join me to learn about transaction log architecture, batching transactions, rollback activity, and the effect these things can have on performance.

SessionID: 84801

Data Modeling and Prototyping in Power BI Desktop [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: BI Design

Speaker: Steve Wake

Title: Data Modeling and Prototyping in Power BI Desktop [VIDEO]

Abstract:

Power BI Desktop is often shown as a self-service reporting and analytics tool, but it can also be used earlier in the development cycle for prototyping and data modeling and can do it quicker and easier than other tools made for this purpose. In this session we will go through multiple examples showing how Power BI Desktop is the perfect tool to quickly model data from multiple data sources (including web sites, databases, cubes, online services and even flat files) perform quick actions to cleanse and connect these various sources to each other using M and DAX functions built-in to Power BI Desktop. Once this model has been built it can be used to create some quick reports to show how this will be used to help get a project approved/funded. Best of all using Power BI Desktop to do all of this is completely free to use, no licensing or Power BI login required!

SessionID: 84802

Administrating SQL Server with PowerShell dbatools

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: DBAdmin

Speaker: Rob Sewell

Title: Administrating SQL Server with PowerShell dbatools

Abstract:

Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.

Afraid of PowerShell? Worried its too complicated? Don't want to go through the learning curve?

Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday

Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session

SessionID: 84921

Power BI data preparation with Dataflows [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: BI Arch/Admin

Speaker: Michael Johnson

Title: Power BI data preparation with Dataflows [VIDEO]

Abstract:

Data preparation is often the most labour-intensive component of an analytics project and getting this right is vital if the results are to be accurate. While the growth of self-service BI has empowered users to answer important questions, ensuring well managed data is available to all employees remains one of businesses biggest challenges.

Dataflows is an extension of the Power BI ecosystem, providing a low code approach using Power Query to create curated datasets that can be easily consumed by business analysts, thereby improving the speed at which business value can be delivered. Dataflows provides a single-version-of-the-truth which was traditionally attained by building a data warehouse. You will learn -How Dataflows can be used to create rich, vetted datasets -How Dataflows can be created with the click of a button, ingesting data from many well knows SAAS solution such as Dynamics and Salesforce -How to manage Dataflows using advanced data preparation tools such as Databricks

SessionID: 85222

Performance Tuning for Salary Negotiations [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Prof Dev

Speaker: Je'Anna Lanza-Abbott

Title: Performance Tuning for Salary Negotiations [VIDEO]

Abstract:

Because little in business or life gets done without negotiation, this session has the potential to deliver significant upside in your professional and personal outcomes. In this session, you will be introduced to basic negotiation concepts and tactics, followed by a focus on important aspects of the negotiation process—obstacles to effective communication at the bargaining table, the maximization of multiple interests, and preparation tactics for your next negotiation. We will put it all together by examining a special type of negotiation: YOUR SALARY!

Participants will:

• Learn strategies for negotiation analysis and preparation • Understand different strategic choices and interpersonal skills necessary for success • Know what information is needed to negotiate effective outcomes • Experiment with new techniques and test their effectiveness in a safe environment

SessionID: 85531

The Big Picture: SQL Overview -Getting the Most of SQL Saturday

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Essentials

Speaker: Michael Curry

Title: The Big Picture: SQL Overview -Getting the Most of SQL Saturday

Abstract:

Targeted to anyone new to SQL server technologies, this is a holistic overview of multiple core technologies, career paths and how to maximize your SQL Saturday experience. This presentation starts with a business approach to structured data for business to introduce relational database concepts. We review key differences between operational and analytical databases for decision support and how the extract, transform and load (ETL) process is used to change operational into analytical data. We finish with a short intro to data analysis and Power BI to generate new insights from data. We will highlight complementary sessions that relate to the different topics and also briefly review necessary skills and career paths for those considering this exciting field. Audience QA encouraged. Materials include slides and a short introductory video.

SessionID: 86897

Lightning Talks: Session One

Back to calendar

Event Date: 03-11-2018 - Session time: 08:30:00 - Track:

Speaker: Misc Speakers

Title: Lightning Talks: Session One

Abstract:

Best in Class: A DAX Pattern for Identifying Top Performers |

Creating a Time Inspector Measure in Power BI for Easier Time Intelligence | Data Science in 15 Minutes! Predictive Analytics with R in Power BI

SessionID: 84386

Educating yourself will make a SQL career more fulfilling

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: Prof Dev

Speaker: Chris Wood

Title: Educating yourself will make a SQL career more fulfilling

Abstract:

Do you want to turn your SQL knowledge into a possible career?

This session will show you what options are available to learn about MS SQL Server and make you more knowledgeable about the product This session will show the many different options available to learn MS SQL Server ranging from free events thru to international conferences It will also show how to make any conference more affordable and justify the benefits

SessionID: 84653

Establishing a SLA form

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: Essentials

Speaker: Thomas Grohser

Title: Establishing a SLA form

Abstract:

Most rookie DBA's do not establish a Service Level Agreements (SLA) with the management and if they do they sometimes just come up with some random numbers for availability. Then when at some point later something goes wrong everybody wonders why it takes so long to bring everything back online.

This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA and communicate it to the rest of the comapany

SessionID: 84657

Everything You Need to Know About SQL Server Indexes

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBAdmin

Speaker: Janis Griffin

Title: Everything You Need to Know About SQL Server Indexes

Abstract:

You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.

This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown. This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.

SessionID: 84857

Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: BI Arch/Admin

Speaker: Jason Horner

Title: Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2

Abstract:

In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.

Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.

SessionID: 84974

Power BI Report Design for the aesthetically challenged

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: BI Design

Speaker: James McGillivray

Title: Power BI Report Design for the aesthetically challenged

Abstract:

Do you ever worry that your reports look they were born in the 90s, or designed by a grade 1? Do you feel overwhelmed when tasked with creating attractive reports which tell the customer a story?

Thankfully, a few simple design concepts can have big impacts on your reports. There are easy-to-learn techniques and patterns to create a pleasing look and feel to our reports, and some well defined principles to decide which visual is most appropriate in your situation.

Join me in this session to learn:

SessionID: 85043

Locks, Blocks, and Deadlocks, Oh My!

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBAdmin

Speaker: Randy Knight

Title: Locks, Blocks, and Deadlocks, Oh My!

Abstract:

"I've got a locking problem", "I need to get rid of blocking," and "deadlocks are normal behavior" are all things heard way too many times.

In this session targeted at the accidental or new DBA, we will walk through each of these items, what they are, what their causes are, which of them are normal behavior and which are not, and some common causes of deadlocks and excessive blocking.

SessionID: 85518

Relational Data Architecture 101

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBAdmin

Speaker: Pat Phelan

Title: Relational Data Architecture 101

Abstract:

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.

SessionID: 85636

Be Friendly to SQL Server with TSQL Best Practices [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBDev

Speaker: Ben Miller

Title: Be Friendly to SQL Server with TSQL Best Practices [VIDEO]

Abstract:

TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring. I will go over 5 key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. This is a beginners session but the concepts in this session are a great foundation to begin with. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.

SessionID: 85650

Data Types Do Matter [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBDev

Speaker: Angela Henry

Title: Data Types Do Matter [VIDEO]

Abstract:

They're just numbers, right? A date's a date. It's just string data, who cares? I can't tell you how many times I've heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.

SessionID: 86898

Lightning Talks: Session Two

Back to calendar

Event Date: 03-11-2018 - Session time: 10:15:00 - Track:

Speaker: Misc Speakers

Title: Lightning Talks: Session Two

Abstract:

What's it like to have a career in consulting?

Why Solidity is Solid - Basic of Ethereum, Smart Contracts, and Blockchain. Managing Execution Plans [VIDEO]

SessionID: 84636

3D printing at HP and spreadsheets; how HP broke free of data bottlenecks.

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: Essentials

Speaker: Jeff Honsowetz

Title: 3D printing at HP and spreadsheets; how HP broke free of data bottlenecks.

Abstract:

Join Jeff and guest speaker from HP to hear their story. In today’s complex world, we know inherently simple gets it done now. And “now” is the typical deadline of our supervisors. The difficulty is they demand tough requirements and often make changes that take extra time and staff. In HP’s world of 3D printing, they discovered a new simplicity in consuming data daily, pivoting quickly in new directions, and keeping their users in control within IT boundaries. Learn about HP 3D printing ingenuity in your own back yard and how Interject provided a spreadsheet platform for them to run even faster and collaborate on data in record time. What took months or weeks, now takes days or hours, and users need minimal training.

Be the first 20 to attend and pick a cold red bull or hot latte/mocha that will be waiting. Even better, at the end of the session we will be giving another $300 lightsaber like last year that is too cool for the kids. Space is limited so arrive early.

SessionID: 84655

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: BI Arch/Admin

Speaker: Diane Schuster

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 84983

Azure Intelligent Services

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: Data Science

Speaker: Amie Mason

Title: Azure Intelligent Services

Abstract:

Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.

SessionID: 85039

Game, Set, Match: Set Theory for Beginners [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBDev

Speaker: Jared Karney

Title: Game, Set, Match: Set Theory for Beginners [VIDEO]

Abstract:

Set Theory is the basis for designing relational databases and working with them. Understanding it can help you to design better databases and write better performing code. In this session, Jared Karney will give you the basics of Set Theory that you can take with you to design a relational database and write SQL that is scalable and performant.

SessionID: 85558

Successfully Virtualizing and Maintaining SQL Server on VMware vSphere [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBAdmin

Speaker: Victor Isakov

Title: Successfully Virtualizing and Maintaining SQL Server on VMware vSphere [VIDEO]

Abstract:

Microsoft SQL server is the most virtualized enterprise mission critical application today. In recent years it has become a mainstream effort among VMware customers to virtualize critical databases to allow better agility and scale while increasing availability and operational efficiency. In this session we will focus on the configuration of vSphere and SQL server for maximizing the benefits of virtualizing SQL server. The session is aimed at providing VMware customers and partners guidance on how to achieve best performance and efficiency with the latest versions of Microsoft SQL server and VMware vSphere.

SessionID: 86132

Going Beyond Monitoring With SentryOne

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBAdmin

Speaker: Andy Yun

Title: Going Beyond Monitoring With SentryOne

Abstract:

Hopefully you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.

SessionID: 86162

3 tips for getting executive buy-in for DevOps

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DevOps

Speaker: Kendra Little

Title: 3 tips for getting executive buy-in for DevOps

Abstract:

DevOps practices are a powerful tools to build productive, engaged teams who constantly learn and regularly deliver value to their customers. High DevOps performers report greater workplace satisfaction than their peers. But implementing DevOps isn’t a matter of being great at writing code: to become a high DevOps performer, you need the powerful catalyst of executive support. In this talk, we will discuss the value of DevOps from the perspectives of CEOs, CIOs/CTOs, and Managers. We will explore how the role of CIOs and CTOs are undergoing a major transformation, and how DevOps aligns with that transformation. You will leave the session with a fresh take on how to discuss DevOps with company leaders, and an understanding of how to explain the value of DevOps to people in these roles.

SessionID: 86585

Running SQL Server on Amazon Web Services

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: Cloud Data

Speaker: Richard Waymire

Title: Running SQL Server on Amazon Web Services

Abstract:

You can run SQL Server on Amazon Web Services (AWS). In this session, Richard will review how you can run SQL Server, including both EC2 and RDS deployments. He will explore how Amazon RDS helps you cover the requirements for high availability, backup, and encryption, freeing you to focus on improving your schemas and application performance.

SessionID: 86615

Real-time monitoring and detailed workload analysis with Spotligh

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBAdmin

Speaker: Trent Mera

Title: Real-time monitoring and detailed workload analysis with Spotligh

Abstract:

In this overview you’ll see how Spotlight on SQL Server gives you real-time performance alerts and brings together all of your critical SQL Server metrics into a single dashboard-style screen, color-coded for problem severity and clickable for rapid diagnostics. You’ll also see how Spotlight’s Wait Event and Workload Analysis screens enable a deep dive into which queries caused exactly how much of each type of workload at particular times.

SessionID: 86896

Maximum performance for SQL with Dell EMC

Back to calendar

Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBAdmin

Speaker: Craig Allen

Title: Maximum performance for SQL with Dell EMC

Abstract:

Get maximum performance for SQL Server with Dell EMC’s modern infrastructure using the latest technology #GetModern

SessionID: 84573

SQL Server Take Over:  Establishing a Baseline

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: DBAdmin

Speaker: Lowry Kozlowski

Title: SQL Server Take Over:  Establishing a Baseline

Abstract:

SQL Server Take Over:  Establishing a Baseline

Performance assessment and tuning for the beginner DBA   Have you ever inherited a group of servers with not a lot of documentation to accompany them?  Do you have a lot of undocumented or new servers in your environment and you want to establish some baseline configuration setting prior to making changes? You need up to date information on the system very quickly.    The server is running slowly... or is it? Slow compared to what?  Before you being digging into performance issues, there are some baseline metrics you should have established. Only after the information has been gathered, can a plan of attack be developed to help resolve issues with performance. Attendees in this session will learn how to quickly  gather information, review the results and get an action plan on the next step in performance tuning.

SessionID: 84610

Detecting and Capturing Change for Data Warehousing

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: BI Design

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

Select Stars: A SQL DBA's Introduction to Azure Cosmos DB

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: Cloud Data

Speaker: Bob Pusateri

Title: Select Stars: A SQL DBA's Introduction to Azure Cosmos DB

Abstract:

Azure Cosmos DB has quickly become a buzzword in database circles over the past year, but what exactly is it, and why does it matter? This session will cover the basics of Azure Cosmos DB, how it works, and what it can do for your organization. You will learn how it differs from SQL Server and Azure SQL Database, what its strengths are, and how to leverage them. We will also discuss Azure Cosmos DB's partitioning, distribution, and consistency methods to gain an understanding of how they contribute to its unprecedented scalability. Finally, we will demonstrate how to provision, connect to, and query Azure Cosmos DB. If you're wondering what Azure Cosmos DB is and why you should care, attend this session and learn why Azure Cosmos DB is an out-of-this-world tool you'll want in your data toolbox!

SessionID: 85040

Indexing for Beginners [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: Essentials

Speaker: Kathi Kellenberger

Title: Indexing for Beginners [VIDEO]

Abstract:

To a beginner, indexes may seem like magic. The right index can drastically reduce query time. But, how do you know which indexes are the right ones? SQL Server will suggest helpful indexes in the graphical execution plan and with the Database Engine Tuning Advisor, but follow that advice with caution. This session will explain how indexes work and how to tune indexes so that your application has the best performance.

SessionID: 85210

SSIS Deployment Smackdown! Package vs. Project!

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: BI Arch/Admin

Speaker: Peter Kral

Title: SSIS Deployment Smackdown! Package vs. Project!

Abstract:

SSIS Package deployment was the first, but is it the best? Project deployment promised so much, but did it deliver? Find out which method is best for you when you see two expert practitioners go head-to-head, presenting their best-case solution for their method, and then take on the weaknesses of their opposition! Which will emerge as the supreme deployment method? BE THERE!!!

SessionID: 85434

Intermediate Security Topics in SQL Server

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: DBAdmin

Speaker: Ben Thul

Title: Intermediate Security Topics in SQL Server

Abstract:

How many times have you been told by your customers:

In this session, we'll talk about ways to service requests like these without having to give away the world. We’ll start with authentication and authorization, for context.

We will then go into different methods to augment the "normal" means of obtaining permissions that will allow you to help your customers while at the same time not needing to be overly permissive.

In the course of this presentation, you'll learn about:

* Module signing
* Permission chaining
* Impersonation
and more!

SessionID: 85610

What is Temporal Tables

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: DBDev

Speaker: Jean-Pierre Voogt

Title: What is Temporal Tables

Abstract:

In this session we will take an introduction look at Temporal Tables in SQL Server. How do we query a temporal table and how do we manage a large temporal table with Stretch Database to Azure. We will look at when to use Temporal tables and why would you use it.

SessionID: 85652

T-SQL Habits and Practices That Can Kill Performance

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track: DBDev

Speaker: Vern Rabe

Title: T-SQL Habits and Practices That Can Kill Performance

Abstract:

All too often we are on a project or given a task where the time or financial constraints require us to develop T-SQL “quick-and-dirty”. Or maybe we have been tasked with quickly improving the performance of some existing T-SQL. These situations often lead to code that later needs to be tuned for better performance. Wouldn’t it be nice if we could satisfy those tight time constraints while also avoiding many of the pitfalls that later plague performance?

In this session we will see ten common T-SQL writing habits that contribute to poor performance. We’ll see WHY each of these patterns can have such negative impact on performance, including examples, and we’ll see one or more alternatives for each that don’t have the same negative impact. Armed with this knowledge, you will definitely impress your boss with your ability to create fast T-SQL within tight time constraints, and also quickly fix existing T-SQL code. Enjoy the merit raise you’ll get due to your new tuning talents.

SessionID: 86899

Lightning Talks: Session Three

Back to calendar

Event Date: 03-11-2018 - Session time: 13:00:00 - Track:

Speaker: Misc Speakers

Title: Lightning Talks: Session Three

Abstract:

Comment Your Code!

ProperCase - My Favorite UDF PLE, it's not what you think it is!

SessionID: 84557

Containerized databases: SQL Server and DevOps

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track: DevOps

Speaker: Ned Otter

Title: Containerized databases: SQL Server and DevOps

Abstract:

What are containers? When would you use them? Are they supported for production? Do they run on Windows? Do they run on Linux? Can they persist data?

These are just a few of the questions we will answer in this session. Containers are all the rage today - don't get left behind!

SessionID: 84600

How to Migrate your in house data to the cloud [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track: Cloud Data

Speaker: James Phillips

Title: How to Migrate your in house data to the cloud [VIDEO]

Abstract:

Now that you have decided to migrate to the cloud you may be thinking all I have to do is back and restore my database then change some connection strings. While sure this will work in some cases you'll soon find yourself banging your head against the wall wondering why your having performance issues or suddenly getting errors. Depending on the type of database and workload you are migrating there are certain steps that should be taken to ensure that your migration goes smoothly. In this session we will go over what those checklists should be and also cover common performance issues and techniques to rectify them during your migration.

SessionID: 84695

Don't Use Cursors or Why You Maybe Should Use a Cursor After All

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track: DBDev

Speaker: Erland Sommarskog

Title: Don't Use Cursors or Why You Maybe Should Use a Cursor After All

Abstract:

You might have heard "don't use cursors, they are slow!". In this presentation, you will learn what actually means: you should normally write set-based statements instead and I will explain why they generally are faster than writing your own loops. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that you implement it properly. The presenation also gives some tips how you can troubleshoot performance problems with loops.

SessionID: 84889

Predictive Analytics with R in Power BI [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track: Data Science

Speaker: Joseph Yeates

Title: Predictive Analytics with R in Power BI [VIDEO]

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 introduce how to start the shift from descriptive to predictive analysis and how you can begin to leverage the power of machine learning in your business intelligence solutions. No previous knowledge of R or predictive modeling is required!

We will cover the basics and best practices of predictive modeling and then these concepts will be applied to create three different predictive models in R. Then we will cover three ways to integrate the predictive power of these models into a Power BI report.

SessionID: 85239

Execution plans ... where do I start? [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track: Essentials

Speaker: Hugo Kornelis

Title: Execution plans ... where do I start? [VIDEO]

Abstract:

SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.

But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.

However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?

In this session you will learn how to obtain execution plans. and how to start reading and understanding them.

SessionID: 85365

Introduction to SQL Server Reporting Services [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track: BI Design

Speaker: Ted Stathakis

Title: Introduction to SQL Server Reporting Services [VIDEO]

Abstract:

This session will cover the basics of developing, publishing and using SQL Server Reporting Services. You will learn all the steps needed to get started from connecting to the data source, creating data sets through putting the data on the page and publishing the report to the report server. See how easy SSRS is to use and how powerful it can be. The demo will be using SSRS 2016 but the concepts covered are applicable to any version of SQL Server.

The session will also include: A tour of a wide variety of report examples including interactive graphical dashboards that you can do in SSRS, even in older versions. A comprehensive discussion of design elements to include and avoid when creating reports. Report printing and export considerations for optimal output depending on rendering format. You will leave this session able to return to the office and present meaningful data to your end users with minimal time and effort with easy to use and powerful BI tool that you already own

SessionID: 85492

PowerShell for the DBA

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track: DBAdmin

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

What is DevOps? - and why should I care?

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track: DBDev

Speaker: Martin Catherall

Title: What is DevOps? - and why should I care?

Abstract:

If you like an interactive and lively sessions them this is the place for you.

We’ll look at the background of this term – and see how it has transformed to bring focus to the data professional. We’ll take a peak at what it means for the technology professional as well as what it means for the business professional - and we'll see Visual Studio Team Services (VSTS) and the cloud in action. We’ll look at the different kinds of disciplines that lead to a well-rounded DevOps set up. We’ll have a run through some of the motivations for developing a DevOps mindset and we’ll also hear about some of the arguments for non-adoption. We’ll look at some of the other IT methodologies that we’ve seen emerge over the years and examine exactly what sets DevOps apart from these. Regardless of if you’re never heard this term before or you have strong feeling about the subject – either way – you’ll leave the room with a new perspective and quite likely you’ll have contributed to your fellow delegates kn

SessionID: 86901

Lightning Talks: Session Four

Back to calendar

Event Date: 03-11-2018 - Session time: 14:45:00 - Track:

Speaker: Misc Speakers

Title: Lightning Talks: Session Four

Abstract:

Using Text Manipulation For Great Good

The top 3 Availability Groups pitfalls and how to avoid them The top five things DBAs need to know about DevOps

SessionID: 84575

Code Like a Snake Charmer - Intro to Python! [VIDEO]

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track: Data Science

Speaker: Jamey Johnston

Title: Code Like a Snake Charmer - Intro to Python! [VIDEO]

Abstract:

The session will be an introduction to the Python language including:

1.) Installing and Configuring Python 2.) Access and Manipulate Data 3.) Install and Manage Packages 4.) Create and Use Objects/Variables 5.) Control Flows and Functions 6.) Managing the Python installation in MSSQL

Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.

No prior statistics knowledge needed.

SessionID: 84579

DBA vNext

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track: DBAdmin

Speaker: Armando Lacerda

Title: DBA vNext

Abstract:

Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.

Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.

In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.

SessionID: 84612

High Availability/Disaster Recovery 101

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track: DBAdmin

Speaker: Glenn Berry

Title: High Availability/Disaster Recovery 101

Abstract:

How do you design a SQL Server 2017 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2017, showing how you can combine them to design and build a solution to help meet your HA/DR goals. This session also teaches you how to formulate policies that enable effective use of technology in your organization.

SessionID: 84646

Introduction to Managed Instances [Video]

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track: Cloud Data

Speaker: John Martin

Title: Introduction to Managed Instances [Video]

Abstract:

What are Azure SQL Database Managed Instances?

The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are and how you might start using them.

Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server. Including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges to using Azure SQL Databases.

But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology, working through a full migration including workload analysis, selecting the appropriate migration pathway and then putting it in place.

SessionID: 85506

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

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track: DBDev

Speaker: Hamish Watson

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

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

Data Testing Integrity – BI Edition

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track: BI Design

Speaker: Rob Long

Title: Data Testing Integrity – BI Edition

Abstract:

Unit Testing and Test-Driven Development are common practices in application development. In SQL development we’ve even got tSQLT! In the realm of BI with desperate systems, integration layers, data warehouses and even cubes we need a better approach.

In this session, we’ll discuss different problem scenarios and practical solutions. We’ll identify the need to look at the data from the business perspective and define specific integrity checks to ensure our data is accurate. Then the fun part! Using the Microsoft BI tool-set, we will walk-through a working solution demonstrating a way to efficiently centralize this process.

At the end of the session, we’ll all still agree that we can’t use a unit test or record counts to ensure that data is accurate. You will have a simple solution that you can start with to work in your environment and look at data testing integrity differently.

SessionID: 85619

Building Your Own Power BI Image Generating Measures

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track: BI Design

Speaker: Brian Grant

Title: Building Your Own Power BI Image Generating Measures

Abstract:

With the August 2018 version of Power BI, you can now write DAX measures that generate dynamic chart images using the SVG (Scalable Vector Graphics) standard. This means the long sought-after chart types of "small multiples" and "spark lines" are suddenly available, letting report authors create a sort of pivot table, not of numbers, but of dozens of tiny dynamic charts. However, this only works if you know how to leverage DAX to write dynamic SVG code, a rather oblique use of the language. In this session we'll be showing users how to do exactly that live on stage. We'll create several chart measures, from KPI indicators, to spark lines, to the game-changing bullet charts. Folks will walk away with some basic patterns they can use to create their own chart measures at home in no time at all.

SessionID: 85623

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track: Essentials

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.

SessionID: 86900

Lightning Talks: Session Five

Back to calendar

Event Date: 03-11-2018 - Session time: 16:15:00 - Track:

Speaker: Misc Speakers

Title: Lightning Talks: Session Five

Abstract:

TBD