David Patrick

Information & Communications Technology

Government, Social Sector & Education

Business & Management

SharePoint SQL SharePoint Framework Office 365 SharePoint Productivity csharp Azure SQL Server power bi ASP.NET Microsoft PowerApps Microsoft Teams Flow Power Automate Power Apps Microsoft Power BI Microsoft Power Automate Microsoft Power platform Power Automate (Flow) Microsoft Power Apps SharePoint Online Microsoft SharePoint SharePoint Server SharePoint Development SharePoint modern web parts SharePoint Administration Modern SharePoint SharePoint governance ShareGate

Aberdeen, Maryland, United States

David Patrick


Dave has been developing database applications for over 30 years. A Microsoft Certifed Trainer (MCT) since 2001, he has taught many classes from Intro to Programming to Advanced SharePoint Development. Dave is a five time Microsoft MVP and runs three user groups, MAD SharePoint, www.madsharepoint.com, the Mid Atlantic Cybersecurity Experts MeetUp, www.meetup.com/MACEME, and the Baltimore Cloud Meetup, www.meetup.com/Baltimore-Cloud.

Dave does SharePoint training and application development for DSA, Inc., a DoD contractor that does great work for the U.S. Army over at Aberdeen Proving Ground. Dave has a bunch of certifications, including MCSD App Builder, MSCE for SharePoint, and MCSA SQL Server certification.

In his spare time, Dave teaches as an Adjunct Professor at the University of Maryland College Park's iSchool, Towson University and Stevenson University.

Check out www.PatrickPerspective.com to hear about Dave and his daughter Sarah's different views on tech!

Current sessions

Intro to AI

A fast paced tour of Microsoft’s Artificial Intelligence offerings. We’ll cover QnA Maker, LUIS, Power Virtual Agents and more! We’ll demonstrate integration with SharePoint and show how AI can do things like image recognition and text sentient analysis, ie. “What you talking about, Willis!”

Developing Custom Visuals for Power BI

Power BI visuals are packages that include code for rendering the data served to them and anyone with knowledge of TypeScript can create a custom visual. Learn how to get started with a Power BI custom visual and how to package it as a single .pbiviz file, that can be imported into a Power BI report.

DEV302 - All about the CRUD - Data Operations in SharePoint

This session will deep dive into working with SharePoint content in SharePoint Framework projects. You'll learn about the SharePoint REST API, be able to do all the CRUD (Create Read Update and Delete) operations with a SharePoint list, use the local workbench, and learn about creating mock data with the SharePoint Framework.

From Xamarin to MAUI - Next Level Mobile Development

For old school Xamarin developers and new to mobile development developers alike, this talk is designed to get .NET devs up to speed on the new MAUI framework.

We'll cover how .NET MAUI simplifies the project structure into a single project to target multiple platforms and how you can easily deploy to any target that you wish including your desktop, emulators, simulators, or physical devices with a single click.

We'll cover the built-in cross-platform resources available and show how you will be able to add any images, fonts, or translation files into the single project and also how .NET MAUI will automatically setup native hooks so you can just code.

Learning with Microsoft Learn - Access Free Exam Crams, Hands On Labs, and Azure Sandboxes

Covering all the fantastic and FREE exam prep resources from Microsoft Learn! We'll demo how to use their free Azure Sandbox to create resources like virtual machines and databases in Azure. We'll go through their great step by step tutorials on creating a web app in about 10 minutes and we'll cover the exam crams and online assessments that help test your knowledge and prepare you for the real thing!

On-Demand sessions available from the morning of the Event until 20th Feb 2021

Please see the additional on-demand sessions that we have available throughout the day on the on-demand page (Only available in the Event site, Linked in your Eventbrite notification)

Getting Data from Dataverse inside of Teams

Microsoft Dataverse for Teams delivers a no code / low code out of the box data platform for Microsoft Teams. You get relational data storage, rich data types, enterprise-grade governance, and one-click solution deployment. Dataverse for Teams enables everyone to easily build and deploy apps. Come see what Dataverse for Teams is all about and how to get started building databased apps within Teams.

Intro to Security in Microsoft Teams

Wondering why someone can't unmute? Or why they can? How about why some people can like a message and others can't even get into the meeting? Come to our talk and learn all about the different permissions and other security settings that affect who can do what and when in Teams! Lot of demos and we'll even try to break some things!

