sqlsathistory

Nr: 883

Back to Main list

SQLSaturday #883 - Louisville 2019

Start Time (24h)	Speaker	Track	Title
14:15:00	Chris Hyde	Analytics and Visualization	An Introduction to Data Science with Python for Data Professionals
14:15:00	Tim Radney	Enterprise Database Administration Deployment	Common SQL Server Mistakes and How to Correct Them
08:15:00	Mala Mahadevan	Application Database Development	SQL Graph Revealed
08:15:00	Jay Falck	Enterprise Database Administration Deployment	Introduction to Linux for SQL Server Professionals
08:15:00	Matt Gordon	Enterprise Database Administration Deployment	Top 5 Tips to Keep Always On AGs Humming and Users Happy
08:15:00	Peter Doyle	Application Database Development	Become a T-SQL Pivoting Ninja in 60 Minutes Or Less
08:15:00	Chris Hyde	Analytics and Visualization	Python in SQL Server 2017 and 2019
08:15:00	Elizabeth Noble	Enterprise Database Administration Deployment	Improving Database Code Quality with Unit Tests
09:30:00	Monica Rathbun	Enterprise Database Administration Deployment	Performance Tuning, Getting the Biggest Bang for Your Buck
09:30:00	Kevin Feasel	Analytics and Visualization	Launching A Data Science Project: Cleaning Is Half The Battle
09:30:00	Dave Bland	Enterprise Database Administration Deployment	Is my SQL Server having Memory Pressure?
09:30:00	David Maxwell	Enterprise Database Administration Deployment	Transaction Log Internals and Performance
09:30:00	Leonard Lobel	Application Database Development	Docker for the SQL Server Developer
09:30:00	Leslie Andrews	BI Platform Architecture, Development Administration	A Perfect Ten: The Data Model
10:45:00	Jamey Johnston	BI Platform Architecture, Development Administration	Microsoft Azure Modern Data Warehouse
10:45:00	Dan Mallott	Application Database Development	Secure SQL Server Database Design: Tactics and Technology
10:45:00	Angela Tidwell	BI Platform Architecture, Development Administration	Data Collection and Usage: Illegal or Unethical?
10:45:00	Greg Deckler	Analytics and Visualization	Building a Machine Learning Regression Model with Zero Code in PowerBI
10:45:00	Brian Hansen	Application Database Development	Remember Back When? Temporal Tables in SQL Server 2016 and 2017
12:00:00	Marsha Pierce	Enterprise Database Administration Deployment	How Fast Can You Restore Your Database?
13:15:00	Vladimir Oselsky	Application Database Development	Performance Tuning for SQL Developer through Execution Plans
13:15:00	Meagan Longoria	Analytics and Visualization	Practical Power BI Report Design Tips for the Non-Artist
13:15:00	Hilary Wilkie	Professional Development	User Experience Brilliance in Power BI Dashboards
13:15:00	Amy Herold	Enterprise Database Administration Deployment	PowerShell for the DBA
13:15:00	Kevin Wilkie	Application Database Development	The function of Windowing Functions
13:15:00	Sriharsh Adari	Strategy and Architecture	Modernize Data Platform - A Detailed Case Study
14:30:00	John Deardurff	Application Database Development	Inside the Database Engine
14:30:00	Simon Kingaby	Cloud Application Development Deployment	Moving Data to the Cloud (with Azure Data Factory)
14:30:00	Hasan Savran	Cloud Application Development Deployment	Cosmos DB was the missing piece to my Data puzzle!
14:30:00	Sam Nasr	Application Database Development	Using FileTables
14:30:00	Warren Sifre	Other	Introduction To Data Governance
14:30:00	Rob Volk	Enterprise Database Administration Deployment	Revenge: The SQL!
14:30:00	Tim Radney	Enterprise Database Administration Deployment	Azure for the Production Data Professional
15:45:00	Tracy Boggiano	Enterprise Database Administration Deployment	Using Open Source Products to Collect Performance Metrics
15:45:00	Spencer Swindell	BI Platform Architecture, Development Administration	Applying Data Warehousing Principles
15:45:00	Joshua Higginbotham	Application Database Development	Introduction to GitHub
15:45:00	Dustin Dorsey	Strategy and Architecture	10 reasons you are paying too much (or too little) on your SQL licenses
15:45:00	Peter Shore	Enterprise Database Administration Deployment	Infrastructure for the DBA: An Introduction
15:45:00	Lucas Feiock	Analytics and Visualization	Intro to SQL Spatial Data: Location Analytics

SessionID: 94699

An Introduction to Data Science with Python for Data Professionals

Back to calendar

Event Date: 03-08-2019 - Session time: 14:15:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: An Introduction to Data Science with Python for Data Professionals

Abstract:

Data Science is currently the hottest topic among data analysts and technologists, but getting started can sometimes be daunting or confusing to many data professionals. We aim to change that with this full-day, hands-on course in which you will be introduced to data science and its basic methodologies using the Python programming language!

Together we will work through some real-world data analyses using several of the most popular Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. We'll cover collecting and importing data, and introduce basic statistics around our data. We'll then move on to create some simple visualizations of our data to help us identify trends and patterns.

Note that as this is a hands-on pre-con, participants will be required to bring a laptop with a working Python installation. Full details on this will be provided prior to the session.

SessionID: 94750

Common SQL Server Mistakes and How to Correct Them

Back to calendar

Event Date: 03-08-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Common SQL Server Mistakes and How to Correct Them

Abstract:

Making mistakes is natural, but learning from them and avoiding them in the future takes effort. There’s no substitute for experience or the shared wisdom of others to help you learn what mistakes to avoid and how to correct them. In this full-day workshop, Tim will share with you a ton of what he’s learned over the years from working and consulting at multiple Fortune-level companies. You’ll hear about real-world environments he has worked on where there was a high impact from administrators making mistakes in how SQL Server was configured and administered. We will cover key topics such as backups, recovering from disasters, database maintenance, consistency checks, security reviews, installation best practices, and monitoring and troubleshooting performance issues. By the end of the day you’ll be comfortable with your ability to support SQL Server because you will know what you need to do and have a checklist of items to take home to make sure your SQL Server is configured properly.

SessionID: 90884

SQL Graph Revealed

Back to calendar

Event Date: 03-08-2019 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Mala Mahadevan

Title: SQL Graph Revealed

Abstract:

‘Graph data’ is normally used to describe data that is highly interconnected. Transportation routes, social media friends or connections, organizational charts, genealogical charts, product and customer data…the scenarios where you can find them are endless. The most common way graph data is modeled in the relational world is by using many-many-relationships..querying such structures can be very painful and expensive in terms of time and computing power. There are dedicated graph databases that do this..such as Neo4j..but what if most of your data is in a relational engine already? What if you want to keep the gains of a relational engine such as security, ACID properties and high availability and still do some graph modeling? SQL Server 2016+ supports graph data modeling as well. In this talk on SQL Graph Revealed we will learn about origins of graph theory, components of graph data, and advantages of modeling relationships using graph capabilities of SQL Server.

SessionID: 90918

Introduction to Linux for SQL Server Professionals

Back to calendar

Event Date: 03-08-2019 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jay Falck

Title: Introduction to Linux for SQL Server Professionals

Abstract:

SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.

SessionID: 92886

Top 5 Tips to Keep Always On AGs Humming and Users Happy

Back to calendar

Event Date: 03-08-2019 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: Top 5 Tips to Keep Always On AGs Humming and Users Happy

Abstract:

Have you ever wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? Let my experience maintaining several production Always On Availability Groups provide you some battle-tested information and hopefully save you some sleepless nights. From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy and the DBA’s phone quiet.

SessionID: 93656

Become a T-SQL Pivoting Ninja in 60 Minutes Or Less

Back to calendar

Event Date: 03-08-2019 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Peter Doyle

Title: Become a T-SQL Pivoting Ninja in 60 Minutes Or Less

Abstract:

Stop wasting time using Excel Pivot Tables. Create Pivot Tables in SQL with ease.

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible

SessionID: 93873

Python in SQL Server 2017 and 2019

Back to calendar

Event Date: 03-08-2019 - Session time: 08:15:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: Python in SQL Server 2017 and 2019

Abstract:

SQL Server 2017 and 2019 have arrived, bringing with them a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 96235

Improving Database Code Quality with Unit Tests

Back to calendar

Event Date: 03-08-2019 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Elizabeth Noble

Title: Improving Database Code Quality with Unit Tests

Abstract:

You're a developer or DBA who cares about code quality, but you don't have automated testing for your T-SQL code --- yet. That's about to change!

In this session, you will learn how to unit test your T-SQL code. You will learn how to build unit tests into your own development environment. You'll see demonstrations of how to create and run unit tests to confirm functionality of database objects using test driven design. You'll leave the session with a knowledge of which tools help you create unit tests for SQL Server and a checklist of how to get started writing your first tests.

SessionID: 90911

Performance Tuning, Getting the Biggest Bang for Your Buck

Back to calendar

Event Date: 03-08-2019 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: Performance Tuning, Getting the Biggest Bang for Your Buck

Abstract:

Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.

SessionID: 91168

Launching A Data Science Project: Cleaning Is Half The Battle

Back to calendar

Event Date: 03-08-2019 - Session time: 09:30:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Launching A Data Science Project: Cleaning Is Half The Battle

Abstract:

There's an old adage in software development: Garbage In, Garbage Out. This adage certainly applies to data science projects: if you simply throw raw data at models, you will end up with garbage results. In this session, we will build an understanding of just what it takes to implement a data science project whose results are not garbage. We will use the Microsoft Team Data Science Process as our model for project implementation, learning what each step of the process entails. To motivate this walkthrough, we will see what we can learn from a survey of data professionals' salaries.

SessionID: 91385

Is my SQL Server having Memory Pressure?

Back to calendar

Event Date: 03-08-2019 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Is my SQL Server having Memory Pressure?

Abstract:

As we all know, SQL Server loves memory and will use as much as it can get. However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure. During this session we will explore how SQL Server uses memory and how to properly configure memory settings. We will discuss the use of DMVs and other tools to help us find what is consuming the most memory and some potential solutions.

SessionID: 91755

Transaction Log Internals and Performance

Back to calendar

Event Date: 03-08-2019 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Transaction Log Internals and Performance

Abstract:

The transaction log is one of the most critical, yet often misunderstood, components of SQL Server. From out of control log growth to very long start-up times, problems with the transaction log can cause a lot of pain. In this session, we'll look at how the transaction log works and what information is actually stored in the log. You'll learn how to optimize the log's performance, determining the right settings for log growth, and what to do when things get out of control.

SessionID: 94115

Docker for the SQL Server Developer

Back to calendar

Event Date: 03-08-2019 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Leonard Lobel

Title: Docker for the SQL Server Developer

Abstract:

Containerization with Docker is a hot topic these days, and SQL Server’s ability to run in-side Docker containers on both Windows and Mac has revolutionized the way develop-ers work with Microsoft’s venerable database engine. This dynamic session starts with a quick introduction to Docker and how it utilizes OS virtualization in Windows 10 and Windows Server 2019 to provide isolation across multiple containers running on your machine. Then you’ll see how fast and easy it is to spin up any number of SQL Server in-stances to run in both Windows and Linux containers simultaneously. Get bit by the Docker bug, and you’ll never go through the pain of installing SQL Server on your devel-opment machine ever again!

SessionID: 94412

A Perfect Ten: The Data Model

Back to calendar

Event Date: 03-08-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leslie Andrews

Title: A Perfect Ten: The Data Model

Abstract:

Do you know what makes a great data model? What does it mean to be Third Normal Form or a Star Schema? When would you use one over the other and why? How can you identify bad designs? In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!

SessionID: 91075

Microsoft Azure Modern Data Warehouse

Back to calendar

Event Date: 03-08-2019 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jamey Johnston

Title: Microsoft Azure Modern Data Warehouse

Abstract:

The Microsoft Azure Ecosystem has a rich toolset to build a modern data warehouse using tools like Azure Data Factory v2, Azure Data Lake gen2, Azure SQL DB and Data Warehouse, Azure Analysis Services and Databricks.

This session will give an overview of each of the pieces of this modern data warehouse and demos of how to setup this architecture for you environment.

SessionID: 91311

Secure SQL Server Database Design: Tactics and Technology

Back to calendar

Event Date: 03-08-2019 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Dan Mallott

Title: Secure SQL Server Database Design: Tactics and Technology

Abstract:

When we design and build an application, do we think about security first or is it an afterthought? As we read about more and more data breaches, it is clear that we need to think security-first when designing and building our applications.

Where does design start for an application? It starts with the database layer. In this talk, we will discuss strategies for designing a more secure SQL Server database. We will start with simple design decisions for tables, views, stored procedures, and database roles that can improve security before moving on to talk about built-in SQL Server security technologies such as Always Encrypted, Row-Level Security, Dynamic Data Masking, Transparent Data Encryption, and SQL Server Audit. Lastly, we will finish up with some tips on how to retrofit security features onto existing databases and look at how data access from the application may need to change.

SessionID: 92210

Data Collection and Usage: Illegal or Unethical?

Back to calendar

Event Date: 03-08-2019 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Angela Tidwell

Title: Data Collection and Usage: Illegal or Unethical?

Abstract:

Data collection and usage is all around us, it is what we do. But is what we do with the data ethical? Are we collecting and processing biased data? We will take a look at ethical data collection and usage, what it means to your models and forecasts, and how being aware of possible biases can impact your bottom line. You might be training on extremely biased data and not know it, skewing your forecasts in the wrong direction.

SessionID: 93024

Building a Machine Learning Regression Model with Zero Code in PowerBI

Back to calendar

Event Date: 03-08-2019 - Session time: 10:45:00 - Track: Analytics and Visualization

Speaker: Greg Deckler

Title: Building a Machine Learning Regression Model with Zero Code in PowerBI

Abstract:

PowerBI recently added support for AutoML (Supervised Automated machine Learning). This session demonstrates the new ML capabilities with an end to end example using Power BI Dataflows. In this session, we will use AutoML to create and apply a regression model. Regression is a machine learning technique used for understanding the relationship between input and output variables. Regression techniques provide additional insight into data, making it easier to see relationships between dependent and independent variables.

SessionID: 94708

Remember Back When? Temporal Tables in SQL Server 2016 and 2017

Back to calendar

Event Date: 03-08-2019 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Brian Hansen

Title: Remember Back When? Temporal Tables in SQL Server 2016 and 2017

Abstract:

SQL Server 2016 and 2017 come with their own version of a Wayback Machine: temporal tables. With this new feature, it is easy to store and query the history of changes to data. We will discuss the fundamentals and creating, storing data in, querying from, and maintaining these tables. We will also take a quick look under the hood to see how they work. And yes, this is a version 1 (and 2) product, so we'll also consider the current limitations that are in place. Find out how temporal tables can benefit your system!

SessionID: 96411

How Fast Can You Restore Your Database?

Back to calendar

Event Date: 03-08-2019 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: How Fast Can You Restore Your Database?

Abstract:

Availability Groups and Clustering are great but they only protect you against hardware failures. DBA's still need to rely on backups to set up AGs, initialize replication, recover from data corruption and more. Join us to discuss how you can restore your database in minutes and not hours.

SessionID: 91000

Performance Tuning for SQL Developer through Execution Plans

Back to calendar

Event Date: 03-08-2019 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Performance Tuning for SQL Developer through Execution Plans

Abstract:

Performance Tuning for SQL Developer session aims to provide essential building blocks to get starting with this challenging subject. When it comes to performance tuning the execution plan needs to be the first stop for every developer however many developers don’t know how to read and extract relevant information. When looking at execution plans in SSMS, there are many different ways of getting relevant information however it is not always simple to understand. The goal of this presentation is to provide tools and high-level overview of pertinent information to enable each developer to start optimizing their code.

SessionID: 91259

Practical Power BI Report Design Tips for the Non-Artist

Back to calendar

Event Date: 03-08-2019 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Meagan Longoria

Title: Practical Power BI Report Design Tips for the Non-Artist

Abstract:

You don't have to be super artistic to make professional looking Power BI reports. We'll walk through several design concepts borrowed from web design and cognitive psychology and then apply them to a Power BI report. You'll learn practical steps to enhance your reports that you can do today, even if you don't consider yourself artistic.

SessionID: 93699

User Experience Brilliance in Power BI Dashboards

Back to calendar

Event Date: 03-08-2019 - Session time: 13:15:00 - Track: Professional Development

Speaker: Hilary Wilkie

Title: User Experience Brilliance in Power BI Dashboards

Abstract:

User Experience (UX) and Design Thinking are common buzz words around the office. What do these words have to do with BI and Dashboards, anyway?

Sure, Power BI itself is intuitive and user friendly, but are YOU building dashboards that give the best user experience? In this session we will explore in a hands-on exercise what UX and Design thinking is, how to apply the methodologies to our daily work and then how we could apply it to BI to make kick ass dashboards and reporting for our internal and external customers.

SessionID: 93857

PowerShell for the DBA

Back to calendar

Event Date: 03-08-2019 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

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

The function of Windowing Functions

Back to calendar

Event Date: 03-08-2019 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Kevin Wilkie

Title: The function of Windowing Functions

Abstract:

What is a windowing function?

What do I do with them? Are they actually useful?

By the end of the class, you'll be asking yourself -

Why haven't I used these before? How can I use them more often?

Learn more about the class of functions that are known as "windowing functions" and why you should get to know them more!

SessionID: 94710

Modernize Data Platform - A Detailed Case Study

Back to calendar

Event Date: 03-08-2019 - Session time: 13:15:00 - Track: Strategy and Architecture

Speaker: Sriharsh Adari

Title: Modernize Data Platform - A Detailed Case Study

Abstract:

Microsoft Azure is becoming one of the most popular public cloud platforms available, and its popularity is only continuing to grow. To date, more than 85pc of Fortune 500 companies are on the Microsoft cloud. In this session, we will use a case study approach to understand key considerations and Implementation approach to migrate on-premise Database platforms and set up a Modern Data Platform on Azure and deep dive into using the Azure Database Migration Service and related tools. We also cover most commonly seen migration challenges and demonstrate how we can unblock them using Azure Tools and Technologies.

SessionID: 90908

Inside the Database Engine

Back to calendar

Event Date: 03-08-2019 - Session time: 14:30:00 - Track: Application Database Development

Speaker: John Deardurff

Title: Inside the Database Engine

Abstract:

This session is for the absolute beginner to learn the basic components of the Database Engine (Relational Engine, Storage Engine, and SQLOS) and what is the purpose of each of these three components in the execution of a simple query. The relational engine to process a query, the storage engine to access data and the SQLOS to manage resource access. The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.

SessionID: 90957

Moving Data to the Cloud (with Azure Data Factory)

Back to calendar

Event Date: 03-08-2019 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Simon Kingaby

Title: Moving Data to the Cloud (with Azure Data Factory)

Abstract:

You need to move data. A lot of data. To the cloud. You’ve got data in a variety of on- and off-site data sources. There are several ways to do it. Some of them can be quite easily implemented using Azure Data Factory. Learn how to use variables and looping in your Data Factory pipelines. Use the Integration Runtime to pull directly from on-site sources. See how to upload files to blob storage and import them. Learn how to trigger Data Factory activities. And, learn how to keep all those connection strings and passwords secret in Azure Vault. After this session, you will have tools that you can readily implement in your own data migrations.

SessionID: 91590

Cosmos DB was the missing piece to my Data puzzle!

Back to calendar

Event Date: 03-08-2019 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Hasan Savran

Title: Cosmos DB was the missing piece to my Data puzzle!

Abstract:

Cosmos DB is one of the fastest growing Azure Services, we all have questions about this new database system. In this session, I am going to answer some of the common questions about Azure Cosmos DB by using SQL API.

Join me to see Cosmos DB in action with many demos! Don't miss it.

SessionID: 92445

Using FileTables

Back to calendar

Event Date: 03-08-2019 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Sam Nasr

Title: Using FileTables

Abstract:

The FileStream feature allows BLOBs to be managed by the DB. FileTable expands on this feature by using specific tables for storing these BLOBs. This allows Windows apps to access these items as if there were stored on the file system but with benefits only a database can offer, such as text searching and querying.

SessionID: 93357

Introduction To Data Governance

Back to calendar

Event Date: 03-08-2019 - Session time: 14:30:00 - Track: Other

Speaker: Warren Sifre

Title: Introduction To Data Governance

Abstract:

Data Governance has been seen by many as a very SCARY and BIG thing requiring biblical efforts to understand and more so to implement. Our discussion will provide context for what, why, and how of Data Governance. You will have an understanding of this and more importantly a road map for how to begin to implement and evangelize within the organization.

SessionID: 94660

Revenge: The SQL!

Back to calendar

Event Date: 03-08-2019 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL! This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * in ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge! Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 94751

Azure for the Production Data Professional

Back to calendar

Event Date: 03-08-2019 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Azure for the Production Data Professional

Abstract:

Microsoft Azure is an open, flexible, scalable, enterprise-grade cloud computing platform. This full day class will teach you why migrating to SQL Server running in Azure is secure, reliable, easy, as well as how to do it.

The Azure platform is vast with many services to choose from. You will get a high level overview of the various services with a focus on SQL Server running in Azure Infrastructure as a Service (Iaas) and Azure SQL Database as a Platform as a Service (PaaS).

You will see how easy it is to build a virtual machine in Azure running SQL Server and how to migrate your data. You will gain insight into licensing, security, pricing, and networking.

You will learn all about Azure SQL Database, its features and limitations for Singleton and Elastic databases as well as Managed Instances.

If you are interested in learning about Azure for your SQL Server environment, this session is for you.

SessionID: 90932

Using Open Source Products to Collect Performance Metrics

Back to calendar

Event Date: 03-08-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Using Open Source Products to Collect Performance Metrics

Abstract:

Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

In this session, we will discuss sp_whoisactive and Query Store. Then we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we’ll put it all together in an interactive dashboard for easy visualization.

Attendees will see how easy it is to get good performance data and visualize in an interactive way and combine with other tools to troubleshoot issue

SessionID: 91011

Applying Data Warehousing Principles

Back to calendar

Event Date: 03-08-2019 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Spencer Swindell

Title: Applying Data Warehousing Principles

Abstract:

Many data analysts typically begin to work with data as a single flat table. While this works for small datasets, as the size of the data grows these naive methods do not scale. Processing records takes longer, queries become more complex, and introducing new datasets is inconsistent at best. In order to solve these problems, we must take into account the underlying architecture of our data and how it should be modeled. During this talk we will discuss key concepts, patterns, and techniques for designing a data model that is simple to query, scales with your data, and is extendable to new datasets.

SessionID: 91345

Introduction to GitHub

Back to calendar

Event Date: 03-08-2019 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Joshua Higginbotham

Title: Introduction to GitHub

Abstract:

Getting started with GitHub can at times be overwhelming. Especially when you've been working with other source control and project management systems your whole career. In this session, we will overview the below tasks to ensure your success with GitHub.

• Initial setup of a Repository in GitHub.
• Build Issue templates for new features, bugs, or custom tasks.
• Securing the check-in/merge process to your root branch.
• Integrating GitHub with other productivity tools to keep on top of changes.

SessionID: 93318

10 reasons you are paying too much (or too little) on your SQL licenses

Back to calendar

Event Date: 03-08-2019 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Dustin Dorsey

Title: 10 reasons you are paying too much (or too little) on your SQL licenses

Abstract:

If you are running SQL server in your production environment, then you know that licensing is not cheap. Not only is it expensive, but SQL licensing can be confusing, changes often, and can be hard to navigate even for the most seasoned professionals. This session will dive into 10 reasons your company may be overpaying (or underpaying) on your licenses and provide you with practical steps you can do to discover and fix those issues. As a bonus, I will also be sharing a free calculator script that I created that takes into account several things shared in this presentation (and more) that you can begin using immediately to help with your licensing decisions.

This session is intended for anyone who is responsible for managing, allocating or advising on SQL licensing.

SessionID: 94386

Infrastructure for the DBA: An Introduction

Back to calendar

Event Date: 03-08-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: Infrastructure for the DBA: An Introduction

Abstract:

It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.

SessionID: 94738

Intro to SQL Spatial Data: Location Analytics

Back to calendar

Event Date: 03-08-2019 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Lucas Feiock

Title: Intro to SQL Spatial Data: Location Analytics

Abstract:

In this session we will cover Spatial Data Types available in SQL Server. Then we will review the basics of spatial queries and the different methods to create points, lines, and polygons. Finally we will demo a few examples of location analytics and how to integrate into other data sets.

This site is open source. Improve this page.