sqlsathistory

Nr: 888

SQLSaturday #888 - Sioux Falls 2019

Start Time (24h)	Speaker	Track	Title
09:00:00	Martin Schoombee	PreCon1	Power BI Development Best Practices (Deep Dive)
09:00:00	Ryan Swanstrom	PreCon2	Doing Data Science on Azure (and the Certifications)
09:00:00	Dave Bland	PreCon3	Using SQL Server tools to Find Performance Bottlenecks
08:00:00	Justin Mannhardt	Analytics and Visualization	Playing with (M)agic: an introduction to writing M code in Power BI
08:00:00	CJ Knapp	Professional Development	Introduction to Business Intelligence
08:00:00	Thomas Grohser	Application Database Development	42 TSQL Functions
08:00:00	Dave Bland	Enterprise Database Administration Deployment	How to use Execution Plans to find Performance Issues
08:00:00	Martin Schoombee	BI Platform Architecture, Development Administration	The 10 Commandments of ETL
09:25:00	Bill Fellows	BI Information Delivery	Real Time Monitoring with Power BI
09:25:00	Adam Hafner	Application Database Development	Unit Testing - How to Make Friends and Influence Databases
09:25:00	Mohammad Darab	Enterprise Database Administration Deployment	Big Data Clusters for the Absolute Beginner
09:25:00	John Byrnes	Advanced Analysis Techniques	Data Science with SQL Server 2017
10:50:00	Rick Lowe	Enterprise Database Administration Deployment	Why should I care about ... the plan cache?
10:50:00	Brian Larson	Analytics and Visualization	Hyper-Interactivity in Power BI
10:50:00	Kevin Trojanowski	Application Database Development	SQL Unit Testing with T-SQLt
10:50:00	Brian Hansen	Enterprise Database Administration Deployment	Real-World PowerShell for SQL Administration
13:15:00	Leslie Weed	Application Database Development	Innovative Data Modeling: Make Data Warehousing Cool Again
13:15:00	Jason Brimhall	Enterprise Database Administration Deployment	Extended Events - Better than Profiler
13:15:00	Martin Schoombee	BI Information Delivery	Advanced Power BI Modeling Techniques
13:15:00	Shawn Meyers	Enterprise Database Administration Deployment	HA in an about an Hour
14:40:00	Matthew Sharkey	Application Database Development	Building Web-Apps with R and SQL Server
14:40:00	Marcus Hopfinger	Enterprise Database Administration Deployment	Are you getting the most out of SQL Agent?
14:40:00	Preston VanderPlaats	Enterprise Database Administration Deployment	"Why is My Drive Full?" Understanding SQL Backups - Even if you are not responsible for Backups
14:40:00	Ryan Swanstrom	Professional Development	What are these new Microsoft Data Certifications?
16:05:00	Leveat Ruse	Professional Development	Resume Tips-Go Beyond the Print Out
16:05:00	Adam Koehler	Enterprise Database Administration Deployment	XML? What’s this doing in my database?
16:05:00	Kevin Mackey	Application Database Development	Don't just code it—Generate It
16:05:00	Ankit Baria	BI Platform Architecture, Development Administration	Hidden Power: Service Broker

SessionID: 95401

Power BI Development Best Practices (Deep Dive)

Back to calendar

Event Date: 10-08-2019 - Session time: 09:00:00 - Track: PreCon1

Speaker: Martin Schoombee

Title: Power BI Development Best Practices (Deep Dive)

Abstract:

Are you a developer or analyst, creating Power BI reports that will be shared across teams or even your entire organization? Moving from "quick and dirty" deployments to production ready solutions intended for larger audiences means that you should already be thinking about performance, standardization and (most importantly) your end users. Bring your laptop to follow along as well!

In this pre-con we will take a deep dive into the considerations and best practices when developing Power BI models, reports and dashboards to help you bridge the gap and make your solutions enterprise ready. Some of the topics we will cover are: · Power BI Desktop Configuration · Connection Reuse · Entity/Table Design · Cross Filters · Date Entities · Aggregates Measures Prerequisites Beginner or intermediate Power BI development experience is required

SessionID: 95402

Doing Data Science on Azure (and the Certifications)

Back to calendar

Event Date: 10-08-2019 - Session time: 09:00:00 - Track: PreCon2

Speaker: Ryan Swanstrom

Title: Doing Data Science on Azure (and the Certifications)

Abstract:

Companies everywhere are racing to implement AI and data science (a $169 billion industry by 2025). At the same time, companies are making a huge push toward the cloud. Microsoft Azure is leading the way in cloud data science. That is why, in early 2019, Microsoft released new certifications aimed at that skillset. This full day training will leave you knowledgeable about the data science and AI offerings on Azure. Plus, it will leave you prepared to apply data science techniques to your own projects. Finally,it will give you a jump start on preparing for the Azure Data Scientist Associate Exam.

Things to bring with you (besides a smile) • A Microsoft account (Hotmail, live.com, outlook.com), a free account will suffice • A laptop • Some previous experience with programming or scripting (Any necessary math or machine learning background will be covered)

SessionID: 95403

Using SQL Server tools to Find Performance Bottlenecks

Back to calendar

Event Date: 10-08-2019 - Session time: 09:00:00 - Track: PreCon3

Speaker: Dave Bland

Title: Using SQL Server tools to Find Performance Bottlenecks

Abstract:

Performance is always at the top of every DBA’s list of things to do. There are many tools that are available that are native to SQL Server. This session will cover how to use Extended Events, DMVs, Execution Plans and QueryStore to find performance bottlenecks.

Topics to be covered, as well as a few surprises • Query Timeouts • Index Fragmentation • Execution Plan Warnings • Missing Indexes • SQL Server Wait information • Missing Statistics • Query bottlenecks • Data type conversion issues • CPU and Memory Issues • IO issues • Deadlocks

This session will also cover a few additional topics such as how to format your SQL code allowing for easier reading. How to perform a complete server assessment and baseline will also be covered as part of the session.

SessionID: 92025

Playing with (M)agic: an introduction to writing M code in Power BI

Back to calendar

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

Speaker: Justin Mannhardt

Title: Playing with (M)agic: an introduction to writing M code in Power BI

Abstract:

Do you love Power Query? Are you ready to take your skills to the next level? Learning to write M code is easier than you think! Writing M code can reduce maintenance and create a more dynamic solution for you and your users.

In this session you will learn:

Where you can write M code in PowerQuery.
The different types of objects you can use as variables in your code.
Different ways you can leverage variables to create a dynamic solution.

SessionID: 93522

Introduction to Business Intelligence

Back to calendar

Event Date: 10-08-2019 - Session time: 08:00:00 - Track: Professional Development

Speaker: CJ Knapp

Title: Introduction to Business Intelligence

Abstract:

Session in the SQLStarter beginner track to introduce the business intelligence career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 93941

42 TSQL Functions

Back to calendar

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

Speaker: Thomas Grohser

Title: 42 TSQL Functions

Abstract:

SQL Server has many build in T-SQL functions. This session will introduce you to 42 (or more) of them and explain how they can make your life easier. To name just a few TRANSLATE(REVERSE(DIFFERENCE(STATS_TIME(STRING_SPLIT(…)))).

SessionID: 94806

How to use Execution Plans to find Performance Issues

Back to calendar

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

Speaker: Dave Bland

Title: How to use Execution Plans to find Performance Issues

Abstract:

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems. We will also spend some time on how to properly read execution plans.

SessionID: 95055

The 10 Commandments of ETL

Back to calendar

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

Speaker: Martin Schoombee

Title: The 10 Commandments of ETL

Abstract:

ETL (Extract, Transform Load) processes are fundamentally important in any data warehouse environment, and there are many different ways in which to develop the components.

In this session I will share the 10 basic principles I follow when developing ETL processes, and also show how the different choices can affect performance. Following these simple guidelines have resulted in many successful projects and happy customers. I'm sure it will work for you too!!

SessionID: 94213

Real Time Monitoring with Power BI

Back to calendar

Event Date: 10-08-2019 - Session time: 09:25:00 - Track: BI Information Delivery

Speaker: Bill Fellows

Title: Real Time Monitoring with Power BI

Abstract:

How are my systems performing RIGHT NOW! That's the problem we had to solve for a client's real-time messaging solution. In this talk we'll discuss the problem domain, the important metrics we needed to collect, how we could collect them, serve them and display them.

SessionID: 94260

Unit Testing - How to Make Friends and Influence Databases

Back to calendar

Event Date: 10-08-2019 - Session time: 09:25:00 - Track: Application Database Development

Speaker: Adam Hafner

Title: Unit Testing - How to Make Friends and Influence Databases

Abstract:

Is your motto "I don't usually test my database code, but when I do, I do it in production"? Then this series is for you. Many times in developing against a database there are many arguments with why testing is impossible. This session will cover an introductory topic of what unit testing is and how testing databases doesn't have to be a white unicorn.

SessionID: 94436

Big Data Clusters for the Absolute Beginner

Back to calendar

Event Date: 10-08-2019 - Session time: 09:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Mohammad Darab

Title: Big Data Clusters for the Absolute Beginner

Abstract:

Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today's ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts

SessionID: 94984

Data Science with SQL Server 2017

Back to calendar

Event Date: 10-08-2019 - Session time: 09:25:00 - Track: Advanced Analysis Techniques

Speaker: John Byrnes

Title: Data Science with SQL Server 2017

Abstract:

Every wonder if you could predict the outcome of the Superbowl? Or know the score of any game? The NFL is perfect for predictive analytics: it has a fixed time frame, large playing field, and rigorous rules. These are characteristics we can only envy in the business world. With the power of machine learning Services in SQL Server 2017, we have the strength of statistical languages like R and Python right within the database engine. In this session, John will demonstrate the steps for successfully preparing the data, then run a regression model to predict the scores for a current week’s scheduled NFL games. Want to know if your team is likely to win against the spread? Wanna bet?

SessionID: 94330

Why should I care about ... the plan cache?

Back to calendar

Event Date: 10-08-2019 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why should I care about ... the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick's "Why should I care" series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 94366

Hyper-Interactivity in Power BI

Back to calendar

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

Speaker: Brian Larson

Title: Hyper-Interactivity in Power BI

Abstract:

Power BI provides numerous features to enabling data interactivity. This session combines the more advanced interactive features to demonstrate a truly dynamic viewing experience. Together we will explore the use of specialized report pages, bookmarks, advanced DAX and more, to dynamically change chart axes and even visualization measures with a selection from a slicer. We will even see how to completely change the presentation on a Power BI tab with the single click of a button. Come see how to take your dashboards and reports from interactive to hyper-interactivity.

SessionID: 94464

SQL Unit Testing with T-SQLt

Back to calendar

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

Speaker: Kevin Trojanowski

Title: SQL Unit Testing with T-SQLt

Abstract:

Unit testing is an important part of application development and maintenance. Knowing that your latest change is not only providing the desired results but also is free from side-effects is critical to the rapid pace expected by your customers. This session will provide an introduction in to how you can easily create a library of unit tests around your database and its programmable objects.

SessionID: 95058

Real-World PowerShell for SQL Administration

Back to calendar

Event Date: 10-08-2019 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Real-World PowerShell for SQL Administration

Abstract:

If you're like me, you've attended PowerShell sessions before. However, much of the practical usage of PS comes with rolling back your sleeves and digging into the nuances of syntax and how to get things done. We are going to focus specifically on using PowerShell within the SQL Server Agent to build out everyday jobs.

In this session, I'm assuming that you know the basics of PowerShell. What we're going to cover are some of the "gotchas" and nuances that I've run into when I've been working with the language, and particularly with the SQL Agent's flavor of PowerShell.

And then we'll spend the balance of our time looking at real-world, practical scripts that I use pretty much every day. PowerShell is an awesome way to automate so many processes and relieve some of the everyday monotony of SQL administration.

SessionID: 93946

Innovative Data Modeling: Make Data Warehousing Cool Again

Back to calendar

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

Speaker: Leslie Weed

Title: Innovative Data Modeling: Make Data Warehousing Cool Again

Abstract:

There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can build a data warehouse solution or hybrid solution that is agile in nature. Discover this highly auditable modeling technique used in international banking, manufacturing, insurance and many more industries. Made a mistake? No worries, own your model. Design changes happen and it can be addressed quickly avoiding pain and project delays and ultimately keeping your business happy. Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. Let us bust the myth that data warehouses take too long to build and are too hard to modify by adding value to your environment and decreasing delivery time.

SessionID: 94713

Extended Events - Better than Profiler

Back to calendar

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

Speaker: Jason Brimhall

Title: Extended Events - Better than Profiler

Abstract:

Extended Events was introduced in SQL Server 2008. Every release since then, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

SessionID: 95054

Advanced Power BI Modeling Techniques

Back to calendar

Event Date: 10-08-2019 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Martin Schoombee

Title: Advanced Power BI Modeling Techniques

Abstract:

Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper.

In this session we'll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures or KPIs in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.

SessionID: 95160

HA in an about an Hour

Back to calendar

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

Speaker: Shawn Meyers

Title: HA in an about an Hour

Abstract:

This session will cover the basics for SQL server native tools to provide high availability to your databases. Overview of AlwaysOn, Failover Cluster Instances, Mirroring, and Log Shipping. Pros and cons for each will be covered and direct comparisons of the technologies. After attending this session attendees should be able to know the questions to answer to select the proper HA solution for their environment.

SessionID: 92086

Building Web-Apps with R and SQL Server

Back to calendar

Event Date: 10-08-2019 - Session time: 14:40:00 - Track: Application Database Development

Speaker: Matthew Sharkey

Title: Building Web-Apps with R and SQL Server

Abstract:

R isn't well known for enterprise Web Applications. However, recent advancements in the R ecosystem aim to change that. In this presentation, I will introduce what you need to know for building a production-ready web-app in R.

Here are a few topics we'll address:

Building and Managing Database Connections
Error Handling Input Validation
Load Testing
Performance Tuning and Optimization

SessionID: 93094

Are you getting the most out of SQL Agent?

Back to calendar

Event Date: 10-08-2019 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Marcus Hopfinger

Title: Are you getting the most out of SQL Agent?

Abstract:

Do you think of SQL Agent as a simple scheduling tool? I used to but over the years have learned how to get more out of SQL Agent than I once did. In this session I will show you how to use SQL Agent for notifications, how to create jobs that can re-run steps, jobs to restart jobs, jobs that start jobs on other servers along with a few other tricks. To close the session, I will demonstrate a SQL Agent job that can even clean up after itself.

SessionID: 94532

"Why is My Drive Full?" Understanding SQL Backups - Even if you are not responsible for Backups

Back to calendar

Event Date: 10-08-2019 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Preston VanderPlaats

Title: "Why is My Drive Full?" Understanding SQL Backups - Even if you are not responsible for Backups

Abstract:

This session will provide an introduction to understanding and configuring SQL Server backups. It will explain Data files, Transaction Log files, Recover Models, Backup Types as well as show multiple examples of Full, Differential and Transaction Log backups and restores. We will also cover the easiest way to schedule backups and to remove the old backup files.

You will also be shown answers to the following questions? What are the different types of Backups? What does the Recovery Model setting do? Are there conflicting backups happening? Why are the log (ldf) files so big? How do I clear space from the log files? How do I shrink the log files?

This is a good introduction, if you need to learn how to backup SQL, want to know more about backups or occasionally need to troubleshoot backup issues.

SessionID: 94755

What are these new Microsoft Data Certifications?

Back to calendar

Event Date: 10-08-2019 - Session time: 14:40:00 - Track: Professional Development

Speaker: Ryan Swanstrom

Title: What are these new Microsoft Data Certifications?

Abstract:

In early 2019, Microsoft released 3 new certifications aimed at data and AI professionals. The new certifications target data scientists, AI engineers, and data engineers. This talk will present the 3 certifications and the necessary exams. It will also cover the topics included for each of the exams. At the end of this talk, you should be able to determine which certification is right for you.

SessionID: 92052

Resume Tips-Go Beyond the Print Out

Back to calendar

Event Date: 10-08-2019 - Session time: 16:05:00 - Track: Professional Development

Speaker: Leveat Ruse

Title: Resume Tips-Go Beyond the Print Out

Abstract:

From the basics to the advanced. From paper, to LinkedIn, to what happens when the hiring manager "googles" you. We will explore what makes a GREAT online presence!

SessionID: 93179

XML? What’s this doing in my database?

Back to calendar

Event Date: 10-08-2019 - Session time: 16:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Adam Koehler

Title: XML? What’s this doing in my database?

Abstract:

As a DBA, we’re responsible for making sure our systems run optimally at all times. We know about Extended Events and how to use XQuery to access them. So what happens when we have XML data in user tables?

In this session, we’ll learn how XML data can be stored in the database, how to index it appropriately for performance, and tips and tricks to make your SQL queries against XML data faster.

SessionID: 94918

Don't just code it—Generate It

Back to calendar

Event Date: 10-08-2019 - Session time: 16:05:00 - Track: Application Database Development

Speaker: Kevin Mackey

Title: Don't just code it—Generate It

Abstract:

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.

Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.

Source to Target mapping documents can be used to generate the code to effect the mapping.
Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
Business rules can be encoded in data and the code to implement them manufactured. Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?

SessionID: 95056

Hidden Power: Service Broker

Back to calendar

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

Speaker: Ankit Baria

Title: Hidden Power: Service Broker

Abstract:

Service Broker is a robust asynchronous programming model that provides reliable messaging between SQL Server instances. Making life easier for developers creating sophisticated applications to communicate between databases and servers.

With focusing on your basic database to database asynchronous messaging to more advance messaging across multiple servers, we are positive you will walk away with new knowledge about Service Broker. And just as positive we will learn something new with you. As some of you may know, Service Broker never ceases to surprise.

This site is open source. Improve this page.