Rob Sewell
Back around the time we did SQL Bits, Rob Sewell spoke to Richard Campbell at RunAs Radio. The show, Managing SQL Server using dbatools with Rob Sewell, is a fun and fantastic listen. Not only does Rob talk at length about the migration capabilities in dbatools, but also other cool things like CI/CD, containers and more. Check it out!
Read moreChrissy LeMaire
Happy Belated World Backup Day! I wish it was Backup and Restore Day, Test Your Backups Day, or World Recoverability Day, but alas. I’m currently working on my portion of the effort to get dbatools to 1.0 - integration tests for our commands. And while I wait for AppVeyor to run all of our tests, I’ve got a few minutes to post. Initially, I wanted to highlight our Backup/Restore commands but there are sooo many, it’d take a few days to write about them.
Read moreChrissy LeMaire
Nearly every time I inherit a SQL Server environment, I’m only given a partial list of SQL Servers that exist on the network. It’s my usual routine to get permission to sniff the network then run about five different programs including Idera’s SQL Discovery and Microsoft’s Assessment and Planning Toolkit. I always thought it’d be cool to have one comprehensive PowerShell command that could do the work of all the above and was ecstatic to see NetSPI’s Scott Sutherland had written a few commands to do just that in his awesome PowerShell module PowerUpSQL.
Read moreJess Pomfret
I’ve been working on a project this year to upgrade SQL Server versions for around 80 application databases, with most of the upgrades requiring both SQL Server and Windows Server upgrades to get to the future state we were looking for. The general process for each of these was to build a new virtual machine with the upgraded operating system, install the desired SQL Server version and then migrate the application databases during an arranged downtime window.
Read moreChrissy LeMaire
Nearly two years ago, I wrote that as a open source GPL-licensed project, dbatools was free as in speech and free as in beer. I chose the GNU GPL for nostalgic reasons and I also wanted companies who used dbatools to contribute back to the project. What I didn’t realize was that licensing dbatools as GPL would hurt integration which ultimately impacts adoption. Permissive licenses like the MIT do not subject users to such restrictions.
Read moreChrissy LeMaire
Gianluca Sartori and I recently presented Simplifying Extended Events with dbatools at SQL Bits and we had a lot of fun. Not only that, we helped convince several people to switch! Honestly, when we proposed the session, I was totally #TeamProfiler. I figured if PowerShell didn’t convince me, I would let people know where I stood, but I was open to switching teams. Slides | Code | Video SQLBits was awesome!
Read moreChrissy LeMaire
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. As of version v1.0, dbachecks contains 15 commands. This article provides an overview of these commands. Rob Sewell offers a fantastic deep-dive article that explains the commands below in greater depth. Usage Usage can be approached in two ways: Run Directly From the Command Line As simple as Invoke-DbcCheck -SqlInstance sqlprod01 -Checks SuspectPage, LastBackup
Read moreChrissy LeMaire
In mid-December, we began working on a new PowerShell module for the SQL Server Community. This free and open-source project can be found in the SQL Server Community Collaborative’s repository. Contributions from the community are welcomed and encouraged! Intro dbachecks is a framework created by and for SQL Server pros who need to validate their environments. Basically, we all share similar checklists and mostly just the server names and RPO/RTO/etc change.
Read moreIn today’s post, I will tell you about how we managed to successfully complete a migration during a ~12 hour maintenance window. This could have taken a LOT longer if we didn’t have dbatools to automate several of the steps. Although I will not go in to every detail about our process, I want to emphasize the areas were we chose to use dbatools to make our lives easier. The Goal Recently, we got the green light for upgrading to SQL Server 2016 and we were ready to roll.
Read moreChrissy LeMaire
Today’s blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a blog party on the second Tuesday of each month. Everyone is welcomed to participate. This month’s T-SQL Tuesday, hosted by Arun Sirpal (blog), is all about overcoming technical challenges. The Challenge I always try to solve my technical issues with natively available (aka Microsoft) solutions. It’s one of the many reasons I love PowerShell.
Read moreStart typing to search
Search across posts, pages, and commands
dbatools