Lights & Clockwork - The Ultimate Azure Workshop for SharePoint Professionals

Bewildered by the possibilities in the Microsoft Cloud when it comes to SharePoint? You're not alone.

The Microsoft Cloud brings a huge range of opportunities for how you can leverage Azure with SharePoint.

In this workshop, you will learn how Microsoft Azure fits into your Office 365 and SharePoint world.

From understanding the Azure-based deployment options for SharePoint on-premises to discovering how Azure brings a range of functionality to Office 365, this workshop will walk you through the opportunities that exist to help you get the very best out of the platform.

Topics covered will include:

- An overview of deploying SharePoint to Azure
- Quickly standing up multiple versions of SharePoint in Azure
- Identity Management with Azure AD and Office 365 & SharePoint
- Integrating various Azure service into both SharePoint in Azure as well as SharePoint Online

Not for the faint-hearted, this workshop covers a lot of ground so pack your brains and notepads!

SharePoint Security - Breaking Inheritance

In this talk we go over the basics of SharePoint security, what it is and how it works. We cover customizing security aka breaking inheritance for sub sites, libraries and lists, and individual items and demo several situations to fully understand how security works in SharePoint and what to watch out for.

Train the Trainer: The TechGirlz Team Workshop

This session walks you through the Intro to Collaboration with Microsoft Teams workshop that we run for the organization TechGirlz. You will learn how we run the workshops, the activities involved, the goals and learning objectives and how using Microsoft Teams helps teach collaboration.

Inspiring the Next Generation: Teaching TechGirlz

David and Sarah Patrick will discuss their adventures in teaching young ladies a variety of computer related technologies. Through a program called TechGirlz, David and Sarah have been running workshops designed to inspire the next generation of young women to get and stay interested in STEM, to help bridge the gender gap that exists in these fields today. During the talk, David and Sarah will show off how they were able to incorporate into the TechGirlz workshops the latest Microsoft technologies like Office 365, Kodu, Visual Studio Code, Power Apps and Microsoft Teams, so that the ladies would not only be learning technology, but gaining current, relevant, and valuable skills.

Developing in SharePoint - A Crash Course

A fast paced ride through the land of SharePoint development. The tour will cover everything from No-Code solutions to using JQuery and SPServices to extensions using the new SharePoint Framework and everything else in between!

Turning SharePoint Designer Workflows into Power Automate Flows

We'll go step by step taking an existing SharePoint Designer workflow that sends emails based on a central list that stores feedback from an intranet site and show how to convert this on premises workflow to a cloud based Power Automate Flow! We'll cover a bunch of the options for providing the same functionality as before as well as many new features that exist only in a Power Automate flow.

Power BI vs Tableau - A Side by Side Comparison

Having recently attended the Tableau conference, this session will compare and contrast these two powerful BI tools and showcase their pros and cons. We'll walk through ingesting a data set into each tool and perform several visualizations to see how easy or hard it is to tell our data story.

Intro to Power BI

For anyone new to Power BI, we'll cover all the main features and walk through getting data into the tool (using both the desktop and online versions), creating visualizations, turning them into reports and adding them to dashboards. When we're through we'll have several BI components available to share via the Cloud!

Razor Pages with Entity Framework Core in ASP.NET Core

During this demo heavy talk, we'll cover Razor Pages, the Entity Framework Core, ASP.NET Core, and MVC. We'll show how to use the tools and templates built into Visual Studio to auto create pages to support CRUD (aka scaffolding) and how to use dependency injection to make use of services as needed.

Intro to Dataverse inside of Power Automate

Microsoft Dataverse (formerly known as the Common Data Service) lets you securely store and manage data that's used by business applications. Data within Dataverse is stored within a set of tables (fka entities). A table is a set of records used to store data, just like data is stored within a database.

Learn how Microsoft Dataverse ties into Power Automate. Create a Flow, see what triggers and actions are available and how you can use this all to move data back and forth between environments such as Microsoft Dynamics and SharePoint!

Create a web API with ASP.NET Core MVC

Learn how to building a web API with ASP.NET Core.
We'll demo how to create a web API project, add a model class, and create and register the database context. Then we'll add a controller and CRUD methods. We'll add and configure routing and URL paths. We'll call the web API with Postman and with jQuery. At the end, we will have a web API that can manage "to-do" items stored in a relational database.

