sqlsathistory

Nr: 815

Back to Main list

SQLSaturday #815 - Nashville 2019

Start Time (24h)	Speaker	Track	Title
08:30:00	Kellyn Pot'Vin-Gorman	BI Architecture Management	Taming of the Shrew - Optimizing Power BI
08:30:00	Adam McDonald	Database Application Development	Data Analysis With SQL Window Functions
08:30:00	Ameena Lalani	Database Administration	Learn History from Temporal Tables
08:30:00	Leonard Lobel	Database Application Development	Modern SQL Server Security Features for Developers
08:30:00	Rick Lowe	Database Application Development	Weird Stuff I Saw While ... Working With Heaps
08:30:00	Anthony Nocentino	Cloud Database/Application Development Deployment	Containers - You Better Get on Board!
08:30:00	Kevin Wilkie	Cloud Database/Application Development Deployment	Azure Data Factory V2
08:30:00	Eric Peterson	Database Administration	Very Large Databases in your future
08:30:00	Chris Hyde	BI Analytics and Visualization	Python in SQL Server 2017
08:30:00	Jon Boulineau	BI Architecture Management	SQL Server 2019 Big Data Clusters
08:30:00	SQLSaturday Nashville	Other	On-Site Registration non-printed SPEEDPASS
09:45:00	Kevin Feasel	BI Architecture Management	Cleaning Is Half The Battle: Launching A Data Science Project
09:45:00	Hasan Savran	Database Application Development	Reasons to upgade to SQL Server 2017
09:45:00	Kevin Kline	Database Application Development	Query Tuning Internals for the Advanced SQL Developer
09:45:00	Lowry Kozlowski	Database Administration	SQL Server Take Over:  Establishing a Baseline
09:45:00	Lucas Feiock	Cloud Database/Application Development Deployment	Lambda architecture design using Azure Databricks for advanced analytics
09:45:00	Don McMunn	Cloud Database/Application Development Deployment	Integrating Hadoop data into Azure SQL Server PaaS - Lessons Learned
09:45:00	Elizabeth Noble	Database Administration	Using distributed AGs for your migrations
09:45:00	Gareth Swanepoel	BI Architecture Management	SQL Server ColumnStore Indexes
09:45:00	Bradley Ball	Database Administration	SQL Internals , Recovery Models, Backups! OH MY
09:45:00	Dave Mattingly	Professional Development	Achievement Unlocked: How to Get Promoted
11:00:00	David Maxwell	Database Application Development	Using Extended Events for Wait Stats Analysis
11:00:00	Monica Rathbun	Database Administration	How to Get SQL Server to Run Better on Crappy Hardware.
11:00:00	Angela Henry	Database Application Development	Profiling Your Data
11:00:00	Spencer Swindell	BI Architecture Management	Applying Data Warehousing Principles
11:00:00	Anthony Nocentino	Cloud Database/Application Development Deployment	Inside Kubernetes - An Architectural Deep Dive
11:00:00	Dustin Dorsey	Database Administration	Cracking the Code: Understanding and making good decisions on SQL Server licensing
11:00:00	Peter Shore	Professional Development	Continuous Learning for the Modern Age
11:00:00	John Deardurff	Database Administration	A Beginners Guide to Transactions
11:00:00	Eddy Djaja	Database Administration	What Is Clogging Your Database Performance?
11:00:00	Pat Phelan	PowerShell	PowerShell for the Reluctant Administrator
12:20:00	franklin yamamoto	Database Administration	Performance tuning with SQLGrease
12:20:00	Gilda Alvarez	Professional Development	Women in IT. A survival guide.
12:20:00	Kerry Tyler	Cloud Database/Application Development Deployment	The Evolving Role of the Data Professional
12:20:00	Andy Puckett	Other	Rubrik - Simplifying SQL Server Data Protection
12:20:00	Bryan Walsh	Other	#GetModern with Dell EMC
12:20:00	Tyler Graham	Cloud Database/Application Development Deployment	Master Data Services: A Path to the Cloud with Profisee
13:30:00	Carlos L Chacon	Cloud Database/Application Development Deployment	A walk in the Azure cloud
13:30:00	Brian Kelley	Database Administration	How I Would Attack SQL Server
13:30:00	Jonathan Stewart	BI Analytics and Visualization	Data Visualization: How to truly tell a great story!
13:30:00	Eric Blinn	Database Administration	I have Indexes, but do I have the Right Indexes?
13:30:00	Marsha Pierce	Database Administration	Mom Rules for Managing Enterprise Database Environments
13:30:00	Amy Herold	PowerShell	PowerShell for the DBA
13:30:00	Angela Tidwell	BI Architecture Management	Data Collection and Usage: Illegal or Unethical?
13:30:00	Louis Davidson	Database Application Development	Characteristics of a Great Relational Database
13:30:00	Hope Foley	Database Application Development	Throw a Brick at Your Data: Intro to Azure Databricks
13:30:00	Josh Luedeman	Cloud Database/Application Development Deployment	What's New with Azure Data Factory
14:50:00	Matt Gordon	Database Administration	High Availability and Azure - Scaling SQL Server to the Cloud
14:50:00	Rie Irish	Database Application Development	Is My Application Bias Showing?
14:50:00	Gilda Alvarez	Database Administration	Migrations 101
14:50:00	Christina Wheeler	Cloud Database/Application Development Deployment	Introduction to PowerApps
14:50:00	Daniel Glenn	BI Analytics and Visualization	Gaining insights with Power BI
14:50:00	Jeff Dudenhoeffer	BI Architecture Management	DevOops: Why Aren't We Using DevOps for our BI and Analytics Projects?
14:50:00	Rob Volk	Database Administration	Revenge: The SQL!
14:50:00	Dan Evans	BI Analytics and Visualization	The Modern Power BI approach
14:50:00	Tyler Graham	BI Architecture Management	Master Data Services: BI and Data Science’s Best Friend

