text:
---
layout: "post"
title: "SQLSaturday #627 - South Florida 2017"
prettydate: "10 June 2017"
---
# SQLSaturday #627 - South Florida 2017

**Event Date**: 06/10/2017 00:00:00

**Event Location**:
- Nova Southeastern University
- 3301 College Ave
- Davie, Florida

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: Supercharge Your Maintenance Plans!

**Abstract**:
Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies.  From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless.  One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren.  These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.

In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further.  You’ll be amazed at the flexibility offered by the optional parameters.  We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.

**Speaker(s):**
- Troy Gallant

*Track and Room*: Database Administration - 2064

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

## Title: Real World DBA Toolkit: Focus Server

**Abstract**:
If Clothes make the Man, Scripts make the DBA!
Lowell Izaguirre presents his strategy and methodology, featuring a suite of hundreds of stored procedures to allow the analysis,administration and maintenance of server and database objects and "better practices".
This suite of over 75 Server-targeted scripts can turn a Developer or Junior DBA into a superhero.
Scripts identify server level things like memory, disk speed,backups, database mail,Last Accessed databases or tables, and so much more! Make yourself part of the top 10 percent!
Lowell's codebase introduces a unified strategy for a huge list of Server Level DBA Tasks, where the stored procedures identify best practice variances, issues, as well as suggest fixes for the the problems encountered!

**Speaker(s):**
- Lowell Izaguirre

*Track and Room*: Database Administration - 8

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

## Title: Introducing the Limitless DBA-  Copy Data Management, DBA Style

**Abstract**:
Everything in our day to day lives as a DBA is about limits-
•	Limits in space
•	Limits in platform
•	Limits in resources
•	Limits in expertise

This session is about how to remove those limits.  How to provide all the databases you need without having to constantly ask for more disk space.  How to provide a databases as fast as they are needed for new projects, new test cases and new challenges.  How to do more with less time, less people and less hardware and last but not least, how to do all of this without having to become an expert in 20 different languages, products and specialties.

Join Kellyn Pot’Vin-Gorman as she demonstrates why virtualization is key to empowering the database administrator.  This session will cover how to:
•	Ease patching and upgrading.
•	Offer virtualized environments for every project-  development through production with only a 1/3 or the resources once required.
•	How to change OS and database platforms without losing your mind.

**Speaker(s):**
- Kellyn Pot'Vin-Gorman

*Track and Room*: Database Administration - 2

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

## Title: The Next Frontier-  Opportunities When Migrating to the Cloud with Virtualization

**Abstract**:
Cloud is everywhere and the database administrator is caught in the middle. How do you know where to start and what to migrate first? How do you perform consolidation planning and ensure data security? This session builds on a full demonstration, along with tips and tricks to show how the DBA can secure their environment to allow a self-service option so they no longer are the constraints to projects! The attendee will leave with a clear understanding of:
* Principles of virtualization and why it’s the answer to so many challenges we face today.
* How easy it is to secure data in the cloud using data masking features.
* The ease of connecting to the cloud and migrating environments.
* How to troubleshoot when issues arise and the tools available to diagnose issues.

**Speaker(s):**
- Kellyn Pot'Vin-Gorman

*Track and Room*: Database Administration - 7

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

## Title: Performance Dreams started at SQL Server 2014 and come true now at SQL Server 2016

**Abstract**:
“Performance dreams  wait for you at SQL Server 2014 and Come true at SQL Server 2016 “, it is just like this because you there are unbelievable performance reads and substantial improvements that can drive your DB environment to a distinct level of stability and Performance to be a leading environment in a very short time ..! It looks like apparently a myth or legend to see those new SQL Server 2016 features how they could flipped up SQL Server Powers from the old generation to the new generation of in-advanced analytics using In-memory and CCI (Colmnstore indexes) where no longer need for any DWH solutions at all but just reading data directly from production DBs with ZERO performance impacts on end users  ..! come in here to my session and you will know more about many new features and rich powers of SQL Server 2014  2016 regarding performance particularly like  Microsoft project “Hekaton” for In-memory built in for OLTP , CCI( columnstore index) ,Resource Governor for IO consumpti

**Speaker(s):**
- Shehab El-Najjar

*Track and Room*: Database Administration - 2065

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

## Title: T-SQL Performance Guidelines for better DB stress powers

**Abstract**:
To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users nor adequate volume of data exist there but actually they seem totally strange once going to live where they become performing badly ending up eventually with and sharp skew of performance and standstill cases sometimes , this is due to the lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs in particular more therefore I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be explained within this session)

**Speaker(s):**
- Shehab El-Najjar

*Track and Room*: Database Administration - 2067

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

## Title: But I Want it in Excel...

**Abstract**:
As IT professionals we can create reports from SQL using  SSRS, SSMS, Business Objects, Crystal Reports or other popular tools.   How many times have we created something fantastic only to hear the CEO, CFO or sales teams say "That's great... but I want it in Excel".  Ugh!

Instead of fighting your users, make them your partners!  Save time running reports or making small changes for users... empower the business!  You don't have to do the export-import thing!  Learn some basic techniques to interact directly with SQL to create beautiful Pivot Tables and Graphs, right from Excel.  You can even ensure the CxO will always have fresh data and eliminate sync issues with your other reports.

**Speaker(s):**
- Perry Patterson

*Track and Room*: Data Science - 2071

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

## Title: Using PowerQuery to track progress in tuning a stored procedure or complex view

**Abstract**:
Tuning a lengthy stored procedure or complex view can be a challenge. Set Statistics IO On, and have fun wading through lengthy output. Use PowerQuery to organize that output for you so you can see where intensive operations are and how your tuning is progressing.
The focus of this session is PowerQuery, not stored procedures , views or the tuning process. Learn how to read all text files in a folder with PowerQuery, parse the files to retain useful data and then analyze using either Excel or PowerBI. In the process, learn the basics of the PowerQuery Formula Language.

**Speaker(s):**
- Ernest Ostrander

*Track and Room*: Database Administration - 2073

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

## Title: Data Security with Power BI, SSAS, SQL Server and Active Directory

**Abstract**:
Today's Business Intelligence Tools allow to secure the data for a variety of business scenarios. Learn How Row Level Security and other security data technologies can be implemented in Power BI, SSAS, and SQL Server and can change the design of corporate Apps using Active Directory.
In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design and architecture of data security using different tools: Power BI, SSAS, SQL Server, Web Apps and explain when to use them, their differences and their limitations. Throughout the session, we explore and demo various ways to secure the data and witness how to implement the security in each.

**Speaker(s):**
- Hector Villafuerte

*Track and Room*: Business Intelligence - 2071

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

## Title: Virtual HA: Running FCI and AGs in a Virtual Environment

**Abstract**:
High availability can be different in a virtual environment.  Attendees will learn the pros and cons of running SQL Server FCI or Availability Groups in a virtual environment. In this session we will:
Offer a comparison of the different high availability options that exist between all of available technologies.
Discuss how FCI or AG impacts features of VMware and Hyper-V, and how to work with the administrators of your virtual environment.
Walk through all of the storage options in order to determine the best fit for your organization.
Review key settings and configurations for the virtual platform, the virtual machine, and SQL Server; and demonstrate the best settings to ensure top performance.

