sqlsathistory

Nr: 839

Back to Main list

SQLSaturday #839 - Virginia Beach 2019

Start Time (24h)	Speaker	Track	Title
12:45:00	Andrew Kelly	Enterprise Database Administration Deployment	Core Level Practical Performance Monitoring
12:45:00	John Morehouse	Cloud Application Development Deployment	Managing and Architecting Azure Data Platform
12:45:00	Andy Leonard	BI Platform Architecture, Development Administration	Intelligent Data Integration with SSIS
08:15:00	Thomas Norman	Application Database Development	Database Project Makes Deployment Consistent
08:15:00	Matt Cushing	Professional Development	Networking 101: Getting Ready for a SQL Event
08:15:00	Mindy Curnutt	Application Database Development	Parameters in SQL Server - Query Performance Makers or Breakers
08:15:00	Andrew Kelly	Application Database Development	Getting your Database off to a Right Start
08:15:00	Brian Hansen	BI Platform Architecture, Development Administration	Visualize Your Transaction Log
08:15:00	Jim Donahoe	Cloud Application Development Deployment	Getting started with Azure SQL Database: What You Need To Know!
08:15:00	Eric Flamm	Enterprise Database Administration Deployment	Intro to Azure Data Studio
09:30:00	Chris Bell	Enterprise Database Administration Deployment	Using Modular Scripts to Perform SQL Compliance Audits in Seconds
09:30:00	Angela Henry	Application Database Development	Profiling Your Data
09:30:00	Meagan Longoria	BI Platform Architecture, Development Administration	Do Your Data Visualizations Need A Makeover?
09:30:00	Jamie Wick	Enterprise Database Administration Deployment	Automated SQL Server installation and configuration using PowerShell JSON
09:30:00	Slava Murygin	Application Database Development	SQL Joins - Deep Dive into the Shallow Waters
09:30:00	Jim Donahoe	Enterprise Database Administration Deployment	New Instance, Now what?
09:30:00	Tracy Boggiano	Enterprise Database Administration Deployment	Back to Basics: SQL Server Configuration with dbatools and dbachecks
10:45:00	Andy Leonard	BI Platform Architecture, Development Administration	Faster SSIS
10:45:00	Dave Bland	Enterprise Database Administration Deployment	Extended Events: What are they and How do I use them
10:45:00	Alex Grinberg	Application Database Development	Advanced T-SQL Development with latest features.
10:45:00	Judith Moffitt	Application Database Development	Data Meaning in Database Design, Analysis, and Reporting
10:45:00	Mindy Curnutt	Cloud Application Development Deployment	Disaster Recovery - Done Dirt Cheap
10:45:00	John Morehouse	Enterprise Database Administration Deployment	What You'll Love in SQL Server 2019
12:00:00	Sponsor Session	Application Database Development	SentryOne -Beyond Monitoring With SentryOne
12:00:00	Sponsor Session	BI Platform Architecture, Development Administration	Marathon Consulting -A Day in the Life of a Data Consultant
12:00:00	Sponsor Session	Application Database Development	SQL Data Partners Power BI Deployed Lunch Session
13:15:00	Ray Kim	Professional Development	Disaster Documents: The role of documentation in disaster recovery
13:15:00	Louis Davidson	Application Database Development	Relational Design Critique
13:15:00	Anders Pedersen	Application Database Development	I/O Tuning 101
13:15:00	Azhagappan Arunachalam	Enterprise Database Administration Deployment	SQL Server and Docker
13:15:00	John Miner	Application Database Development	Effective Data Warehouse Storage Patterns
13:15:00	Meagan Longoria	Cloud Application Development Deployment	Moving and Transforming Your Data with Azure Data Factory V2
14:30:00	Thomas Norman	Application Database Development	DevOps: Consistent Deployments / Team Development
14:30:00	Andy Leonard	BI Platform Architecture, Development Administration	Moving Data with Azure Data Factory
14:30:00	Jon Tupitza	BI Platform Architecture, Development Administration	Exploring Machine Learning Tasks and Statistical Data Analysis
14:30:00	Andrew Kelly	Enterprise Database Administration Deployment	Practical Monitoring of TempDB
14:30:00	Sarah Patrick	Application Database Development	Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database
14:30:00	John Morehouse	Enterprise Database Administration Deployment	Data Encryption for DBAs
15:45:00	Bhakthi Liyanage	Cloud Application Development Deployment	Build Intelligent Applications with Azure Cognitive Service
15:45:00	boB Taylor	Application Database Development	Temporal Data Capture
15:45:00	David Patrick	Application Database Development	3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
15:45:00	Greg Moore	Enterprise Database Administration Deployment	Whoa! Backup, what happened? The Basics of Backups
15:45:00	John Miner	Application Database Development	Staging data for Azure SQL services
15:45:00	Wayne Sheffield	Application Database Development	Intelligent Query Processing