SessionID: 86346

Taming of the Shrew - Optimizing Power BI

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: BI Architecture Management

Speaker: Kellyn Pot'Vin-Gorman

Title: Taming of the Shrew - Optimizing Power BI

Abstract:

No one wants to tell a report user that while running a report in Power BI they have time to go get a cup of coffee…in another town. Although data sets will often be the focus of performance issues, it’s important to know how to locate performance problems in Power BI and how to eliminate them.

This session will take the Power User through how to identify time consuming processing in Power BI and how to address it through step-by-step and proven methods used to optimize in multi-tier environments. This method removes frustration and finger-pointing and gets to the heart of the problem with a goal of correcting performance challenges. The results are satisfied end users who get the information they need, when they need it.

Take Aways: Learn how to identify what is taking the time in a Power BI data set and report. Understand the logging and tracing mechanisms and capabilities in the environment. Understand when a problem is really a problem.

SessionID: 86360

Data Analysis With SQL Window Functions

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: Database Application Development

Speaker: Adam McDonald

Title: Data Analysis With SQL Window Functions

Abstract:

SQL Window Functions provide a great way to aggregate and analyze data very efficiently. In this session we'll go over what functions are available and look at many examples of how to use them. When you leave you'll be familiar with the concept and will be able to recognize situations where they can be extremely useful.

SessionID: 86566

Learn History from Temporal Tables

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: Database Administration

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 and without needing any triggers. 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: 86570

Modern SQL Server Security Features for Developers

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: Database Application Development

Speaker: Leonard Lobel

Title: Modern SQL Server Security Features for Developers

Abstract:

In SQL Server and Azure SQL Database, the relational engine has been greatly enhanced for security with three new features that you’ll learn about in this demo-packed session. With dynamic data masking (DDM), you can fully or partially conceal sensitive columns from query results. Masking does not modify data on in the table, it simply hides data from users that don’t have permission to see it. Row-level security (RLS) also hides data from unauthorized users, but at the row level. With RLS, you can create your own security policy to control which users can read or write specific rows in the table. Finally, Always Encrypted (AE) uses client-side encryption to ensure that data is encrypted in flight, not just at rest. Furthermore, the encryption keys are accessible only to the client. This guarantees that data cannot be decrypted on the server, easing the migration path to the cloud for users with highly sensitive data.

SessionID: 86731

Weird Stuff I Saw While ... Working With Heaps

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: Database Application Development

Speaker: Rick Lowe

Title: Weird Stuff I Saw While ... Working With Heaps

Abstract:

We've all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for worloads that are mostly insert? Are they always recommended for ETL (Extract, Transform, Load) operations? Does it help to create non-clustered indexes on top of heaps? For this installment of Rick's "Weird Stuff" series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.

SessionID: 86802

Containers - You Better Get on Board!

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: Cloud Database/Application Development Deployment

Speaker: Anthony Nocentino