**Speaker(s):**
- Shawn Meyers

*Track and Room*: Database Administration - 2065

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

## Title: Artificial Intelligence:Canned  Ready to Consume in MS Cognitive Services

**Abstract**:
Microsoft Cognitive Services are a set of APIs, SDKs and services available to developers to make their applications more intelligent, engaging and discoverable. Microsoft Cognitive Services expands on Microsoft’s evolving portfolio of machine learning APIs and 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. Joe will be demonstrating a wide variety of the APIs in multiple clients including PowerApps, Flow and Power BI. He will also be discussing what he learned at Build about new and expanded Cognitive APIs launched there.

**Speaker(s):**
- Joe Homnick

*Track and Room*: Data Science - 2072

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

## Title: Real World DBA Toolkit: Focus Databases

**Abstract**:
If Clothes make the Man, Scripts make the DBA!
Lowell Izaguirre presents his strategy and methodology, featuring a suite of hundreds of stored procedures to  to allow the analysis,administration and maintenance of server and database objects and "better practices".
This suite of over 100 Database-targeted scripts can turn a Developer or Junior DBA into a superhero. Make yourself part of the top 10 percent!
Scripts help with things like scripting objects, fixing heaps, missing indexes, untrusted constraints, and literally hundreds of issues that may exist in a database.
Lowell's codebase introduces a unified strategy for a huge list of Database Level DBA Tasks, where the stored procedures identify issues,  as well as suggest fixes for the the problems encountered!

**Speaker(s):**
- Lowell Izaguirre

*Track and Room*: Database Administration - 1

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

## Title: Create lightning fast Dashboard with Power BI and its Components

**Abstract**:
Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips, You will learn all latest and greatest features of Power BI.

**Speaker(s):**
- Vishal Pawar

*Track and Room*: Power BI and more - 7

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

## Title: Query Store

**Abstract**:
Analyzing query performance can be tricky. It involves knowing several dynamic management views (DMVs) and accessing query plans that are still in the query cache. If you need to get performance metrics for a query which is no longer in the cache, or if your server is restarted it will be an impossible task.
Query Data Store is a new  feature that comes to help DBAs. By persisting query execution data over time, it allows reviewing of statements / plans / properties / statistics.
This session will show you how to enable and use Query Store features, like: obtaining queries with plan changes over time; analyze queries by CPU / Memory / other counters; forcing a plan; and other gems.

**Speaker(s):**
- Sam Mesel

*Track and Room*: Database Administration - 2066

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

## Title: Enabling EDW and BI workloads on Hadoop with Hive / LLAP

**Abstract**:
In its origin, Hadoop was created as a distributed computing system designed to process data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop.  So a few years back the Stinger initiative was created as an ongoing effort to bring interactive SQL querying capabilities to Hive, and its latest release has finally delivered!
In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard,  real world use cases and a live demo.

**Speaker(s):**
- Luis Figueroa

*Track and Room*: Business Intelligence - 2073

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

## Title: Advanced SQL Server execution plans

**Abstract**:
Tired to look at colored and nice shape plans? Want to go further and see geek stuff? Came to this session to explore the query trees, internals and deep analysis on execution plans on SQL Server. This is a advanced session, so, expect to see lots of traceflags, undocumented and nasty execution plans.

**Speaker(s):**
- Fabiano Amorim

*Track and Room*: Database Administration - 4

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

## Title: How to Manage Many Instances of SQL

**Abstract**:
When managing a single instance it can be fairly easy to keep track of the configuration of that instance, but what about when you have more than 10 instances to manage? How do know they are setup correctly?  How do you maintain the databases on each instance and their configurations? How do take care of patching? In this talk we will answer these questions and more as we discuss best practices and technologies (such as PowerShell and CMS) to help keep your instance configurations in-sync.

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

*Track and Room*: Database Administration - 2064

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

## Title: What's new with SQL Server vNext

**Abstract**:
In this session we will be taking a look at the latest advancements in SQL Server vNext, including support for containerization and Linux support. We will also be looking into new features such as clusterless availability groups and retention policies to temporal table.

**Speaker(s):**
- Pankaj Satyaketu

*Track and Room*: Database Administration - 2065

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

## Title: Brand yourself like a pro

**Abstract**:
There are many "social media outlets" but not all of them are "the right one" for you, specially if you don't have a brand. With today tools and methodologies you don't need to be a Kardashian or Zac Efron to build your own brand, or have an army of people to managed it.
Building a brand has to be intentional. You cannot just be you. Discovering the things that make you unique is not enough. You have to package these things in a way that highlights and perhaps even over exaggerates them.
In this interactive session you will learn how to use Social Media to create you personal brand to positioning yourself as a pro, increasing your self confidence, increasing sales and much more.

**Speaker(s):**
- Patricia Monica Ojeda

*Track and Room*: Professional Development - 2074

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

## Title: R Integration in Microsoft Solutions

**Abstract**:
Session Abstract:  R is a very powerful tool that is used for statistical computing and graphics.  R has been adopted by many data scientists around the world and after Microsoft's Revolution Analytics R acquisition is integrated in Microsoft solutions. This introductory session will give a brief history on R and then explain how this popular statistical language is now baked into some of the Microsoft tools such as SQL Server, Power BI, and Azure ML. There will be live demoes that will explain how R can be utilized using each tool.

**Speaker(s):**
- Ryan Fonnett

*Track and Room*: Data Science - 2071

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

## Title: Query Store Primer

**Abstract**:
This session will take a look at the new Query Store feature in SQL Server 2016.  Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise.

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

*Track and Room*: Database Administration - 2065

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

## Title: 5 Things To Consider: Stretching Failover Clustered Instances  Availability Groups to Azure

**Abstract**:
Dealing with SQL Server Failover Clustered Instances and Availability Groups for local high availability is already complicated with a lot of the external dependencies such as the network and the Windows Server Failover Cluster (WSFC.) But it becomes even more complicated when you stretch it out for disaster recovery to Microsoft Azure. In this session, learn the five (5) things that you need to consider when you implement SQL Server Failover Clustered Instances and Availability Group for disaster recovery into Microsoft Azure. We will cover how Active Directory, DNS, WSFC heartbeat and quorum configuration affects deployments of SQL Server Failover Clustered Instances and Availability Group in a disaster recovery site and how to properly configure a client application for connectivity.

**Speaker(s):**
- Edwin M Sarmiento

*Track and Room*: Database Administration - 2064

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

## Title: Data Science: From theory to practice

**Abstract**:
Most of us from Engineering background have learnt Statistics to varying degree in college. With the rising popularity of Data Science, there is tremendous opportunity to put the theory to use in various practical applications.

However, if you have not learnt Statistics earlier, this session will provide the basics of some of the concepts and explain how to apply them to solve various business problems. Some of the examples of topics include Regression, Bayesian, Clustering, and Decision Trees. You will also learn techniques to avoid some of the common pitfalls such as Over-fitting the model.

Finally, the session will give you tidbits to explore advanced concepts on your own.

**Speaker(s):**
- Josh Kodi