SessionID: 88667

Core Level Practical Performance Monitoring

Back to calendar

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

Speaker: Andrew Kelly

Title: Core Level Practical Performance Monitoring

Abstract:

At some point in time every DBA struggles with the concepts and implementation of a proper performance monitoring strategy. This pre-con will cover the fundamental techniques and code snippets that will help you get to the bottom of who or what may be causing you problems. At the end of the day you will feel much more confident that you have the tools and the knowledge to start implementing a fundamental performance monitoring strategy that will work well for your environment. All the demo’s are based on actual code and techniques that anyone can use to obtain these goals. We will also cover the key aspects of SQL Server that you need to be aware of to make the right decisions regarding performance.

• Learn the core aspects of SQL Server that require monitoring • Learn how to properly capture the required performance metrics • Learn how to analyze and understand the metrics to maximize your time and reduce your effort

SessionID: 89279

Managing and Architecting Azure Data Platform

Back to calendar

Event Date: 08-06-2019 - Session time: 12:45:00 - Track: Cloud Application Development Deployment

Speaker: John Morehouse

Title: Managing and Architecting Azure Data Platform

Abstract:

In this daylong session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier. You will learn about building IaaS solutions to support SQL Server as well as managing Platform as a Service offerings like Azure SQL Database.

Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.

As Azure scales around the world many more companies, no matter where they are located, will be begin moving services from on-premises data centers into the Azure Cloud, and a solid foundation is key to successful migrations

SessionID: 92198

Intelligent Data Integration with SSIS

Back to calendar

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

Speaker: Andy Leonard

Title: Intelligent Data Integration with SSIS

Abstract:

What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data Integration Lifecycle Management), produced using Biml (Business Intelligence Markup Language) and executed using an SSIS

Framework.

Attend a day of training focused on intelligent data integration delivered by an experienced SSIS consultant who has also led an enterprise team of several ETL developers during multiple projects that spanned 2.5 years. And delivered.

Attendees will learn:

• a holistic approach to data integration design.
• a methodology for enterprise data integration that spans development through operational support.
• how automation changes everything. Including data integration with SSIS.

Topics include:

1. SSIS Design Patterns
2. Executing SSIS in the Enterprise
3. Custom SSIS Execution Frameworks
4. DevOps and SSIS
5. Biml, Biml Frameworks, and Tools

SessionID: 87261

Database Project Makes Deployment Consistent

Back to calendar

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

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.

SessionID: 87570

Networking 101: Getting Ready for a SQL Event

Back to calendar

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

Speaker: Matt Cushing

Title: Networking 101: Getting Ready for a SQL Event

Abstract:

Looking to get the most out of your SQL Saturday, PASS Summit, or local user group meeting? Plan ahead! Events aren't just about learning new things, they're about meeting new people, networking with peers, and learning different approaches to common issues.

In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.

SessionID: 88658

Parameters in SQL Server - Query Performance Makers or Breakers

Back to calendar

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

Speaker: Mindy Curnutt

Title: Parameters in SQL Server - Query Performance Makers or Breakers

Abstract:

T-SQL programming makes wide use of parameterization in stored procedures, dynamic statements and ad-hoc queries. Many developers aren’t aware of the significant influence they have on query performance. Incorrect use or lack of parameters is a common reason for query performance issues.

Have you experienced a query that always ran fast, suddenly (and for "no reason") become slow? And with nothing changing? Yep!

• In this session we will learn about how the plan cache deals with queries that are (and are not) parameterized.
• You'll learn about parameter sniffing, what it is, and how it's handled in the older and newest versions of SQL.
• We will explore the problem of mismatched data types and implicit conversions - and how that ties in with ORM generated code.
• Lastly, we'll take a peek at value list handling from applications, and how using a table valued parameter as an input instead. If this is a new topic to you, you'll leave this session with takeaways galore.

SessionID: 88669

Getting your Database off to a Right Start

Back to calendar

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

Speaker: Andrew Kelly

Title: Getting your Database off to a Right Start

Abstract:

When you create a new database do you ensure you have done everything you can to give it the chance to shine when things get tough? How many times have you seen a database created with all the defaults and down the road it becomes out of control due to the size, amount of data or even activity? If you really want to ensure your database can scale and perform well at all times you need to do the proper homework before you create the database. We will walk thru the various factors that affect performance and scalability under real life conditions and help you understand how to properly configure them up front to avoid issues down the road. Scalability is all about having a proper foundation to build on.

SessionID: 90705

Visualize Your Transaction Log

Back to calendar

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

Speaker: Brian Hansen

Title: Visualize Your Transaction Log

Abstract:

The SQL transaction log can be a mystery to many DBAs. We live in the age of visualizations, so let's visualize the log! In this session, we will examine the purpose and organization of the transaction log and will explore the log through a unique visualization tool. We will consider common performance issues that are related to the logging mechanism and how to overcome these problems. Finally, we will discuss some techniques to monitor the log so that potential performance problems can be addressed pro-actively.

SessionID: 91268

Getting started with Azure SQL Database: What You Need To Know!

Back to calendar

Event Date: 08-06-2019 - Session time: 08:15:00 - Track: Cloud Application Development Deployment

Speaker: Jim Donahoe

Title: Getting started with Azure SQL Database: What You Need To Know!

Abstract:

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

SessionID: 91692

Intro to Azure Data Studio

Back to calendar

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

Speaker: Eric Flamm

Title: Intro to Azure Data Studio

Abstract:

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Azure Data Studio offers a modern editor experience with Intellisense, code snippets, source control integration, and an integrated terminal. It is engineered with the data platform user in mind, with built in charting of query result sets and customizable dashboards. Built on the Electron framework, Azure Data Studio is highly extensible and offers a large library of community-authored extensions as well as access to many of the extension available for Visual Studio Code.

Release 1.5.1 (March 2019) adds support for PostgreSQL and updated support for SQL Server 2019 (pre-release). It also includes support for SQL Notebooks, bringing the persistent, interactive presentation of Jupyter Notebooks to SQL Server, Postgres, and other supported languages.

SessionID: 87258

Using Modular Scripts to Perform SQL Compliance Audits in Seconds

Back to calendar

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

Speaker: Chris Bell

Title: Using Modular Scripts to Perform SQL Compliance Audits in Seconds

Abstract:

Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it can take considerable time to gather the information needed.

In this session, we will go over some scripts that are used for compliance audits that make it easy to collect the information required. Even when there are multiple SQL Servers, these scripts and processes can quickly and easily identify where to focus efforts to ensure compliance. Through heavy demonstration and discussion, you will leave with a better equipped to understand and obtain compliance within your SQL Server environment.

SessionID: 87449

Profiling Your Data

Back to calendar

Event Date: 08-06-2019 - Session time: 09:30:00 - Track: Application Database 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: 87623

Do Your Data Visualizations Need A Makeover?

Back to calendar

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

Speaker: Meagan Longoria

Title: Do Your Data Visualizations Need A Makeover?

