sqlsathistory

Nr: 743

Back to Main list

SQLSaturday #743 - Pensacola 2018

Start Time (24h)	Speaker	Track	Title
08:30:00	Janis Griffin	Enterprise Database Administration Deployment	Need For Speed? Top Five SQL Server Query Tuning Tips
08:30:00	Kerry Tyler	BI Platform Architecture, Development Administration	Introduction to Business Intelligence
08:30:00	Sean McCown	Application Database Development	The Master Stored Procedure Workshop
08:30:00	Rodney Landrum	Enterprise Database Administration Deployment	The Strategic Value of Monitoring SQL Server
10:15:00	Monica Rathbun	Enterprise Database Administration Deployment	You're Stuck with Crappy Hardware, Now What?
10:15:00	John Wells	Application Database Development	Fundamentals That Will Improve Your Query Performance!
10:15:00	Ed Watson	BI Platform Architecture, Development Administration	A Beginner's Guide to Power BI
10:15:00	Jennifer McCown	Enterprise Database Administration Deployment	Beginning Admin: The Care and Feeding of SQL Server
10:15:00	Elizabeth Noble	Application Database Development	Source control, now. Peace through database lifecycle management.
10:15:00	Neal Waterstreet	BI Platform Architecture, Development Administration	Master Data Management with SQL Server 2016 MDS
11:30:00	Mohammad Darab	Professional Development	3 Lessons Learned in Successful Consulting
11:30:00	Monica Rathbun	Enterprise Database Administration Deployment	Always Encrypted for Beginners
11:30:00	Samir Behara	Application Database Development	DevOps, Continuous Integration Automated Testing: Rule them all
11:30:00	John Morehouse	Application Database Development	Temporal Tables – The New Hotness in Data Auditing
11:30:00	Kerry Tyler	Enterprise Database Administration Deployment	Tuning Like CSS: With These Tools There's No Need Call Support
11:30:00	Shabnam Watson	BI Platform Architecture, Development Administration	Introduction to SQL Server Analysis Services (SSAS) Tabular
13:00:00	Jennifer McCown	Enterprise Database Administration Deployment	MinionWare Solves All* Your SQL Admin Problems (*most)
14:00:00	Paul LaGrone	BI Platform Architecture, Development Administration	SQL 2017 SSIS Scale Out - Why and How
14:00:00	Rob Volk	Enterprise Database Administration Deployment	That's So Metadata: Discover Your Database From the Inside
14:00:00	William Wolf	Application Database Development	Who's on First? SQL Server statistics Dynamic Power BI Visuals!
14:00:00	Mike Lawell	Cloud Application Development Deployment	Cosmos DB: Planet Earth Scale
14:00:00	Lance Tidwell	Application Database Development	New Features in SQL That Will Change the Way You Tune
14:00:00	David Pless	Enterprise Database Administration Deployment	SQL SERVER 2016 / 2017 AND AZURE SQL DB: SECURITY ALL UP
15:15:00	Michael Viron	Enterprise Database Administration Deployment	Fundamentals of Disaster Planning Recovery
15:15:00	Tim Radney	Enterprise Database Administration Deployment	Azure SQL Database for the Production DBA
15:15:00	Angela Tidwell	Professional Development	Becoming the MVP: Soft Skills for the Hard Market
15:15:00	Sven Aelterman	Application Database Development	On the Cutting Edge with Nodes: Graph Tables in SQL Server

SessionID: 72897

Need For Speed? Top Five SQL Server Query Tuning Tips

Back to calendar

Event Date: 02-06-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Need For Speed? Top Five SQL Server Query Tuning Tips

Abstract:

Query tuning is key to peak performance in SQL Server databases. However, lots of developers and DBAs constantly struggle to pinpoint the root cause of performance issues and spend way too much time in trying to fix them. In this presentation, I will share my tried and true best practices for tuning SQL statements and other issues by utilizing Wait Time Analysis, reviewing execution plans and using SQL diagramming techniques. In addition, several case studies will be used to demonstrate these best practices.

Regardless of the complexity of your database or your skill level, this systematic approach will lead you down the correct tuning path with no guessing, saving countless hours of tuning queries and optimizing performance of your SQL Server databases. Learning objectives: • Learn how to effectively use wait types to quickly identify bottlenecks and get clues on the best tuning approach • Quickly identify inefficient operations through review of query execution plans • Learn how

