Let’s get back to DBAs@Midnight, and talk enterprise management in Continue reading “DBAs@Midnight 2024-001: Well hellooooo there!”
Author: Sean McCown
The Ultimate Guide to SQL Server Management with Minion Enterprise
Here is our no-nonsense, live LinkedIn event recording: “The Ultimate Continue reading “The Ultimate Guide to SQL Server Management with Minion Enterprise”
Named File Streams
Have you ever wondered how Windows keeps track of file Continue reading “Named File Streams”
Prepared SQL
Have you ever wondered what prepared SQL is? It’s Continue reading “Prepared SQL”
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”
Powershell Format-Table Expressions
You can create custom columns using expressions in format-table.
Here I Continue reading “Powershell Format-Table Expressions”
MinionWare M.E. – Navigating Minion Enterprise
Once Minion Enterprise is installed and configured, you need to Continue reading “MinionWare M.E. – Navigating Minion Enterprise”
Beginning Desktop Apps: 02
Continuing with desktop apps, we talk about populating combo boxes, Continue reading “Beginning Desktop Apps: 02”
Beginning C# Desktop Apps
Here we’re starting with the basics of C# desktop apps Continue reading “Beginning C# Desktop Apps”
Logs and With Move
Here I’m talking about scale-out vs scale-up, along with SQL Continue reading “Logs and With Move”
Regex SSIS Environment Variable Script
When you script SSIS environment variables it gives you all Continue reading “Regex SSIS Environment Variable Script”
Backup Recovery Models
Here I teach the basics of recovery models, LSNs, and Continue reading “Backup Recovery Models”
Backup Tuning: Maximize Network Backups
Covering more backup tuning with maxtransfersize and jumbo frames.
PS Classes: Part 6 – Static Properties
Here we’re solving problems with static class properties and methods.
1NF – 1st Normal Form
Here I’m talking about 1NF, not only in the context of a table, but also in the context of a DB or even an enterprise.
1NF – 1st Normal Form
Here I’m talking about 1NF, not only in the context Continue reading “1NF – 1st Normal Form”
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?”
SSIS: EventHandlers
This is a quick intro to event handlers in SSIS. Continue reading “SSIS: EventHandlers”
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”
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″
Backup Tuning: Part 02
This is our 2nd session on backup tuning. Today Continue reading “Backup Tuning: Part 02”
Backup Tuning – Part 1
This is an extension of my backup tuning session that Continue reading “Backup Tuning – Part 1”
Microsoft SQL Server – Powershell Splatting
Help keep your command code organized by splatting parameters. Continue reading “Microsoft SQL Server – Powershell Splatting”
Minion Backup Intro Webinar: 6/1/2016
This is an intro to Minion Backup that shows you Continue reading “Minion Backup Intro Webinar: 6/1/2016”
Get started with Minion Enterprise – What is ME?
What is Minion Enterprise? It’s enterprise management. Automation. Auditing. And Continue reading “Get started with Minion Enterprise – What is ME?”
T-SQL: Switching data with a Single Partition
This is the fastest way to move data to a new table. Of course, you have to move all the data, but it’s quite useful. Tables are partitioned in SQL by default so this is a great technique.
Microsoft SQL Server – T-SQL: Switching data with a Single Partition
This is the fastest way to move data to a Continue reading “Microsoft SQL Server – T-SQL: Switching data with a Single Partition”
Powershell Classes: Part 5 – Inheritance con’t
Here we finish up the discussion on inheritance and we Continue reading “Powershell Classes: Part 5 – Inheritance con’t”
Powershell Classes: Part 4 – Inheritance
Here we’re talking about inheritance in PS and what it’s Continue reading “Powershell Classes: Part 4 – Inheritance”
CPU Affinity in SQL Server
Here we talk about how to adjust CPU affinity Continue reading “CPU Affinity in SQL Server”
Powershell Classes: Part 3
This is part 3 of our series on how to
create classes in powershell.
We start by going over homework and then get into hidden classes and creating a fire hazard in our code.
Watch Part 1
Watch Part 2
Watch Part 4
Watch Part 5
Classes in Powershell: Part 2
Here I’m continuing my live class in writing classes in powershell. We go over adding some useful properties and developing a help system.
Classes in Powershell- Part 2
Here I’m continuing my live class in writing classes in Continue reading “Classes in Powershell- Part 2”
Classes in Powershell: Part 1
Ever want to create your own classes in powershell? Continue reading “Classes in Powershell: Part 1”
The Truth About SQL Security
Here I show you how xp_cmdshell isn’t the danger everyone Continue reading “The Truth About SQL Security”
Speed SQL backups with COMPRESSION
Just a quick little talk about _why_ backup compression is Continue reading “Speed SQL backups with COMPRESSION”
Powershell Error Handling Basics 2
Continuing with our discussion on PS error handling.
Watch the first vid here:
XP_CmdShell Default Proxy
Most DBAs don’t think of it, but xp_cmdshell has a
default proxy account. In fact, this proxy is responsible for its permissions, and actually follows Microsoft’s current external script security strategy. So xp_cmdshell isn’t unique and it doesn’t do anything special security-wise.
Here you’ll see how to test which credentials xp_cmdshell is using. It’s actually pretty easy.
Powershell Error Handling Basics
This is a live session where I teach someone the
basics of PS error handling.
Here’s the 1st vid in the series.
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”
Empower SQL Server database teams
Here at MinionWare, we are on a mission to help Continue reading “Empower SQL Server database teams”
Invitation to Automation
Here’s a quick word about Minion Enterprise!
Your DBA team needs Continue reading “Invitation to Automation”
Private video
This video is private.
DBAs@Midnight: The 4th Dimension, episode 2
DBAs@Midnight is back WITH VIDEO this time! This week’s episode Continue reading “DBAs@Midnight: The 4th Dimension, episode 2”
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”
Master Stored Procedure Workshop: Part 2
This is part 2 of the previous session from SQLSaturday Continue reading “Master Stored Procedure Workshop: Part 2”
Master Stored Procedure Workshop: Part 1
This is from SQLSaturday Richmond, VA on 3/30/2019.
I’m teaching stored Continue reading “Master Stored Procedure Workshop: Part 1”
Beginning SQL Server SMO
Recently I was invited to talk about beginning SMO on Continue reading “Beginning SQL Server SMO”
Loading SQL Data From Powershell
Learn how to load data into and out of SQL Continue reading “Loading SQL Data From Powershell”
REGEX for DBAs
This is the version of my session that works with Continue reading “REGEX for DBAs”
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”
Database Unit Testing with SSDT
DB unit testing has been a cloud for a long Continue reading “Database Unit Testing with SSDT”
Series: Setup SQL Server Cluster- 9 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 9 of 15”
Series: Setup SQL Server Cluster- 11 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 11 of 15”
Series: Setup SQL Server Cluster- 12 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 12 of 15”
Series: Setup SQL Server Cluster- 1 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 1 of 15”
Series: Setup SQL Server Cluster- 2 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 2 of 15”
Series: Setup SQL Server Cluster- 13 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 13 of 15”
Series: Setup SQL Server Cluster- 4 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 4 of 15”
Series: Setup SQL Server Cluster- 7 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 7 of 15”
Series: Setup SQL Server Cluster- 8 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 8 of 15”
Series: Setup SQL Server Cluster- 5 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 5 of 15”
Series: Setup SQL Server Cluster- 15 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 15 of 15”
Series: Setup SQL Server Cluster- 6 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 6 of 15”
Series: Setup SQL Server Cluster- 14 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 14 of 15”
Series: Setup SQL Server Cluster- 10 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 10 of 15”
Series: Setup SQL Server Cluster- 3 of 15
This is a training course that was intended to be Continue reading “Series: Setup SQL Server Cluster- 3 of 15”
Tea with Kalen Delaney – May 2018
We sat down with Kalen again, RIGHT after her big Continue reading “Tea with Kalen Delaney – May 2018”
REGEX: Use Lookbehind for PRINT Statements
Regular find can’t show you negative searches. That’s searches where letters don’t exist. So here I’m going to show you how to find Continue reading “REGEX: Use Lookbehind for PRINT Statements”
Beginning Powershell for DBAs: Part 1
The time has come where DBAs can no longer afford to ignore Powershell. Not only has it become an integral part of SQL Server, but Continue reading “Beginning Powershell for DBAs: Part 1”
Sean’s Famous Backup Tuning class!
Yes, you can tune your SQL Server backups!
Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of Continue reading “Sean’s Famous Backup Tuning class!”
Regex: Removing Restore Statement Dupes
This is a great video to show you how to think in a way that gets you a good regex. Here I’ve got SQL Continue reading “Regex: Removing Restore Statement Dupes”
What are Orphaned Users?
Here I’ll describe what an orphaned user is and how it happens. I’ll even show you how to produce the condition yourself. Orphaned Continue reading “What are Orphaned Users?”
Replication: Initialize with Backup
Sometimes your DB is so big you need to initialize replication with a backup and restore instead of a snapshot. Here I show you Continue reading “Replication: Initialize with Backup”
Minion Backup: Regex vs. DBGroups
In Minion Backup, you can use regex to include/exclude DBs from a backup. This actually works with all of the modules, so it’s included Continue reading “Minion Backup: Regex vs. DBGroups”
Minion Backup: Exclude DBs by Size
In Minion Backup you can exclude DBs from backup based on any criteria you like. Here I’ll show you a good example with excluding Continue reading “Minion Backup: Exclude DBs by Size”
Regex Word Boundary Example
It’s one thing to know the syntax for word boundaries in regex and it’s another to actually be able to use them. So here Continue reading “Regex Word Boundary Example”
Regex Word Boundaries
Here I’m going to show you how to use regex word boundaries. Word boundaries allow you to match entire words, or even words that Continue reading “Regex Word Boundaries”
Regex Lookarounds
In regex you can perform lookarounds to check for matches that don’t get consumed. These are zero-length assertions that merely report the match. Here Continue reading “Regex Lookarounds”
Find double words in regex
Here I show you how to use a backreference in regex to be able to find double words in regex. What you’ll learn how to do Continue reading “Find double words in regex”
Find Log Space Used
Find out how to query the log space usage for all DBs on the server with a single statement. This is a quick way Continue reading “Find Log Space Used”
How to set PasswordNeverExpires for Office 365 Users
In O365 you can only set a user password to never expire using powershell. Here I show you how to do it.
Here are the Continue reading “How to set PasswordNeverExpires for Office 365 Users”
Mouth Wide Shut: Coherent Interviewing
Sean and Jen lend their unique style of teaching to talk to you about the ins and outs of passing a technical interview. You Continue reading “Mouth Wide Shut: Coherent Interviewing”
Sean’s Killing Spree
This week we have a big collection of end user Continue reading “Sean’s Killing Spree”
The SANs Of Time
Today we start by talking about security vs. the appearance Continue reading “The SANs Of Time”
Zombie Jesus Weekend
Just returning from London and having missed filming last week, Continue reading “Zombie Jesus Weekend”
FishBoy
Season 4 starts here with a glorious discussion on ORMs, Continue reading “FishBoy”
DBAs@Denver
This week we were in Denver for SQL Saturday #169. Continue reading “DBAs@Denver”
The Wendy City
Tonight we talked about consulting, PASS board elections, and a Continue reading “The Wendy City”
Precon Sean
We talked about precons, news, Sean’s firing story, consulting, PASS/Inappropass, Continue reading “Precon Sean”
Ready for PASS
Today we’re all about user group elections, our UG class, Continue reading “Ready for PASS”
Halloween 2012
This episode, we talked about Sean’s junior DBAs, SAN follies, Continue reading “Halloween 2012”
Be Specific, Bob
Tonight was all about Surface, PASS tips and precons, and Continue reading “Be Specific, Bob”
PASS 2012
We’re at PASS this week, and so by the time Continue reading “PASS 2012”
Microsoft Blew It!
Tonight, an argument (phobias vs. compulsions), how Microsoft has already Continue reading “Microsoft Blew It!”
Schroedinger’s Server
We talked about the holidays, of course. We had a Continue reading “Schroedinger’s Server”
Xmas/Doomsday
Tonight, we talked about news (as usual), getting after-hours work Continue reading “Xmas/Doomsday”
Vendorbaiting
Tonight, we talked about news (as usual), getting after-hours work Continue reading “Vendorbaiting”
Ninja SPID
We have a new set! We had a couple of Continue reading “Ninja SPID”
Real or Fake?
We had a ton of real news today, plus stupid Continue reading “Real or Fake?”
SSMS: Client Stats
Proving a query is inefficient can be hard, but with solid numbers to back you up, you’ll be able to prove that a huge query Continue reading “SSMS: Client Stats”
What is a Stored Procedure
Here Jen explains what a stored procedure is, and how to create a basic one with no parameters. She also compares it with other Continue reading “What is a Stored Procedure”
Object Properties in Powershell
This is a great video that shows you how to look at the properties collection in objects and explains what the different properties mean. Continue reading “Object Properties in Powershell”
Script PK/FKs in Powershell
Here I show you how to script out objects that belong to tables like primary keys, forgeign keys, constraints, and indexes with powershell. It’s Continue reading “Script PK/FKs in Powershell”
Get into SQL
Have you ever found yourself locked out of SQL because your account doesn’t have rights and you don’t know the sa password? Here I Continue reading “Get into SQL”
Troubleshoot Default Schema
Here I troubleshoot why a user’s default schema isn’t being honored.
Best Backup Class Evar: 6 of 6
The 6th in the backup class at NTSSUG.
Best Backup Class Evar: 5 of 6
The 5th in the backup class at NTSSUG.
Best Backup Class Evar: 3 of 6
The 3rd in the backup class at NTSSUG.
Best Backup Class Evar: 2 of 6
The 2nd in the backup class at NTSSUG.
Change Users Password
Users don’t need special permissions to change their own passwords, but there is a minor trick to it. Here I’ll show you 3 ways Continue reading “Change Users Password”
Find File Lock
Have you ever been plagued by a file you couldn’t delete or move because it was being held open by something else? Well here Continue reading “Find File Lock”
Server Properties
Have you ever wanted to be able to view instance-level stats or change certain values without having to use the GUI? Here I’ll show Continue reading “Server Properties”
Optimize For Adhoc Workloads
There’s a lovely sp_configure option that can help you keep the size of your plan cache under control. Let’s go have some fun.
Insert Into vs. Select Into
Knowing how and when to use Insert Into or Select Into can quite often make or break your load process. Here I show you Continue reading “Insert Into vs. Select Into”
Best Backup Class Evar: 4 of 6
The 4th in the backup class at NTSSUG.
The Reverse Godfather
This was a fun episode. We talk about Intel’s Continue reading “The Reverse Godfather”
P.I.O.
This was such a fun week. We talked about Continue reading “P.I.O.”
Season 3 Opener
We’re kicking off another season with a bang. We Continue reading “Season 3 Opener”
Slightly Used Interview
Leave it to us to bring you all the big Continue reading “Slightly Used Interview”
It’s Being Mailed
This was such a fun week. We talked about Continue reading “It’s Being Mailed”
STOP!!!
This is a special election episode. We have 2 Continue reading “STOP!!!”
DBAs@Midnight 9.9 – Star Trek Can’t do Security
The definition of insanity. Wolves. Bad shows you loved anyway. Continue reading “DBAs@Midnight 9.9 – Star Trek Can’t do Security”
Bring in the Nerds
A fabulous show this week. We have Denny Cherry, Continue reading “Bring in the Nerds”
Xmas Special
This is a xmas blowout like no other. We Continue reading “Xmas Special”
Campfire Stories
Welcome to our Halloween episode. We start off with Continue reading “Campfire Stories”
Sexy Hat Night
Tonight we talk about the best way to make sure Continue reading “Sexy Hat Night”
Stop Looking at Me
This was a fun episode where we talk about IT Continue reading “Stop Looking at Me”
We LOVE Mark
PASS Special: We make sure we talk to Mark Continue reading “We LOVE Mark”
Itzik Rules
PASS Special: What can I say… every time we Continue reading “Itzik Rules”
DBAs of Our Lives
It’s New Year’s Eve and we’re having some fun. Continue reading “DBAs of Our Lives”
SOPA Sucks
We have a wonderful show this week. Jen actually Continue reading “SOPA Sucks”
Forced Reboot
This week brings a fabulous interview skit, a nice rant, Continue reading “Forced Reboot”
Jen’s Milkshake
Tonight we have all kinds of good stuff. We Continue reading “Jen’s Milkshake”
Sean’s Pretty Hands
Tonight we have a very big announcement and we catch Continue reading “Sean’s Pretty Hands”
Goodbye Chef
This week we say goodbye to one of our favorite Continue reading “Goodbye Chef”
Yet here we are
We’ve got a fabulous debacle with ShrinkDB as well as Continue reading “Yet here we are”
Fake Projects for Steve
We’re back and on the tail of Sean’s plague. Continue reading “Fake Projects for Steve”
MVP Summit 2012
Well, we’re here at the MVP Summit in Seattle. Continue reading “MVP Summit 2012”
Change Startup Params in Powershell
I heard someone today say that you can’t change startup parameters in Powershell. So I made this vid to set the record straight.
Server Configuration Settings in Powershell
I love making vids on the trickier stuff and this one is it. Here we’re talking about duplicating sp_configure in Powershell. It’s pretty Continue reading “Server Configuration Settings in Powershell”
Drop Tables in Powershell
Today I’m dropping tables based off of a regex expression and by rowcount. Good stuff here. The power of the shell shines through Continue reading “Drop Tables in Powershell”
Truncate Tables in Powershell
Here I show you how to truncate a mass of tables in the same schema. Of course, you don’t have to limit it to Continue reading “Truncate Tables in Powershell”
Get SQL Server Root Dir in Powershell
Here we’re finding the root install directory for SQL Server.
Fix AutoShrink in Powershell
Here I show you how to turn off AutoShrink on a DB and then how to make sure it’s turned off on all your DBs.
Attach DBs in Powershell
This continues the series on detach/attach for DBs. Along the way I show you how to deal with a powershell provider bug, work with Continue reading “Attach DBs in Powershell”
Calling Detach Methods in Powershell
Detaching DBs in Powershell is pretty easy, which is why you should learn how to do it. It takes less typing than the t-sql Continue reading “Calling Detach Methods in Powershell”
Get IP and DNS in Powershell
Getting IP address and DNS info from your servers in a useful format isn’t as straightforward as you would think. Here I’m going to Continue reading “Get IP and DNS in Powershell”
Change Schema in Powershell
Changing object schemas is easy enough in T-SQL when it’s a single object, but it get considerably more complicated when you’ve got several objects to Continue reading “Change Schema in Powershell”
Change SQL Server Permissions in Powershell: Part 2
Continuing from the 1st video, here I show you how to capture useful errors from the method call. I explain how to Trap the Continue reading “Change SQL Server Permissions in Powershell: Part 2”
Read SQL Server Error Logs in Powershell
Would you like to work with the SQL Server error logs in Powershell? Well here I’m gonna show you how. Not only do Continue reading “Read SQL Server Error Logs in Powershell”
Cycle Error Log on all Servers using Powershell
Here I show you how to use the Carrier Method for using powershell to cycle all your error logs. This is an excellent way Continue reading “Cycle Error Log on all Servers using Powershell”
Largest SQL Server Installs
Kaylan Yella brings us another excellent session, this time on the largest SQL installs. If you’ve ever wanted to have some ammo for those Continue reading “Largest SQL Server Installs”
NCC-1701-DBA: 1 of 6
This is the first of a series to teach you how to think like and become an enterprise DBA. The skills and the mindset Continue reading “NCC-1701-DBA: 1 of 6”
Dealing with Sql_variant in SSIS
Every now and then you come across something you don’t want to deal with that you’re forced to handle in your SSIS packages. Here Continue reading “Dealing with Sql_variant in SSIS”
Deploying SSRS Reports
One of the most common questions I get is how to deploy reports in SSRS. Here I show you pretty much everything you need Continue reading “Deploying SSRS Reports”
Data-driven Subscriptions in SSRS
Here I get into an elegant method for giving users a report that has a dynamic distribution list. As DBAs we don’t want to Continue reading “Data-driven Subscriptions in SSRS”
Best Habit for Coders
There’s a step you can make in your code to improve it many times over. It’s an easy step to take, but it can Continue reading “Best Habit for Coders”
Querying Dev Metadata
Sometimes you need to get info on objects you’ve created. Here you can see how you can query for this info, and even learn Continue reading “Querying Dev Metadata”
A New Leaf
We’ve decided to become a kinder, gentler show. We’re Continue reading “A New Leaf”
DBAs@Midnight 9.10 – Try it Sometime
We had many lovely Letters from our Friends. Sean takes issue with “you don’t have a backup until…”
Also: Are SQL coders real coders? Continue reading “DBAs@Midnight 9.10 – Try it Sometime”
Useless Superpowers
I think we had a lot of fun this week. We talked about useless superpowers, rules for presenting to techies, and stuff we got Continue reading “Useless Superpowers”
Hottub of Bellydancers
This is probably our best show to date. Not only do we crown a new MVP, but we have so many HUGE gueses Continue reading “Hottub of Bellydancers”
Waits and Queues
Thomas LaRock from Confio came to give us this really good talk on waits and queues. And as an added bonus, the entire PASS Continue reading “Waits and Queues”
Replace sp_MSForEachDB with Powershell
A user request came in to write something in powershell that would replace sp_MSForEachDB. I took it a step further and showed you how Continue reading “Replace sp_MSForEachDB with Powershell”
Monitoring SAN Space
Monitoring SAN Space.
Intro to SSIS
Intro to SSIS.
Sum DB Sizes with Powershell
Quite often it can be useful to not only get a list of DB sizes, but also sum it up in the last line. Continue reading “Sum DB Sizes with Powershell”
Now with temp tables
This week Sean tells a fun story about being sarcastic at work. We also go into the topic of DR plans and talk about Continue reading “Now with temp tables”
UNION and UNION ALL
Here I talk about UNION and UNION ALL, and the different rules about using ORDER BY, GROUP BY, SELECT INTO, and INSERT INTO with a Continue reading “UNION and UNION ALL”
Windows Crash Dump Analysis
If Windows has ever bluescreened on you, then you know how important it can be to find the issue. Windows creates a crash dump Continue reading “Windows Crash Dump Analysis”
Sean gets 69
Tonight we talk about a big downtime at Pilgrim’s Pride, 24-HOP sessions, a yearly downtime report, ownership chains, cross joins, and much more.
You got munkey lips
Here we are on the back end of SQLSaturday #57 in Houston. We decided to make a party out of it and bring along Continue reading “You got munkey lips”
Slapping the dog
We’ve got an excellent show tonight. We have an excellent discussion on an update statement gone horribly wrong and how to prevent it. Continue reading “Slapping the dog”
They kept felons
We talked briefly about Egypt’s revolution, and then got onto the techie stuff: Companies We Love poll results, Un-SQL Friday, King 5 Fingers, Sean’s NetworkWorld Continue reading “They kept felons”
I would yank for Melissa
This week we’re all about sa passwords, buying software you don’t need, our new ringtones, and troubleshooting code errors.
Simple Mode prevents STDs
Our botched commercial, the new Infragistics MVP, resume review and much more on this week’s episode.
Falling Asleep on Tyra Banks
Tonight we talked about the magic tables, a cool clustering problem,orphaned windows accounts, cross join madness, and more.
Don Gill
Don is our special friend, but more importantly he’s the head of the BOL team. This is such an interesting interview you’ll just die.
Get Away from Me
Today we’re talking about database hacks, getting rid of problems, Denny Cherry’s new book, and more.
Leaking MVPee
Here we are on the back of the 2011 MVP Summit, and we’re gonna give away some Denali secrets. For those of you who Continue reading “Leaking MVPee”
Pimp-A-Thon
This week we talk about the Denali release date, Sean’s big new shiny SQLSaturday session on interviewing, and much more. There’s even a new Continue reading “Pimp-A-Thon”
The Peeping Jedi
This was a fun night. We talked about Yoda’s naughty shower habits, did a lot of bitching about SAN guys, company loyalty, and much Continue reading “The Peeping Jedi”
Itzik knows all
Jen got to visit with Itzik Ben Golly and get some answers to some coding questions, and I presented 2 awards. There was also Continue reading “Itzik knows all”
Installed Anally
Wow, what a good show this week. We talked about setting max server memory, how to get ready for cert exams, massive feature packs, Continue reading “Installed Anally”
Allan! Allan! Allan! Allan! Allan!
Allan Hirt actually cam into our studio and played the base for us. And while he was here we thought we’d ask him a Continue reading “Allan! Allan! Allan! Allan! Allan!”
Cherry Cheesecake
This week we cover Sean’s mainframe story, twitter updates, Allan Hirt’s new whitepaper, and Itzik is here again.
LOL Cats
This was a fun week because we talked about xlocks on tempdb, nested views, and new SQL languages.
Season 2 Finale
Another season comes to a close. We give a nice recap of the entire season, a strange DB problem, and adding NULLs. And Continue reading “Season 2 Finale”
Uninstall a CU in SQL Server 2008 R2
Here I’ll show you how to uninstall a CU from SQL Server 2008 R2, CU5 to be specific, but it doesn’t matter. Here there’s Continue reading “Uninstall a CU in SQL Server 2008 R2”
Database Performance
Paul and Kim Tripp from SQLSkills.com came to teach us their award-winning presentation on DB performance.
Find query timeouts in Profiler
I like this video. This is a simple example of how you can track down queries that are timing out. Be careful though. Continue reading “Find query timeouts in Profiler”
DBAs@Midnight 9.8 – *Blink*Blink*Blink*
Terrible phishing attempts, bad puns, nice allegations, a PASS Suummit recap..this week’s episode has it all. As usual!
DBAs@Midnight 9.7 – Seven of Nine
We have Minion recommendations from the world, a good-bad RegEx pun, the interview tip of the week, a story of a rescue at sea, and Continue reading “DBAs@Midnight 9.7 – Seven of Nine”
DBAs@Midnight 9.6 – Say You’re Sorry
Letters from our Friends, the stupid interview answer of the week, a letter from all women, more irritated wordgasms, a poorly rehearsed song, and another Continue reading “DBAs@Midnight 9.6 – Say You’re Sorry”
DBAs@Midnight 9.4 – Invisible Mask
We have punful letters from our friends, a letter from Elon Musk (not to us). We talk about the Equifax breach. Sean sings a brand Continue reading “DBAs@Midnight 9.4 – Invisible Mask”
DBAs@Midnight 9.5 – We’re paying 8K
In this show:
A skit
A song
MARVELOUS things
“It was spontaneous when I rehearsed it!”
What is a basic?
Good interviewing advice
And, of course, more
Developing Dynamic SSIS
Dynamic SSIS.
Loading Files without SSIS
Loading Files without SSIS.
Monitor Backups with Powershell
I know you guys are just begging for an easy way to monitor your backups and alert when one hasn’t been backed up recently. Continue reading “Monitor Backups with Powershell”
Audit Service Accounts with Powershell
How would you like to be able to audit your service accounts with powershell so you can tell how many boxes are running on the Continue reading “Audit Service Accounts with Powershell”
Sean’s Rub-n-Tug: 3 of 5
Part 3 of Sean’s Rub-n-Tug
Sean’s Rub-n-Tug: 4 of 5
Part 4 of Sean’s Rub-n-Tug
Sean’s Rub-n-Tug: 5 of 5
Part 5 of Sean’s Rub-n-Tug
Sean is Petri’s Dish: 1 of 4
Here we talk about an extremely bad cluster install done by one of my DBAs.
Sean is Petri’s Dish: 2 of 4
Part 2 of Sean is Petri’s Dish.
Sean is Petri’s Dish: 3 of 4
Part 3 of Sean is Petri’s Dish.
Sean is Petri’s Dish: 4 of 4
Part 4 of Sean is Petri’s Dish.
Season 1 Finale
The finale of our 1st season. Some good discussion here.
Aristocratic Corn
Our first show of season 2. We catch everyone up on what’s been going on since we left and throw in some SSIS discussion Continue reading “Aristocratic Corn”
Sean’s Man-crush
This week we talk about Freddie bringing our site down, we unveil a new award, and we had a near cornhole of the week. Continue reading “Sean’s Man-crush”
Polishing Dung
This week we’re talking about all kinds of things, the main one being people getting started as speakers and community leaders. There’s lots of Continue reading “Polishing Dung”
The Unnamed Episode
This week was pure fun as we talked about building clusters, Sean’s Scripting Guys article, and whether or not you should rally people to vote Continue reading “The Unnamed Episode”
Hot Tubbin With Bob
What a fun episode this was. We talked about sexual harrassment and many other things. Come have a few laughs and maybe even Continue reading “Hot Tubbin With Bob”
Olympic Cornholing
This week we talk about sex week on MidnightDBA as well as big production problems, crappy vendors, and more.
What kind of pistol?
Sorry, I don’t remember what we talked about here cause I’m uploading so late. You’ll just have to come see.
Your Face or Mine?
I suppose this is officially our Halloween episode. Come along as we discuss whatever it is we talked about here.
No Management DBs
I suppose this is officially our Halloween episode. Come along as we discuss whatever it is we talked about here.
Steve Jones in the House!!
We hooked up with Steve Jones of SQLServerCentral.com in an empty ballroom we hijacked the night before PASS. He’s so laid back we decided Continue reading “Steve Jones in the House!!”
Denny ‘Five Fingers’ Cherry
Denny is one of our best friends at PASS. We were all so tired that we cut the talk short and meant to get Continue reading “Denny ‘Five Fingers’ Cherry”
Grant Fritchey is our Hero
What can we say about Grant that isn’t already in the police report? He’s just an interesting guy. Come see us discuss query Continue reading “Grant Fritchey is our Hero”
Merkin Glue
This is our show at the end of PASS 2010 and we have Nic Cain in our hotel room. Come have a look while Continue reading “Merkin Glue”
Bathrobe Bonanza
This is our post-Thanksgiving episode. Today we talk about why Bing sucks, jr. DBAs, and the cloud.
Adam Machanic has soft hands
We love talking to Adam. He’s such a cool dude and it just so happens that he really knows his stuff too. I Continue reading “Adam Machanic has soft hands”
Clustering: Part 3
Here we have the 3rd class by Kal. This time he was cool enough to take time out of his busy schedule and record Continue reading “Clustering: Part 3”
Clustering: Part 2
Here we have the 2nd class by Kal. This time he was cool enough to take time out of his busy schedule and record Continue reading “Clustering: Part 2”
Ground Zero SSIS: Class 1
This is the 1st class I’m teaching at the NTSSUG for ground zero SSIS. I hope to have 6 in all, but it may Continue reading “Ground Zero SSIS: Class 1”
Correlate Lock Timeouts with Statements
I’ve been getting lock timeouts on one of my systems, so I captured the timeouts in a profiler trace. Here, we walk through developing a Continue reading “Correlate Lock Timeouts with Statements”
Check if File Exists
Inspired by a user question I decided to make a quick vid on how to use a script task to check that a file exists. Continue reading “Check if File Exists”
Clustering 101
SPEAKER: Kaylan Yella. We were fortunate enough to get someone of his skill to teach us about clustering. The basics take a lot Continue reading “Clustering 101”
Designing Efficient Functions
Here I get on my cert soapbox again. I was going through a practice cert exam and came across an answer to a question Continue reading “Designing Efficient Functions”
OR is bad, IF is good
Here I tell you about a common mistake – using OR instead of IF – and show you that IF is better.
Companies don’t Care
We’re back with another DBAs@Midnight. This week we’re talking about how companies don’t really care enough about their employees to keep them. We Continue reading “Companies don’t Care”
Resumes: 2 of 3
Part 2 of Resumes.
Resumes: 3 of 3
Part 3 of Resumes.
Breaking up with your Boss: 1 of 4
This is another one that I just love. We ramble on a bit I think, but overall I think we give some good info Continue reading “Breaking up with your Boss: 1 of 4”
Stuff Auction: 3 of 3
Part 3 of Stuff Auction. Priorities and important questions on the first day of your job, a quick recap, we wander for a bit after Continue reading “Stuff Auction: 3 of 3”
Evangelizing SQL Part: 1 of 3
This is a fun vid where we talk about evangelizing SQL in your company, getting devs to take part in code reviews, and much more. Continue reading “Evangelizing SQL Part: 1 of 3”
Evangelizing SQL Part: 2 of 3
Part 2 of Evangelizing SQL
Evangelizing SQL Part: 3 of 3
Part 3 of Evangelizing SQL
How to Spin a Firing: 2 of 3
Part 2 of How to Spin a Firing.
No Religion at Work: 1 of 4
This is a nice film with a few good laughs and we also get in our first on-film fight. However, come with us to Continue reading “No Religion at Work: 1 of 4”
No Religion at Work: 2 of 4
Part 2 of No Religion at Work.
No Religion at Work: 3 of 4
Part 3 of No Religion at Work.
No Religion at Work: 4 of 4
Part 4 of No Religion at Work.
Plagiarism: 1 of 4
This is a fun one we did in Redmond while waiting for the SQL Server R2 TweetUp event at MS. We’re here with Denny Continue reading “Plagiarism: 1 of 4”
Plagiarism: 2 of 4
Part 2 of Plagiarism.
Plagiarism: 3 of 4
Part 3 of Plagiarism.
Plagiarism: 4 of 4
Part 4 of Plagiarism.
Adopting New Features: 1 of 4
While playing with our SQLChickens, we’re trying to top the plagiarism video from last week in Redmond. So after messing around a little bit, Continue reading “Adopting New Features: 1 of 4”
Adopting New Features: 2 of 4
Part 2 of Adopting New Features.
Adopting New Features: 3 of 4
Part 3 of Adopting New Features.
Adopting New Features: 4 of 4
Part 4 of Adopting New Features.
T-SQL Code Sins
SPEAKER: Jen McCown. Do you know how to set yourself for good coding practices? Well Jen does. Come see the advice she Continue reading “T-SQL Code Sins”
Ground Zero SSIS: Class 3
Here in another live presentation to NTSSUG we discuss where to hold your query inside your packages, as well as get into flatfile error handling.
Data Mining 101
SPEAKER: Andrew Minkin. Drew stopped by to teach all of us mortals about data mining. There’s so much more to cover in this Continue reading “Data Mining 101”
Ground Zero SSIS: Class 2
In this 2nd class we discuss how to decide whether you should architect your table loads in single or multiple packages. We also start Continue reading “Ground Zero SSIS: Class 2”
Beginning Execution Plans
Here’s a level zero introduction to tuning queries. I go over execution plans, sp_help, and clustered primary key indexes.
HTML: Table Basics
Continuing with basic HTML, I talk about table basics here. I’m not kidding; this is basic. So if you already know anything about Continue reading “HTML: Table Basics”
Clean Package Design
This is a nice little primer on designing clean packages that are easier to support. Get rid of the sea of arrows that afflict Continue reading “Clean Package Design”
Manage DB Files in Powershell
I’m excited to be able to film this one because it has the potential to save you so much time and effort. I’m showing Continue reading “Manage DB Files in Powershell”
Start Agent Jobs in Powershell: Part 2
Starting SQL Agent jobs in powershell part 2.
Start Agent Jobs in Powershell
Starting SQL Agent jobs in powershell is easy, but there’s a trick to it that’s not obvious. Here I’ll show you how to start Continue reading “Start Agent Jobs in Powershell”
T-SQL Codig Sins: SQL Saturday #41 – Atlanta
Come see Jen teach T-SQL Code Sins at SQL Saturday #41 in Atlanta. You see these huge mistakes in many shops so come take Continue reading “T-SQL Codig Sins: SQL Saturday #41 – Atlanta”
Get Table Stats with Powershell
Let’s get stats for every table in the DB and put them in a file so we can send them to a customer or view Continue reading “Get Table Stats with Powershell”
Fire the Samurai: 1 of 4
This week we talk about the death of Database Underground, Jen stealing at work, and much more.
Fire the Samurai: 2 of 4
Part 2 of Fire the Samurai.
Fire the Samurai: 3 of 4
Part 3 of Fire the Samurai.
Fire the Samurai: 4 of 4
Part 4 of Fire the Samurai.
Sean’s Rub-n-Tug: 1 of 5
We talk about a few things here, one of which is parameter sniffing. I know we’ve covered this before, but it keeps coming up Continue reading “Sean’s Rub-n-Tug: 1 of 5”
Sean’s Rub-n-Tug: 2 of 5
Part 2 of Sean’s Rub-n-Tug
Firing DBAs: Part 1
This week we have a nice talk about how to handle a DBA who isn’t performing like he should (No, not like that!!). We Continue reading “Firing DBAs: Part 1”
Firing DBAs: Part 2
Part 2 of Firing DBAs.
Firing DBAs: Part 3
Part 3 of Firing DBAs.
Firing DBAs: Part 4
Part 4 of Firing DBAs.
Recompiling and Parameter sniffing: 1 of 5
We talk about so many things here it’s hard to nail it all down in a summary. Let’s see though, we talk about companies Continue reading “Recompiling and Parameter sniffing: 1 of 5”
Recompiling and Parameter sniffing: 2 of 5
Part 2 of Recompiling and Parameter sniffing.
Bobble-Head Buck: 1 of 5
This is kind of a fun video. We talk about Buck’s bobble head along with DNS and DR, and the joy of logon triggers.
Bobble-Head Buck: 2 of 5
Part 2 of Bobble-Head Buck.
Bobble-Head Buck: 4 of 5
Part 4 of Bobble-Head Buck.
Bobble-Head Buck: 5 of 5
Part 5 of Bobble-Head Buck.
Bobble-Head Buck: 3 of 5
Part 3 of Bobble-Head Buck.
Buck’s Taint: 1 of 5
We start out this episode with a great discussion on taints. Does it actually ite into IT? You’ll have to come and find Continue reading “Buck’s Taint: 1 of 5”
Buck’s Taint: 2 of 5
Part 2 of Buck’s Taint.
Buck’s Taint: 3 of 5
Part 3 of Buck’s Taint.
Buck’s Taint: 4 of 5
Part 4 of Buck’s Taint.
Buck’s Taint: 5 of 5
Part 5 of Buck’s Taint.
The Latin DB: 1 of 5
We start this episode with the special guest we’ve been talking about. Then we talk about the Latin DB, and all kinds of things.
The Latin DB: 2 of 5
Part 2 of The Latin DB.
Keeping your Sanity when out of Work: Part 1
Here we’re discussing some ways of keeping your sanity and your confidence when you’re out of a job so you can ensure you get that Continue reading “Keeping your Sanity when out of Work: Part 1”
Keeping your Sanity when out of Work: Part 2
We’re continuing the discussion of keeping your sanity while out of work.
Fix SSIS Pkg Import Errors
This is a live troubleshooting video. I had an error importing an SSIS pkg so I turned on the camera and worked the issue Continue reading “Fix SSIS Pkg Import Errors”
Add User to Windows Group with Powershell
I love this video because it’s so unusual to find something like it in the DBA community. We’re quite often called on to do Continue reading “Add User to Windows Group with Powershell”
Get a Specific Method in Powershell
Sometimes the list of properties and methods is too big to sift through when you do a get-member on an object. Here I’ll show Continue reading “Get a Specific Method in Powershell”
Change DB Compatibility Level in Powershell
Here I show you 2 easy ways to change the DB compatibility level in powershell. Otherwise you have to use a T-SQL cursor and Continue reading “Change DB Compatibility Level in Powershell”
Build .Net Objects in Powershell
I just love the topic of this video. Here we show you how to create .NET code with powershell. While we create an Continue reading “Build .Net Objects in Powershell”
Good Interview Still Don’t Get the Job: Part 1
Hey guys… here we kick off a discussion about some reasons why you may still not get the job even though you had an excellent Continue reading “Good Interview Still Don’t Get the Job: Part 1”
Good Interview Still Don’t Get the Job: Part 2
OK, we’re just continuing our discussion of having an excellent interview.
DBAs@Midnight: No Moving Schema
OK guys, here we’re talking about no moving schema. If you don’t know what that is, then watch this and see not only what Continue reading “DBAs@Midnight: No Moving Schema”
DBAs@Midnight: Managing Tasks 1 of 2
This one was rather fun because it was another one of those nights when were were both rather punchy. HOwever, amidst all the messing Continue reading “DBAs@Midnight: Managing Tasks 1 of 2”
DBAs@Midnight: Managing Tasks 2 of 2
Here’s the exciting conclusion to the 1st one.
PASS Summit 09 Interview: Itzik Ben-Gan, 1of2
We found Itzik at PASS 2009 and decided to keep him. This is a very informative interview on a number of topics.
PASS Summit 09 Interview: Itzik Ben-Gan, 2 of 2
Part 2 of Itzik.
Get Jiggy with Allen White: 1 of 2
We’re here at PASS 2009 in Seattle and we caught up with my friend Allen White. We talked about SQL, and Oracle, and even Continue reading “Get Jiggy with Allen White: 1 of 2”
Get Jiggy with Allen White: 2 of 2
Finishing up with Allen White… good times.
The Early Bird Gets Brian Knight: 1 of 2
What can I say, Brian is just the bomb. He has more SSIS knowledge under his fingernails than the rest of us do all Continue reading “The Early Bird Gets Brian Knight: 1 of 2”
The Early Bird Gets Brian Knight: 2 of 2
Brian’s cute, and brilliant, and he’s here for another round.
Bill Ramos Talks Tools: 1 of 2
If you don’t know Bill, he’s on the tools team, so he’s the one you talk to when there’s something you don’t like in SSMS.
Bill Ramos Talks Tools: 2 of 2
Part 2 with Bill Ramos.
Grant is quite Fritchey: 1 of 3
We found Grant wearing a dress so of course we had to put him in our sandwich.
Grant is quite Fritchey: 2 of 3
Here’s the 2nd part of our talk with Grant.
Grant is quite Fritchey: 3 of 3
Here’s the 3rd part of our talk with Grant.
Buck, Paul, Joe, and Louis: 1 of 7
RATED R for language content. Whenever you get Sean and Joe in the same room the language goes out the window. It’s very Continue reading “Buck, Paul, Joe, and Louis: 1 of 7”
Buck, Paul, Joe, and Louis: 2 of 7
Here’s part 2 of the big group interview.
Buck, Paul, Joe, and Louis: 3 of 7
Here’s part 3 of the big group interview.
Buck, Paul, Joe, and Louis: 4 of 7
Here’s part 4 of the big group interview.
Buck, Paul, Joe, and Louis: 5 of 7
Here’s part 5 of the big group interview.
Buck, Paul, Joe, and Louis: 6 of 7
Here’s part 6 of the big group interview.
Buck, Paul, Joe, and Louis: 7 of 7
Here’s part 7 of the big group interview.
How to Study
We’re very proud to bring you our first DBAs@Midnight video. Here we talk about how to study SQL books and be effective at learning what Continue reading “How to Study”
Who Should Manage Backups
SORRY GUYS!!! This was about a 45min video and a glitch with the computer lost the first part of it so you only get the Continue reading “Who Should Manage Backups”
T-SQL: CASE Statement
Here’s an intro to case statements, in the form of a conversation with Sean. I cover simple case and searched case, and the special Continue reading “T-SQL: CASE Statement”
TSQL: Grouping Basics
Here’s a ground level intro to grouping, with a lovely 80s arcade theme. This is a reshoot of the original Grouping Basics video (now Continue reading “TSQL: Grouping Basics”
Recover SQL Passwords
Did you know that SQL Server stores username/password combos in cleartext in memory? And did you know that you can also use a debugger to Continue reading “Recover SQL Passwords”
Dirty Tricks 2: Get List From Command Line
Here’s one of my dirty tricks: getting a list of folders or files from a command prompt, and formatting it for use in code using Continue reading “Dirty Tricks 2: Get List From Command Line”
Dirty Tricks: Text Manipulation
Dirty tricks are the little tricks we use that aren’t official, may not be “proper”, but are insanely useful. Today we look at script building Continue reading “Dirty Tricks: Text Manipulation”
Source Control in SSMS
Here I show you how to setup source control in SSMS and who should and shouldn’t use it.
Intro to ASP.NET
Intro to ASP.NET This is a decent intro to ASP.NET. Personally I don’t think it’s the best one you’ll ever see, but it’s ok. You’ll Continue reading “Intro to ASP.NET”
Setup Server-Side Trace
server side traces, the benefits, and how to set up, edit, run, and stop a server side trace.
Insert Non-duplicate Rows
Here we work our way through a coding scenario—inserting rows—that should illustrate the process of solving a problem from the simplest case to your intended Continue reading “Insert Non-duplicate Rows”
T-SQL: Over() and Partition By
Show how to use OVER and PARTITION BY to get groups of data with aggregation.
Grouping Sets
Here Jen and I go over grouping sets the only way we can. I hope you guys enjoy us late at night.
T-SQL: Find Last Day of Month
Follow Jen as she steps you through 3 progressively elegant solutions for finding the last day of the month.
Troubleshoot Missing DB File
Come with me on a quick trip to see how to troubleshoot a missing database file.
Using TFS in SSMS
Here I show you how to set SSMS up to work with Team Foundation Server
Deploy Packages
Jen and I sit up very late one night and discuss how do deploy SSIS packages. If you don’t know anything at all about Continue reading “Deploy Packages”
Index Scripting Problems
This is just a fun vid. Again, we’re sitting here late at night feeling a little punchy so we’re a little goofier than usual.
Replace Text in File
Here I show you how to replace a given string in a file and either write it back to the same file, or write the Continue reading “Replace Text in File”
Uninstalling SP1 in SQL2K8
SP1 is the first one that you can uninstall in SQL Server, so here I thought I’d take a look at the uninstall process and Continue reading “Uninstalling SP1 in SQL2K8”
Relational Multiplication
Here’s a quick talk on relational multiplication that gets us to take a closer look at what our joins are really doing.
Relational Division
Here we discuss relational division, the counterpart to relational multiplication (cross joins). We’ll hit a couple of examples, using subqueries to implement two different Continue reading “Relational Division”
Pass Params to Scripts (Powershell)
Wanna know how to pass parameters to scripts, and when to use each method?
Find DB Files with Powershell
Here I need to find the .MDF for a database so I can attach it, but I have no idea where the .MDF is.
Beginning Powershell for DBAs 4
Here I continue with the 4th class in the series at the NTSSUG user group.
Minion Backup: BackupRestoreDB
We’ve got some great new functionality in 1.3 for restoring DBs. Here I tell you what you need to know.
Compression Basics
I’m going over the basics of how to implement data compression here. I’m not really touching on where and why you’d want to do Continue reading “Compression Basics”
SSMS Fast Load
Here I show you how to get SSMS to get SSMS to load a lot faster so you don’t have to wait.
Cool New SSMS Features for DBAs
I give MS a hard time sometimes so I like to give them props when I find something really worth it. And here I Continue reading “Cool New SSMS Features for DBAs”
Katmai’s Search Feature
Here I explore Katmai’s new search feature.
SSIS Scripting Languages
This covers how to change the scripting language in SSIS for Katmai.
Katmai Server Group Management
Learn how to use the new group server mgmt functionality in the Katmai SSMS.
Sending HTML SQL Emails
I’m actually excited to be able to bring you this video because this is a topic that comes up quite often in DBA circles. Continue reading “Sending HTML SQL Emails”
Commenting Tribal Knowledge in SPs
There is a lot of tribal knowledge that accumulates in any organization. Here I discuss some ways to document your SPs so you can Continue reading “Commenting Tribal Knowledge in SPs”
Write Good Dynamic SQL
Here I show you a couple methods for getting around really hard to read dynamic SQL.
Red-Gate’s Data Generator
A walkthrough of Red-Gate’s new data generator tool.
HTML Styles: Part 1
Here I continue with the HTML basics video by showing you a better way to do styles. I hinted about this in the basics Continue reading “HTML Styles: Part 1”
Basic HTML for DBAs
After my last video I got some emails saying that not all DBAs already know HTML. So I decided to teach some basic HTML Continue reading “Basic HTML for DBAs”
SSIS Basics 2: Flatfile Olympics
Here we’re just going to jump into SSIS and do some real practical work. We’re going to learn all about taking things to/from multiple Continue reading “SSIS Basics 2: Flatfile Olympics”
SSIS Basics
This is a live presentation I gave recently. Here is a bare bones bottom of the barrel discussion on SSIS. This is for Continue reading “SSIS Basics”
Commenting Tribal Knowledge in SSIS Packages
There is a lot of tribal knowledge that accumulates in any organization. Here I discuss some ways to document your SSIS packages so you Continue reading “Commenting Tribal Knowledge in SSIS Packages”
Introduction to Sequence Containers
This video takes a look at the basics of using the Sequence Container in SSIS. There’s not a lot to it, but it’s a Continue reading “Introduction to Sequence Containers”
Creating Files with ForEach Loop
Here I take the intro one step further and show you how to create multiple txt files based off of a looping variable in the Continue reading “Creating Files with ForEach Loop”
Introduction to ForEach Loops
Here I show you the basics of how to work with ForEach loops. Good stuff.
Row Count Transform
Here I discuss how to use the row count transform in SSIS and give you some good advice for naming and working with the variable Continue reading “Row Count Transform”
Execute SQL Task with Parameters
This video discusses how to pass parameters to queries and SPs inside the Execute SQL Task. It doesn’t teach the basics of the task. Continue reading “Execute SQL Task with Parameters”
Forcing Package Failures
This one was by user request to show how you can compare the counts of 2 tables and use it to force the package to Continue reading “Forcing Package Failures”
Connection strings in Package Config Files
Here I show you how to put your data source connection string inside a package configuration XML file. This was inspired by a forum post Continue reading “Connection strings in Package Config Files”
Derived Columns
Here I show you how to work with derived columns in SSIS and use it to not only marry columns, but also troubleshoot data flows. Continue reading “Derived Columns”
MultiFlatFile Connection Manager
Here I talk about how to use the multiflatfile connection manager in SSIS to loop through flatfiles.
SSIS Variable Scope
Learn how SSIS scopes variables. It’s not a complicated topic, but worth covering.
SSIS Using Variables in Script Tasks
Here I talk about how to setup the script task to work with variables, and how to access them through code once the script can Continue reading “SSIS Using Variables in Script Tasks”
Beginning Powershell for DBAs 1
This is an excellent video that explains what schemas are and why you should care.
Building a Powershell BCP Routine
Here I show you how to build a script that will BCP an entire group of tables and even log the progress. You can Continue reading “Building a Powershell BCP Routine”
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”
Introduction to Schemas
This is an excellent video that explains what schemas are and why you should care.
Windows Performance Monitoring: Part 2
This is the continuation of the live presentation I did a couple weeks ago. This one covers disk counters, memory architecture, and counters.
Windows Performance Monitoring: Part 1
This is a nice video that discusses the basics of performance monitoring in windows. This is actually a live class that I taught to Continue reading “Windows Performance Monitoring: Part 1”
Backup with Init
In this video I discuss the init option for the backup command. You’ll come away knowing how to use it and what it’s for.
Simple Backup Procedures
This is a tutorial not only on how to turn your backup commands into SPs, but also the basics of stored procedures are discussed.
RESTORE with move
This one covers restore with move syntax to restore DBs while moving the files to a different location.
Remote Backups
Learn how to do a backup across the LAN.
BCP in errors
Learn how to diagnose BCP import problems.
BCP in
Learn how to BCP data into a table.
BCP out
Learn how to BCP data out of a table.
CACTUSS Sept 2017 Meeting – Regular Expressions for the DBA
This was recorded for http://cactuss.pass.org for their Sept 2017 user group meeting.
Regular expressions can help you perform incredible tasks with very little Continue reading “CACTUSS Sept 2017 Meeting – Regular Expressions for the DBA”
Custom Snapshot for Multiple Files
When you have DBs with multiple files, you may need to spread your snapshot files across many different drives. Here I’m going to show Continue reading “Custom Snapshot for Multiple Files”
Custom Snapshot for CheckTable
You can take custom snapshots for CheckTable operations as well. Not only that, but you can take dynamic rotating snapshots to keep from running Continue reading “Custom Snapshot for CheckTable”
Order Databases
Minion CheckDB lets you processes the DBs in any order you like. Say you’ve got a tight maintenance window. You can make sure Continue reading “Order Databases”
Order Tables
You can process tables in Minion CheckDB in the exact order you like. So if you’ve got a tight maintenance window, you can make Continue reading “Order Tables”
Include DBs
See how to include databases in Minion CheckDB. To download Minion CheckDB and to see full docs, go to http://MinionWare.net
RunAs Magic
This is a really good video on how to use the RunAs utility in windows. There are several scenarios when a DBA/Dev may need Continue reading “RunAs Magic”
Select Into with Identity()
This video shows you how to use the Identity() function to create an identity column on the fly during a select into statement. You don’t Continue reading “Select Into with Identity()”
Troubleshoot DB Connection with Telnet
Here I show you how to trouble a DB connection issue to eliminate the firewall as a suspect. Using telnet you can tell pretty clearly Continue reading “Troubleshoot DB Connection with Telnet”
SSIS Data Cleansing
Fix data errors with derived cols and conditional split transformations.
Building Subreports
I got a user question through email and rather write-out how to do this, I just shot him a quick video. So the quality Continue reading “Building Subreports”
Using ServerProperty
Here I show you the benefit of using ServerProperty() instead of @@Version to find the version of SQL Server you’re on.
Running Websites with AD Accounts
This is an excellent tutorial on how to run a website under a specific AD account so you can use windows authentication in the database. Continue reading “Running Websites with AD Accounts”
Interpreting Disk Queues
Disk queues are a mystery for the majority of DBAs. They may know that they need to look at them, but they have no Continue reading “Interpreting Disk Queues”
Moving DB Files
Moving database files is easy, but misunderstood. Here I’ll show you how to move user DB files using 2 methods.
sp_HelpIndex Shortcut
There’s a nifty keyboard shortcut to help you with things like sp_helpindex. It works with many SPs so have fun.
When did SQL Server Start?
Find out 2 ways to tell when SQL Server started.
Trace Flag 1807
This one covers restore with move syntax to restore DBs while moving the files to a different location.
Change SQL Server Job Owner
This is a really cool method for changing SQL job owners or any job property I would imagine. It really simplifies it from using Continue reading “Change SQL Server Job Owner”
Schemas: Ownership Chaining and Schema Ownership
Continuing with schemas, here I talk about ownership chaining and how schema ownership effects them. I start with the basics of chaining and then get Continue reading “Schemas: Ownership Chaining and Schema Ownership”
Schemas as Documentation
This is the 2nd video in the schema series. Here I give you a really good reason to adopt schemas in your architectures. Hope Continue reading “Schemas as Documentation”
Beginning Powershell for DBAs 2
This is the 2nd video in the schema series. Here I give you a really good reason to adopt schemas in your architectures. Hope Continue reading “Beginning Powershell for DBAs 2”
Powershell Profiles
Here I finally address how to connect to SQL Server from powershell proper by adding the SQL Server snapins. Then I show you how Continue reading “Powershell Profiles”
Grant Schema Permissions in Powershell
This is another excellent video that shows the power of powershell in SQL administration. I love this video because it’s a very common scenario Continue reading “Grant Schema Permissions in Powershell”
Grant DB Permissions
This is a beautiful bit of script that allows you to set DB permissions for a user. This is particularly useful for adding a Continue reading “Grant DB Permissions”
Powershell with –NoExit
Here I show you how to get around the problem of your Powershell window closing down when you call it from either the run window Continue reading “Powershell with –NoExit”
Working with PSDrive in PowerShell
Here I go over what PSDrive is and how to work with it. I also go into aliases again as well as how to Continue reading “Working with PSDrive in PowerShell”
Scripting DB Objects in Powershell (Advanced Topics)
Here I get past the basics of using the Script() method and take you to how to recreate some of the scripts you can create Continue reading “Scripting DB Objects in Powershell (Advanced Topics)”
Scripting DB Objects in PowerShell
Continuing with PowerShell I thought I’d show you something really cool you can do that would make a difference in your shop right away. So Continue reading “Scripting DB Objects in PowerShell”
PowerShell Basics
Here I start the first in an exciting new series of vids on PowerShell both in Windows and SQL. I go over how to Continue reading “PowerShell Basics”
DBAs@Midnight 9.1 – Irritated Wordgasms
New season, new format! Since it’s been such a rough year, we’re going the “kinder, gentler” route and paying homage to the gentlest, kindest person Continue reading “DBAs@Midnight 9.1 – Irritated Wordgasms”
DBAs@Midnight 9.2 – Hey, #1
This week we continue the “kinder, gentler” theme with Letters From our Friends (on the Internet), interviews, and Play Nice with Pizza. We also have Continue reading “DBAs@Midnight 9.2 – Hey, #1”
DBAs@Midnight 9.3 – Mouth-filling Ending
Letters from our friends! Random songs! Awards, plural! A hashtag game – #ChangeALetterRuinASQLFeature! And this week we have a code review in Make-Believe Land.
Introduction to Minion CheckDB
Here we walk you through the biggest capabilities of the entire product.
Remote CheckDB Overview-Start Here
This is the overview for the remote CheckDB capabilities in Minion CheckDB. Watch this video first when wanting to get started with remote CheckDB Continue reading “Remote CheckDB Overview-Start Here”
Remote CheckDB Connected Mode with No Backup
In Minion CheckDB you don’t have to take a backup to do a remote CheckDB. You can simply use a DB that’s already on Continue reading “Remote CheckDB Connected Mode with No Backup”
Remote CheckDB Connected Mode with LastMinionBackup
Minion CheckDB allows you to use your last backup and restore it to another server to run CheckDB. Here I’ll walk you through how Continue reading “Remote CheckDB Connected Mode with LastMinionBackup”
Remote CheckDB Connected Mode with NewMinionBackup
Minion CheckDB allows you to take a fresh backup and restore it to another server to run CheckDB. Here I’ll walk you through how Continue reading “Remote CheckDB Connected Mode with NewMinionBackup”
Rotate DBs by Count
In Minion CheckDB we allow you rotate through CheckDB a few DBs at a time and rotate them until they’re all done, then start over. Continue reading “Rotate DBs by Count”
Rotation by Time
In Minion CheckDB you can rotation through DBs and tables based off of time. That is, you can run CheckDB or CheckTable every day Continue reading “Rotation by Time”
Inline Tokens
This is a great new feature of MB 1.3. It allows you to have dynamic paths and filenames for your backups. Here, I Continue reading “Inline Tokens”
Exclude Tables
There may be some tables you don’t want to process. I’ll show you how easy it is to exclude them. To download Minion CheckDB Continue reading “Exclude Tables”
Exclude Databases
See how easy it is to exclude DBs from CheckDB operations. To download Minion CheckDB and to see full docs, go to Continue reading “Exclude Databases”
Choosing Tables and Schemas
Want to run operations on selected objects? Minion CheckDB makes it really easy to run CheckTable on a specific schema, or set of tables. Continue reading “Choosing Tables and Schemas”
Multi-threading: CheckDB
In Minion CheckDB you can process many databases at the same time. Let me show you how to easily setup Minion CheckDB to run Continue reading “Multi-threading: CheckDB”
Multi-Threading: CheckTable
In Minion CheckDB you can process many tables at the same time. Let me show you how to easily setup Minion CheckDB to run Continue reading “Multi-Threading: CheckTable”
Custom Snapshot Basics
Minion CheckDB let’s you create custom snapshots for CheckDB and CheckTable operations. Here I’ll show you the basics of how to set it up. Continue reading “Custom Snapshot Basics”
Who is MinionWare?
Who is MinionWare Software? Here we explain the core of our product line and give you a short demo of a couple cool features.
Beginning Programming with Powershell
Have you ever wanted to learn how to code, but you don’t think you have enough knowledge to jump into a class? In this Continue reading “Beginning Programming with Powershell”
The Enterprise Maintenance Lifecycle: Problems & Solutions
Database maintenance isn’t a single event; it’s a lifecycle. Aside from the maintenance event itself, there’s also reporting, error management, specialized configs, HA/DR and more. Continue reading “The Enterprise Maintenance Lifecycle: Problems & Solutions”
Simple Backup
Here I show you how to do simple backups in SQL.
Backup File Extensions
Here I talk about how you can use the file extensions to your advantage, but also have a little fun with it too.
Hack-attak a damaged DB
What do you do if you have a set of data and log files you can’t attach because the log is damaged? Here I show Continue reading “Hack-attak a damaged DB”
Change Excel Delimiter
Description
Minion Backup: Dynamic Parts
Minion Backup 1.3 has a fabulous new feature: Dynamic Parts. This allows you to have unprecedented control over your paths and filenames.
Minion Backup: Backup ResourceDB
The ResourceDB in SQL Server doesn’t backup like regular DBs. Come see how to do this in Minion Backup 1.2 and below.
Minion Enterprise: User Scripting and Cloning
In this ME talk, we show off Minion Enterprise’s security audit and control features: login collections, Active Directory group expansion, sysadmin audits, and most impressively, Continue reading “Minion Enterprise: User Scripting and Cloning”
Introducing Minion Enterprise
Meet MinionWare and its flagship product, Minion Enterprise: the first SQL Server management solution. Here you’ll get a quick introduction and demonstration of the power Continue reading “Introducing Minion Enterprise”
Minion Enterprise Talk: Managing Backups
In our monthly series about Minion Enterprise, we show you how ME can help you with your database enterprise. Specifically, this month we show off Continue reading “Minion Enterprise Talk: Managing Backups”
Minion Enterprise Talk: Managing and Projecting Disk Space with ME
In our monthly series about Minion Enterprise, we show you how ME can help you with your database enterprise. In this session, we show Continue reading “Minion Enterprise Talk: Managing and Projecting Disk Space with ME”
Private video
This video is private.
Minion Enterprise Talk: Passing Your Security Audits
In the first of a monthly series about Minion Enterprise, we will show you how ME can help you pass your security audits, AND how Continue reading “Minion Enterprise Talk: Passing Your Security Audits”
Minion Enterprise: Introduction to ME Webinar
In this demo, we take a look at Minion Enterprise, our SQL Server management solution! We briefly introduce you to the key principles we used Continue reading “Minion Enterprise: Introduction to ME Webinar”
Minion Enterprise: Active Directory Group Expansion
What users are in this Windows group? We have solved this question. In this demo, we show you the SQL Server login and Active Directory Continue reading “Minion Enterprise: Active Directory Group Expansion”
Minion Reindex: Settings Tables
You can control almost anything with the settings tables in Minion Reindex. Here I’ll show you how you can completely customize your settings without creating Continue reading “Minion Reindex: Settings Tables”
Minion Reindex: Reorder Objects
You can process databases and tables in any order you like. Let me show you how much power and flexibility you have with Minion Reindex. Continue reading “Minion Reindex: Reorder Objects”
Minion Reindex: Regex Exclude
We have advanced exclusions in Minion Reindex. You can do anything you want with our powerful regex exclusion feature. Come see how it works. Download Continue reading “Minion Reindex: Regex Exclude”
Minion Reindex: Include and Exclude
There are different ways to include and exclude both databases and tables. Here I’ll show you exactly how to efficiently manage the objects you want Continue reading “Minion Reindex: Include and Exclude”
Minion Reindex: Print Statements
You don’t have to alter the procedure in order to print reindex statements so you can run indexes manually. This is an excellent feature that Continue reading “Minion Reindex: Print Statements”
Minion Reindex: Change FillFactor
Learn how to change the FillFactor both at the database and at the table levels. When logs get too large because of large transactions Continue reading “Minion Reindex: Change FillFactor”
Minion Backup: Shrinking Logs
When logs get too large because of large transactions or missed backups it can cause issues in your environment. And the DBA usually has to Continue reading “Minion Backup: Shrinking Logs”
Minion Backup: Striping Backup Files
Striping backups is an important step in tuning your backups so they run nice and fast. MB makes it so easy to have specialized configurations Continue reading “Minion Backup: Striping Backup Files”
Minion Backup: Include / Exclude Databases
MB has a few ways to include and exclude databases from the backup process. Here I walk you through the nuances of this feature. Some Continue reading “Minion Backup: Include / Exclude Databases”
Minion Backup: Status Monitor
We consider this one of our flagship features. The status of the current backup and of the entire job is updated in the log. You Continue reading “Minion Backup: Status Monitor”
Minion Backup: Server Labels
Server labels are one of our great high availability features. This feature allows you to organize Availability Group backups as well as mirroring, log shipping, Continue reading “Minion Backup: Server Labels”
Minion Backup: Replacing Diff Actions
Some DBs are too small to need a differential backup. MB makes it really easy to supply different actions in these situations. You can have Continue reading “Minion Backup: Replacing Diff Actions”
Minion Backup: Path Basics
One of the coolest aspects of MB is how it handles your backup paths. There are some really cool options for configuration and it even Continue reading “Minion Backup: Path Basics”
Minion Backup: File Actions
This is an important feature. MB allows you to copy or move your backup files after you take the backup. There are some pretty cool Continue reading “Minion Backup: File Actions”
Minion Backup: Mirroring Backups
Mirroring backups is not only easy it’s very flexible. Here I’ll show you the ins and outs of setting up and managing mirrored backups.
Download Minion Continue reading “Minion Backup: Mirroring Backups”
Minion Backup: Tuning Threshold Basics
One of Minion Backup’s most incredible features is its dynamic tuning. Here I talk about threshold basics and how to configure the settings to do Continue reading “Minion Backup: Tuning Threshold Basics”
Minion Backup: Encrypted Backups
SQL Server 2014 and above has native backup encryption and this is fully supported by Minion Backup. Here I’ll show you how to setup and Continue reading “Minion Backup: Encrypted Backups”
Minion Backup: Azure Backups
Here I show you how to setup backups to Azure blobs. This is an end to end video and I show you from both the Continue reading “Minion Backup: Azure Backups”
Minion Backup: Advanced Tuning Thresholds
Here I show you how to configure MB backup thresholds using the advanced options. If you’re going to get it right you need to watch Continue reading “Minion Backup: Advanced Tuning Thresholds”
Minion Backup: Certificate Backups
Minion Backup will automatically backup your server-level and database-level certificates. Here I’ll show you what you need to know to be successful with this feature.
Download Continue reading “Minion Backup: Certificate Backups”