Abstract:

Do you ever look at your data visualizations and feel that they are lackluster? Have you made a report using the latest chart types, but you still can’t gain adoption from your target audience? Lots of people feel this way, but they can’t quite identify what should be changed or how to change it. This session will help you identify signs that it’s time to give your data visualizations a makeover and provide practical tips for improving your reports and dashboards. We’ll discuss how simple changes in design choices related to color, chart types, chart formatting, and report layout can make a big difference in creating clear and engaging visualizations with common analysis tools like Power BI and Excel.

SessionID: 87907

Automated SQL Server installation and configuration using PowerShell JSON

Back to calendar

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

Speaker: Jamie Wick

Title: Automated SQL Server installation and configuration using PowerShell JSON

Abstract:

Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at using PowerShell scripts and JSON parameter files to automate the installation and post-install configuration of a SQL Server.

SessionID: 88969

SQL Joins - Deep Dive into the Shallow Waters

Back to calendar

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

Speaker: Slava Murygin

Title: SQL Joins - Deep Dive into the Shallow Waters

Abstract:

You’ve already learned how to do SELECT from a table. You’ve joined tables together and you think you know how to code SQL now. But there are even more gems hidden within a connection of two tables.

In this session, we will review different types of Join predicates, such as LEFT, RIGHT FULL, etc., visually differ them from each other and compare their results. We also will go deeper to research different techniques of using joined sub-queries and functions, and after this session your knowledge on how to write SQL queries will Rock.

SessionID: 91270

New Instance, Now what?

Back to calendar

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

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

SessionID: 91723

Back to Basics: SQL Server Configuration with dbatools and dbachecks

Back to calendar

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

Speaker: Tracy Boggiano

Title: Back to Basics: SQL Server Configuration with dbatools and dbachecks

Abstract:

Automating the configuration of SQL Server instances and being able to check the configuration for standard configuration is an important role for any DBA when you have lots of instances. But how can we automate the configuration easily? How can we check to make sure the proper configuration is in place and hasn’t changed?

In this session, we will look at how to configure your SQL Server Instances using PowerShell and the dbatools module. Then we will look at how to use dbachecks to confirm the configuration of our instances and how to check for changes in the future of the configuration.

Attendees will see how easy it to use PowerShell via dbatools to configure their SQL Server instances. Attendees will see how easy it is to use PowerShell via dbachecks and PowerBI to see if their servers are configured properly. Attendees will be given a set of scripts that take back to use to configure and test the configuration of their SQL Server instances.

SessionID: 87272

Faster SSIS

Back to calendar

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

Speaker: Andy Leonard

Title: Faster SSIS

Abstract:

Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.

SessionID: 87314

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

Back to calendar

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

Speaker: Dave Bland

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

Abstract:

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

SessionID: 87482

Advanced T-SQL Development with latest features.

Back to calendar

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

Speaker: Alex Grinberg

Title: Advanced T-SQL Development with latest features.

Abstract:

In the last releases, SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re

SessionID: 87487

Data Meaning in Database Design, Analysis, and Reporting

Back to calendar

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

Speaker: Judith Moffitt

Title: Data Meaning in Database Design, Analysis, and Reporting

Abstract:

Most training for databases ignores the single most critical element for successful collection and analysis of data, the meaning of the data itself.

This session explores how meaning affects results and why assuming a query is right just because it ran creates problems for the decision makers using the data results.a We will look at how it impacts database design. We will examine how it affects ETL and Big Data analyses. We will look at complex reporting queries and how incorrect results can harm the business.

SessionID: 88660

Disaster Recovery - Done Dirt Cheap

Back to calendar

Event Date: 08-06-2019 - Session time: 10:45:00 - Track: Cloud Application Development Deployment

Speaker: Mindy Curnutt

Title: Disaster Recovery - Done Dirt Cheap

Abstract:

Operating on a budget can result in some creative solutions. Recently I've come up with a creative solution for traditional on-premise client-server solutions that allows for full redundancy in the cloud, but at a budget price. This is accomplished through VMs, copying of logs to Blob Storage, automation of hydration, updates de-allocation. It may be a bit of a Rube Goldberg machine, but it works! The result is an extremely pro-rated and affordable DR solution that is restorable to within 1 hour or less of production. Come to this session to learn more about the hurdles faced when putting this solution together and to brainstorm together how it can even be improved.

SessionID: 93383

What You'll Love in SQL Server 2019

Back to calendar

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

Speaker: John Morehouse

Title: What You'll Love in SQL Server 2019

Abstract:

Technology moves at a blinding pace and the SQL Server platform is no exception. With the release of SQL Server 2019, you will see some great improvement in the database engine of the platform. In this session, you will examine some of the new features of SQL Server 2019 such as Accelerated Database Recovery (ADR), resumable index creation, UTF-8 support, online columnstore rebuilds, an improved data truncation message, among other features. After this session you will have a better understanding how you can leverage SQL Server 2019 to enhance your database environment.

SessionID: 92125

SentryOne -Beyond Monitoring With SentryOne

Back to calendar

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

Speaker: Sponsor Session

Title: SentryOne -Beyond Monitoring With SentryOne

Abstract:

Hopefully you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.

SessionID: 92126

Marathon Consulting -A Day in the Life of a Data Consultant

Back to calendar

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

Speaker: Sponsor Session

Title: Marathon Consulting -A Day in the Life of a Data Consultant

Abstract:

Have you ever wondered what we do at Marathon when we are not running? Marathon Consulting will entertain your lunch by going through a day in the life of a Marathon data consultant. We will discuss some sample projects as well as the services Marathon offers.

SessionID: 94001

SQL Data Partners Power BI Deployed Lunch Session

Back to calendar

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

Speaker: Sponsor Session

Title: SQL Data Partners Power BI Deployed Lunch Session

Abstract:

It's the best thing since sliced bread and management wants their long awaited dashboard. They say it only costs $10 a month, but what does that really mean? There is a lots of hype around Power BI and this session explores the components and pieces you will need for successful construction and deployment of Power BI reports. The session will detail the architecture and vocabulary used by Microsoft for this awesome visualization tool. This session is geared toward those who have not yet implemented Power BI.

SessionID: 87429

Disaster Documents: The role of documentation in disaster recovery

Back to calendar

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

Speaker: Ray Kim

Title: Disaster Documents: The role of documentation in disaster recovery

Abstract:

I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001. Prior to that infamous date, I had written several departmental documents that ended up being critical to our recovery. In this presentation, I provide a narrative of what happened in the weeks following 9/11, and how documentation played a role in getting the organization back on its feet.

While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself. We will discuss the documents we had and how they were used in our recovery. We will also discuss what documents we didn't have, and how they could have made the process better.

SessionID: 87478

Relational Design Critique

Back to calendar

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

Speaker: Louis Davidson

Title: Relational Design Critique

Abstract:

The process of designing a relational database is not overly complex, and may be done by almost anyone on the development team. The process requires one to take the time to understand the requirements, when they exist, and apply a straightforward set of transforms to produce table structures that meets the needs. The tough part is that the process requires time and experience, neither of which anyone has enough of. In this session, to help the attendee differentiate right-enough designs from overly simple or overly complex designs, we will look at a variety of database snippets, each inspired from a real life design. We will discuss the pros and cons of the approach taken, and consider possible remediations to learn from a failure that was made by someone else.

SessionID: 87814

I/O Tuning 101

Back to calendar

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

Speaker: Anders Pedersen

Title: I/O Tuning 101

Abstract:

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query. Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.

SessionID: 87929

SQL Server and Docker

Back to calendar

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

Speaker: Azhagappan Arunachalam

Title: SQL Server and Docker

Abstract:

Containers are everywhere. If server virtualization dominated the past decade, then this one belongs to the containers. Name any product, and the chances are there is a container image of that product ready to be deployed at a moment's notice. Containers can be used for hosting any type of application, and in this session, we'll take a look at what you need to know to get started with containers with respect to SQL Server (2019, 2017 and prev versions), and address some of the common questions that come up during this setup.

