text:
---
layout: "post"
title: "SQLSaturday #839 - Virginia Beach 2019"
prettydate: "8 June 2019"
---
# SQLSaturday #839 - Virginia Beach 2019

**Event Date**: 06/08/2019 00:00:00

**Event Location**:
- ECPI University
- 5555 Greenwich Road
- Virginia Beach, Virginia

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

Sessions

Speakers

Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

-----------------------------------------------------------------------------------

# Sessions
This is a list of sessions from the event, based on the schedule in the XML files.

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Louis Davidson

*Track and Room*: Application  Database Development - 403

-----------------------------------------------------------------------------------

## 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

**Speaker(s):**
- Alex Grinberg

*Track and Room*: Application  Database Development - 403

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Ray Kim

*Track and Room*: Professional Development - 353

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Chris Bell

*Track and Room*: Enterprise Database Administration  Deployment - 401

-----------------------------------------------------------------------------------

## 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

**Speaker(s):**
- Bhakthi Liyanage

*Track and Room*: Cloud Application Development  Deployment - 353

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- John Miner

*Track and Room*: Application  Database Development - 360

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Anders Pedersen

*Track and Room*: Application  Database Development - 411

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Meagan Longoria

*Track and Room*: BI Platform Architecture, Development  Administration - 360

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Greg Moore

*Track and Room*: Enterprise Database Administration  Deployment - 401

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Mindy Curnutt

*Track and Room*: Cloud Application Development  Deployment - 402

-----------------------------------------------------------------------------------

## 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

**Speaker(s):**
- Andrew Kelly

*Track and Room*: Enterprise Database Administration  Deployment - 403

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Andrew Kelly

*Track and Room*: Application  Database Development - 401

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Thomas Norman

*Track and Room*: Application  Database Development - 353

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Mindy Curnutt

*Track and Room*: Application  Database Development - 403

-----------------------------------------------------------------------------------

## 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?

**Speaker(s):**
- John Miner

*Track and Room*: Application  Database Development - 402

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Andy Leonard

*Track and Room*: BI Platform Architecture, Development  Administration - 360

-----------------------------------------------------------------------------------

## 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

**Speaker(s):**
- John Morehouse

*Track and Room*: Cloud Application Development  Deployment - 402

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Thomas Norman

*Track and Room*: Application  Database Development - 411

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- John Morehouse

*Track and Room*: Enterprise Database Administration  Deployment - 360

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Jim Donahoe

*Track and Room*: Cloud Application Development  Deployment - 411

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Eric Flamm

*Track and Room*: Enterprise Database Administration  Deployment - 402

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Tracy Boggiano

*Track and Room*: Enterprise Database Administration  Deployment - 353

-----------------------------------------------------------------------------------

## 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

**Speaker(s):**
- Andy Leonard

*Track and Room*: BI Platform Architecture, Development  Administration - 401

-----------------------------------------------------------------------------------

## 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!

**Speaker(s):**
- Wayne Sheffield

*Track and Room*: Application  Database Development - 411

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Meagan Longoria

*Track and Room*: Cloud Application Development  Deployment - 360

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Judith Moffitt

*Track and Room*: Application  Database Development - 411

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Slava Murygin

*Track and Room*: Application  Database Development - 403

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Sponsor Session

*Track and Room*: Application  Database Development - 402

-----------------------------------------------------------------------------------

## Title: Networking 101: Getting Ready for a SQL Event

**Abstract**:
Looking to get the most out of your SQLSaturday, 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.

**Speaker(s):**
- Matt Cushing

*Track and Room*: Professional Development - 401

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Andrew Kelly

*Track and Room*: Enterprise Database Administration  Deployment - 403

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Sponsor Session

*Track and Room*: BI Platform Architecture, Development  Administration - 401

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- boB Taylor

*Track and Room*: Application  Database Development - 403

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Angela Henry

*Track and Room*: Application  Database Development - 402

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Jim Donahoe

*Track and Room*: Enterprise Database Administration  Deployment - 353

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Sponsor Session

*Track and Room*: Application  Database Development - 360

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Sarah Patrick

*Track and Room*: Application  Database Development - 353

-----------------------------------------------------------------------------------

## 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!

**Speaker(s):**
- Dave Bland

*Track and Room*: Enterprise Database Administration  Deployment - 353

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Jon Tupitza

*Track and Room*: BI Platform Architecture, Development  Administration - 402

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Andy Leonard

*Track and Room*: BI Platform Architecture, Development  Administration - 401

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- David Patrick

*Track and Room*: Application  Database Development - 402

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Brian Hansen

*Track and Room*: BI Platform Architecture, Development  Administration - 360

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Jamie Wick

*Track and Room*: Enterprise Database Administration  Deployment - 411

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- John Morehouse

*Track and Room*: Enterprise Database Administration  Deployment - 401

-----------------------------------------------------------------------------------

## 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.

**Speaker(s):**
- Azhagappan Arunachalam

*Track and Room*: Enterprise Database Administration  Deployment - 401

-----------------------------------------------------------------------------------

## Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

**Andrew Kelly**

