sqlsathistory

Nr: 736

Back to Main list

SQLSaturday #736 - Columbus 2018

Start Time (24h) Speaker Track Title
08:30:00 Ameena Lalani Enterprise Database Administration Deployment Learn History from Temporal Tables
08:30:00 Kevin Feasel Analytics and Visualization Applying Forensic Accounting Techniques Using SQL And R
08:30:00 Dave Bland Enterprise Database Administration Deployment Extended Events: What are they and How do I use them
08:30:00 George Bryant BI Platform Architecture, Development Administration Little and Large - Cubes to Scale
08:30:00 Wendy Pastrick Professional Development Moving Past Imposter Syndrome
08:30:00 Allen White Enterprise Database Administration Deployment Maintain SQL Server Performance Baseline with PowerShell
08:30:00 Brian Carrig Application Database Development Temporal Tables in SQL Server 2016 and 2017
09:45:00 Jim Donahoe Cloud Application Development Deployment Getting started with SQL Azure Database: What you need to know
09:45:00 Drew Furgiuele Enterprise Database Administration Deployment SQL Server and PowerShell: Let's Get Serious
09:45:00 Jim Miller BI Platform Architecture, Development Administration Populating a Data Warehouse with SSIS and Biml Patterns
09:45:00 Bert Wagner Application Database Development SQL Injection Attacks: Are Your Queries Secure?
09:45:00 Erin Stellato Enterprise Database Administration Deployment Analyzing Your Workload with Query Store
09:45:00 Amy Herold Application Database Development The Case for Change: Identifying and Remedying Bad Code
11:00:00 Rie Irish Application Database Development Is My Application Bias Showing?
11:00:00 Cassandra Faris Professional Development (Not So) Accidental Personal Branding
11:00:00 Jess Pomfret Enterprise Database Administration Deployment Data Compression: Squeeze Out Some Free Gains
11:00:00 Britton Gray Analytics and Visualization Data Science in Reverse: Creating Credible Fake Data Sets
11:00:00 Frank Gill Cloud Application Development Deployment Azure Managed Instance: Reducing Maintenance Costs While Making Migration Simple
11:00:00 Chris Hyde BI Platform Architecture, Development Administration Detecting and Capturing Change for Data Warehousing
12:15:00 David Maxwell Other Rubrik - Sponsor Session
12:15:00 David Maxwell Other Product Demonstration by Quest Software
12:15:00 David Maxwell Other Cardinal Solutions Sponsor Session
13:30:00 Eugene Meidinger Application Database Development Execution Plans 101
13:30:00 Matt Gordon Cloud Application Development Deployment Data To Impress Those That Sign The Checks - Azure Logic Apps, Social Media, and Sentiment Analysis
13:30:00 Paul Popovich Jr Enterprise Database Administration Deployment SQL on Linux and Docker 101
13:30:00 Tim Radney Enterprise Database Administration Deployment Common SQL Server Mistakes and How to Avoid Them
13:30:00 Ginger Grant Analytics and Visualization Implementing Python in SQL Server 2017
13:30:00 Andy Mallon Professional Development How to get your Dream Job: Resume job hunting tips
13:30:00 Akhil Mahajan Cloud Application Development Deployment Getting Started with Azure Data Lake Analytics (ADLA)
14:45:00 John Deardurff Application Database Development The Vocabulary of Performance Tuning
14:45:00 Kevin Feasel Analytics and Visualization Grokking the Grammar of Graphics
14:45:00 Ryan Wade Analytics and Visualization A Tour of R in the Microsoft Ecosystem
14:45:00 Kellyn Pot'Vin-Gorman Enterprise Database Administration Deployment Screw DevOps, Let's Talk DataOps
14:45:00 Kathi Kellenberger Application Database Development T-SQL Window Function Performance
14:45:00 Elizabeth Noble Professional Development How to win Dev and influence QA
14:45:00 Gareth Swanepoel Enterprise Database Administration Deployment A Deep Dive into Locking, Blocking Latches
14:45:00 Luis Gonzalez Enterprise Database Administration Deployment Introduction to System Catalog Views and System Dynamic Management Views
16:00:00 Tracy Boggiano Enterprise Database Administration Deployment Monitoring Availability Groups
16:00:00 Sam Nasr Application Database Development Building REST API using SQL Server JSON functions
16:00:00 Sourav Mukherjee Cloud Application Development Deployment Know different AWS Database Products - their benefits and key features
16:00:00 Matt Gordon Cloud Application Development Deployment Where Should My Data Live (and Why)?
16:00:00 Rob Volk Enterprise Database Administration Deployment That's So Metadata: Discover Your Database From the Inside
16:00:00 Michael Fal Application Database Development Getting Started with Git/GitHub
16:00:00 Evelyn Maxwell Professional Development Improving your PowerPoint Skills

