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!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 2A 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@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 dbatoolsThe 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-UpA few weeks ago, I teased good news. One person hypothesized that I’m joining Microsoft (it seems to be the thing to do lately) and another jumped to the conclusion that I must be pregnant. Both creative responses, but not quite correct. I’ll be at PASS Summit 2018! So much to do! Pick some sessions…
Read More I Will See You in Seattle!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 2018Earlier 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!This week I had a user come to me asking about how fields were defined on a few tables he was using in writing some reports. Long story short, he’s been tasked with writing some new reports and updating existing ones, but he doesn’t have visibility to the database itself so he’s left with the…
Read More Quick Table Info Export with PowerShellI wrote a post over on the dbatools website about how to get involved with improving comment-based help Working on the CBH is a great way to get started with the dbatools project, even (especially) if you’re not a PowerShell expert or MVP-level DBA. Getting everything clean and consistent in the CBH is an important…
Read More How to Help with dbatools Comment-based Help