Title: Containers - You Better Get on Board!

Abstract:

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get you started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

In this session we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes

SessionID: 86911

Azure Data Factory V2

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: Cloud Database/Application Development Deployment

Speaker: Kevin Wilkie

Title: Azure Data Factory V2

Abstract:

Moving data around in On-Prem databases is easy.

Moving data around when involving Azure - may be not. Especially if you don't have a VM or an On-Prem server to move things around on.

We'll look at moving data around from On-Prem to Azure, moving files to Azure, and moving data between Azure databases.

SessionID: 87128

Very Large Databases in your future

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: Database Administration

Speaker: Eric Peterson

Title: Very Large Databases in your future

Abstract:

Your databases may not be terabyte-sized yet, but they're probably growing every day. We'll look at lessons learned

from working with multi-terabyte, very large databases (VLDBs) in the real world. Topics include storage layout decisions, unique tuning challenges, HA/DR implications, and database restores, along with shoehorning backups, re- indexing and DBCC checks into itty-bitty maintenance windows. As a bonus, many of the techniques also apply to smaller databases and consolidated servers that run hundreds of databases.

SessionID: 87152

Python in SQL Server 2017

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: BI Analytics and Visualization

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 has finally arrived, bringing with it 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: 87233

SQL Server 2019 Big Data Clusters

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: BI Architecture Management

Speaker: Jon Boulineau

Title: SQL Server 2019 Big Data Clusters

Abstract:

One of the most significant announcements in SQL Server history came in September 2018; the addition of SQL Server Big Data Clusters to the 2019 release. Combining big data tools such as HDFS and Spark with SQL Server into a single platform has tremendous potential. The change to platform architecture and administration, however, is extensive. In this session we we review the capabilities enabled by Big Data Clusters and become familiar with some necessary technologies that may be new to many, such as Kubernetes. Most of the time will be spent in demos of how the platform works.

SessionID: 87936

On-Site Registration non-printed SPEEDPASS

Back to calendar

Event Date: 12-01-2019 - Session time: 08:30:00 - Track: Other

Speaker: SQLSaturday Nashville

Title: On-Site Registration non-printed SPEEDPASS

Abstract:

If you didn't print your speedpass you may stop in here to get one printed. If you didn't register you can also register in here. If you had issues printing/paying for lunch or any other questions you may stop by.

SessionID: 86542

Cleaning Is Half The Battle: Launching A Data Science Project

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: BI Architecture Management

Speaker: Kevin Feasel

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

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

Reasons to upgade to SQL Server 2017

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: Database Application Development

Speaker: Hasan Savran

Title: Reasons to upgade to SQL Server 2017

Abstract:

You just upgraded your database to SQL Server 2017 recently or you are planning to upgrade your database to SQL Server 2017 soon and you want to learn more about its features and services.

Join me to learn about SQL Server 2017 with many demos and tips.I will cover the following services/features :

Linux Support Graph Tables Intelligent Query Processing Resumable Online Index Rebuild How to run R/Python with Machine Learning Services In-Memory Tables (NoSQL in SQL Server)

SessionID: 87015

Query Tuning Internals for the Advanced SQL Developer

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: Database Application Development

Speaker: Kevin Kline

Title: Query Tuning Internals for the Advanced SQL Developer

Abstract:

Skilled SQL developers know that the SQL Server Query Optimizer uses a multi-step process to produce execution plans. But what about deeper components like the parser, the binder, the algebrizer, as well as the optimizer itself? This session will teach you advanced techniques for query tuning as well as surprising behaviors of the query optimization process that can have a dramatic impact on performance, with special attention paid to the transformations applied by the algebrizer, including associative, commutative, and transitive transforms. We will examine a variety of everyday queries whose performance can be greatly improved by applying a deeper understanding of these internal behaviors. Lots of examples and demos!

SessionID: 87041

SQL Server Take Over:  Establishing a Baseline

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: Database Administration

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

Lambda architecture design using Azure Databricks for advanced analytics

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: Cloud Database/Application Development Deployment

Speaker: Lucas Feiock

Title: Lambda architecture design using Azure Databricks for advanced analytics

Abstract:

In this session, we will review the history of Azure Databricks, world records it broke, and how to accelerate your data platform solutions. We will cover lambda architecture, Azure Databricks components, and how to integrate other Microsoft Azure services. Then we will see a demonstration on creating clusters, notebooks, team collaboration, and advanced analytics. Finally, we will take a look at additional information on how to further utilize Azure Databricks.