SessionID: 88914

Effective Data Warehouse Storage Patterns

Back to calendar

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

Speaker: John Miner

Title: Effective Data Warehouse Storage Patterns

Abstract:

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval? This presentation will review the following techniques to fix your woes.

Techniques: 1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?

SessionID: 93386

Moving and Transforming Your Data with Azure Data Factory V2

Back to calendar

Event Date: 08-06-2019 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Meagan Longoria

Title: Moving and Transforming Your Data with Azure Data Factory V2

Abstract:

Azure Data Factory (ADF) is a cloud-based data integration service that automates data movement and data transformation using both cloud and on-premises data sources and destinations. This introductory session will cover basic components of an ADF solution including integration runtimes, linked services, datasets, pipelines, activities, and triggers. We'll also discuss the development environment and integration with source control as well as monitoring. This session will include demos to show you how to build, execute, and monitor a pipeline. And since Data Factory is frequently updated with new features, we'll highlight some of the latest releases. If you have been waiting to dip your toe in the ADF waters, this is your chance to learn the basics and ask questions.

SessionID: 87263

DevOps: Consistent Deployments / Team Development

Back to calendar

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

Speaker: Thomas Norman

Title: DevOps: Consistent Deployments / Team Development

Abstract:

Unless you are developing code by yourself, you face challenges of working with several team members. Different people are changing code which affects the code someone else is working on. In addition, there will be teams working on different projects at the same time. In the middle of the projects, an emergency fix needs to be deployed to Production. So where is the code, when do you shared it with others, when do you get the code that has been shared, where is the production code branch located. How do I branch and when do merge? How do I get a release branch? Let me share with you how we are handling this area of DevOps.

SessionID: 87273

Moving Data with Azure Data Factory

Back to calendar

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

Speaker: Andy Leonard

Title: Moving Data with Azure Data Factory

Abstract:

Azure Data Factory - ADF - is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) - or "SSIS in the Cloud."

Attend this session to learn:

• How to build a "native ADF" pipeline;
• How to lift and shift SSIS to the Azure Data Factory integration Runtime; and
• ADF Design Patterns to execute and monitor pipelines and packages.

SessionID: 87820

Exploring Machine Learning Tasks and Statistical Data Analysis

Back to calendar

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

Speaker: Jon Tupitza

Title: Exploring Machine Learning Tasks and Statistical Data Analysis

Abstract:

This session will explore how to apply the various categories and types of Machine Learning algorithms to common data science tasks, along with explaining the corresponding statistical methods being implemented by those algorithms.

SessionID: 88668

Practical Monitoring of TempDB

Back to calendar

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

Speaker: Andrew Kelly

Title: Practical Monitoring of TempDB

Abstract:

While TempDB make look like any other database it’s usage patterns are typically unique and require a special type of monitoring to stay ahead of any potential performance or space issues. This session is packed with demo’s that will outline what aspects of TempDB you need to pay attention to and exactly how to monitor for them. We will discuss what you can do to tune this database to match your workload and allow for proper scaling over time and different work patterns you may encounter. If you want peak performance from your SQL Serve Instance you need to ensure TempDB is up to the challenge. Come see exactly what those challenges are and what you can do to be ready for them.

SessionID: 89125

Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database

Back to calendar

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

Speaker: Sarah Patrick

Title: Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database

Abstract:

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Flow, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.

SessionID: 89278

Data Encryption for DBAs

Back to calendar

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

Speaker: John Morehouse

Title: Data Encryption for DBAs

Abstract:

It seems more lately than not, there are daily stories of a data breach somewhere. Data security is one of the most critical things a data professional should be aware of. Now, there are several ways of implementing data security in today's world. SQL Server comes with several native data encryption methods that you can use. In this session, we will explore the basics of data encryption, how to implement some of them, some gotchas as well as some of the newer features of data encryption in newer versions.

