Skip to content
MidnightDBA

MidnightDBA

We make videos while you sleep

  • About us
  • Links
  • FAQs
  • Contact

Category: Uncategorized

Named File Streams

Have you ever wondered how Windows keeps track of file Continue reading “Named File Streams”

Author Sean McCownPosted on April 11, 2023Categories Uncategorized

Prepared SQL

Have you ever wondered what prepared SQL is? It’s Continue reading “Prepared SQL”

Author Sean McCownPosted on February 13, 2023Categories Uncategorized

Best Backup Class Evar: 1 of 6

This is the intro to backup that set the mood Continue reading “Best Backup Class Evar: 1 of 6”

Author Sean McCownPosted on February 3, 2023Categories Uncategorized

Powershell Format-Table Expressions

You can create custom columns using expressions in format-table.
Here I Continue reading “Powershell Format-Table Expressions”

Author Sean McCownPosted on November 7, 2022Categories Uncategorized

Beginning Desktop Apps: 02

Continuing with desktop apps, we talk about populating combo boxes, Continue reading “Beginning Desktop Apps: 02”

Author Sean McCownPosted on September 15, 2022Categories Uncategorized

Beginning C# Desktop Apps

Here we’re starting with the basics of C# desktop apps Continue reading “Beginning C# Desktop Apps”

Author Sean McCownPosted on September 8, 2022Categories Uncategorized

Logs and With Move

Here I’m talking about scale-out vs scale-up, along with SQL Continue reading “Logs and With Move”

Author Sean McCownPosted on August 1, 2022Categories Uncategorized

Regex SSIS Environment Variable Script

When you script SSIS environment variables it gives you all Continue reading “Regex SSIS Environment Variable Script”

Author Sean McCownPosted on July 29, 2022Categories Uncategorized

Backup Recovery Models

Here I teach the basics of recovery models, LSNs, and Continue reading “Backup Recovery Models”

Author Sean McCownPosted on July 27, 2022Categories Uncategorized

Backup Tuning: Maximize Network Backups

Covering more backup tuning with maxtransfersize and jumbo frames.

Author Sean McCownPosted on June 17, 2022Categories Uncategorized

PS Classes: Part 6 – Static Properties

Here we’re solving problems with static class properties and methods.

Author Sean McCownPosted on June 16, 2022Categories Uncategorized

1NF – 1st Normal Form

Here I’m talking about 1NF, not only in the context Continue reading “1NF – 1st Normal Form”

Author Sean McCownPosted on June 3, 2022Categories Uncategorized

Which TYPE of Therapy is Right?

I’m Kati Morton, a licensed therapist making Mental Health videos!
#katimorton Continue reading “Which TYPE of Therapy is Right?”

Author Sean McCownPosted on June 2, 2022Categories Uncategorized

Digital Transformation: Thriving Through the Transition – Jeffrey Snover, Microsoft

Jeffrey Snover, Technical Fellow and Chief Architect for Azure Storage Continue reading “Digital Transformation: Thriving Through the Transition – Jeffrey Snover, Microsoft”

Author Sean McCownPosted on May 8, 2022Categories Uncategorized

TUNE your SQL Server Backups (or, “Limits…in Theory”) – Part 3

Part 3 of our backup tuning class. Today we’re talking Continue reading “TUNE your SQL Server Backups (or, “Limits…in Theory”) – Part 3″

Author Sean McCownPosted on April 29, 2022Categories Uncategorized

Powershell Classes: Part 4 – Inheritance

Here we’re talking about inheritance in PS and what it’s Continue reading “Powershell Classes: Part 4 – Inheritance”

Author Sean McCownPosted on February 3, 2022February 3, 2022Categories Uncategorized

CPU Affinity in SQL Server

Here we talk about how to adjust CPU affinity Continue reading “CPU Affinity in SQL Server”

Author Sean McCownPosted on February 3, 2022Categories Uncategorized

Xp_cmdshell Discussion

Author Sean McCownPosted on January 21, 2022Categories Uncategorized

Classes in Powershell- Part 2

Here I’m continuing my live class in writing classes in Continue reading “Classes in Powershell- Part 2”

Author Sean McCownPosted on January 5, 2022Categories Uncategorized

Redirect command line output in SSIS script task

Here I’m going to show you how to use an Continue reading “Redirect command line output in SSIS script task”

Author Sean McCownPosted on May 11, 2021May 11, 2021Categories Development, SSIS, UncategorizedTags AWS, File processing, S3, Script Task, SSIS

DBAs@Midnight: The 4th Dimension, episode 1

DBAs@Midnight is back, because this is a REALLY WEIRD timeline Continue reading “DBAs@Midnight: The 4th Dimension, episode 1”

Author Sean McCownPosted on April 12, 2020Categories Uncategorized

Two Total Strangers Have Saxophone Battle On NYC Subway Train

Author Sean McCownPosted on August 10, 2019Categories Uncategorized

T-SQL’s Hidden Support Feature

T-SQL’s Hidden Support Feature

The most effective T-SQL support feature comes installed with every Continue reading “T-SQL’s Hidden Support Feature”

Author Sean McCownPosted on September 11, 2018Categories Uncategorized

Tea with Kalen Delaney – May 2018

Tea with Kalen Delaney – May 2018

We sat down with Kalen again, RIGHT after her big Continue reading “Tea with Kalen Delaney – May 2018”

Author Sean McCownPosted on May 22, 2018Categories Uncategorized

BCP With Hyperbac

BCP With Hyperbac

Here I show you how to automatically compress BCP operations with Hyperbac. It’s just a cool bonus you get when you do you database Continue reading “BCP With Hyperbac”

Author Sean McCownPosted on October 1, 2017Categories Uncategorized

BROWSE VIDEOS

By Subject

  • Administration
    • Backup and Restore
    • BCP
    • Optimization
    • Powershell
    • Other
  • Development
    • SSIS
    • TSQL
    • Other
  • Minion
    • Minion Enterprise
    • Minion Backup
    • Minion Reindex
    • Minion CheckDB

WEBSHOW

  • DBA’s@midnight
    • Season 1
    • Season 2
    • Season 3
    • Season 4

BROWSE CATEGORIES

  • Administration
  • Backup and Restore
  • BCP
  • DBAs@Midnight
  • Development
  • Events
  • HADR
  • Minion
  • Minion Backup
  • Minion CheckDB
  • Minion Enterprise
  • Minion Reindex
  • Optimization
  • Other
  • Other
  • Powershell
  • season 1
  • Security
  • SSIS
  • SSRS
  • TSQL
  • Uncategorized

BROWSE TAGS

.NET Administration AWS Backup/Restore BCP Clustering Config Development Enterprise Administration File issues File processing HADR HTML Index Maintenance Minion Backup Minion CheckDB Minion Enterprise Minion Reindex Modeling Office365 Performance Powershell Regex Reindex Replication S3 Script Task Security SMO Soft Skills SQL Saturday SSIS SSRS Stored Procedures T-SQL Troubleshooting Virtual Computing Visual Studio Windows

OUR WEBSITES


BLOGS

DBA Rant
The MidnightDBA Star
Minion Blog

  • About us
  • Links
  • FAQs
  • Contact
Copyright MidnightDBA