SessionID: 72151

Learn History from Temporal Tables

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ameena Lalani

Title: Learn History from Temporal Tables

Abstract:

SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. SQL Server 2017 made some enhancements in this area. Temporal tables are basically history tables of the normal tables; that allows us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. We will touch upon retention of history as well. It has lots of demos and less theory.

SessionID: 72264

Applying Forensic Accounting Techniques Using SQL And R

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Applying Forensic Accounting Techniques Using SQL And R

Abstract:

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.

SessionID: 77113

Extended Events: What are they and How do I use them

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Extended Events: What are they and How do I use them

Abstract:

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!

SessionID: 77323

Little and Large - Cubes to Scale

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: George Bryant

Title: Little and Large - Cubes to Scale

Abstract:

In 2018 creating a cube is one of the easier tasks in BI, however what happens when the cube you inherit is so big that it officially becomes the biggest cube in the Midwest, and therefore one of the biggest cubes in the country? This session shows how to handle tabular models of size and scale. It also delves into what assistance and considerations are required when considering moving, or even building, your cubes in Azure.

SessionID: 80526

Moving Past Imposter Syndrome

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Professional Development

Speaker: Wendy Pastrick

Title: Moving Past Imposter Syndrome

Abstract:

We have heard a lot on recognizing Imposter Syndrome and how to address it. However, what if it’s not Imposter Syndrome after all? We will discuss working scenarios and how you approach or deal with them to determine “is it you or is it me?”

SessionID: 80675

Maintain SQL Server Performance Baseline with PowerShell

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

Title: Maintain SQL Server Performance Baseline with PowerShell

Abstract:

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 83830

Temporal Tables in SQL Server 2016 and 2017

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Brian Carrig

Title: Temporal Tables in SQL Server 2016 and 2017

Abstract:

SQL Server 2016 introduced the concept of a system-versioned temporal table. Further enhancements were added in SQL 2017. This is a type of user table that is designed to keep a complete history of all data changes to facilitate easy point-in-time analysis. In this session we will cover the basics of the internals of how temporal tables work, how to create them and their wide variety of use cases from auditing, to trend analysis and even recovery from data corruption.

SessionID: 71925

Getting started with SQL Azure Database: What you need to know

Back to calendar

Event Date: 28-07-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Jim Donahoe

Title: Getting started with SQL Azure Database: What you need to know

Abstract:

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.

In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

SessionID: 71944

SQL Server and PowerShell: Let's Get Serious

Back to calendar

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

Speaker: Drew Furgiuele

Title: SQL Server and PowerShell: Let's Get Serious

Abstract:

Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away. It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA.

In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.

Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.

SessionID: 74000

Populating a Data Warehouse with SSIS and Biml Patterns

Back to calendar

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

Speaker: Jim Miller

Title: Populating a Data Warehouse with SSIS and Biml Patterns

Abstract:

This session will demonstrate how to leverage Biml Patterns, along with SQL Server Metadata, to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to most any ETL/ETL scenarios.

The components used during this session:

Attend to see how Biml can revolutionize your SSIS development!

SessionID: 81958

SQL Injection Attacks: Are Your Queries Secure?

Back to calendar

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

Speaker: Bert Wagner

Title: SQL Injection Attacks: Are Your Queries Secure?

Abstract:

Sometimes using dynamic SQL is the only way to write a query that accomplishes what you need. But did you know that dynamic SQL statements can leave you vulnerable to SQL injection attacks?

In this session we'll examine how SQL injection works and how we can write injection-proof queries through a series of examples and demos. We'll also look at why some commonly used techniques aren't as secure as many people think.

If you ever write or maintain dynamic SQL queries, or work with developers who do, then this session is for you. After all, do you really want to be the person responsible for allowing hackers into your database?

SessionID: 83106

Analyzing Your Workload with Query Store

Back to calendar

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

Speaker: Erin Stellato

Title: Analyzing Your Workload with Query Store

Abstract:

I've said it before and I'll say it again: Query Store is a game-changer for troubleshooting query performance. Yet when I ask people who are running SQL Server 2016 or higher if they're using Query Store, less than half say they are. If you fall into that category, this session is for you.

We’ll start by discussing Query Store configuration. Sound a little boring? It won't be. There are multiple settings that affect how information is captured and you need to understand them. Next, we'll look at the data. Definitely not boring, as it's imperative you understand exactly what gets stored (and what doesn't) so you can find problematic queries quickly.
Lastly, we'll mine the data in Query Store, and mining is more than just finding queries that use a particular index, or those that access a specific table. We’ll discuss different workload characteristics and how they affect system performance, and how to use Query Store to better understand your own workload.

SessionID: 83831

The Case for Change: Identifying and Remedying Bad Code

Back to calendar

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

Speaker: Amy Herold

Title: The Case for Change: Identifying and Remedying Bad Code

Abstract:

There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one "perfect storm" that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it's a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance.

How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.

SessionID: 82614

Is My Application Bias Showing?

Back to calendar

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

Speaker: Rie Irish

Title: Is My Application Bias Showing?

Abstract:

Computers can't be biased, right? I mean, it's just lines of code. Yes or No. Ones Zeros. Those lines of code are written by people. People have life experiences that color how they see the world. Okay, let's be blunt. People have baggage. And that baggage is seeping into your application, surveys and web forms.

You've got an idea for a new app and it's going to change the world! Right? It's a brilliant idea no one has ever thought of it before. You're working on the GUI for your company's web portal and you know just what information to collect from the user. Are you sure about that? Odds are pretty good that the information you're going to collect is a reflection of your life your experiences.
Learn how to identify bias when it seeps in, how to code to be inclusive instead of exclusive , and some quick tips tricks to make sure you're accounting for all the users that will use YOUR application to change the world. Instead of just the ones that look like you.

SessionID: 82712

(Not So) Accidental Personal Branding

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: Professional Development

Speaker: Cassandra Faris

Title: (Not So) Accidental Personal Branding

Abstract:

If you have an online presence, you have a personal brand. Most of us didn’t intend to create a brand when we made our first websites and social media profiles. They were just fun ways to share our lives and meet people. Now, they’re networking and career growth tools. In this talk, you’ll hear about people whose brands helped them become respected developers, managers, and community leaders. You’ll learn how to use your online presence to advance your career. You’ll also pick up best practices, common mistakes, and tips for balancing professional and personal content. Intentional personal branding opens the door to endless opportunities. Come see how to make that happen!

SessionID: 83086

Data Compression: Squeeze Out Some Free Gains

Back to calendar

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

Speaker: Jess Pomfret

Title: Data Compression: Squeeze Out Some Free Gains

Abstract:

Since data compression is now a standard level feature (2016 SP1+) learn how to squeeze a little extra performance out of your databases for free! We’ll cover the types of compression available, the costs and benefits and how to determine good candidates for compression. Once we know what we want to compress we’ll cover three ways to apply it, including the easiest way to compress your whole database to meet best practices with just one line of code!

SessionID: 83139

Data Science in Reverse: Creating Credible Fake Data Sets

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Britton Gray

Title: Data Science in Reverse: Creating Credible Fake Data Sets

Abstract:

Sometimes a data professional will find themselves in need of a large demonstration data set. However, non-proprietary options are few and usually lacking. This session will educate attendees in how to get around these obstacles by creating their own data. We'll talk about the process of using real-world variability, creating inconsistency that leads to insight using some basic statistical concepts, the process of putting everything together, and getting the data set into SQL Server.

SessionID: 83143

Azure Managed Instance: Reducing Maintenance Costs While Making Migration Simple

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Frank Gill

Title: Azure Managed Instance: Reducing Maintenance Costs While Making Migration Simple

Abstract:

While Azure SQL Database provides the full feature of the SQL Server database engine, it is designed primarily for newly developed, cloud-based applications. For existing applications running on traditional SQL Server instances, the cost and complexity of migration can be prohibitive. With the release of Azure Managed Instances, much of the cost and complexity have been removed. Join me for this session to learn about the differences between Azure SQL Database and Azure Managed Instances. Additionally, discover methods for migrating existing instances to Azure.

