Announced at DataGrillen 2019 today, the amazing dbatools PowerShell module has officially released version 1.0. This is a tremendous milestone for the best Open Source project built for data professionals.Read More dbatools One Point OH YEAH!
I was recently working on a PowerShell script to set up some new databases for my users and found myself writing the same things over and over again. By the 4th Invoke-DbaQuery, I found myself thinking “this repetitive typing kind of sucks.” Then I remembered Chrissy LeMaire’s segment in the first PSPowerHour where she talked…Read More Tidier Powershell Scripts with Default Parameter Values
In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.Read More A Monumental Migration to SQL Server 2016 – Part 2
A bit over a year ago, I blogged about my experience migrating a test SQL Server instance from a VM to a physical machine with a little help from my friends. That migration went well and the instance has been running trouble-free ever since. But it’s small potatoes. A modest instance, it’s only about 5%…Read More A Monumental Migration to SQL Server 2016 – Part 1
In my previous post, I mentioned that I wasn’t checking the status of my RSJobs because I had logging built into my function. I originally tried to log out to plain text files with Out-File, but quickly hit a wall. In a multi-threaded script, attempting to write to the same text file from multiple threads…Read More Thread-safe PowerShell Logging with PSFramework
Intro PowerShell has had a native method for spawning multiple “threads” ever since I can remember, in the form of the *-Job functions. They work OK, but there are a couple downsides: Each job is its own PowerShell process, so it takes a non-trivial amount of time and memory to spin each up There’s no…Read More PowerShell Multithreading with PoshRSJob
@SQLMonkeyNYC asked on Twitter this morning: #sqlhelp Does anyone have a product that will back up a single table and restore it to another database? Thanks in advance!! — My friends call me Gandalf (@SQLMonkeyNYC) November 14, 2018 Pat Phelan replied, suggesting that dbatools can do it, but after thinking on it for a bit…Read More Copying Individual Tables with dbatools
The first edition of the PSPowerHour is in the books and it looks like it was a big success. This one was dbatools-heavy but I chalk that up to the dbatools community having lots of free time because we’ve automated so many of our tasks 🙂 Overall Impressions I signed in about half an hour…Read More PSPowerHour v1.0 Wrap-Up
It’s official! I will be speaking at the inaugural PowerHour online lightning demo event on Tuesday, August 21st at 2200 UTC. I’ll be demoing Better, Safer SQL Queries from PowerShell. If you’re working with SQL Server from PowerShell, either as a DBA, analyst, or anyone else running queries, you’ve probably used Invoke-SqlCmd. But depending on…Read More Speaking: PowerHour, August 21st 2018
Earlier this week, the PowerHour was announced. What is it? It’s kind of like a virtual user group. One hour, 6(ish) lightning demos (10 minutes or less), centered on PowerShell. All community-sourced and driven – anyone can submit a proposal for a demo and if accepted, you’ll be slotted into an available spot. They’ve already…Read More PowerHour – Online PowerShell Lightning Talks!