SessionID: 87166

Integrating Hadoop data into Azure SQL Server PaaS - Lessons Learned

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: Cloud Database/Application Development Deployment

Speaker: Don McMunn

Title: Integrating Hadoop data into Azure SQL Server PaaS - Lessons Learned

Abstract:

Is integrating Hadoop data into an Azure SQL Server PaaS environment for BI reporting on your to-do list? Join us for data architecture lessons learned while migrating Apache Kudu data into an Azure SQL PaaS environment for a client new to the Azure cloud. We will address getting to know your data, the importance of designing an indexing strategy up front, helpful data pre-processing optimizations, ELT vs. ETL, the importance of managing Querystore and statistics purging, a couple of methods for capturing real-time query performance. Helpful links and Azure PaaS metadata queries will be provided.

SessionID: 87173

Using distributed AGs for your migrations

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: Database Administration

Speaker: Elizabeth Noble

Title: Using distributed AGs for your migrations

Abstract:

You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session I will discuss what distributed AGs are, show how to set them up, and show how to monitor distributed AGs.

SessionID: 87519

SQL Server ColumnStore Indexes

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: BI Architecture Management

Speaker: Gareth Swanepoel

Title: SQL Server ColumnStore Indexes

Abstract:

Come and learn how the SQL Server feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, dos and don'ts, restrictions, and more. I will also have some insight into how CSI's have been updated in SQL Server 2014 beyond.

If you are a production DBA who needs to find out more about some of the additional hot features that have been included with CSI's, like batch mode processing and data segments, then this session is for you. If you are a BI DBA or developer who needs to find out how CSI's can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.

SessionID: 87527

SQL Internals , Recovery Models, Backups! OH MY

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: Database Administration

Speaker: Bradley Ball

Title: SQL Internals , Recovery Models, Backups! OH MY

Abstract:

The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!

SessionID: 87781

Achievement Unlocked: How to Get Promoted

Back to calendar

Event Date: 12-01-2019 - Session time: 09:45:00 - Track: Professional Development

Speaker: Dave Mattingly

Title: Achievement Unlocked: How to Get Promoted

Abstract:

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.

SessionID: 86245

Using Extended Events for Wait Stats Analysis

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: Database Application Development

Speaker: David Maxwell

Title: Using Extended Events for Wait Stats Analysis

Abstract:

When troubleshooting overall server performance, wait statistics are a great place to start. But when your SQL Server hosts a complex set of workloads, it can be difficult to narrow down which queries are causing the most wait, and what types of wait they are causing. Fortunately, SQL Server provides easy ways for targeting which queries are causing you the most wait time. In this session, we’ll learn how to use both Extended Events, and Dynamic Management Views for examining wait statistics from the instance level to the database level, all the way down to the individual query level. We’ll analyze poorly performing queries using a combination of methods including T-SQL queries and SQL 2017’s new XEvent Profiler, and show how to quickly narrow down what SQL Server is waiting for, and why.

SessionID: 86332

How to Get SQL Server to Run Better on Crappy Hardware.

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Monica Rathbun

Title: How to Get SQL Server to Run Better on Crappy Hardware.

Abstract:

Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking. Let’s see how compression, statistics, and indexes bring new life into your existing hardware.

SessionID: 86465

Profiling Your Data

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: Database Application Development

Speaker: Angela Henry

Title: Profiling Your Data

Abstract:

Have you ever started a warehouse or ETL project and realized that the data wasn't as "clean" as you were told? If only you had profiled your data before you started then you wouldn't have to rework design elements, change code or redesign your database. In this session we will talk about what data profiling is, why you should do it and how you can do it with tools that are already included in the SQL Server BI stack.

SessionID: 86613

Applying Data Warehousing Principles

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: BI Architecture Management

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

Inside Kubernetes - An Architectural Deep Dive

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment

Speaker: Anthony Nocentino

Title: Inside Kubernetes - An Architectural Deep Dive

Abstract:

In this session we will introduce Kubernetes, we’ll deep dive into each component and its responsibility in a cluster. We will also look at and demonstrate higher-level abstractions such as Services, Controllers, and Deployments and how they can be used to ensure the desired state of an application and data platform deployed in Kubernetes. Next, we’ll look at Kubernetes networking and intercluster communication patterns. With that foundation, we will then introduce various cluster scenarios such as a single node, single head, and high availability designs. By the end of this session, you will understand what's needed to put your applications and data platform in production in a Kubernetes cluster