SessionID: 83832

Detecting and Capturing Change for Data Warehousing

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

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

Rubrik - Sponsor Session

Back to calendar

Event Date: 28-07-2018 - Session time: 12:15:00 - Track: Other

Speaker: David Maxwell

Title: Rubrik - Sponsor Session

Abstract:

SessionID: 84806

Product Demonstration by Quest Software

Back to calendar

Event Date: 28-07-2018 - Session time: 12:15:00 - Track: Other

Speaker: David Maxwell

Title: Product Demonstration by Quest Software

Abstract:

Product Demonstration by Quest Software

SessionID: 84828

Cardinal Solutions Sponsor Session

Back to calendar

Event Date: 28-07-2018 - Session time: 12:15:00 - Track: Other

Speaker: David Maxwell

Title: Cardinal Solutions Sponsor Session

Abstract:

SessionID: 71957

Execution Plans 101

Back to calendar

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

Speaker: Eugene Meidinger

Title: Execution Plans 101

Abstract:

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, and additional features.

SessionID: 74122

Data To Impress Those That Sign The Checks - Azure Logic Apps, Social Media, and Sentiment Analysis

Back to calendar

Event Date: 28-07-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Matt Gordon

Title: Data To Impress Those That Sign The Checks - Azure Logic Apps, Social Media, and Sentiment Analysis

Abstract:

The job of a data professional is evolving rapidly, driving many of us to platforms and technologies that were not on our radar screen a few months ago. I am certainly no exception to that trend. Most of us aren't just monitoring backups and tuning queries - we are collaborating with teams throughout the company to provide them data and insights that drive decisions. This presentation walks you through how a silly idea from a soccer podcast got me thinking about how Azure Logic Apps, sentiment analysis, and Azure SQL DB combine to provide potentially powerful insights to any company with a social media and sales presence. Join me as I walk you through building a solution that can impact your company's bottom line - and potentially yours too!

SessionID: 74356

SQL on Linux and Docker 101

Back to calendar

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

Speaker: Paul Popovich Jr

Title: SQL on Linux and Docker 101

Abstract:

By now you've heard that SQL Server is available on various flavors of Linux and Docker. Join me in this session to go through the basics of these technologies. I want to show you how to setup, install, configure, and have a database to insert some data into and query. Then I want to go through your tool management options. All in all I hope to leave you with the ability to take this to your shop to see where it might make sense to use in the future.

SessionID: 77250

Common SQL Server Mistakes and How to Avoid Them

Back to calendar

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

Speaker: Tim Radney

Title: Common SQL Server Mistakes and How to Avoid Them

Abstract:

Making mistakes is human nature, avoiding them comes from experience and shared wisdom from others. In this session, Tim Radney will share experiences he has encountered supporting multiple fortune level companies. Tim will share real world experiences of environments he has worked on and the impact he has seen from administrators not knowing how to properly configure and administer SQL Server. In this session you will learn many accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smooth as possible. When you leave this session you will have a checklist of items to take back to your shop to make sure your environment is configured properly.

SessionID: 80575

Implementing Python in SQL Server 2017

Back to calendar

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

Speaker: Ginger Grant

Title: Implementing Python in SQL Server 2017

Abstract:

SQL Server 2016 added R to the analytical toolset and SQL Server 2017 has added Python. When looking at various lists of the most popular programming languages, Python always has one of the top positions. This session provides an introduction to Python, including why it is a good choice for analyzing data.

If you have not had a chance to review SQL Server 2017 yet, please attend to see some of the new changes coming later this year. One of the features covers will show what is needed to incorporate Python into SQL Server and how Python can be incorporated in stored procedures to provide the ability to analyze data using arguably the most popular programming language to review data.

SessionID: 80646

How to get your Dream Job: Resume job hunting tips

Back to calendar

Event Date: 28-07-2018 - Session time: 13:30:00 - Track: Professional Development

Speaker: Andy Mallon

Title: How to get your Dream Job: Resume job hunting tips

Abstract:

What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I'm living my dream.

In this session, we'll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing my journey, I'll give some helpful tricks to getting your next job. You'll learn how to write a resume that gets you noticed, how to navigate interviews, and learn how to decide if a potential job and employer is right for you.

Bring your own resume to this session, and I'll provide you some personal (and private) feedback on what I would do to help improve your resume so you can land your Dream Job.

Slides handouts available on GitHub: http://am2.co/dream-job-ppt

SessionID: 80916

Getting Started with Azure Data Lake Analytics (ADLA)

Back to calendar

Event Date: 28-07-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Akhil Mahajan

Title: Getting Started with Azure Data Lake Analytics (ADLA)

Abstract:

Did you throw your data in a lake, specifically an Azure Data Lake? Are you now wondering what to do with all of that data? Microsoft provides Azure Data Lake Analytics (ADLA) “An on-demand analytics job service to power intelligent action.”

We will take a look at U-SQL, the big data language, which will empower you to leverage the T-SQL you know to extract meaningful insights from your big data.

SessionID: 71923

The Vocabulary of Performance Tuning

Back to calendar

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

Speaker: John Deardurff

Title: The Vocabulary of Performance Tuning

Abstract:

This session is for the absolute beginner to learn the terminology of performance tuning and how queries are processed. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss table structures and the differences between Heaps and Clustered Indexes. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses.

SessionID: 72265

Grokking the Grammar of Graphics

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Grokking the Grammar of Graphics

Abstract:

One of the most popular libraries in R is ggplot2, a graphics library built on a concept called the grammar of graphics. In this example-heavy talk, we will learn about the grammar of graphics through ggplot2. We will start by building a series of simple visuals using ggplot2. Then, we will show how easy it is to add more and more complex functionality to our visuals, showing that we can incrementally add polish to our visuals. By the end of the talk, you will have the tools to build professional-quality visuals in R.

SessionID: 75849

A Tour of R in the Microsoft Ecosystem

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Ryan Wade

Title: A Tour of R in the Microsoft Ecosystem

Abstract:

Over the past few years R has been popping up in several areas within the Microsoft ecosystem. It was first introduced in Azure ML then later appeared in Power BI and SQL Server. Unfortunately, the benefits of the R programming language are not understood by many Microsoft professionals so these tools are not being fully utilized. I hope to change that for some with this talk.

In this session we will take a tour of R in the Microsoft ecosystem. We will show the different ways R can be leverage and present compelling reasons why it is a very valuable tool that you should add to your data analytics arsenal. No R experience is needed for this session.

SessionID: 76880

Screw DevOps, Let's Talk DataOps

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: Screw DevOps, Let's Talk DataOps

Abstract:

DevOps is the new hot topic for IT, but only answers part of the problem. This session and demo will discuss why data creates continual friction in the DevOps environment and how it must be incorporated into the solution.

Reasons for this solution is required: -Data is getting bigger and more complex -Security concerns around critical data is becoming more evident every day -Data is created in silos in many sources, yet consumed in just as many locations, including on-premises and in the cloud.

We'll discuss the tech, the politics and the challenges of bringing data into DevOps and how to do so more successfully with culture changes, tools, scripting, and virtualization.

Takeaways from this session:

  1. Learn the five principles of Data Ops 2. How embracing a dynamic data platform can eliminate challenges and provide automation. 3. Learn the difference between containers, packages and data pods. 4. Learn how to bridge the gap between data and people, eliminating culture from the scene

SessionID: 80762

T-SQL Window Function Performance

Back to calendar

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

Speaker: Kathi Kellenberger

Title: T-SQL Window Function Performance

Abstract:

Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

SessionID: 82894

How to win Dev and influence QA

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: Professional Development

Speaker: Elizabeth Noble

Title: How to win Dev and influence QA

Abstract:

Are you having a hard time enforcing or updating processes? Are you having trouble getting the business to see your vision of the future? Do you want to improve process or tasks at your office? Your answer to these challenges may be to improve relationships with key departments like Development and Quality Assurance.

In this session, I will go over steps I took to improve relationships with other members of the IT department. I will also discuss how improving my relationships helped me accomplish my long-term goals.

SessionID: 83157

A Deep Dive into Locking, Blocking Latches

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Gareth Swanepoel

Title: A Deep Dive into Locking, Blocking Latches

Abstract:

This topic sounds scary, but it’s not. Regardless of whether you have a small database with only a few users, or a large multi-tenant system, you have Locking, Blocking, Latches, and Spinlocks. Understanding what they are and how they work is the first step in understanding how to troubleshoot them. Deadlocks are a problem, but they are a problem we can fix. In this session, we will explain and investigate how to find and fix the problems that we see in our database every day.