SessionID: 80122

Introduction to Business Intelligence

Back to calendar

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

Speaker: Kerry Tyler

Title: Introduction to Business Intelligence

Abstract:

Are you curious about Business Intelligence and how it drives the world around us? In this session, we'll cover high-level technical components of a BI system and the business processes that drive them. Whether you are new to IT in general or considering a career change, you'll come out of this session with a basic understanding of the BI world.

SessionID: 80417

The Master Stored Procedure Workshop

Back to calendar

Event Date: 02-06-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Sean McCown

Title: The Master Stored Procedure Workshop

Abstract:

Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? In a single day, we will show you how to write stored procedures from scratch, using the design advice we’ve accumulated in our combined 40 years of experience.

Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!

SessionID: 82983

The Strategic Value of Monitoring SQL Server

Back to calendar

Event Date: 02-06-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rodney Landrum

Title: The Strategic Value of Monitoring SQL Server

Abstract:

Why would you ever need to automatically monitor the SQL Servers in your care? What is the business value of doing so? What are the important features that a DBA should look for in a performance-monitoring tool? Rodney gives answers based on long experience and why tools like Redgate’s SQL Monitor are often the best option for implementing in your organization.

SessionID: 72408

You're Stuck with Crappy Hardware, Now What?

Back to calendar

Event Date: 02-06-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: You're Stuck with Crappy Hardware, Now What?

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

Fundamentals That Will Improve Your Query Performance!

Back to calendar

Event Date: 02-06-2018 - Session time: 10:15:00 - Track: Application Database Development

Speaker: John Wells

Title: Fundamentals That Will Improve Your Query Performance!

Abstract:

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!

SessionID: 78748

A Beginner's Guide to Power BI

Back to calendar

Event Date: 02-06-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Watson

Title: A Beginner's Guide to Power BI

Abstract:

Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.

SessionID: 78765

Beginning Admin: The Care and Feeding of SQL Server

Back to calendar

Event Date: 02-06-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jennifer McCown

Title: Beginning Admin: The Care and Feeding of SQL Server

Abstract:

Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected. In this class, we'll cover the basics of the big five administrator tasks:

• Backups – You must set up regular backups, to keep copies of your databases...just in case something breaks, or someone makes a bad, bad mistake.
• Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
• Index maintenance – Databases need regular upkeep so they'll continue to run well.
• Disk management – It's actually your job to find out about full disks before they happen. After all, databases grow!
• Alerting – Alerts tell you what's wrong, so you don't have to go looking for problems.

Being a database administrator is a big job, but we can cover the basics in one session!

SessionID: 78775

Source control, now. Peace through database lifecycle management.

Back to calendar

Event Date: 02-06-2018 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Elizabeth Noble

Title: Source control, now. Peace through database lifecycle management.

Abstract:

Database source control can be challenging and tricky to implement. This session will be a discussion on setting up a good foundation to implement source control. During this session we will go over getting buy-in for source control, managing database changes, and avoiding common pitfalls.

SessionID: 80033

Master Data Management with SQL Server 2016 MDS

Back to calendar

Event Date: 02-06-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Neal Waterstreet

Title: Master Data Management with SQL Server 2016 MDS

Abstract:

Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

SessionID: 73213

3 Lessons Learned in Successful Consulting

Back to calendar

Event Date: 02-06-2018 - Session time: 11:30:00 - Track: Professional Development

Speaker: Mohammad Darab

Title: 3 Lessons Learned in Successful Consulting

Abstract:

I would like to share the 3 lessons I learned that helped me become a much better consultant. These lessons were crucial in helping me make that "mind shift" from thinking like a regular "9 to 5 DBA" to thinking like a consultant. The goal of this session is to help those who are interested in becoming a consultant. Hopefully these 3 lessons will help make that transition successful as it did for me.

SessionID: 73554

Always Encrypted for Beginners

Back to calendar

Event Date: 02-06-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: Always Encrypted for Beginners

Abstract:

One of the biggest challenges to successful implementation of data encryption has been the back and forth between the application and the database.  You have to overcome the obstacle of the application decrypting the data it needs.  Microsoft tried to simplify this process when it introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database. In this demo intense session, you will learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt. You will also learn about the current limitations of the feature and what your options are to work around them.