Build Your First SharePoint Client-Side Web Part with the SharePoint Framework

Client-side web parts are client-side components that run inside the context of a SharePoint page. Client-side web parts can be deployed to SharePoint Online, SharePoint 2019, or SharePoint 2016. HTML, CSS, JavaScript and JavaScript libraries are used to build these web parts.

In this talk, we'll walk through the process of building a client side web part from the ground up. We'll introduce the pieces and parts of the new SharePoint Framework and we'll also cover what you need to get started and how to set up your development environment.

Big Data in Action: Integrating Hadoop with BI

We will explore delivering a corporate tabular data model that includes a table which sources its data from an optimized Hive query. We will combine a modern data warehouse with a traditional data warehouse data and cloud Big Data to enable data insights. We will use a Azure subscription to create Azure Storage and an Azure HDInsight cluster.

Intro to Azure

An introduction to Azure and the Microsoft Cloud for Developers. We'll discuss how to use Azure VMs as well as creating apps.

Intro to Visual Web Parts

In SharePoint, Web Parts are an essential component of ASP.NET technologies used to present dynamic information to users and are arguably the most common customization created for SharePoint. In this presentation, we discuss and demonstrate how to build a web part using Visual Studio and its visual design tools. We'll create a visual web part and use LINQ to SharePoint to retrieve data from a SharePoint list to be displayed in our new visual web part. We'll then build and deploy our web part to a SharePoint site to see it in action!

SharePoint's Hidden Lists

Ever had a workflow email not get sent? What about a user with full control getting an Access Denied message? The answer to these and other mysteries are revealed in this talk where we explore the hidden lists of SharePoint and how the information in these lists can help solves problems like unsent emails from workflow notifications. We'll also show how issues with these lists can cause invalid access permissions and other issues and we'll discuss how to identify and address these problems.

Scaling the SharePoint Development Landscape

Interested in getting started with SharePoint development but not sure where to begin? This talk will dig into the many tools and technologies available to the budding SharePoint developer. From so called "No Code Solutions" to the recently released SharePoint Framework, we'll dive into each methodology and discuss the extension points, the technologies involved, and artifacts that can be created. We'll cover SharePoint integration with .NET, C#, Client Side Object Model, Server Side Object Model, Node.js, NPM, React, Angular and more! We show you how to create Web Parts, Delegates and Event Receivers, just to name a few.

SELECT * FROM SharePoint

Ever want to know how many Tasks are assigned each day? How about the last modified document for each user? Sure, some of these can be answered by a view, but what if you are exploring your data? Do you keep creating new views? There is a better way! We'll show you how to create business intelligence using tools you already have, like Excel and Access. We'll connect to SharePoint document libraries and lists and query them like any other data table. We'll show you how to connect to lists like Tasks, Announcements and even Surveys!

SharePoint and Azure - How to Jump Start SharePoint Development Fast and Easy with Cloud Power!

This presentation shows how to use Azure Virtual Machines for hosting a SharePoint 2013 and 2016 farm in the cloud! We will demo how to get started with Azure using Dev Essentials, a free offering from Microsoft for developers to get started with developing on Azure, and we'll show several ways to get a SharePoint farm up and running using the SharePoint farm wizard in Azure. Once we have our SharePoint 2013 farm up and running, we will demo adding an Azure based virtual machine to our SharePoint 2013 farm, and then install SharePoint 2016 on it, to give us both a SharePoint 2013 and 2016 farm in the cloud!

Intro to Machine Learning with ML.NET

Come and get immersed into the world of machine learning with this introduction and demonstration of to ML.NET. We'll show how to create an app that can predict the type of iris flower based on features such as petal length. We'll show how to download and install ML.NET, create a data set, write the required c# code and run the finished app.

Intro to Azure for SharePoint Geeks

Wondering what Azure could possibly have for you as a SharePoint geek? Come to this session to find out what Azure is and how it can offer benefits to the SharePoint geek in all of us.

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

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.

Microsoft and Big Data - An Overview of the Power Tools and more!

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll present on Microsoft's "power" tools for Business Intelligence, Power BI, Power Pivot, Power Query, Power View, and Power Map presenting using Power Point (and lots of demos!).

Past and future events

Power Platform Conference (Community Content)