Session Objectives: Understand Kubernetes cluster architecture Understand Services, Controllers, and Deployments Designing Production Ready Kubernetes Clusters

SessionID: 87176

Cracking the Code: Understanding and making good decisions on SQL Server licensing

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Dustin Dorsey

Title: Cracking the Code: Understanding and making good decisions on SQL Server licensing

Abstract:

Have you found yourself confused about how SQL Server licensing works or wondered if you have made the right decisions for your organization? This session helps crack the code on this subject and provides you with information on the different options and and how to use these to your benefit. We will also look at things you can do to optimize your environment to make sure you are getting the most from your licenses.

SessionID: 87234

Continuous Learning for the Modern Age

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: Professional Development

Speaker: Peter Shore

Title: Continuous Learning for the Modern Age

Abstract:

You have read this far, great! I already know this session is for you. How do I know? It is exceedingly rare that today’s “9-5” job provides anywhere near what is needed to develop the career you want to have. For the purposes of this session it does not matter if you are a newly minted, “wet behind the ears” data professional or a grizzled veteran. What does matter is that you know that you have a career oriented mindset and a desire to grow beyond what you are today.

This session is designed to help with just that. In addition to talking about a learning plan that fits your needs, we will discuss how to execute that plan, including lab environments, as well as resources to help you execute those plans. If you have reached this point, you simply need to be in this session, see you there.

SessionID: 87657

A Beginners Guide to Transactions

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: John Deardurff

Title: A Beginners Guide to Transactions

Abstract:

This session is for the absolute beginner to learn the basics of Transactions and will answer questions such as, What is a Transaction? What are the ACID properties of a Transaction? How does the Transaction Log work to provide consistency to a database? What is a checkpoint? Are dirty pages bad or good? What is a lock? The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.

SessionID: 87801

What Is Clogging Your Database Performance?

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Eddy Djaja

Title: What Is Clogging Your Database Performance?

Abstract:

A concise and systematic approaches rather than guessing to analyze SQL Server performance will be presented. Through measuring the response time and wait time at the query level, the performance bottleneck is pinpointed and tuned. The presentation will look at the basic of gathering the stats from SQL Server DMVs.

SessionID: 88245

PowerShell for the Reluctant Administrator

Back to calendar

Event Date: 12-01-2019 - Session time: 11:00:00 - Track: PowerShell

Speaker: Pat Phelan

Title: PowerShell for the Reluctant Administrator

Abstract:

You've heard many people claim that PowerShell is fabulous, but you've never really felt the need for it. What's all the fuss? What is PowerShell and why should you even care, much less learn it? How will this new toy make your work easier?

This session will help you understand what PowerShell is, how it integrates into the tools you know and love, and how it can help make your everyday work go faster and more smoothly. Along with the background on PowerShell, you'll see some simple but useful tools and ideas for how you can use those tools and make your own tools too.

This session was designed for the non-PowerShell user and the new PowerShell user. It is intended to help people understand what PowerShell is and start to use PowerShell, and it will touch on advanced ideas but only assumes only basic scripting/coding experience like understanding a variable, a loop, etc.

SessionID: 88236

Performance tuning with SQLGrease

Back to calendar

Event Date: 12-01-2019 - Session time: 12:20:00 - Track: Database Administration

Speaker: franklin yamamoto

Title: Performance tuning with SQLGrease

Abstract:

Performance tuning a production system can be a difficult process when only relying on out of the box tools. This is even more difficult if you aren’t on the most recent release of SQL Server. In this presentation I will show you some common performance problems and how SQLGrease can help tune these. Along the way I will provide details on how SQLGrease collects its data in order to give some clarity on how we monitor as well as provide some useful queries you can use even if you aren’t a SQLGrease user.

SessionID: 88339

Women in IT. A survival guide.

Back to calendar

Event Date: 12-01-2019 - Session time: 12:20:00 - Track: Professional Development

Speaker: Gilda Alvarez

Title: Women in IT. A survival guide.

Abstract:

How to stay relevant if a tsunami of technology changes? what are the tools needed to survive and thrive in an IT career?

SessionID: 88358

The Evolving Role of the Data Professional

Back to calendar

Event Date: 12-01-2019 - Session time: 12:20:00 - Track: Cloud Database/Application Development Deployment

Speaker: Kerry Tyler