SessionID: 78951

DevOps, Continuous Integration Automated Testing: Rule them all

Back to calendar

Event Date: 02-06-2018 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Samir Behara

Title: DevOps, Continuous Integration Automated Testing: Rule them all

Abstract:

Do you want to make your deployments risk free? Do you want to deliver business values to your customers faster? Do you want to increase the efficiency of your Team? Are your application and database deployment separate processes? Do you encounter issues while deploying your database changes? Do you want to automate your testing process? Is your database slowing you down?

If the answer to any of the above questions is a Yes, then this presentation is for YOU. Come join me in this 60 min session to understand the problems with traditional database development, why organizations are moving towards achieving Continuous Integration and Database DevOps, the problems it tries to solve and learn about the toolsets which will assist you in this journey towards painless database deployments.

SessionID: 80118

Temporal Tables – The New Hotness in Data Auditing

Back to calendar

Event Date: 02-06-2018 - Session time: 11:30:00 - Track: Application Database Development

Speaker: John Morehouse

Title: Temporal Tables – The New Hotness in Data Auditing

Abstract:

A common issue database administrators face is data auditing. Many use triggers, CDC, third-party tools, or roll their own type of auditing tool. In SQL Server 2016, a new feature called Temporal Tables was introduced and helps to simplify this common need. In this session, we will take a look at what temporal tables are, how they work and how you can implement them into your environment.

SessionID: 80123

Tuning Like CSS: With These Tools There's No Need Call Support

Back to calendar

Event Date: 02-06-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kerry Tyler

Title: Tuning Like CSS: With These Tools There's No Need Call Support

Abstract:

What do you do when you have a performance or troubleshooting problem that you can’t figure out? One option is to open a support ticket with Microsoft Support (CSS). The CSS engineer will use a specific set of tools to collect and analyze workload data from your SQL Server. Based on this information they might recommend patches, configuration changes, or identify the worst-performing queries.

  But what if you could bypass support and do all of this analysis yourself?   In this session, you'll learn how to use battle tested tools to analyze your workload and error logs. Armed with this information, you'll understand the root cause of the problem and propose solutions to performance and stability problems.

SessionID: 80487

Introduction to SQL Server Analysis Services (SSAS) Tabular

Back to calendar

Event Date: 02-06-2018 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shabnam Watson

Title: Introduction to SQL Server Analysis Services (SSAS) Tabular

Abstract:

During this session you will learn about SSAS Tabular concepts, how to create a new Tabular project in Visual Studio, design a simple model using Adventure Works sample database, build basic DAX calculations, explore the model using Excel, and how to deploy the project to an SSAS Server. Along the way, you will learn about best practices when creating Tabular models and post-deployment considerations.

SessionID: 83300

MinionWare Solves All* Your SQL Admin Problems (*most)

Back to calendar

Event Date: 02-06-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jennifer McCown

Title: MinionWare Solves All* Your SQL Admin Problems (*most)

Abstract:

Come see us for a talk about SQL database administrator issues, and how Minion Enterprise can solve them! We'll cover time savings, security, auditing, enterprise alerting, centralized maintenance, disk space management, and more. Bring your questions and your lunch!

SessionID: 77035

SQL 2017 SSIS Scale Out - Why and How

Back to calendar

Event Date: 02-06-2018 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paul LaGrone

Title: SQL 2017 SSIS Scale Out - Why and How

Abstract:

2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.

SessionID: 77486

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

Back to calendar

Event Date: 02-06-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

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

Abstract:

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

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

• Document your database schema objects such as procedures, functions, tables, columns and indexes
• Investigate performance and look for bottlenecks
• Discover metadata to administer your databases backups, index maintenance, and security
• Apply your own metadata using extended properties

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

SessionID: 77612

Who's on First? SQL Server statistics Dynamic Power BI Visuals!

Back to calendar

Event Date: 02-06-2018 - Session time: 14:00:00 - Track: Application Database Development

Speaker: William Wolf

Title: Who's on First? SQL Server statistics Dynamic Power BI Visuals!

Abstract:

What will happen when a Performance Tuner is analyzing statistics and using Power BI reports based on that analysis? A dynamic learning experience from a different perspective.