18 Sep 2022 - 23 Sep 2022
Orlando, Florida, United States

Magic of Science Fair

11 Jun 2022
Bel Air, Maryland, United States

Microsoft Cloud Friday Cancun 2022

3 Jun 2022
Cancún, Quintana Roo, Mexico

#DataWeekender CU5

14 May 2022

Microsoft 365 Virtual Marathon 2022

4 May 2022 - 6 May 2022

Minnesota Microsoft 365 User Group - Virtual Workshop Day Spring, 2022

29 Apr 2022

Microsoft 365 Conference April 2022

3 Apr 2022 - 8 Apr 2022
Las Vegas, Nevada, United States

InnoVAte Virginia 2022

25 Mar 2022

Power Platform 24

15 Mar 2022 - 16 Mar 2022

Power BI Summit 2022

7 Mar 2022 - 11 Mar 2022

philly.NET Code Camp 2022

4 Mar 2022

Global Power Platform Bootcamp 2022 - TriState

18 Feb 2022

DataMinutes #2

21 Jan 2022

M365 Below in Chicago!

14 Jan 2022

365 EduCon DC 2021

12 Dec 2021 - 16 Dec 2021
Washington, D.C., United States

Microsoft Teams Day Online 4

17 Nov 2021 - 18 Nov 2021

PASS Data Community Summit 2021

8 Nov 2021 - 12 Nov 2021

DataSaturdays #13 - Minnesota - Oct 16 2021

16 Oct 2021

Northern VA CodeCamp Fall 2021

16 Oct 2021

CollabDays New England - Microsoft 365 2021

9 Oct 2021
Burlington, Massachusetts, United States

Code PaLOUsa 2021

18 Aug 2021 - 20 Aug 2021

The North American Collaboration Summit 2021

9 Aug 2021 - 11 Aug 2021
Branson, Missouri, United States

Data Geeks Saturday Conference

7 Aug 2021

Virtual 2021 Data.SQL.Saturday.LA

12 Jun 2021

DataMinutes #1

11 Jun 2021

A Taste of M365 Chicago!

4 Jun 2021

Techorama 2021 Spring Edition

17 May 2021 - 19 May 2021
Antwerpen, Flanders, Belgium

M365 Philly Virtual 2021

14 May 2021 - 15 May 2021

Teams Nation 2021

12 May 2021

Minnesota Microsoft 365 User Group - Virtual Admin Workshop Day Spring, 2021

30 Apr 2021

Microsoft 365 Virtual Marathon

26 Apr 2021 - 28 Apr 2021

Power BI Summit

19 Apr 2021 - 24 Apr 2021

Certification Saturday 2021

10 Apr 2021

Teams Day Online 3

7 Apr 2021 - 8 Apr 2021

Virtual Power BI Days Germany 2021-03-23

23 Mar 2021

Power Platform Virtual Conference

11 Mar 2021 - 12 Mar 2021

Virtual Scottish Summit 2021

22 Feb 2021 - 27 Feb 2021

Global Power Platform Bootcamp - New York

20 Feb 2021

CollabDays Birmingham Virtual 2021

28 Jan 2021

TeamscommunityDay 2021

28 Jan 2021

Microsoft 365 Friday California 2021

22 Jan 2021

philly.NET Code Camp 2021

15 Jan 2021 - 16 Jan 2021

Collabdays Munich & Vienna - Winter across the Alps

4 Dec 2020

aMS Germany - 1/12/2020

1 Dec 2020
Aachen, North Rhine-Westphalia, Germany

M365 Chicago - Virtual Event

13 Nov 2020
Chicago, Illinois, United States

M365 Friday Cincinnati

23 Oct 2020
Cincinnati, Ohio, United States

M365 Saturday Ottawa

17 Oct 2020
Ottawa, Ontario, Canada

TeamsFest | October 2020

7 Oct 2020

SharePoint Saturday Saskatchewan 2020

3 Oct 2020
Regina, Saskatchewan, Canada

Power Platform 24

1 Oct 2020 - 2 Oct 2020

Teams Day Online 2

30 Sep 2020 - 1 Oct 2020

The North American Collaboration Summit 2020

28 Sep 2020 - 30 Sep 2020
Branson, Missouri, United States

M365 Philly (AKA SPS Philly)