SessionID: 87456

Build Intelligent Applications with Azure Cognitive Service

Back to calendar

Event Date: 08-06-2019 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Bhakthi Liyanage

Title: Build Intelligent Applications with Azure Cognitive Service

Abstract:

Microsoft Cognitive Services enables developers with powerful set of APIs that can be used to develop intelligent apps with powerful algorithms, using just a few lines of code.The API enables developers to easily add intelligent features – such as emotion and video detection; facial, speech and vision recognition; and speech and language understanding – into their applications with minimum effort. This session will show case how to get started with the API and how it can be integrated with your application

SessionID: 87480

Temporal Data Capture

Back to calendar

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

Speaker: boB Taylor

Title: Temporal Data Capture

Abstract:

Come see how I solved that lack of CDC in SQL Azure Database by leveraging a new feature in SQL Azure database and SQL Server 2016: Temporal tables. In this in-depth 400-level session I will demonstrate the techniques that I created to simulate CDC in SQL Azure Database. We will examine the code that implements the solution, the code that automatically writes code for you, and a wizard that makes it simple to consume.

SessionID: 87514

3 Ways for Getting Data from SharePoint : SSIS, Excel and Access

Back to calendar

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

Speaker: David Patrick

Title: 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access

Abstract:

Need to report on some data from SharePoint? We will look at three different techniques to pull data from a SharePoint Server. We will start with SSIS and the SharePoint List Source and Destinations. Next, We will use Excel to connect to various SharePoint lists (both online and on premise), and finally We will use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, We will have three different ways to get data from SharePoint.

SessionID: 88304

Whoa! Backup, what happened? The Basics of Backups

Back to calendar

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

Speaker: Greg Moore

Title: Whoa! Backup, what happened? The Basics of Backups

Abstract:

This session will start with performing a basic backup and restore of a database and then discuss the difference between FULL, Differential and Transaction backups. From there I will discuss many of the available options for backups, including backups of specific database files, to multiple files and different restore options.

Many DBAs still setup their backups via a GUI and “fire and forget” and don’t think about backups and restores until too late. This session will show you while that works in many cases, for larger or more complex databases, or databases with specialized HA requirements, the out of the box solution may be far from optimal.

SessionID: 88915

Staging data for Azure SQL services

Back to calendar

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

Speaker: John Miner

Title: Staging data for Azure SQL services

Abstract:

Most companies are faced with the ever-growing big data problem. There have been two schools of thought on how to solve this problem.

Schema on write is represented by the traditional relational database table. Only a small portion of the total data owned by the company resides in the database.

Schema on read is represented by technologies such as Hadoop or PolyBase. All data owned by the company can reside in simple storage.

Today, we will learn how to stage data using Azure blob storage which can be ingested by both techniques.

1 – Grab some big data. 2 – Create blob storage account. 3 – Copy data to container. 4 – Azure SQL database plumbing. 5 – Loading data with BULK INSERT. 6 – Azure SQL data warehouse plumbing. 7 – Loading data with POLYBASE. 8 – Azure automation with RUNBOOKS.

SessionID: 92216

Intelligent Query Processing

Back to calendar

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

Speaker: Wayne Sheffield

Title: Intelligent Query Processing

Abstract:

SQL Server has evolved many times over the years. SQL Server 2019 introduces “Intelligent Query Processing”, greatly enhancing the “Adaptive Query Processing” which was introduced in SQL Server 2017. Intelligent Query Processing allows your queries to operate more efficiently (resulting in better query performance) – without needing to make changes to the code or the application.

In this session we will explore all the Intelligent Query Processing features in SQL Server 2019. Time permitting, we will go into other changes in recent versions of SQL Server (such as execution plan changes and new Dynamic Management Objects) that will help improve your efficiency at troubleshooting and tuning SQL Server.

Coming away from this session, you will have plenty of reasons to want to upgrade to SQL Server 2019 immediately!

This site is open source. Improve this page.