The SQL Server optimizer uses distribution statistics when creating execution plans. Statistics are used to provide the optimizer with estimations for the best way to process the query and hopefully optimize performance.

Power BI is a powerful tool that has been released in the last few years that helps you visualize your information to help make informative decisions with rich visualization.

In this session, we will show you how SQL Server uses statistics to create the execution plan and Power BI to visualize that statistical distribution; with a TWIST. Roles will be reversed to show a dynamic and interactive learning experience helping users with two different concepts in one exciting session!

SessionID: 80216

Cosmos DB: Planet Earth Scale

Back to calendar

Event Date: 02-06-2018 - Session time: 14:00:00 - Track: Cloud Application Development Deployment

Speaker: Mike Lawell

Title: Cosmos DB: Planet Earth Scale

Abstract:

In this session you will be learn what Cosmos DB is and why it is the hottest thing in Azure.

What does massively scalable, mullti-model, globally distributed, well-defined consistency models look like?

Most important, who is going to be using it and why?

SessionID: 80653

New Features in SQL That Will Change the Way You Tune

Back to calendar

Event Date: 02-06-2018 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Lance Tidwell

Title: New Features in SQL That Will Change the Way You Tune

Abstract:

Since the new cardinality estimator was released in SQL Server 2014, every version on SQL has introduced new great features design to help your queries run at max performance. In 2016, it was Query Store; in 2017, Adaptive Query Processing and Automatic Tuning have been introduced.

In this session we will explore these new features and how they can make your life easier. We will also look at some of the pitfalls and potential issues that can arise from these new features.

SessionID: 82367

SQL SERVER 2016 / 2017 AND AZURE SQL DB: SECURITY ALL UP

Back to calendar

Event Date: 02-06-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Pless

Title: SQL SERVER 2016 / 2017 AND AZURE SQL DB: SECURITY ALL UP

Abstract:

We will cover many security features in SQL Server 2016/2017 such as Row Level Security, Dynamic Data Masking, Always Encrypted, Advanced Threat Detection, and the Azure Security Center covering SQL Server.

Row-Level Security enables customers to control access to rows based on the characteristics of the user executing a query. RLS enables you to implement restrictions on data row access. Dynamic Data Masking limits sensitive data exposure by masking it to non-privileged users. Always Encrypted is a feature designed to protect sensitive data stored in a SQL database. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the Database Engine.

We will cover the Azure Security Center and Advanced Threat Detection which can be used to provide a dashboard for viewing responding to security risks. The benefits of include configuration of SQL threat detection policy, email alerts, Azure Portal and Excel integration.

SessionID: 72271

Fundamentals of Disaster Planning Recovery

Back to calendar

Event Date: 02-06-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Viron

Title: Fundamentals of Disaster Planning Recovery

Abstract:

In this session, we'll cover the basics of Disaster Planning and key operational items to consider when establishing software systems. We'll cover terms and their importance as well as commonly used software and hardware techniques for disaster planning purposes.

SessionID: 72566

Azure SQL Database for the Production DBA

Back to calendar

Event Date: 02-06-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Azure SQL Database for the Production DBA

Abstract:

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

SessionID: 73224

Becoming the MVP: Soft Skills for the Hard Market

Back to calendar

Event Date: 02-06-2018 - Session time: 15:15:00 - Track: Professional Development

Speaker: Angela Tidwell

Title: Becoming the MVP: Soft Skills for the Hard Market

Abstract:

Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success. Often times we focus on showing how smart we are instead of showing what a good team member we can be. We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills? We will explore innovative and fun ways in which to do just that!

SessionID: 76899

On the Cutting Edge with Nodes: Graph Tables in SQL Server

Back to calendar

Event Date: 02-06-2018 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Sven Aelterman

Title: On the Cutting Edge with Nodes: Graph Tables in SQL Server

Abstract:

SQL Server 2017 introduces new schema extensions that make working with certain types of data easier and potentially more efficient. These graph extensions make it possible to create graph structures consisting of nodes and edges inside the relational database. Graphs are commonly used to describe network topology, but they are also used to model certain other types of data, including hierarchical and complex many-to-many relationships. In this talk, you will receive a brief introduction to graph concepts and some use cases for modeling data as graphs. You will then learn how to apply the new SQL Server extensions to create node and edge type tables, as well as how to efficiently query these structures.

This site is open source. Improve this page.