Have you ever written a PowerShell command so long that it stretched across the screen? Or had to update a script and hunt through a long parameter list to change a single value? Splatting solves that problem by letting you pass multiple parameters to a command using a single variable. What Is Splatting? Splatting allows … Read more
In this and the next two blog posts I will be bringing diverse dbatools commands into scripts that can handle a complete deployment, do a checkup of major health and configuration metrics, and do a true up of a pre-existing instance. This post will cover the complete deployment, which if you have been reading the … Read more
I’ll be speaking on Tuesday, 8/19, at the PASS Summit on tour in New York City. I’ll be giving a talk in the “professional development” world this time.. And I’ll be doing the same session at the PASS Summit in Seattle this fall. This time, rather than talk about SQL Server DBA tips, upgrades, migrations, … Read more
When I was in the world of EMS, you rarely started a course for the next level of license without a chapter or two on the legal side. They hammered negligence into us — what it takes to lose in court on a negligence lawsuit. It’s the same thing in IT.And here’s what you don’t … Read more
As DBAs we install SQL Server for various reasons regularly. If you could save time for each installation for more critical tasks, would you? In this blog post, we will audit the dbatools command Install-Dbainstance. I will test, review, and evaluate the script based on a series of identical steps. Our goal is to provide … Read more
Since we introduced sp_CheckBackup last year we’ve gotten some great feedback on ways to improve this tool that helps you quickly and easily review the backup history for your SQL Server databases. We’ve even noticed a few things ourselves that we wanted to change as we used it more internally here at Straight Path Solutions. … Read more
Most businesses are rotten with Excel sheets and CSV exports from various tools and as my mentor puts it “Excel is the world’s database”. The dbatools command Import-DbaCsv enables the quick load of CSV tables into SQL Server, which then opens up the world of fast transformation and use in other tools such as PowerBI, … Read more