Twitter:  - [gunneyk](https://www.twitter.com/gunneyk)

Contact: [http://sqlblog.com/blogs/andrew_kelly/default.aspx](http://sqlblog.com/blogs/andrew_kelly/default.aspx)

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.

**Louis Davidson**

Twitter:  - [drsql](https://www.twitter.com/drsql)

LinkedIn: [Louis Davidson](http://www.linkedin.com/in/louisdavidson)

Contact: [https://www.red-gate.com/simple-talk/author/louis-davidson/](https://www.red-gate.com/simple-talk/author/louis-davidson/)

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

**Tracy Boggiano**

Twitter:  - [TracyBoggiano](https://www.twitter.com/TracyBoggiano)

LinkedIn: [Tracy Boggiano](https://www.linkedin.com/in/tracyboggiano)

Contact: [http://databasesuperhero.com](http://databasesuperhero.com)

Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

**Andrew Kelly**

Twitter:  - [gunneyk](https://www.twitter.com/gunneyk)

Contact: [http://sqlblog.com/blogs/andrew_kelly/default.aspx](http://sqlblog.com/blogs/andrew_kelly/default.aspx)

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.

**Eric Flamm**

Twitter:  - [eflamm](https://www.twitter.com/eflamm)

LinkedIn: [Eric Flamm](http://linkedin.com/in/ericmflamm)

Contact: [http://blog.flammconsulting.com](http://blog.flammconsulting.com)

Eric Flamm is the principal consultant with Flamm Consulting, which provides Business Intelligence and Data Engineering consulting services to a range of small and medium-sized businesses.  His clients have included Pactiv Corp (formerly Tenneco Packaging), Colography Group, Principia Partners, and Tillster, Inc (formerly Snapfinger.com), along with a range of smaller clients and projects.

Eric graduated from Stanford and the Booth School at U of Chicago.

Eric has volunteered with SQLSaturday Atlanta since the first event (SQLSaturday #13 in 2009). He has presented to SQLSaturdays in  Atlanta, Chicago, and Columbus (GA), Azure Data Fest (Atlanta), the Atlanta Power BI chapter, and the Kennesaw (GA) Amazon Web Services Meetup group.

**Andrew Kelly**

Twitter:  - [gunneyk](https://www.twitter.com/gunneyk)

Contact: [http://sqlblog.com/blogs/andrew_kelly/default.aspx](http://sqlblog.com/blogs/andrew_kelly/default.aspx)

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.

**boB Taylor**

Twitter:  - [sqlbobt](https://www.twitter.com/sqlbobt)

LinkedIn: [boB Taylor](http://www.linkedin.com\in\sqlbobt)

Contact: [http://aka.ms\sqlbobt](http://aka.ms\sqlbobt)

In his 45-year IT career, boB Taylor has pretty much done it all – Fortran 66 on Hollerith Cards, assembly language programming on drum-based computers, and LOB application development. He served as a VP of Software Development and was Director of Database Technologies for Avanade West Region. Then he joined Microsoft’s Partner Advantage practice, advising ISVs on effectively using SQL Server.
After becoming a Microsoft Certified Architect, boB moved to PFE and is now with the Oracle Compete Team. Besides passing 40+ certification exams on the first attempt, boB helped develop both SQL Server 2000 certification exams, SQL Server 2005 developer exams, and all MCSD.NET exams.

**Mindy Curnutt**

Twitter:  - [@sqlgirl](https://www.twitter.com/@sqlgirl)

LinkedIn: [Mindy Curnutt](https://www.linkedin.com/in/mindycurnutt)

Contact: [http://www.mindycurnutt.com](http://www.mindycurnutt.com)

Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning.  She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

**Matt Cushing**

Twitter:  - [Sqlkohai](https://www.twitter.com/Sqlkohai)

LinkedIn: [Matt Cushing](https://www.linkedin.com/in/mattcushing/)

Contact: [http://sqlkohai.com](http://sqlkohai.com)

Matt started out his career in Accounting and quickly realized he liked data a whole lot more!  Starting as a help desk associate, he's moved through support, development, data, and management positions before settling back to his passion for data.

Currently working for Applegate Farms in NJ, he loves the people he works with and for, and the company as a whole.  Thanks to the input and help from the SQL community, he was able to be ready for the right opportunity in his current position as a BI developer.  He also teaches a Database Management class at Rutgers University.

Ask him about the Red Sox sometime if you want your ear talked off ;).

**Judith Moffitt**

With over 20 years of database experience, Judy specializes in creating complex imports/ exports and reporting queries.  She has done development for databases for aviation/flight planning, equipment maintenance, inventory, sales proposals and meeting planning. Her expertise saved the US government over $400 million by identifying parts that were on order in one place that were in the excess inventory at another, a task that required her to query many databases with many different data structures.

She is currently employed by EPAM and extensively works with developers in India and across the US.

**Andy Leonard**

Twitter:  - [AndyLeonard](https://www.twitter.com/AndyLeonard)

LinkedIn: [Andy Leonard](http://www.linkedin.com/in/AndyLeonard)

Contact: [https://andyleonard.blog](https://andyleonard.blog)

Andy Leonard is founder and Chief Data Engineer at Enterprise Data  Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of "The Biml Book and SQL Server Integration Services Design Patterns" and author of "Managing Geeks - A Journey of Leading by Doing", "Data Integration Lifecycle Management with SSIS", "Building Custom Tasks for SSIS", and the "Stairway to Integration Services". Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

**Thomas Norman**

Twitter:  - [ArmorDba](https://www.twitter.com/ArmorDba)

LinkedIn: [Thomas Norman](http://www.linkedin.com/in/armordba)

Contact: [https://armordba.com/](https://armordba.com/)

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

**Sarah Patrick**

Twitter:  - [sarahepatrick](https://www.twitter.com/sarahepatrick)

LinkedIn: [Sarah Patrick](https://www.linkedin.com/in/sarahepatrick/)

Sarah has presented at several TechGirlz workshops for the Boys and Girls Club of Harford County, as an advocate for women in STEM. Sarah graduated from the Science and Mathematics Academy in Aberdeen, MD in May 2018, where she presented her senior capstone project "Engineering peer credibility via mastery of roles," where she designed roles for an ad hoc team. She worked with an army professional from CERDEC. She is currently attending the University of Maryland - College Park to major in Information Science. Sarah completed an internship with the Project Management Institute, helping them with their Professional Development Event, and worked as at the SharePoint Intern at Smithsonian Institution’s Office of the Chief Information Officer.

**Mindy Curnutt**

Twitter:  - [@sqlgirl](https://www.twitter.com/@sqlgirl)

LinkedIn: [Mindy Curnutt](https://www.linkedin.com/in/mindycurnutt)

Contact: [http://www.mindycurnutt.com](http://www.mindycurnutt.com)

Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning.  She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

**Meagan Longoria**

Twitter:  - [mmarie](https://www.twitter.com/mmarie)

LinkedIn: [Meagan Longoria](http://www.linkedin.com/in/meaganlongoria/)

Contact: [http://datasavvy.me](http://datasavvy.me)

Meagan Longoria is a business intelligence consultant with Denny Cherry  Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).

**Thomas Norman**

Twitter:  - [ArmorDba](https://www.twitter.com/ArmorDba)

LinkedIn: [Thomas Norman](http://www.linkedin.com/in/armordba)

Contact: [https://armordba.com/](https://armordba.com/)

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

**Andy Leonard**

Twitter:  - [AndyLeonard](https://www.twitter.com/AndyLeonard)

LinkedIn: [Andy Leonard](http://www.linkedin.com/in/AndyLeonard)

Contact: [https://andyleonard.blog](https://andyleonard.blog)

Andy Leonard is founder and Chief Data Engineer at Enterprise Data  Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of "The Biml Book and SQL Server Integration Services Design Patterns" and author of "Managing Geeks - A Journey of Leading by Doing", "Data Integration Lifecycle Management with SSIS", "Building Custom Tasks for SSIS", and the "Stairway to Integration Services". Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

**John Morehouse**

Twitter:  - [SQLrUs](https://www.twitter.com/SQLrUs)

LinkedIn: [John Morehouse](https://www.linkedin.com/in/sqlrus)

Contact: [http://www.sqlrus.com](http://www.sqlrus.com)

John Morehouse is currently a Consultant with Denny Cherry  Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server.  He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member  Community Ambassador, and 2016 Idera Ace.  John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible.  He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

**John Morehouse**

Twitter:  - [SQLrUs](https://www.twitter.com/SQLrUs)

LinkedIn: [John Morehouse](https://www.linkedin.com/in/sqlrus)

Contact: [http://www.sqlrus.com](http://www.sqlrus.com)

John Morehouse is currently a Consultant with Denny Cherry  Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server.  He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member  Community Ambassador, and 2016 Idera Ace.  John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible.  He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

**Sponsor Session**

Sponsor Lunch Session

**Dave Bland**

Twitter:  - [@SQLDave29](https://www.twitter.com/@SQLDave29)

LinkedIn: [Dave Bland](https://www.linkedin.com/in/dave-bland-sql-server)

Contact: [https://www.davebland.com](https://www.davebland.com)

Over 20 years of SQL Server experience that includes being a DBA,  BI development and Application development using VB.NET.  Dave currently is the Manager of the DBA team at Stericycle.  Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQLSaturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD  • MCSE: Data Management and Analytics

**David Patrick**

Twitter:  - [DavidEPatrick](https://www.twitter.com/DavidEPatrick)

LinkedIn: [David Patrick](http://www.linkedin.com/in/davidepatrick)

Contact: [http://www.madsharepoint.com](http://www.madsharepoint.com)

Dave has been developing database applications for over 25 years. An MCT since 2001, he has taught many classes from Intro to Visual Interdev to Advanced SharePoint Development. Dave runs two user groups, the Maryland and Pennsylvania Microsoft Developers User Group, www.mapamdug.com, and MAD SharePoint, www.madsharepoint.com. Dave does SharePoint training and development for DSA, Inc., a DoD contractor that does great work for the Army over at Aberdeen Proving Ground. Dave is also an MVP.

**Wayne Sheffield**

Twitter:  - [@DBAWayne](https://www.twitter.com/@DBAWayne)

LinkedIn: [Wayne Sheffield](http://www.linkedin.com/in/WayneSheffield)

Contact: [http://blog.waynesheffield.com/wayne](http://blog.waynesheffield.com/wayne)

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

**Chris Bell**

Twitter:  - [@cbelldba](https://www.twitter.com/@cbelldba)

LinkedIn: [Chris Bell](http://www.linkedin.com/pub/christopher-bell/19/a08/93/)

Contact: [https://www.wateroxconsulting.com/](https://www.wateroxconsulting.com/)

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.

**Angela Henry**

Twitter:  - [SQLSwimmer](https://www.twitter.com/SQLSwimmer)

LinkedIn: [Angela Henry](http://www.linkedin.com/in/angelahenrydba)

Contact: [http://SQLSwimmer.com](http://SQLSwimmer.com)

Angela is a Solution Architect, living in High Point, NC and loves what she does. She's worked with all versions of SQL Server  worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She has her MSCE in Data and Analytics (f.k.a., Business Intelligence), is a Data Platform MVP, and a Microsoft Certified Trainer (MCT).  She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in or at the pool, she's an avid US Masters Swimmer, Coach and Instructor.

**John Miner**

Twitter:  - [https://twitter.com/JohnMiner3](https://www.twitter.com/https://twitter.com/JohnMiner3)

LinkedIn: [John Miner](https://www.linkedin.com/in/minerjohn/)

Contact: [https://www.mssqltips.com/sqlserverauthor/154/john-miner/](https://www.mssqltips.com/sqlserverauthor/154/john-miner/)

John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.

He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.

He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island.  Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.

Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.

**Jim Donahoe**

Twitter:  - [SQLFlipFlopsDBA](https://www.twitter.com/SQLFlipFlopsDBA)

Contact: [http://www.sqlflipflopsdba.com](http://www.sqlflipflopsdba.com)

Jim is a Premier Field Engineer for Microsoft in the Data/AI space.  He lives in Pittsburgh in a small suburb.  He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS).  He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.

**Bhakthi Liyanage**

Twitter:  - [@bhakthil](https://www.twitter.com/@bhakthil)

LinkedIn: [Bhakthi Liyanage](https://www.linkedin.com/in/bhakthi-liyanage/)

Bhakthi Liyanage is a seasoned IT professional with many years of industry experience, a Microsoft MVP on AI, and is currently working as an AI Architect at one of the largest banks in the US where he leads projects to provide predictive analytics and AI solutions for complex business problems.

**Slava Murygin**

Twitter:  - [SlavaSQL](https://www.twitter.com/SlavaSQL)

LinkedIn: [Slava Murygin](https://www.linkedin.com/pub/slava-murygin/9/b95/858)

Contact: [http://slavasql.blogspot.com/](http://slavasql.blogspot.com/)

Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a  contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses,  cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

**Andy Leonard**

Twitter:  - [AndyLeonard](https://www.twitter.com/AndyLeonard)

LinkedIn: [Andy Leonard](http://www.linkedin.com/in/AndyLeonard)

Contact: [https://andyleonard.blog](https://andyleonard.blog)

Andy Leonard is founder and Chief Data Engineer at Enterprise Data  Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of "The Biml Book and SQL Server Integration Services Design Patterns" and author of "Managing Geeks - A Journey of Leading by Doing", "Data Integration Lifecycle Management with SSIS", "Building Custom Tasks for SSIS", and the "Stairway to Integration Services". Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

**Jamie Wick**

Twitter:  - [Jamie_Wick](https://www.twitter.com/Jamie_Wick)

LinkedIn: [Jamie Wick](https://www.linkedin.com/in/jamiewick/)

Contact: [http://blog.wicktech.net](http://blog.wicktech.net)

Jamie Wick is the Systems  Database Engineer for The College of William  Mary and has been working with SQL databases for the past 10+ years.  His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Masters degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications.  He is the Chapter Leader of the Richmond SQL Server Users Group, a volunteer and speaker at regional SQL events (User Groups/SQLSaturdays), helps run the SQLSaturday RVA events, and is an avid photographer.

**Azhagappan Arunachalam**

Az Arunachalam has been working with SQL server since v4.21/SQLNT.  He started his career with troubleshooting at chip level, worked as a network engineer managing Novell NetWare networks, graduated into managing Windows NT, moved onto development, administered databases, and is currently working as a database architect.  He#39;s excited about all the cloud offerings that Microsoft and others have made possible, and in sharing his findings with aspiring data enthusiasts.

**Greg Moore**

Twitter:  - [@stridergdm](https://www.twitter.com/@stridergdm)

LinkedIn: [Greg Moore](https://www.linkedin.com/in/gregdmoore)

Contact: [https://blog.greenms.com](https://blog.greenms.com)

Greg Moore is a graduate of RPI. There, he majored in CompSci, but probably spent as much time hiking, canoeing, caving and rock-climbing as he did studying.
He started working with SQL Server 4.21a in 1995 and has survived numerous upgrades.
He's been a Director and later VP of IT at several startups including PowerOne Media, TownNews and Traffiq and now consults. These days, when he's not busy with playing with SQL Server or spending time with his family, he can often be found underground caving or teaching cave rescue with the NCRC.
While his focus is on the operations side of DBA, his interests include DR, performance and general IT problem solving.
He is the author of: IT Disaster Response: Lessons Learned in the Field.

**Jon Tupitza**

Twitter:  - [JTupitza](https://www.twitter.com/JTupitza)

LinkedIn: [Jon Tupitza](http://linkedin.com/in/jontupitza)

Contact: [http://www.jon-tupitza.com](http://www.jon-tupitza.com)

Jon Tupitza  has two decades of experience in providing data platform, business intelligence and data science solutions to Public Sector customers.
Tupitza served as a Senior Business Intelligence  SQL Server consultant for Microsoft’s U.S. Public-Sector Consulting Services where he supported clients including Civilian, DoD and Intelligence Community agencies. His other prior experience includes serving as a Managing Consultant at SolidQ, a global provider of BI, analytics and data management consulting services, and as a Principal Solution Developer at Avanade, a global Microsoft-focused IT consulting services company

**John Morehouse**

Twitter:  - [SQLrUs](https://www.twitter.com/SQLrUs)

LinkedIn: [John Morehouse](https://www.linkedin.com/in/sqlrus)

Contact: [http://www.sqlrus.com](http://www.sqlrus.com)

John Morehouse is currently a Consultant with Denny Cherry  Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server.  He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member  Community Ambassador, and 2016 Idera Ace.  John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible.  He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

**Sponsor Session**

Sponsor Lunch Session

**Anders Pedersen**

Twitter:  - [@arrowdrive](https://www.twitter.com/@arrowdrive)

LinkedIn: [Anders Pedersen](https://www.linkedin.com/in/anders-pedersen-993676)

Contact: [http://blog.AndersOnSQL.com](http://blog.AndersOnSQL.com)

20+ years of experience with SQL Server, from version 6.0 to 2017.  Funnily enough, the only certification I have is on SQL 2012, the one version I have never used.
Mostly worked at medium sized companies, by choice.  Was a consultant for 6+ years, working on anything from facility security systems, background checks, retail PoS systems, to major financial systems.
Passion for performance, and teaching people easy ways to better SQL performance.

**Brian Hansen**

Twitter:  - [tf3604](https://www.twitter.com/tf3604)

Contact: [http://www.tf3604.com](http://www.tf3604.com)

Brian is a database administrator at Children International in Kansas City.  He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.

**Alex Grinberg**

LinkedIn: [Alex Grinberg](https://www.linkedin.com/in/alex-grinberg-36773a6/)

I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book "XML and JSON Recipes for SQL Server", also wrote number of articles for Simple-Talk and SQLServerCentral.com

**Meagan Longoria**

Twitter:  - [mmarie](https://www.twitter.com/mmarie)

LinkedIn: [Meagan Longoria](http://www.linkedin.com/in/meaganlongoria/)

Contact: [http://datasavvy.me](http://datasavvy.me)

Meagan Longoria is a business intelligence consultant with Denny Cherry  Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).

**Sponsor Session**

Sponsor Lunch Session

**Ray Kim**

Twitter:  - [PianoRayK](https://www.twitter.com/PianoRayK)

LinkedIn: [Ray Kim](https://www.linkedin.com/in/pianorayk)

Contact: [https://pianorayk.wordpress.com/](https://pianorayk.wordpress.com/)

Ray Kim is an advocate for documentation and technical communication. He is a co-founder of the Albany, NY SQL group (CASSUG), a member of the AlbanyUX user group, and has spoken at numerous SQLSaturdays and at PASS Summit. He has worked various positions in technology, including as a developer, webmaster, analyst, technical writer, and instructor. He holds an MS in technical communication from Rensselaer Polytechnic Institute and a BS in computer science from Syracuse University.

A musician in his spare time, Ray plays four different instruments. He also enjoys going to ball games and doing CrossFit, and is a two-time SQLServerCentral.com fantasy football champion. He lives in Troy, NY with his wife, Lianne, and their two cats.

**John Miner**

Twitter:  - [https://twitter.com/JohnMiner3](https://www.twitter.com/https://twitter.com/JohnMiner3)

LinkedIn: [John Miner](https://www.linkedin.com/in/minerjohn/)

Contact: [https://www.mssqltips.com/sqlserverauthor/154/john-miner/](https://www.mssqltips.com/sqlserverauthor/154/john-miner/)

John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.

He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.

He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island.  Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.

Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.

**Jim Donahoe**

Twitter:  - [SQLFlipFlopsDBA](https://www.twitter.com/SQLFlipFlopsDBA)

Contact: [http://www.sqlflipflopsdba.com](http://www.sqlflipflopsdba.com)

Jim is a Premier Field Engineer for Microsoft in the Data/AI space.  He lives in Pittsburgh in a small suburb.  He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS).  He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.

## Sponsors
The following is a list of sponsors that helped fund the event:

- [Microsoft Corporation](https://www.microsoft.com/en-us/server-cloud/products/sql-server/)

- [SentryOne](https://www.sentryone.com/)

- [Chartway Federal Credit Union](https://www.chartway.com/)

- [Marathon Consulting](http://www.marathonus.com)

- [Solvaria](http://www.solvaria.com)

- [SQL Data Partners LLC](http://www.sqldatapartners.com/podcast)

- [Denny Cherry and Associates Consulting](http://www.dcac.co)

- [Vaco Hampton Roads](https://www.vaco.com/)

- [SQLSaturday Atlanta](http://www.atlantamdf.com/)

- [TECHEAD](http://www.techead.com)

- [Devada](https://devada.com/)

- [C# Corner](https://c-sharpcorner.com)

- [SQLGrease](https://www.sqlgrease.com)

- [COZYROC](http://bit.ly/cozyrocssis)

- [Pure Storage](http://www.purestorage.com)

- [Redgate Software](http://www.red-gate.com/)

- [SQL Espresso](https://sqlespresso.com/)

- [Dallas DBAs](http://www.dallasdbas.com)

- [SQL Swimmer](https://sqlswimmer.wordpress.com/)

- [JMorehouse Consulting, LLC](http://dbawithabat.com)

- [SQLCoop.com, LLC](https://www.youtube.com/channel/UCc1u_C8ukXd1Lkd9uF-Tj4w/videos?view=0sort=pview_as=subscriberflow=grid)

- [ECPI University](https://www.ecpi.edu/locations/virginia-beach-va)

[Back to the SQLSaturday Event List](/past)

[Back to the home page](/index)

repository: red-gate/sql-saturday-website

extension: markdown

repo_name: red-gate/sql-saturday-website


text:
# `use_loader_rule`: Add a Loader Ruée

## Description

 Adds a loader rule that is not yet implemened in packer.

## Usage

```r
use_loader_rule(packages, test, ..., use = as.list(packages))
```

## Arguments

Argument      |Description
------------- |----------------
```packages```     |     NPM packages (loaders) to install.
```test```     |     Test regular expression test which files should be transformed by the loader.
```...```     |     Any other options to pass to the rule.
```use```     |     Name of the loaders to use for `test` .

## Details

 Reads the `srcsjs/config/loaders.json` and appends the rule.

license: MIT

repository: flrd/packer

branch_name: refs/heads/master

extension: md

license_type: permissive

repo_name: flrd/packer


text:
# Useless return in setter
Returning a value from a property setter function is useless, since it will always be ignored.

## Recommendation
Remove the return statement altogether, or replace it with a simple `return;` statement that does not return a value.

## Example
The following example shows a constructor function `Point` that uses property accessors on `x` and `y` to ensure that they are only set to integer values. It returns the new values for `x` and `y` from their setters, but these return values will simply be ignored.

```javascript
function Point(x, y) {
	return {
		get x() { return x; },
		set x(_x) { x = _x|0; return x; },
		get y() { return y; },
		set y(_y) { y = _y|0; return y; }
	};
}
```
It would be clearer to omit the return statements:

```javascript
function Point(x, y) {
	return {
		get x() { return x; },
		set x(_x) { x = _x|0; },
		get y() { return y; },
		set y(_y) { y = _y|0; }
	};
}
```

## References
* Mozilla Developer Network: [Property setters](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Functions/set).

branch_name: refs/heads/main


text:
---
layout: app

permalink: /CozyDrive/
description: Save them safely in your open source personal cloud, access them anywhere, anytime with the mobile application and share them with the world or just your friends and colleagues. You can host your own Cozy Cloud, and or use the hosting services. Your freedom to chose is why you can trust us.
license: AGPL-3.0

screenshots:
  - CozyDrive/screenshot.png

authors:
  - name: cozy-labs
    url: https://github.com/cozy-labs

links:
  - type: GitHub
    url: cozy-labs/cozy-desktop
  - type: Download
    url: https://github.com/cozy-labs/cozy-desktop/releases

desktop:
  Desktop Entry:
    Name: Cozy Drive
    Comment: Save them safely in your open source personal cloud, access them anywhere,
      anytime with the mobile application and share them with the world or just your
      friends and colleagues. You can host your own Cozy Cloud, and or use the hosting
      services. Your freedom to chose is why you can trust us.
    Exec: AppRun
    Terminal: false
    Type: Application
    Icon: cozydrive
    X-AppImage-Version: 3.4.2-beta.4.4513
    X-AppImage-BuildId: e4950840-fd51-11a7-2b77-95a3cff6b30a
    StartupNotify: true
    Categories: Network
  AppImageHub:
    X-AppImage-Signature: no valid OpenPGP data found. the signature could not be verified.
      Please remember that the signature file (.sig or .asc) should be the first file
      given on the command line.
    X-AppImage-Type: 2
    X-AppImage-Architecture: x86_64
    X-AppImage-Payload-License: AGPL-3.0

electron:
  version: 3.4.2-beta.4
  description: Cozy Drive is a synchronization tool for your files and folders with
    Cozy Cloud.
  homepage: https://github.com/cozy-labs/cozy-desktop
  author: Cozy Cloud<EMAIL_ADDRESS>(https://cozycloud.cc/)
  license: AGPL-3.0
  bugs:
    url: https://github.com/cozy-labs/cozy-desktop/issues
  main: gui/main.js
  repository:
    type: git
    url: git://github.com/cozy-labs/cozy-desktop.git
  dependencies:
    async: "^2.1.5"
    auto-launch: "^5.0.3"
    babel-polyfill: "^6.26.0"
    bluebird: "^3.5.0"
    btoa: 1.1.2
    bunyan: "^1.8.10"
    chokidar: 1.7.0
    commander: 2.9.0
    cozy-client-js: "^0.3.13"
    electron-fetch: "^1.1.0"
    electron-main-notification: "^1.0.1"
    electron-positioner: "^3.0.0"
    electron-proxy-agent: "^1.0.2"
    electron-updater: 2.17.6
    fs-extra: "^3.0.0"
    isomorphic-fetch: 2.2.1
    lnk: "^1.1.0"
    lodash: "^4.17.4"
    lodash.debounce: "^4.0.8"
    micromatch: 3.0.2
    mime: "^1.3.4"
    node-fetch: 1.7.0
    node-uuid: "^1.4.8"
    opn: 5.0.0
    pouchdb: "^6.2.0"
    pouchdb-find: "^6.2.0"
    progress: "^2.0.0"
    read: 1.0.7
    readdirp: 2.1.0
    request-json-light: 0.5.25
    trash: "^4.0.1"
    uuid: "^3.0.1"
    yargs: "^10.0.3"
---

gha_license_id: NOASSERTION


text:
# ✏✏Resume of Java Software Engineer <GitHubLink repo="JoeyBling/cv"/>

- English | [中文](cv.md)

> **Welcome to Use And Star project support，If encounter a problem in using process，You can put forward Issue，I will try my best to perfect it.**

## Introduction
- Function is still very few, welcome to give me Suggestions and Suggestions ~
- **This project originated from：[https://github.com/zhaoky/flqin](https://github.com/zhaoky/flqin "https://github.com/zhaoky/flqin")。Great respect to the author。**

## Online Preview

> **Preview ➡ [https://zhousiwei.gitee.io/cv/](https://zhousiwei.gitee.io/cv/)**

## Project Screenshots

[![zhousiwei's resume](../assets/opensource/en/1_mini.png "zhousiwei's resume")](https://zhousiwei.gitee.io/cv/ "zhousiwei's resume")
[![zhousiwei's resume](../assets/opensource/en/2_mini.png "zhousiwei's resume")](https://zhousiwei.gitee.io/cv/ "zhousiwei's resume")
[![zhousiwei's resume](../assets/opensource/en/3_mini.png "zhousiwei's resume")](https://zhousiwei.gitee.io/cv/ "zhousiwei's resume")
[![zhousiwei's resume](../assets/opensource/en/4_mini.png "zhousiwei's resume")](https://zhousiwei.gitee.io/cv/ "zhousiwei's resume")
[![zhousiwei's resume](../assets/opensource/en/5_mini.png "zhousiwei's resume")](https://zhousiwei.gitee.io/cv/ "zhousiwei's resume")

## Local Preview
1. Install `node.js/npm`
> Refer to My Article ➡ [Linux或Win下安装node和npm](https://www.jianshu.com/p/f8b0a4f7a822)

2. Run
```bash
npm install
npm run dev
```

## Compile
```bash
npm run build   //or `yarn run build`
```

## Project support

### [@korey/MVVM](https://github.com/zhaoky/mvvm)

> A simple MVVM framework, which currently implements the functions of data-binding and view-refresh, is still being optimized and updated. Welcome to learn and exchange ideas.

### [@korey/Fullpage](https://github.com/zhaoky/fullpage)

> A simple Fullpage framework, the current implementation of up and down, pulley rolling, direct anchor full-screen page-turning function, is still continuing to optimize and update, welcome to learn exchange.

**Always trying, never giving up**
> Not impetuous, not radical, not conservative, love programming, love the back end, love new technology, love sports, love travel, execution and learning ability are awesome!

# About Me
- [Personal blog](https://zhousiwei.gitee.io/)
- [Opensource Project](https://zhousiwei.gitee.io/ibooks/opensource)
- [GitHub](https://github.com/JoeyBling)
- [Gitee](https://gitee.com/zhousiwei)
- [notes](https://www.jianshu.com/u/02cbf31a043a)
- [CSDN](https://blog.csdn.net/qq_30930805)
- [zhihu](https://www.zhihu.com/people/joeybling)
- [weibo](http://weibo.com/jayinfo)
- **Major Technology：`Java`、`Third Party Pay`、`Wechat_Mp`、`Open Source Enthusiasts`、`Linux`**

## License

[Apache License](https://github.com/JoeyBling/cv/blob/master/LICENSE)

repository: JoeyBling/ibooks

gha_language: JavaScript

gha_license_id: MIT

repo_name: JoeyBling/ibooks


text:
Diffable table<!--more-->

### Research
- Manual section + uitable + diffable source: https://blog.mallow-tech.com/2021/01/diffable-datasource-in-tableview-and-collection-view-in-ios/
- UITableViewDiffableDataSource: https://developer.apple.com/documentation/uikit/uitableviewdiffabledatasource
- Manual section + UITable + diffable source (with github code): https://alfianlosari.medium.com/using-diffable-data-source-ios-13-api-in-uitableview-47343c2332be
- diffable table Example https://wwdcbysundell.com/2019/diffable-data-sources-first-look/
- Diffable data source (a lot of good detailed info):  https://www.donnywals.com/modern-table-views-with-diffable-data-sources/
- Diffable data source + section https://stackoverflow.com/questions/63981508/uitableview-diffable-data-source
- For macOS: NSTableViewDiffableDataSource https://developer.apple.com/documentation/appkit/nstableviewdiffabledatasource
- For macOS NSCollectionView: https://developer.apple.com/documentation/appkit/nscollectionviewdiffabledatasource
- Search with diffable: ✨ https://dev.to/ahmed_komsan12/getting-started-with-diffable-data-source-2581

### Keep your identifiers simple and to the point
When you choose your identifiers for your diffable data source and snapshot, try to make sure they only include data that will be rendered or influences the rendering. When I was stuck with reloading my cells, I was using NSManaged object subclasses to drive my data source. This seems to work well enough because everything was there. Items were added, removed and reordered. However, for some reason, my data source never seemed to pick up changes to the properties of my managed objects. I eventually got around this by providing a struct that contained the data I wanted to render rather than the entire managed object. A nice way I've found to define these structs is as extensions on the models themselves:

```swift
extension MyModel {
  struct Diffable {
    let id: UUID
    let title: String
    let subtitle: String
    // other properties that will be rendered on the cell
    init(model: MyModel) {
      self.id = model.id
      self.title = model.title
      self.subtitle = model.subtitle
    }
  }
}
```

### Always create typealiases of datasources:
```swift
fileprivate typealias UserDataSource     = UICollectionViewDiffableDataSource<ViewController.Section, Contact>
fileprivate typealias DataSourceSnapshot = NSDiffableDataSourceSnapshot<ViewController.Section, Contact>
```

When using this approach, you'd replace the MyModel item identifier with MyModel.Diffable, and when you create your snapshot, you must convert all MyModel instances to MyModel.Diffable. Since the initializer for the MyModel.Diffable object takes an instance of MyModel this is fairly straightforward:

### Hide in-activce sections:
- https://stackoverflow.com/questions/28947139/how-to-hide-uitableviewsections-in-swift
- https://stackoverflow.com/questions/6489731/hide-or-remove-section-from-uitableview
- https://medium.com/@novall/how-to-cleanly-hide-a-uitableview-section-4e11d43741e3

## Other links:
- Discussion regarding animation issues: https://stackoverflow.com/questions/58475481/how-to-get-a-diffable-snapshot-from-an-nsfetchresultscontroller-in-ios-13

### Gotchas:
- instead of storing data in an array, use a currentSnapshot variable as the one source of truth

### Resources
- Consider using type safe identifiers in model: https://www.swiftbysundell.com/articles/type-safe-identifiers-in-swift/
- Wrapper around row: https://stackoverflow.com/a/59790173/5389500
- Diffable data source utils: https://github.com/ivanvorobei/SPDiffable

### Thoughts:
- What about making the all `a-z` sections upfront. And then only showing the sections that has items. that way you dont have to generate the sections on the fly ✅

### Todo:
- Go through this: has a lot of diffable examples and demos: https://developer.apple.com/documentation/uikit/views_and_controls/collection_views/implementing_modern_collection_views
- And this: https://developer.apple.com/documentation/uikit/uiimage/building_high-performance_lists_and_collection_views

gha_language: HTML


text:
# Swagger APIs

## quantumleap.yml (WIP)

This example uses the [Connexion](https://github.com/zalando/connexion) library
on top of Flask.

To run the server for testing you can execute the following:

```bash
connexion run specification/quantumleap.yml --mock=all -v -p 8668
```

and open your browser to here:

```basj
http://<IP_ADDRESS>:8668/v2/ui/
```

Or, go to your QuantumLeap deployment to the `/v2/ui` endpoint.

repository: FIWARE-GEs/quantum-leap

gha_language: Python

repo_name: FIWARE-GEs/quantum-leap


text:
Sharemarks Test Pages Server
-------------------

The server runs on port 8765 and is required for unit tests that load html pages

Installation Instructions for Mac OS X:
* Install homebrew from http://brew.sh/
* Install node: brew install npm

Installation Instructions for Ubuntu:
* Install node (note that this might remove a package named node, which you won't need unless you're into amateur packet radio): sudo apt-get install nodejs-legacy npm

Installation Instructions for Windows:
* Install node from https://nodejs.org/en/

Running:
* Download dependencies: npm install
* Start the server: npm start
* Check it's working by loading this URL in your favourite browser: http://localhost:8765
* To access localhost from the android emulator use IP <IP_ADDRESS>

repository: appham/Sharemarks

repo_name: appham/Sharemarks


text:
---
# Display name
title: Dongjin Song

# Username (this should match the folder name)
authors:
- admin

# Is this the primary user of the site?
superuser: true

# Role/position
role: Assistant Professor of CSE

# Organizations/Affiliations
organizations:
- name: University of Connecticut
  url: "https://uconn.edu"

# Short bio (displayed in user profile at end of posts)
bio: My research interests include distributed robotics, mobile computing and programmable matter.

interests:
- Machine Learning
- Data Mining
- Deep Learning
- Time Series Analysis
- Graph Representation Learning
- Federated Learning

education:
  courses:
  - course: Ph.D. in ECE
    institution: University of California, San Diego (UCSD)
    year: 2016
  - course: MPhil
    institution: The Hong Kong Polytechnic University
    year: 2010
  - course: B.Eng
    institution: University of Science and Technology of China (USTC)
    year: 2007

# Social/Academic Networking
# For available icons, see: https://sourcethemes.com/academic/docs/page-builder/#icons
#   For an email link, use "fas" icon pack, "envelope" icon, and a link in the
#   form<EMAIL_ADDRESS>or "#contact" for contact widget.
social:
- icon: envelope
  icon_pack: fas
  link<EMAIL_ADDRESS>  #'#contact'  # For a direct email link, use<EMAIL_ADDRESS>#- icon: twitter
#  icon_pack: fab
#  link: https://twitter.com/GeorgeCushen
- icon: google-scholar
  icon_pack: ai
  link: https://scholar.google.com/citations?user=BJdHw6AAAAAJ&hl=en
- icon: github
  icon_pack: fab
  link: https://github.com/songdj
# Link to a PDF of your resume/CV from the About widget.
# To enable, copy your resume/CV to `static/files/cv.pdf` and uncomment the lines below.
# - icon: cv
#   icon_pack: ai
#   link: files/cv.pdf

# Enter email to display Gravatar (if Gravatar enabled in Config)
email<EMAIL_ADDRESS>
# Organizational groups that you belong to (for People widget)
#   Set this to `[]` or comment out if you are not using People widget.
user_groups:
- Principal Investigators
#- Visitors
---

I am an assistant professor in the Department of Computer Science and Engineering, [University of Connecticut](https://uconn.edu) (UConn). Before that, I was a research staff member at [NEC Labs America](http://www.nec-labs.com) in Princeton, NJ, since July 2016. In June 2016, I received my Ph.D. degree in the Department of Electrical and Computer Engineering from [University of California San Diego](https://www.ucsd.edu) (UCSD) with the guidance of [Prof. David A. Meyer](https://math.ucsd.edu/people/profiles/david-meyer/). My thesis committee includes [Prof. Lawrence Saul](https://cseweb.ucsd.edu/~saul/), [Prof. Nuno Vasconcelos](http://www.svcl.ucsd.edu/~nuno/), [Prof. Gert Lanckriet](http://eceweb.ucsd.edu/~gert/), and [Prof. Julian McAuley](https://cseweb.ucsd.edu/~jmcauley/). I also work closely with [Prof. Dacheng Tao](https://www.sydney.edu.au/engineering/about/our-people/academic-staff/dacheng-tao.html) from the University of Sydney.

I have broad research interests in machine learning, data mining, deep learning, federated learning, and related applications for time series representation, similarity search, prediction/forecasting, and anomaly detection (with data from IoT devices, healthcare, smart city, environmental science, etc.). I am also interested in graph representation learning with applications to link prediction, node classification, recommendation, dynamic systems, etc.

** Recruiting: ** ***Looking for Ph.D. students to jointly work with Prof. [Bing Wang](https://bing.cse.uconn.edu/) at UCONN CSE! If you are interested in working on machine learning/deep learning/reinforcement learning/federated learning, please send me an email with your CV and transcript.***

| News            |                                   |
| --------------------| --------------------------------- |
|`Feb 2023`| One paper is accepted to Annual Conference on Information Sciences and System (CISS) 2023, Congratulations to Yushan!|
|`Jan 2023`| Two papers are accepted to ICLR 2023! Congratulations to Chang, Yang, and all collaborators!|
|`Dec 2022`| Our tutorial proposal about "Continual Graph Learning" is accepted to WWW 2023! Congratulations to Xikun, Yushan, and Zijie!|
|`Dec 2022`| I am invited to serve as an Associate Editor for Neurocomputing journal (IF=5.719)! |
|`Dec 2022`| I will serve as a Senior PC for IJCAI 2023! |
|`Nov 2022`| I am invited to give a talk about "Continual Graph Learning" at the CS department of University of Central Florida on November 17th, 2022! |
|`Nov 2022`| Our tutorial proposal about "Continual Graph Learning" is accepted to SDM 2023! Congratulations to Xikun, Yushan, and Zijie!|
|`Nov 2022`| One paper is accepted to Smart Health and another paper gets accepted to Computational and Structural Biotechnology Journal! Congratulations to all collaborators! |
|`Oct 2022`| One paper is accepted to IEEE International Conference on Big Data! Congratulations to Wei and all co-authors! |
|`Oct 2022`| I am invited to give a talk about "Harnessing Deep Neural Networks forMultivariate Time Series Analysis" at the CS department of University of Georgia on Oct 28th, 2022! [Link](https://cps.uga.edu/index.php/data-science-and-ai-seminars/) |
|`Oct 2022`| I am honored to received another Gift Fund from NEC Labs America (NECLA) as Sole PI! Thanks for the support, [NECLA](https://www.nec-labs.com/)!|
|`Sep 2022`| Two papers are accepted to NeurIPS 2022 (one to the main track and one to the dataset and benchmark track)! Congratulations to Yang, Xikun, and all collaborators! |
|`Sep 2022`| One paper about Continual Graph Learning **(CGL)** is accepted to ICDM 2022! Congratulations to Xikun! |
**[More News...](https://songdj.github.io/news/)**


text:
---
title: "When automation goes horribly right"
date: "2018-12-03T00:00:00+1300"
description: "What do you do when a UI element disappears but the service powering it still persists?"
 There were a bunch of things from quick replies to profile-listed support hours which I'm sure were of some use.

I used the latter but I also enabled "welcome messages": automated replies that would trigger when a "customer" opened your direct messages. In my case, I'm not a business so it was more just some silliness to add to my profile and it confused a few people along the way.

![A screenshot of a Twitter direct message. On the left is an automated message from the user. It reads "Hey there, lease a message after the beep. This has been an automated message". On the right is a reply from a surprised user who asks how the automated message was created.](confusion-one.png)

Over time, I'd forget that I had it enabled and then someone else would get caught out by it a few months later

![A screenshot of a Twitter direct message, many months after the one just shown previously. On the left are some messages expressing surprise at having found an automated response. On the right is the author expressing confusion, due to having forgot any such automated messages exist.](confusion-two.png)

and then it kept going at which point it started becoming a bit of a nuisance.

![A screenshot of a Twitter direct message. On the left is a user saying that the automated messaging is still intact. On the right is the author, typing in full capital letters to express disbelief, stating that they have tried to turn off this automated feature but can't figure out how.](confusion-three.png)

At this point, I was particularly annoyed and attempted to turn it off. I clearly remembered that there was a dashboard but do you think I could find it? That would be too easy!

You can actually see a walkthrough of that very page right [here](https://youtu.be/H-n0hRO7oLk?t=75) but good luck finding it because it was actually removed.

At first I didn't believe it. I just figured I had forgotten how to navigate to it but every month, I'd try once again to track it down with no luck. Eventually, I just resigned myself to the fact that some automation was running somewhere inside Twitter and I could never turn it off.

Things changed. I started a new job as a Site Reliability Engineer funnily enough. I would laugh to myself whenever we discussed service availability. Inevitably, it would come up that Google has planned outages in order to keep downstream providers on their toes and not overly reliant.

I wished so hard that Twitter would have a planned outage but no, apparently this microservice, or whatever it was, never failed. It was perfect and never toppled.

Obviously I couldn't just simply call Twitter and ask them.

Fast forward to today and once more, a confused friend simply messaged me "?". I didn't even have to ask. Whatever this automation was, it never really seemed consistent either. Those who I talked to often would suddenly receive an automated response out of nowhere. Not that I could tell since it wasn't me talking.

Finally I stumbled onto the Twitter Developer forum and… ah! [I wasn't alone!](https://twittercommunity.com/t/defunct-business-auto-dm-feature-no-longer-editable-and-still-sends/116561) I'm not crazy! Someone else remembers this thing!

After a bit of confusion, it was cleared up that the Twitter API has a section for "welcome messages" which are these very same automated snippets. Using [twurl](https://github.com/twitter/twurl), a Twitter-modified version of curl, I could view those darn things finally.

![A screenshot of a Windows terminal. A command has been run and the image depicts the output. The command is a utility called twurl and a GET request is being made to the welcome_messages API endpoint. The output shows a list with one item which is the automated message that this post has been describing. The nightmare is finally over.](welcome-messages.png)

There they were. Sitting within the API the whole time although I'd guess that feature was only documented as part of the recent overhaul of Twitter's developer APIs. Even the original URL, [dashboard.twitter.com](https://dashboard.twitter.com), doesn't resolve anymore which is all the proof I needed that I'd been left out in the cold.

With some copy paste magic, I quickly wiped the slate clean. I was free!

Finally awake from that god awful nightmare.

The Twitter Business Experience was definitely just that…

That just leaves one last question: if it took me many months to fix this problem, what hope do those actual businesses who signed up have?

I guess you get the support you pay for, huh?


text:
CHANGELOG for 3.X
=================

* 3.3.0 (2017-07-22)
 * [PR#386] Allow to define timeout (default 120s) for symfony/assetic-dump task.
 * [PR#392] Allow to define Host Port in Host configuration.
 * Allow to specify the binary path of tar on for create and extract

* 3.2.0 (2017-04-14)
 * Allow to pre-register Custom Tasks
 * [PR#365] New option "from" to define deployment start point
 * Allow to define excludes in the global scope.
 * Improve code quality, remove duplications on Symfony Tasks.
 * Improve code quality, remove duplications on Composer Tasks.
 * [PR#364] Allow to define custom timeout to Composer:Install

* 3.1.0 (2017-02-25)
 * Add new Exec task to execute arbitrary shell commands
 * Add new Composer task, to update phar (composer/self-update)
 * [#344] Allow to flag Filesystem tasks
 * [PR#346] Add new File System task, to change file's modes (fs/chmod)
 * [BUGFIX] [PR#342] Ignore empty exclude lines
 * [PR#330] Allow Composer task options to be overwritten at environment level
 * [PR#330] Add new method Runtime::getMergedOption to merge ConfigOption and EnvOption
 * [Documentation] [PR#333] Improve example config file

* 3.0.1 (2017-01-10)
 * [BUGFIX] [#350] [#353] Fix escape issue when commands are sent through SSH

* 3.0.0 (2017-01-31)
 * v3 series release

repository: OnekO/Magallanes

repo_name: OnekO/Magallanes