Title: The Evolving Role of the Data Professional

Abstract:

TBD

SessionID: 88496

Rubrik - Simplifying SQL Server Data Protection

Back to calendar

Event Date: 12-01-2019 - Session time: 12:20:00 - Track: Other

Speaker: Andy Puckett

Title: Rubrik - Simplifying SQL Server Data Protection

Abstract:

When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn't want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it's not about backing up, it's about going forward!

SessionID: 88581

#GetModern with Dell EMC

Back to calendar

Event Date: 12-01-2019 - Session time: 12:20:00 - Track: Other

Speaker: Bryan Walsh

Title: #GetModern with Dell EMC

Abstract:

Dell EMC’s unique integrated copy data management (iCDM) offering combines performance scalability with reduced operational risk through automation and self-services. Maximize the value of your company’s storage deployment by simplifying MS SQL database application workflows and reducing development timelines. In this session, we will discuss how application admins and DBAs can repurpose different copies SQL Server DBs instantaneously and become more agile.

SessionID: 88683

Master Data Services: A Path to the Cloud with Profisee

Back to calendar

Event Date: 12-01-2019 - Session time: 12:20:00 - Track: Cloud Database/Application Development Deployment

Speaker: Tyler Graham

Title: Master Data Services: A Path to the Cloud with Profisee

Abstract:

Microsoft Master Data Services has been shipping in Enterprise Box for 10 years now. Come learn how you can work with Profisee to bring your Master Data Management to the cloud. We will discuss the challenges or Azure and the benefits that a cloud environment can bring.

SessionID: 86722

A walk in the Azure cloud

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: Cloud Database/Application Development Deployment

Speaker: Carlos L Chacon

Title: A walk in the Azure cloud

Abstract:

The Microsoft Azure offering now has several compelling features that are helpful to the business and to the data professional. This session highlights the landscape and provides an introduction to the landscape with an emphasis on SQL Server offerings. At the end of the session, the attendee will have some additional vocabulary they can use as they discuss Azure with others or they go looking for additional details.

SessionID: 86829

How I Would Attack SQL Server

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: Database Administration

Speaker: Brian Kelley

Title: How I Would Attack SQL Server

Abstract:

This isn’t a talk about best practices or how to configure your system. It’s designed to get into the mindset of a motivated, equipped adversary who wants to get in to a system or application, specifically SQL Server, and uses the full extent of his or her creativity to do so. We’ll look at both traditional and non-traditional weak points, how an attacker discovers them, exploits them, and then covers up his or her tracks. We’ll also discuss what we can do to compensate for a weakness we can’t fix, which revolves mostly around detection and response and how an attacker will respond to such countermeasures.

SessionID: 86913

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: BI Analytics and Visualization

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 87147

I have Indexes, but do I have the Right Indexes?

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: Database Administration

Speaker: Eric Blinn

Title: I have Indexes, but do I have the Right Indexes?

Abstract:

SQL Server indexes come in multiple types: clustered, non-clustered, full text and column store. In this session, you’ll get an understanding of what these types are and when each is an appropriate solution. We will explain and demonstrate each type, and you’ll leave this class with a repeatable indexing methodology you can use to improve your database performance.

SessionID: 87169

Mom Rules for Managing Enterprise Database Environments

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: Database Administration

Speaker: Marsha Pierce

Title: Mom Rules for Managing Enterprise Database Environments

Abstract:

Have you ever looked at an environment and wondered how the heck they ever got anything done because it is so disorganized? The first thing I do for newly inherited environments is implement some organization and do some database clean up. Not only does organization make the environment easier to maintain, it can help speed up trouble shooting. Good organization can even help with some performance issues.

SessionID: 87174

PowerShell for the DBA

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: PowerShell

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

Data Collection and Usage: Illegal or Unethical?

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: BI Architecture Management

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

Characteristics of a Great Relational Database

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: Database Application Development

Speaker: Louis Davidson

Title: Characteristics of a Great Relational Database

Abstract:

When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad relational database design (whether they know what the term "normalized" means or not.) Normalization is a key to great relational designs, but there is so much more to be considered. A normalized database that suffers from poor naming, too many or too few indexes, terrible interfaces, and so on can derail your design's value to the user. In this session I will present primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be discussed.

SessionID: 87243

Throw a Brick at Your Data: Intro to Azure Databricks

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: Database Application Development

Speaker: Hope Foley

Title: Throw a Brick at Your Data: Intro to Azure Databricks