*Track and Room*: Data Science - 2072

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

## Title: Who's Afraid of Entity Framework?

**Abstract**:
Do any applications in your environment use SQL written not by a person but by the application itself? No, the system isn't self-aware. Chances are it is using the Microsoft Entity Framework (EF).

EF and other object relational mapping technologies have been a boon for developers. But is EF a technology that developers should even be using? This session reviews what EF is and how it's changed over time. We'll also dive into how it works and what to look for when inspecting a database generated by EF Finally, we'll review EF-generated T-SQL and give some tips on how to improve performance. If you're a data professional who manages databases that are accessed through EF or want a basic knowledge of how EF works, this session is for you.

**Speaker(s):**
- Richie Rump

*Track and Room*: Database Development - 2067

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

## Title: I'm a DBA. Now what?

**Abstract**:
If you are a developer+DBA, consultant+DBA, IT Manager+DBA, Intern+DBA, technical support+DBA or just a DBA, this session will be useful to you. After working for many years as developer and consultant, the SQL Server MVP Fabiano Amorim has being working with many day-by-day DBA tasks. In this session he will speak a little about the DBA job and show some very good tips about how to do it with efficiency.

**Speaker(s):**
- Fabiano Amorim

*Track and Room*: Database Administration - 1

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

## Title: On-Demand Creation of Dev/Test/Reporting Databases with SQL Clone

**Abstract**:
Imagine a world where developers and testers could run production-like environments on their own workstations, created on-demand and self-serviced. Raising tickets and waiting hours or days to get operations to deliver test databases would be a thing of the past.

With Redgate's new tool, SQL Clone, this world now exists. Administrators and developers can create their own database copies in seconds using just MEGABYTES of disk space without ever touching production. Developers can see how their application behaves in a production-scale environment during both development and troubleshooting and operations no longer need to find disk space, provision, etc.

In this session we will examine how SQL Clone uses disk virtualization to enable quick, easy and even automated creation of database copies that are just MB in size.

**Speaker(s):**
- Kevin Boles

*Track and Room*: DevOps - 2066

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

## Title: PowerShell working with Python and SQL Server

**Abstract**:
As PowerShell is the main technology for automation in Windows Datacenters Infrastructure, now becomes clear its importance in other non-Windows Operating Systems. The way I see it, Windows Admin has the advantage with PowerShell as the Linux Admin has the upper hand with Bash/PHP/Python. Here’s where we can collaborate and work with each other.

**Speaker(s):**
- Maximo Trinidad

*Track and Room*: Database Development - 2067

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

## Title: Know What Your Code is Doing to SQL Server!

**Abstract**:
ORMs - oh how I LOVE them! As a consultant when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance and scalability you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.

**Speaker(s):**
- Kevin Boles

*Track and Room*: Database Development - 2066

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

## Title: Architecting a SQL Server AlwaysOn Availability Groups Topology Without Losing Your Sanity

**Abstract**:
So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different topologies to choose from but they’re all the more confusing. Creating effective design architecture is key. In this session, we will look at the different topologies – from simple ones to advance – that you can implement and how to build them. At the end of the session, you will walk away with the knowledge on how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements.

You will learn:

- Common design patterns and guidelines that you need to consider when building your architecture
- Proper selection of quorum configuration
- Network configuration for local and geographically dispersed replicas
- Combining SQL Server Failover Clustering with AlwaysOn Availability Groups

**Speaker(s):**
- Edwin M Sarmiento

*Track and Room*: Database Administration - 2064

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

## Title: So You think You can Speak?

**Abstract**:
If you've ever enjoyed or admired the knowledge and know-how of a speaker at a SQLSaturday or a Summit , remember that they started where you are, with an interest in SQL and I.T. topics, a passion to learn more, but also with the desire to share what they know with their peers.
If you have an interest in SQL or any of the Microsoft Data platform technologies, and have learned something useful in your I.T. career, consider giving back to the community by sharing what you know. While it may seem intimidating to give an hour long talk at an event like this, remember that every great speaker had to start somewhere. And for you, maybe that start is here!
"Do You Think You can Speak" is a friendly competition for anyone, even first time speakers, to share for 5 - 10 minutes on a technical topic, SQL, Business Intelligence, Power BI, or otherwise, that is informative, useful, and entertaining.

**Speaker(s):**
- Diana Betancourt

*Track and Room*: Professional Development - 2074

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

## Title: 2,4,8  16 - Upgrade your journey with SQL Server

**Abstract**:
2,4,8  16 - these aren't just numbers to count or calculate. These are years that how SQL Server evolved as number of years!

Why Upgrade?
Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe  India) and SQLbits since 2008.

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading  SQL Server (2000 to  2012),  SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.

What to-do and what not-to-do?

A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQLSaturday  SQLbits UK.
We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why  how such a solution.

**Speaker(s):**
- Satya Jayanty

*Track and Room*: Enterprise Database Administration - 2065

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

## Title: Concurrency Controls and Isolation Levels in SQL Server

**Abstract**:
SQL Server determines how multiple processes access the same data simultaneously based on the transaction isolation levels.  Because the locking strategy that the database utilizes to control access to data pages is different between the different isolation level settings, the effects on database performance will also be different.  The right isolation level must be chosen to achieve a good balance between data concurrency and performance.  In this session we will review the isolation level options in SQL Server, their effects on data locks, and performance considerations when running under each of the isolation level.

**Speaker(s):**
- Carlos Colon

*Track and Room*: Database Administration - 2064

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

## Title: How the Grinch Stole SQL Server Performance

**Abstract**:
The SQL Server and Data Access frameworks provide developers a rich set of features that help integrating SQL Server as the system database backend in virtually no time. This simplicity, however, often leads to common database design and code mistakes that introduce severe performance issues later when systems work under the heavy load.

This session shows several common mistakes and inefficiencies that can be found in many production systems such as excessive code reuse in the database using the views and multi-statement functions and in the data access code; unnecessary joins and I/O operations in pagination queries; storage of multiple entities in the same tables using XML for entities-specific attributes; usage of the optional parameters in the where clause of the queries; and several others. The session explains the root-cause of performance issues those mistakes introduce and demonstrates how to properly address them in the code and database design.

**Speaker(s):**
- Dmitri Korotkevitch

*Track and Room*: Database Development - 2067

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

## Title: Becoming a Trusted Advisor

**Abstract**:
Innovative Architects has successfully delivered hundreds of projects over the course of our 13 year history using a unique mix of technology excellence and focus on understanding our client’s needs.  The purpose of this session is to discuss these core principles and show how a handful of specific areas of focus can make your projects run more smoothly.  The topics we cover will include technical delivery, likability, resourcefulness, versatility, expectation management and communication. Our time will be spent explaining how we implement these concepts, what we expect from our consultants in each area and how that translates into lower project stress.

**Speaker(s):**
- Jay Alexander

*Track and Room*: Professional Development - 2074

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

## Title: Introduction to Visualizations with R

**Abstract**:
R is a popular scripting language for data science and visualizations. In this talk we will be going over the basics of the ggplot2 library along with data.tables and rtiny for the purposes of data visualization.

**Speaker(s):**
- Stephen Ippolito

*Track and Room*: Data Science - 2071

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

## Title: Azure Data Lake Store  Data Lake Analytics - Let's Go Swimming!

**Abstract**:
Let's take a lap around Azure Data Lake Store  Analytics!  We'll cover what it is, how it's architected, why you might want to use it, and what other tools are involved (U-SQL!).  The session will consist of an overview of the data store and analytics options, a live demo, and some discussion of how it all comes together.

**Speaker(s):**
- Audrey Hammonds

*Track and Room*: Data Science - 2072

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

## Title: Transform SQL Server (by Pureshare)

**Abstract**:
Please join  the local Pure Storage account team for an eye-opening session on how the innovative, industry-disruptive tech in the Pure Storage FlashArray helps your business do everything faster, easier. Faster transactional workloads, analytics, backups and maintenance, all without the pain of having to tweak a thousand knobs to get things to work. Finally a storage array you can love to use, and be proud to own! Come see what the fuss is all about.

**Speaker(s):**
- Robert Torres

*Track and Room*: SQL Server - 2065

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

## Title: Heckin Sweet Reports with Power BI

**Abstract**:
Power BI is constantly evolving; this session is an overview of the current abilities and ways to implement Power BI, based on our experience in the field using it. Topics include the Power BI Service, Power BI Desktop, Pricing models, and intro to SSRS 2016 Preview with Power BI. Sample data set used in this presentation is from @DogRates)

**Speaker(s):**
- Julie Smith

*Track and Room*: Power BI and more - 2071

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

## Title: For Love or Money, Your Tech Career

**Abstract**:
Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue?

Maintaining a steady job with a biweekly direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are using the latest, most marketable technologies?

In this highly interactive group session, you will learn multiple career strategies for maximizing both the Love and the Money of your multidimensional technology career.

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

*Track and Room*: Professional Development - 2074

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

## Title: Transform SQL Server Agility with XtremIO

**Abstract**:
All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.

**Speaker(s):**
- Rodney Rubio

*Track and Room*: Database Administration - 2066

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

## Title: SQL Server Tips  Tricks

**Abstract**:
Whether you are new to SQL Server or a pro; this session will provide you tips and tricks which will save you a lot of time and provide you new ways to do complex tasks quickly and easily. You can also share your own tips in this session.

**Speaker(s):**
- Nadeem Akhter

*Track and Room*: Database Administration - 2067

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

## Title: InMemory Improvements on SQL 2016

**Abstract**:
SQL Server 2016 lifted several limitations from its initial implementation.
This session will cover how to implement InMemory objects, new capabilities (Defaults, Checks, FK validation, Triggers); performance gains; and an introduction to monitoring these objects.

**Speaker(s):**
- Sam Mesel

*Track and Room*: SQL Server - 2065

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

## Title: Big Data with Azure: where to begin? Concepts and best practices

**Abstract**:
In order to ascertain the abilities of cloud computing platform, let us overview what is available  offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.

**Speaker(s):**
- Satya Jayanty

*Track and Room*: Data Science - 2073

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

## Title: Lightweight geo-replication for SQL Server using the Azure Service Bus

**Abstract**:
In this session I will provide an overview of the Azure Service Bus and how to use it directly from SQL Server to send messages between multiple SQL Server databases across the globe. Sending messages to a service allows database administrators to replicate data from one database to another, or to multiple databases using a subscription model. This demo introduces a technology called Enzo Unified to allow direct connectivity to the cloud from SQL Server databases.

**Speaker(s):**
- Herve Roggero

*Track and Room*: Database Administration - 2073

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

## Title: Devops  Continuous Release for the DBA

**Abstract**:
I've been working on a DevOps team for more than year. Join me as I talk about culture, tools, and processes that are all part of the journey to continuous release.  My goal is to get you thinking about how your job as DBA or database developer changes when you're part of a team that is striving to release faster. Part of that will be sharing the tool stack I use right now and why, and some of the many challenges I've hit so far.

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

*Track and Room*: DevOps - 2066

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

## Title: Practical Uses for SQL Server 2016 Dynamic Data Masking

**Abstract**:
Dynamic Data Masking (DDM) allows database administrators to obfuscate data columns containing sensitive data from unauthorized users without changing the data stored in the database.  This new features has some limitations that prevent it from being used as the only mechanism for securing sensitive data, but it does provide additional flexibility to administrators, developers, and support personnel on querying sensitive data and maintaining compliance.  In this session we will explore how to set up Dynamic Data Masking for use in production support and for generating production-like test data.

**Speaker(s):**
- Carlos Colon

*Track and Room*: Database Administration - 2066

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

## Title: Applied Machine Learning with R Programming and Power BI Dashboard

**Abstract**:
This presentation covers the steps necessary to build and use prediction function, along with the development of Power BI visualization. We will apply machine learning method with R Programming language and consider its practical application. In addition to this, we will walk through the steps of creating and integrating a Power BI Dashboard to visualize the enriched data.

**Speaker(s):**
- Adriano da Silva

*Track and Room*: Data Science - 2072

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

## Title: SQL to NoSQL: Querying Azure DocumentDb

**Abstract**:
NoSQL, or "Not only SQL", might be the greatest misnomer ever. This session will discuss NoSQL queries on DocumentDb, server side scripts, and some of the pros and cons of using NoSQL over a traditional RDBMS.

**Speaker(s):**
- Jason Brugger

*Track and Room*: Database Development - 2067

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

## Title: The DBA Career Path - An Open Discussion

**Abstract**:
Join Andy Warren for an open discussion of the challenges and rewards of being a DBA and what the next step on the career path. Is it managing more and larger databases? Working on life critical systems? Moving into management? Or does our path take us more towards BI, or DevOps? No slides, just a lightly moderated discussion!

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

*Track and Room*: Professional Development - 2074

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

## Title: Monitor and maintain your SQL Server environment anytime, anywher

**Abstract**:
Monitor and maintain your SQL Server environment anytime, anywhere, and on any device.   Come join Quest Software for a brief 15 minute presentation on our industry leading solutions.   Anyone who attends is entitled to a free license of the solution of their choice!”

**Speaker(s):**
- Gordon Cornelius

*Track and Room*: DevOps - 2067

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

## Title: Working with SQL Server for Linux Cross-Platform

**Abstract**:
I will be showing the latest build of SQL Server vNext for Linux. Everything you need to install and connect to SQL Server. Then, what tools are available to use from either Linux and Windows. Sample on querying for database information using Python and PowerShell between two environments.  This will be a demo intensive session

**Speaker(s):**
- Maximo Trinidad

*Track and Room*: Database Administration - 2064

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

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

**Fabiano Amorim**

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