SessionID: 84870

Introduction to System Catalog Views and System Dynamic Management Views

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Luis Gonzalez

Title: Introduction to System Catalog Views and System Dynamic Management Views

Abstract:

System Catalog Views are all about the catalog METADATA in your database. Using basic T-SQL queries they let you look for objects in the database such as Tables, Stored Procedures, Functions, and more. System Dynamic Management Views let you monitor the health of your server instance and database, assist in performance tuning and diagnosing problems. Both can be core sources of information that let you do your job faster and better. Sure, on the surface they can seem rather mundane, but they can save your bacon when your database goes sidewise and you have no idea what’s going on. Join me as we begin our flight at 50,000 feet exploring many of the different types of views available and what they can provide you, then push the yoke forward and dive toward the ground to get a closer look at several in detail. But don’t worry, just as it looks like we’re going to crash and burn we’ll pull back on the yoke and slide in to a smooth landing.

SessionID: 71970

Monitoring Availability Groups

Back to calendar

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

Speaker: Tracy Boggiano

Title: Monitoring Availability Groups

Abstract:

Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups. We will define and cover important metrics and alerts you need to manage a database in an Availability Group.

You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.

SessionID: 72011

Building REST API using SQL Server JSON functions

Back to calendar

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

Speaker: Sam Nasr

Title: Building REST API using SQL Server JSON functions

Abstract:

SQL Server 2016 and Azure SQL Databases both contain JSON features that allow data to be accessed for either reading or writing JSON documents. This combined with REST APIs make it easier than ever for applications to exchange data directly with the database. We'll demonstrate this feature using SQL Server's built-in JSON support.

SessionID: 73717

Know different AWS Database Products - their benefits and key features

Back to calendar

Event Date: 28-07-2018 - Session time: 16:00:00 - Track: Cloud Application Development Deployment

Speaker: Sourav Mukherjee

Title: Know different AWS Database Products - their benefits and key features

Abstract:

AWS offers a broad range of databases purpose-built for your specific application use cases. It offers managed Relational, Non-Relational, Data Warehouse, In-Memory Data Store, and Graph Databases. AWS fully managed database services include relational databases for transactional applications, non-relational databases for internet-scale applications, a data warehouse for analytics, an in-memory data store for caching and real-time workloads, and a graph database for building applications with highly connected data. To migrate their existing databases to AWS, the AWS Database Migration Service makes it easy and cost effective to do so. The specific session will cover all the different databases products offered by AWS and the features and the key benefits and also the key clients who all use the products and catering to their specific needs.

SessionID: 74123

Where Should My Data Live (and Why)?

Back to calendar

Event Date: 28-07-2018 - Session time: 16:00:00 - Track: Cloud Application Development Deployment

Speaker: Matt Gordon

Title: Where Should My Data Live (and Why)?

Abstract:

Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy.

SessionID: 77489

That's So Metadata: Discover Your Database From the Inside

Back to calendar

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

Speaker: Rob Volk

Title: That's So Metadata: Discover Your Database From the Inside

Abstract:

Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team?

SQL Server has a number of metadata facilities available to help you with these tasks, and more. Functions, dynamic management views, and system stored procedures can illuminate details from the smallest column up through an entire SQL Server instance and everything in-between. We will demonstrate metadata techniques to help you:

We'll also demonstrate the new SQL Data Discovery/Classification and Vulnerability Assessment features in SQL Server Management Studio.

SessionID: 83089

Getting Started with Git/GitHub

Back to calendar

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

Speaker: Michael Fal

Title: Getting Started with Git/GitHub

Abstract:

SessionID: 84866

Improving your PowerPoint Skills

Back to calendar

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

Speaker: Evelyn Maxwell

Title: Improving your PowerPoint Skills

Abstract:

PowerPoint can enhance the presentation of any speaker or business professional, but using it effectively in your sessions or presentations can be difficult without practice. In this session, you will learn how to take your PowerPoint skills to the next level, using more advanced transitions, animations, and media in your presentations. This will help you engage your audience and communicate visually instead of just verbally, making your presentations more effective. After attending this session, you can feel confident that your PowerPoint skills have improved.

This site is open source. Improve this page.