Abstract:

There's a new kid on the block in big data in Azure and they are very popular. In this session we'll weed through the hype and take a real look at it. We'll dive into it from the perspective of someone brand new to Databricks, big data, and data science. We'll focus on how you can use it with the skills you have today.

SessionID: 88404

What's New with Azure Data Factory

Back to calendar

Event Date: 12-01-2019 - Session time: 13:30:00 - Track: Cloud Database/Application Development Deployment

Speaker: Josh Luedeman

Title: What's New with Azure Data Factory

Abstract:

Azure Data Factory version 2 was launched into public beta at the end of 2017. It takes the best features of version 1 and adds new features like time execution triggers, Azure Data Lake activities and the ability to execute SSIS packages in Azure Data Factory. In this session we'll do a walk-through of how the product has evolved, and help you understand the full feature set available in version 2. You'll also understand how to lift and shift your SSIS packages to Azure Data Factory.

SessionID: 86150

High Availability and Azure - Scaling SQL Server to the Cloud

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: Database Administration

Speaker: Matt Gordon

Title: High Availability and Azure - Scaling SQL Server to the Cloud

Abstract:

Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database, and how those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss real world case studies covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.

SessionID: 86327

Is My Application Bias Showing?

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: Database Application 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: 86387

Migrations 101

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: Database Administration

Speaker: Gilda Alvarez

Title: Migrations 101

Abstract:

The only constant thing is change. As companies continue to migrate to newer versions or different data centers, we need to develop strategies and tools to make sure we can perform successful migrations. What if we had a checklist? Just like moving to a new home the success of the "move" relies on the preparation. This presentation will go over a checklist of steps needed to prepare for a database migration.

SessionID: 86577

Introduction to PowerApps

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: Cloud Database/Application Development Deployment

Speaker: Christina Wheeler

Title: Introduction to PowerApps

Abstract:

PowerApps is an O365 service that lets you build business apps that can run in the browser, tablet, or phone. To build PowerApps, no coding experience is required since PowerApps combines visual drag-and-drop concepts with Excel-like expressions for building the logic and working with data. You can build PowerApps against a modern SharePoint list or other types of data such as SQL and Excel. PowerApps also provides templates and sample data you can use to quickly build an app that you can customize to better suit your needs. In this session, you will learn the basics to building a PowerApp using PowerApps Studio.

SessionID: 87040

Gaining insights with Power BI

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: BI Analytics and Visualization

Speaker: Daniel Glenn

Title: Gaining insights with Power BI

Abstract:

Power BI is a powerful self-service analysis tool and is being adopted by organizations across the globe to quickly gain meaningful business insights.

This session will cover the basics on creating compelling dashboards and guide you through the process of managing your company’s Power BI service, Power BI desktop, and mobile apps.

SessionID: 87165

DevOops: Why Aren't We Using DevOps for our BI and Analytics Projects?

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: BI Architecture Management

Speaker: Jeff Dudenhoeffer

Title: DevOops: Why Aren't We Using DevOps for our BI and Analytics Projects?

Abstract:

DevOps is one of those buzzwords that can scare people or make them roll their eyes. What does it even mean? Although the term is commonly discussed in the context of software development, the DevOps philosophy can significantly enhance BI and Analytics solutions. Come learn about ways in which you can apply DevOps principles to your BI projects through real enterprise examples and improve speed of deployments, communication among team members, and much more!

SessionID: 87290

Revenge: The SQL!

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: Database Administration

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

The Modern Power BI approach

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: BI Analytics and Visualization

Speaker: Dan Evans

Title: The Modern Power BI approach

Abstract:

Power BI continues to become one of the best ways to report and analyze business data. With recent announcements in Power BI roadmap around Dataflows, Composite models, AI integration, Common Data Service and Power Suite integration there are many more ways to add value to your existing Power BI environment. Come learn about all the key new features in Power BI you should be using and what new features are coming down the roadmap so you can increase value and usage of Power BI across the organization.

SessionID: 88682

Master Data Services: BI and Data Science’s Best Friend

Back to calendar

Event Date: 12-01-2019 - Session time: 14:50:00 - Track: BI Architecture Management

Speaker: Tyler Graham

Title: Master Data Services: BI and Data Science’s Best Friend

Abstract:

No matter the complexity of your BI application, Master Data Services can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how to unlock value MDS can bring to your analytical organization.

This site is open source. Improve this page.