21 Jul 2020 - 23 Jul 2020
Malvern, Pennsylvania, United States


14 Jul 2020 - 15 Jul 2020

Omaha365 Conference - Virtual Edition

22 Jun 2020 - 26 Jun 2020

Microsoft Build 2020

Spotlight Series: Mentoring Future Technologists


Shona Bang
David Patrick
Sarah Patrick
Isabel Wood
Jeremy Wood
18 May 2020 - 19 May 2020
Seattle, Washington, United States

Office 365 Nashville

8 May 2020
Nashville, Tennessee, United States

Global Azure Virtual

23 Apr 2020 - 25 Apr 2020
Seattle, Washington, United States

philly.NET Code Camp 2020.1

17 Apr 2020 - 18 Apr 2020
Malvern, Pennsylvania, United States

Modern WorkPlace Summit

8 Apr 2020
Philadelphia, Pennsylvania, United States

Global Power Platform Bootcamp - Philadelphia

15 Feb 2020
Philadelphia, Mississippi, United States

Microsoft Ignite The Tour DC 2020

Inspiring the Next Generation: Teaching TechGirlz

David and Sarah Patrick will discuss their adventures in teaching young ladies a variety of computer related technologies. Through a program called TechGirlz, David and Sarah have been running workshops designed to inspire the next generation of young women to get and stay interested in STEM, to help bridge the gender gap that exists in these fields today. During the talk, David and Sarah will show off how they were able to incorporate into the TechGirlz workshops the latest Microsoft technologies like Office 365, Kodu, Visual Studio Code, Power Apps and Microsoft Teams, so that the ladies would not only be learning technology, but gaining current, relevant, and valuable skills.
6 Feb 2020 - 7 Feb 2020
Washington, D.C., United States

philly.NET Code Camp 2019.2

18 Oct 2019 - 19 Oct 2019
Malvern, Pennsylvania, United States

SharePoint Saturday New England 2019

5 Oct 2019

Microsoft Flow Online Conference 2019

10 Sep 2019

SPS Events - DC / Reston - Cloud Saturday DC 2019

1 Jun 2019
Reston, Virginia, United States

Northern VA CodeCamp Spring 2019

18 May 2019
Reston, Virginia, United States

philly.NET Code Camp 2019.1

12 Apr 2019 - 13 Apr 2019
Malvern, Pennsylvania, United States

philly.NET Code Camp 2018.2

16 Nov 2018 - 17 Nov 2018
Malvern, Arkansas, United States

SPS Events - DC / Reston

10 Nov 2018
Reston, Virginia, United States

Microsoft Ignite 2018

BRK2131 - Driving Adoption and Usage with OneDrive: You've deployed it, but can you get folks to use it?

Did you know that the average company has three to six different products end users have installed that do pretty much the same thing as your corporate standard app? Why? Lack of change management and understanding end users. In this session we look at end users' fear of change, the importance of a change management plan, and tips and tricks on getting end users to adopt software and actually use it. Hear from corporate trainers, change management professionals, and see examples from real customers of how they achieved roll-out success and usage.

Guest Speaker - David Patrick
24 Sep 2018 - 28 Sep 2018
Orlando, Florida, United States

Microsoft Ignite 2018


PRE08 - OneDrive for Business Deep Dive- From Start To Finish
Speakers: Stephen Rose, Jason Moore, David Patrick, Mike Maadarani, Noorez Khamis, LeAndra Jordan, Heather Fitzpatrick Severino

This full-day workshop outlines all you need to know to adopt OneDrive and drive usage and adoption, enabling collaboration and teamwork. We cover how to best plan, deploy, manage and secure OneDrive
23 Sep 2018 - 28 Sep 2018
Orlando, Florida, United States


30 Jul 2018 - 1 Aug 2018
Philadelphia, Mississippi, United States

SharePoint Conference 2018

OneDrive from Start to Finish
Stephen Rose, David Patrick,
Mike Maadarani, Noorez Khamis,
LeAndra Jordan,
Heather Fitzpatrick Severino
19 May 2018 - 24 May 2018
Las Vegas, Nevada, United States

philly.NET Code Camp 2018.1

23 Mar 2018 - 24 Mar 2018
Malvern, Arkansas, United States

SharePoint Saturday New England 2017

28 Oct 2017

SharePoint Saturday New York City 2017

29 Jul 2017