LinkedIn: [Fabiano Amorim](https://www.linkedin.com/in/fabianoamorim/)

Contact: [http:\\blogfabiano.com](http:\\blogfabiano.com)

Fabiano Amorim is a Data Platform MVP that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.

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

**Perry Patterson**

LinkedIn: [Perry Patterson](http://www.linkedin.com/in/patter38)

Contact: [http://www.facebook.com/3Deers](http://www.facebook.com/3Deers)

3Deers.com, LLC is an independent consulting firm based on Coral Springs, FL.  We work with and teach organizations how they can better manage their business through expertise in SQL Business Intelligence Reporting, Web Site Development and Project Management.

After 30 years of Information Technology Management for corporations in a variety of fields, Perry T Patterson formed 3Deers to help growing business and charitable organizations improve their efficiency, professionalism and visibility.

**Fabiano Amorim**

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

LinkedIn: [Fabiano Amorim](https://www.linkedin.com/in/fabianoamorim/)

Contact: [http:\\blogfabiano.com](http:\\blogfabiano.com)

Fabiano Amorim is a Data Platform MVP that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.

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

**Fabiano Amorim**

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

LinkedIn: [Fabiano Amorim](https://www.linkedin.com/in/fabianoamorim/)

Contact: [http:\\blogfabiano.com](http:\\blogfabiano.com)

Fabiano Amorim is a Data Platform MVP that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.

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

**Carlos Colon**

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

LinkedIn: [Carlos Colon](https://www.linkedin.com/in/carlos-colon-5379875)

Carlos is a certified SQL Server professional and a senior software developer. As a 20 year veteran, Carlos leads Dobler Consulting’s database managed services practice. He’s also a certified PMP and holds a B.S. in Management of Information Systems.

**Dmitri Korotkevitch**

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

LinkedIn: [Dmitri Korotkevitch](https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7)

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

Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.

Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.

**Kellyn Pot'Vin-Gorman**

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

LinkedIn: [Kellyn Pot'Vin-Gorman](https://www.linkedin.com/in/kellynpotvin)

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

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.

Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.

**Ryan Fonnett**

LinkedIn: [Ryan Fonnett](https://www.linkedin.com/in/ryanfonnett)

More than 11 years of professional experience with various programming languages, technologies, frameworks, methodologies, and tools. For 8 of those years most of my focus has been around the BI platform. For the past year or so, I have been focusing most of my attention on the front end specifically predictive analytics and visualizations. My passion is to deliver end to end data driven solutions that enable our customers to have a 'edge' over their competitors.

**Herve Roggero**

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

LinkedIn: [Herve Roggero](https://www.linkedin.com/in/herveroggero)

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

Strategist. Catalyst. Storyteller. Herve Roggero is recognized for his thought leadership and passion for providing accessibility to data in the tech space. Herve’s knack for distilling complex real-time data consumption challenges and presenting digestible solutions make him the ideal speaker, teacher, and teammate.

His leadership skills and passion of Microsoft Azure are a testament to his commitment to ultimately increasing operational efficiency - so much so that Herve has been an Microsoft Azure MVP for over 7 years.

Herve is the Co-Author of PRO SQL Azure, PRO Windows Azure SQL Database and PRO SQL Server 2012 Practices (from APress), a PluralSight author, and runs the Azure Florida Association.

**Carlos Colon**

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

LinkedIn: [Carlos Colon](https://www.linkedin.com/in/carlos-colon-5379875)

Carlos is a certified SQL Server professional and a senior software developer. As a 20 year veteran, Carlos leads Dobler Consulting’s database managed services practice. He’s also a certified PMP and holds a B.S. in Management of Information Systems.

**Kevin Boles**

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

LinkedIn: [Kevin Boles](http://www.linkedin.com/in/thesqlguru)

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

**Kellyn Pot'Vin-Gorman**

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

LinkedIn: [Kellyn Pot'Vin-Gorman](https://www.linkedin.com/in/kellynpotvin)

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

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.

Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.

**Andy Warren**

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

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

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

**Ernest Ostrander**

LinkedIn: [Ernest Ostrander](https://www.linkedin.com/profile/view?id=42794173)

A BI Fanatic. Ernest Ostrander has worked with SQL Server since SQL 7. With training from Kimball University, Informatica University and Oracle University, he has experience worth sharing.
He lives in Bogota, Colombia.
Adelante con SQL!!!!

**Julie Smith**

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

LinkedIn: [Julie Smith](http://www.linkedin.com/in/juliesmith0503/)

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

Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer--but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.

**Vishal Pawar**

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

LinkedIn: [Vishal Pawar](https://www.linkedin.com/in/pawarvishal)

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

Vishal Pawar is a Microsoft Data Platform MVP, Microsoft Certified Trainer (MCT), founder of the Global Power BI User Group and co-leader of the PASS Business Analytics Virtual Group. He is a Principal BI Architect in Green House Data, with decades of experience in BI solution architecture and best practices. He has published more than 1000 articles since 2011 in SQL and  BI. Vishal teaches a free Power BI course through Udemy, which has more than 65K students from the glob. Vishal is an exceptional technology community of leaders worldwide who actively share their high quality, real-world expertise with the technical communities.

**Lowell Izaguirre**

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

LinkedIn: [Lowell Izaguirre](https://www.linkedin.com/in/lowellizaguirre/)

Working as a Senior Database Administrator, I get to work in a SQL 2016 environment. I'm very active in the South Florida SQL Server User Group, the local development community, and attend events like SQL Pass, SQL Cruise, and as many SQLSaturdays as I can get to in South Florida.  My daily tasks are both Development and Operational, so I'm doing  a huge amount of development, lots of ETL's and automation in SSIS, SSAS administration and  debugging issues; I build Powershell scripts to scan and identify/solve problems, and support our ESX servers as an admin in our VMware/VShpere envireonment.

**Alex Funkhouser**

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

LinkedIn: [Alex Funkhouser](http://www.linkedin.com/in/AlexFunkhouser)

Contact: [http://www.sherlocktalent.com/newsletter-archive/](http://www.sherlocktalent.com/newsletter-archive/)

Alex Funkhouser wrote his first lines of code on a TRS80. Alex serves as CEO of SherlockTalent, a South Florida based tech talent agency helping top tech talent find great opportunities. He is an avid supporter of the technology community and also serves as president of ITProCamp, Inc., the community non-profit 501c3 that helps produce amazing tech events such as CodeCamp, TechNightAtTheBallPark, ITProCamp and originally ITPalooza. He earned a Bachelor of Science from Washington University and an MBA from The Netherlands School of Business. Alex’s recruiting philosophy: “Know who is best at what, and know who needs the best!"

**Shehab El-Najjar**

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

LinkedIn: [Shehab El-Najjar](https://www.linkedin.com/profile/view?id=126446983amp;trk=hp-identity-name)

Contact: [http://sqlserver-performance-tuning.net/](http://sqlserver-performance-tuning.net/)

Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East  , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts  to broadcast Microsoft SQL Server technologies all over the Gulf such as  KSA and Emirates and other Gulf cities ahead ..)

	He is now Professional Services Manager at Saudi  Emircom

	He was previously COO and business leader in KSA market through his startup WAJA IT for  3 years

	He is an influencing Database community leader all over the region
	A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region

**Richie Rump**

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

LinkedIn: [Richie Rump](http://linkedin.com/in/richierump)

Contact: [http://jorriss.net](http://jorriss.net)

Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.

**Jason Brugger**

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

LinkedIn: [Jason Brugger](https://www.linkedin.com/in/jasonbrugger)

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

Jason Brugger is a solution architect with experience in both traditional BI technologies and big data analytics on Azure and the Microsoft stack. He recommends and develops data solutions on both mature and emerging technologies, holding MCSE certification in Data Management and Analytics, as well as MCSE: Business Intelligence and MCSE: Data Platform. He has been working with SQL Server and Microsoft technologies since 1995.

**Shawn Meyers**

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

LinkedIn: [Shawn Meyers](http://www.linkedin.com/in/shawnmeyers42)

Shawn Meyers is a Field CTO working at Tintri.  Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5.  A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events.  Current focus is on improving DBAs lives with better infrastructure.

**Maximo Trinidad**

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

LinkedIn: [Maximo Trinidad](Linkedin: http://www.linkedin.com/pub/max-trinidad/12/47/775/)

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

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server  Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro  .NET Code Camps events.

**Kevin Boles**

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

LinkedIn: [Kevin Boles](http://www.linkedin.com/in/thesqlguru)

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

**Joe Homnick**

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

LinkedIn: [Joe Homnick](https://www.linkedin.com/in/joehomnick)

Contact: [http://joeblog.homnick.com/](http://joeblog.homnick.com/)

Joe Homnick is a Microsoft Regional Director since the start of the program over 20 years ago and is a principal owner of Homnick Systems (HSI), a Microsoft Gold Certified Partner located in Boca Raton, Florida. HSI is one of the most established Microsoft Certified Partners in the world, dating back to the beginning of the program in 1993. HSI delivers Microsoft services in the areas of system development and implementation through  software consulting, development, training and mentoring.

**Josh Kodi**

LinkedIn: [Josh Kodi](https://www.linkedin.com/in/joshkodi/)

Enterprise Data Engineering and Analytics leader with significant experience defining and executing overall organization’s strategy for Big Data, Data Warehouse and Business Intelligence. Possess an excellent blend of hands on technical and management experience to direct all aspects of data engineering program.

**Patricia Monica Ojeda**

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

LinkedIn: [Patricia Monica Ojeda](https://www.linkedin.com/in/patriciamonicaojeda/)

I'm a Bilingual Management Consultant and Executive Coach, with 20+ years of experience in the fields of Information Technology, Marketing, and Operations.
I help companies have successful projects, professionals with their personal brands, Millennials with their social communication, and Women to discovering their full potential.
I have extensive experience building professional networks, I am known by the identification of opportunities, analyzing operations, and the development of winning solutions.

**Andy Warren**

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

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

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

**Pankaj Satyaketu**

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

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

Pankaj Satyaketu is a Solutions Sales Manager based out of South Florida focused on driving Data Workloads to Azure. Pankaj has also held several positions within Microsoft focused on Microsoft's Flagship Database Engine, SQL Server.

Prior to joining Microsoft Pankaj was the Lead DBA for a major retailer out of South Florida responsible for managing and maintaining their database systems globally. Pankaj has 13+ years of experience with SQL Server in the areas of High Availability and Disaster Recovery, performance tuning, hybrid cloud migrations along with overall administration and automation.

Pankaj is an active supporter of local user groups and SQLSaturday events in Florida. He is also a graduate of Florida Atlantic University.

**Satya Jayanty**

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

LinkedIn: [Satya Jayanty](https://uk.linkedin.com/sqlmaster)

Contact: [http://www.sqlserver-qa.net](http://www.sqlserver-qa.net)

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation  migrations with major enhancements to current working methods.  Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment  recognition as an industry expert  technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present  share their extraordinary contributions, high quality, and real-world expertise.
Twitter pod (http://twitter.com/sqlmast

**Shehab El-Najjar**

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

LinkedIn: [Shehab El-Najjar](https://www.linkedin.com/profile/view?id=126446983amp;trk=hp-identity-name)

Contact: [http://sqlserver-performance-tuning.net/](http://sqlserver-performance-tuning.net/)

Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East  , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts  to broadcast Microsoft SQL Server technologies all over the Gulf such as  KSA and Emirates and other Gulf cities ahead ..)

	He is now Professional Services Manager at Saudi  Emircom

	He was previously COO and business leader in KSA market through his startup WAJA IT for  3 years

	He is an influencing Database community leader all over the region
	A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region

**Audrey Hammonds**

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

LinkedIn: [Audrey Hammonds](https://www.linkedin.com/in/audreyhammonds/)

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

Audrey Hammonds is a Data Platform Specialist for Microsoft in South Florida. Twenty-one years ago, she volunteered for database training to escape the clutches of COBOL and has never looked back. A firm believer in good fundamentals and solid design, she gets her kicks from making data do nifty things.  These days, she gets her kicks from helping customers adopt data services in Azure.

**Lowell Izaguirre**

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

LinkedIn: [Lowell Izaguirre](https://www.linkedin.com/in/lowellizaguirre/)

Working as a Senior Database Administrator, I get to work in a SQL 2016 environment. I'm very active in the South Florida SQL Server User Group, the local development community, and attend events like SQL Pass, SQL Cruise, and as many SQLSaturdays as I can get to in South Florida.  My daily tasks are both Development and Operational, so I'm doing  a huge amount of development, lots of ETL's and automation in SSIS, SSAS administration and  debugging issues; I build Powershell scripts to scan and identify/solve problems, and support our ESX servers as an admin in our VMware/VShpere envireonment.

**Sam Mesel**

will be provided later on

**Luis Figueroa**

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

LinkedIn: [Luis Figueroa](https://www.linkedin.com/in/luisefigueroa)

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

Luis Figueroa is a data professional with more than 15 years of experience in Information Technologies across many industry verticals. Luis has held a variety of positions in IT such as Network Administrator,  Systems Engineer, Database Administrator and EDW / BI Architect. In the most recent years Luis found his passion in architecting and developing open source data centric solutions that help businesses manage their data and gain a competitive advantage through analytics. Luis currently holds a position as Solutions Engineer for Hortonworks, Inc. where he works with many clients including Fortune 500 companies. Luis’ main focus areas are in Data Warehousing, Business Intelligence, Advanced Analytics, Big Data, IoT and Cloud Computing.

**Nadeem Akhter**

LinkedIn: [Nadeem Akhter](https://www.linkedin.com/feed/)

Contact: [http://blogs.nadeemakhter.com/](http://blogs.nadeemakhter.com/)

Defining/Validating the software architecture for clients and internal projects.Strategic Consulting, including business plan  sales strategy development.
•	A Principle Software Technology Architect with extensive architecture design, development, implementation, testing and support of mission critical high visibility enterprise applications.
•	Areas of expertise range from enterprise application integrations, e-Commerce, collaboration portals, business intelligence systems, web and multimedia applications, enterprise networks and security systems, and enterprise project management systems.
•	A proven troubleshooter with impeccable record for solving ultra-complex multifaceted problems at varying levels including operating systems

**Shawn Meyers**

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

LinkedIn: [Shawn Meyers](http://www.linkedin.com/in/shawnmeyers42)

Shawn Meyers is a Field CTO working at Tintri.  Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5.  A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events.  Current focus is on improving DBAs lives with better infrastructure.

**Adriano da Silva**

Principal Consultant at Bright International Corporation -  BI/DW, Advanced Analytics  Big Data Advisory Services

**Jay Alexander**

Jay Alexander is a proven leader with nearly 20 years of successfully delivering consulting and software solutions across a range of clients and industries. Jay began his career in software development and expanded his responsibilities to include technical account management and solution architecture, before transitioning to managing people and implementations.  He has broad experience in client management, software application development and methodologies, project management and delivery, as well as back office operations and personnel development. At Innovative Architects, Jay’s focus is on understanding core business needs and translating into technology solutions which leads to delivery success.

**Maximo Trinidad**

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

LinkedIn: [Maximo Trinidad](Linkedin: http://www.linkedin.com/pub/max-trinidad/12/47/775/)

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

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server  Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro  .NET Code Camps events.

**Sam Mesel**

will be provided later on

**Diana Betancourt**

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

LinkedIn: [Diana Betancourt](http://www.linkedin.com/in/dianabeta)

Former graduate of the quot;Universidad Santa Maria La Antiguaquot; School of Computer Science. I have been involved in the IT world since 1992, since then I have been working with many OS platforms, development languages and databases, among them Unix, Oracle, SUN, Informix, FoxPro, Microsoft SQL Server, just to mention a few. Diana enjoys solving complex performance tuning issues, examining your data using Databricks, designing in Azure SQL Datawarehouse, developing cool visuals using Power Bi, or evangelizing about Microsoft Data technologies at community events like SQLSaturday and local user group meetings.

**Edwin M Sarmiento**

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

LinkedIn: [Edwin M Sarmiento](http://ca.linkedin.com/in/edwinmsarmiento)

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

Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.

**Rodney Rubio**

LinkedIn: [Rodney Rubio](https://www.linkedin.com/in/rodneyrubio/)

Dell EMC Modern Infrastructure Team Systems Engineer supporting all of Florida Enterprise.

**Stephen Ippolito**

Well as of 2015 I' a graduate of FAU with my Ph.D  in Applied Mathematics go Owls! Following gradation I started a Post Doc modeling Crop Diseases for the USDA and ASTA (The American Seed Trade Association). Recently I started a position as a Data Scientist for Florida Crystals. My research interests involve using dynamical systems and Bayesian methods to understand biological phenomena. Recently I've worked on a project involving student success in Math Classes. On my spare time which I affectionately call "The empty set", I like to run, go dancing, and cook.

**Gordon Cornelius**

I am the Database Solutions Account Manager for the Southeast.   Happy to discuss all things SQL Server and Quest Software's future investment in SQL Server technologies.

**Troy Gallant**

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

Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA.  As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.

**Robert Torres**

LinkedIn: [Robert Torres](https://www.linkedin.com/in/robert-torres-a8a5b682?authType=NAME_SEARCHamp;authToken=JOHRamp;locale=en_USamp;srchid=2941106021465307514517amp;srchindex=1amp;srchtotal=839amp;trk=vsrp_people_res_nameamp;trkInfo=VSRPsearchId%3A2941106021465307514517%2CVSRPtargetId%3A294110602%2CVSRPcmpt%3Aprimary%2CVSRPnm%3Atrue%2CauthType%3ANAME_SEARCH)

Robert Torres has been the south Florida systems engineer at Pure Storage, Inc. since November, 2015. Robert has been in the enterprise IT industry for over 20 years and today serves as the Pure Storage south Florida technical lead in helping customers transform into the next generation data center. He has held technical leadership positions during his tenures at CDW and Carnival Cruise Lines ranging from enterprise data center architect, vendor management and enterprise storage administration.

**Shawn Meyers**

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

LinkedIn: [Shawn Meyers](http://www.linkedin.com/in/shawnmeyers42)

Shawn Meyers is a Field CTO working at Tintri.  Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5.  A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events.  Current focus is on improving DBAs lives with better infrastructure.

**Hector Villafuerte**

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

LinkedIn: [Hector Villafuerte](http://www.linkedin.com/in/hector-v)

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

Hector Villafuerte is a Microsoft Certified Professional and is currently the BI Solutions Architect at Starwood Property Trust in Miami Beach, Florida.
He has over twenty years of experience working in all areas of the Software Development Life Cycle. Current focuses include Power BI, SQL Server, SharePoint, Dynamics CRM, Office 365, Azure SQL, SSAS, No SQL, Machine Learning and other Azure Development Technologies as full stack developer.

**Satya Jayanty**

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

LinkedIn: [Satya Jayanty](https://uk.linkedin.com/sqlmaster)

Contact: [http://www.sqlserver-qa.net](http://www.sqlserver-qa.net)

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation  migrations with major enhancements to current working methods.  Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment  recognition as an industry expert  technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present  share their extraordinary contributions, high quality, and real-world expertise.
Twitter pod (http://twitter.com/sqlmast

**Fabiano Amorim**

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

LinkedIn: [Fabiano Amorim](https://www.linkedin.com/in/fabianoamorim/)

Contact: [http:\\blogfabiano.com](http:\\blogfabiano.com)

Fabiano Amorim is a Data Platform MVP that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.

**Edwin M Sarmiento**

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

LinkedIn: [Edwin M Sarmiento](http://ca.linkedin.com/in/edwinmsarmiento)

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

Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.

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

- [Convergence Consulting Group](http://www.ccgBI.com)

- [Dobler Consulting Services LLC](http://doblerconsulting.com)

- [DELL EMC](https://www.dellemc.com/en-us/index.htm)

- [SherlockTalent, Inc.](http://www.SherlockTalent.com)

- [Signature Consultants](http://www.sigconsult.com/)

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

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

- [New Horizons Computer Learning Centers of South Florida](http://www.nhflorida.com/)

- [Quest Software](https://www.quest.com/)

- [Idera](http://www.idera.com/Content/Home.aspx)

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

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

- [Redgate Software (GAP)](http://rd.gt/2j7SNf9)

- [Community Care Plan](http://ccpcares.org/)

- [SQL Smash](http://www.sqlsmash.com/)

- [O'Reilly Media, Inc](http://www.oreilly.com)

- [Acceleratio Ltd.](https://www.sqldockit.com/)

- [Gordon  Doner, P.A.](https://www.fortheinjured.com/)

- [ApexSQL](http://www.apexsql.com/)

- [TechSmith](http://www.techsmith.com)

- [Intertech](http://www.intertech.com/)

- [Devart](http://www.devart.com/)

- [Consultis](http://www.consultis.com)

- [PASS](http://www.pass.org)

[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:
English|[中文](Readme_cn.md)

# for_1.0.7.alpha

## Matching relationship

The business card requires the driver and firmware package.

Atlas 200 DK contains:

-   Driver and Firmware package: provides the drivers and firmware required by the AI software stack and maintenance and test software, and file system image on the device.
-   CANN package: enables the Huawei-developed AI-oriented heterogeneous compute architecture. The architecture provides hierarchical APIs to streamline the development of AI applications and services on the Ascend platform.

For details about the version mapping between the Atlas 200 DK Driver and Firmware package and the CANN package, see [the version mapping](../Version_Mapping.md).

## File introduction

- make_sd_card.py：Make SD Card entry script

- make_ubuntu_sd.sh：Make SD card operating system script

## Card making steps

**For card making steps, please refer to [Atlas 200 DK Developer Kit (1.0.7.alpha)](https://support.huaweicloud.com/intl/en-us/usermanual-A200dk_3000/atlas200dk_02_0011.html)**

branch_name: refs/heads/master

extension: md

license_type: permissive


text:
MySchedule - Shift scheduling application

  [![Status](https://img.shields.io/badge/status-active-success.svg)]()
  [![GitHub Issues](https://img.shields.io/github/issues/hwattenberger/scheduling_application.svg)](https://github.com/hwattenberger/scheduling_application/issues)
  [![GitHub Pull Requests](https://img.shields.io/github/issues-pr/hwattenberger/scheduling_application.svg)](https://github.com/hwattenberger/scheduling_application/pulls)
  [![License](https://img.shields.io/badge/license-MIT-blue.svg)](/LICENSE)

---

 This is a full stack application geared towards restaurants that have many shift works where availability could change throughout a week (students, part time workers, etc).

## 📝 Table of Contents
- [Problem Statement/Business Case](#businesscase)
- [Built Using](#built_using)
- [Features](#about)
- [Data Model](#datamodel)
- [See Demo and/or Live Example](#example)
- [Learnings](#learnings)
- [TODOs](#todos)
- [Author](#authors)

## 🧐 Problem Statement/Business Case
It is hard to schedule lots of part time staff.  While their availability may be consistent from week to week, they need time off or can only work once a week or have various other challenges.  When I worked in a restaurant, the manager spent hours a week scheduling everyone.  Similarly it's tough for busy part time workers to remember when they were scheduled and to show up on time.  The goal of this project is to help both types of people.

## ⛏ Built Using
- [React](https://reactjs.org/) - Front end framework
- [MaterialUI](https://v4.mui.com/) - React UI components
- [NodeJS](https://nodejs.org/en/) - Back end
- [Express](https://expressjs.com/) - Back end framework
- [MongoDB](https://www.mongodb.com/) - Database
- Also passport (authentication), dayjs (date library), Cloudinary (image storage)

## 🧐 Features
For Managers (Only available for users who are marked as admins):
- Create staff roles (sever, manager, host, etc.) and [shift types](https://hilary-wattenberger.netlify.app/images/Scheduling%20App%20-%20Create%20and%20update%20shifts.png) (AM server shift, PM host shift)
- [Manage staff](https://hilary-wattenberger.netlify.app/images/Scheduling%20App%20-%20Update%20Staff%20Information.png) (activate & deactivate/turn into admin/manage staff information including staff role, image)
- Create [weekly schedules](https://hilary-wattenberger.netlify.app/images/Scheduling%20App%20-%20Schedule.png) to publish to your staff.  More details on scheduling below.

For Staff:
- [Update weekly availability](https://hilary-wattenberger.netlify.app/images/Scheduling%20App%20-%20Specify%20Your%20Schedule.png) and user information
- [Create time off requests](https://hilary-wattenberger.netlify.app/images/Scheduling%20App%20-%20Request%20Time%20Off.png)
- [See upcoming shifts](https://hilary-wattenberger.netlify.app/images/Scheduling%20App%20-%20View%20Upcoming%20Shifts.png)

General Features:
- [Authentication](https://hilary-wattenberger.netlify.app/images/Scheduling%20App%20-%20Register.png) either natively with a username and password OR through Google

Scheduling information:
- Schedules are created from a combination of each user's specified weekly availability and their time off requests.
- You can copy forward the schedule from last week and it will keep all scheduled shifts unless users have requested time off (so you don't mistakenly schedule someone for a shift when they aren't available).
- Users are scheduled for a specific shift on a specific date.  You can schedule them in the scheduling activity either by selecting a shift for that user or dragging an open shift to their user.
- You can schedule a user for multiple shifts in a day.
- Filter to only show shifts for a specific user role (for example servers).
- [Modify specific days](https://hilary-wattenberger.netlify.app/images/Scheduling%20App%20-%20Change%20People%20Needed.png) to require less or more for a specific shift.  For example on a holiday you may want to close or expect 3 instead of 5 servers for the evening shift.

## Data Model
Here is the data model for this project:

## 🏁 See Demo and/or Live Example
See this image for workflow (coming soon!):

You can access the live application here: https://hwattenberger-schedulingapp.netlify.app/schedule

If you don't want to create your own user, you can use:

Admin User<EMAIL_ADDRESS>Password: willy

Non-Admin User<EMAIL_ADDRESS>Password: jill

## 🎈 What did I learn?
This project took a while and I learned loads.
- Data model.  I went through a number of iterations on how to store schedules.  Ultimately I have a much better understanding of when to make certain choices of creating new Schemas/Models/Documents and when to imbed.
- MongoDB.  I hadn't used pipelines before and spent a good deal of time learning how to extract complex data from a database.
- Dates.  Dealing with dates with a server with a different timezone.  I learned some but still have more to learn here.
- Authentication.  I understanding authentication a lot more.  Certainly using passport but also middleware in NodeJS.  As part of this project, I did research into sessions & JWT.  Happy that I was able to use Google auth in addition to native.
- Deploying.  This is deployed in Heroku on the back-end and Netlify for React so learning about how to do that and also dealing with CORS.
- Code organization.  I am reasonably happy with the output but I think there's still opportunity to improve especially with my React components (could be more split up into more appropriate folders).
- React.  I spent a lot of time on the React portion of this application.  Among other things, I now understanding much better useContext and useReducer.
- MaterialUI.  I wanted to try using something instead of making everything from scratch.  It certainly saved some time and I was able to see many different components.  I liked using the Snackbar - I'd use that more broadly in future projects to help users understand that what they are doing is successful (or unsuccesful)

## 🎈 Todos
I have a long list of things I'd work on if I had more time.  Here are some of them:
- Analytics.  I'd love to make a dashboard.  There aren't too many options with the data I currently collect so I'd need to capture some additional information
- Email shifts.  I could integrate with somewhere like Twillio and auto send emails around scheduled shifts or have users request an email of their shifts
- Better error handing
- There's no great handling currently of what happens when shifts are changed from what they were before (for example you were scheduled for a shift type and then the shift type gets changed to a different role.  Very unlikely in the real world but still something I should handle better)
- Responsiveness.  Most of the pages are reasonably responsive but there's certainly more work to be done.
- More validation on forms.  I did this for the registration form to show that I could make it work but could do it on all forms
- Way too much prop drilling on the scheduling page.  I'd move to useContext (if not something like Redux)
- I'd move the API calls outside of components into their own hook

## ✍ Author
- [@hwattenberger](https://github.com/hwattenberger)

license: MIT

branch_name: refs/heads/main


text:
unpdf
=====

unpdf is ostensibly a PDF text extractor - pass it a PDF file and it
will output the textual content. However, if you are actually looking
for something to perform this function, I strongly recommend going with
something like [Poppler](http://poppler.freedesktop.org/)'s `pdftotext`
instead; unpdf is just a sandbox for me to play around with
[pdf-toolbox](https://github.com/Yuras/pdf-toolbox).

repository: olorin/unpdf

repo_name: olorin/unpdf