Skip to content

Repository for source files in my past and upcoming presentations. Powershell, SQL, Azure or AWS command line script files, code for examples and demos, supporting slides as PDFs.

Notifications You must be signed in to change notification settings

dave-007/presentations

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

37 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Presentations

Repository for source files in my past and upcoming presentations.

Quick Stats: 15 presentations | 2011-2025 | Topics: SQL Server, PowerShell, Cloud Technologies, AI/ML


By Topic

AI & Machine Learning

Containers & Kubernetes

Cloud - AWS

Cloud - Azure

SQL + PowerShell

PowerShell

SQL Server


By Year


Complete Chronological Index with Abstracts

2011

Tags: sql-server virtualization clustering hyper-v

Presentation materials from SQL Saturday covering how to set up and configure Hyper-V clustering for SQL Server, including network configuration for active-active clusters.

2012

Tags: sql-server replication troubleshooting

Custom class materials focused on troubleshooting SQL Server replication issues, including resources for students and detailed technical documentation.

Tags: powershell sql-server dba automation

Introduction to using PowerShell with SQL Server 2012, covering SQLPS cmdlets, syntax enhancements, and practical scripts for database administration tasks including backups, restores, error log reading, and server management.

2013

Tags: powershell beginner scripting

Beginner-friendly presentation introducing PowerShell scripting fundamentals, including slide decks and demo scripts for initializing SQL PowerShell environments and database restore operations.

2014

Tags: powershell beginner hands-on

Interactive, hands-on introduction to PowerShell for .NET developers with no slides - just code. Covers PowerShell basics, variables, core commands, providers, common cmdlets, filtering, and WMI/CIM.

2015

Tags: sql-server database-snapshots automation mirroring

Complete solution for creating and managing rolling database snapshots on mirrored databases, including stored procedures, SQL jobs, and PowerShell scripts for automation. Includes concept diagrams and demo scripts.

2016

Tags: sql-server powershell beginner smo

By adding PowerShell to our toolset when working with data, DBAs and developers can go beyond Management Studio and T-SQL, applying a powerful scripting language that leverages .NET objects and Windows server capabilities to simplify management, automate processes, and manipulate data.

Tags: sql-server powershell beginner smo

Same core content as Code Camp presentation, delivered to HP on behalf of LearnNowOnline. Covers PowerShell basics for SQL professionals, SMO usage, and community resources.

Tags: sql-server powershell beginner smo

Online learning version of the SQL and PowerShell introduction, including additional SQL treemap visualization script.

Tags: sql-server powershell beginner smo dba-tools

Virtual presentation to PASS Virtual Chapter, includes DBATools coverage in addition to core SQL and PowerShell content.

2017

Tags: sql-server powershell tools modules

Exploration of the current state of PowerShell tools for SQL Server, comparing SQLPS and the new SQLServer module, PowerShell Gallery, and community tools like DBATools. Covers PowerShell 5.1 and SSMS 2016.

2018

Tags: kubernetes containers azure windows

Walkthrough of standing up Azure Container Services (ACS) with Kubernetes orchestrator and Windows containers. Includes PowerShell scripts for cluster setup, container deployment, and useful references.

2019

Tags: aws cloud cli automation jmespath

Introduction to AWS CLI with focus on command syntax, JMESPath queries, and practical examples for managing AWS resources from the command line. Includes reference materials and learning resources.

2020

Tags: azure powershell cloud beginner

Beginner-level session on using PowerShell 7 with Azure. Covers first login, command syntax discovery, common features and shortcuts, and how command line increases understanding and confidence in building in the cloud. Code-intensive tutorial designed for hands-on learning.

Tags: azure cloud dba migration career

Presentation covering the journey of database administrators transitioning to Azure cloud technologies.

2022

Tags: azure cloud career learning generalist

Sharing discoveries about technology levers, filters, forcing factors, and what it really means to be a 'cloud expert'. Mastering these concepts helps improve confidence and skills in the cloud. Includes video recording and slide deck.

2024

Tags: azure cloud learning education teaching

External presentation on teaching and learning Azure cloud technologies in 2024.

Tags: ai machine-learning education bootcamp

External AI bootcamp workshop materials and resources.

2025

Tags: ai ethics future intentional-design

External presentation on intentional AI design and co-creating the future we want through thoughtful AI development.


Tag Index

  • ai - Artificial Intelligence and Machine Learning topics
  • automation - Scripting and automation solutions
  • azure - Microsoft Azure cloud platform
  • aws - Amazon Web Services cloud platform
  • beginner - Entry-level content suitable for beginners
  • career - Career development and professional growth
  • cli - Command Line Interface tools
  • cloud - Cloud computing platforms and services
  • clustering - High availability and clustering solutions
  • containers - Container technologies
  • dba - Database Administrator focused content
  • database-snapshots - SQL Server snapshot technology
  • education - Teaching and learning resources
  • ethics - Ethical considerations in technology
  • future - Future-looking technology discussions
  • generalist - Generalist vs specialist approaches
  • hands-on - Interactive, code-focused sessions
  • hyper-v - Microsoft Hyper-V virtualization
  • jmespath - JMESPath query language
  • kubernetes - Kubernetes orchestration
  • learning - Learning methodologies and resources
  • migration - Technology migration topics
  • mirroring - Database mirroring technology
  • modules - PowerShell modules and packages
  • powershell - PowerShell scripting language
  • replication - SQL Server replication
  • scripting - Scripting languages and techniques
  • smo - SQL Server Management Objects
  • sql-server - Microsoft SQL Server database platform
  • tools - Development and administration tools
  • troubleshooting - Problem-solving and debugging
  • virtualization - Virtualization technologies
  • windows - Windows-specific technologies

About

This repository contains presentation materials, slides, scripts, and code samples from presentations delivered from 2011 to 2025. Topics have evolved from SQL Server administration and PowerShell scripting to cloud technologies and AI.

All materials are provided as-is for educational purposes. Feel free to fork, clone, and adapt the code for your own use.


GitHub Pages

This repo is set up to publish as a GitHub Pages site using Jekyll.

Local preview

If you want to preview the site locally (same dependency set as GitHub Pages):

  1. Install Ruby + Bundler
  2. Run bundle install
  3. Run bundle exec jekyll serve

Theme

The current theme is set in _config.yml via theme:.

Popular built-in (supported) themes you can switch to by changing theme::

  • jekyll-theme-architect
  • jekyll-theme-cayman
  • jekyll-theme-dinky
  • jekyll-theme-hacker
  • jekyll-theme-leap-day
  • jekyll-theme-merlot
  • jekyll-theme-midnight
  • minima
  • jekyll-theme-minimal
  • jekyll-theme-modernist
  • jekyll-theme-slate
  • jekyll-theme-tactile
  • jekyll-theme-time-machine

If you want a more modern docs-style site, GitHub Pages also supports remote_theme: (for example just-the-docs/just-the-docs).

About

Repository for source files in my past and upcoming presentations. Powershell, SQL, Azure or AWS command line script files, code for examples and demos, supporting slides as PDFs.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •