Chrissy 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 moreChrissy LeMaire
A number of dbatools contributors will be presenting at SQL Bits next week in London! To start, Rob Sewell and I will be presenting a PowerShell and dbatools heavy precon on Wednesday. Precon Reliable, Repeatable, & Automated: PowerShell for DBAs Automating and testing your SQL Server environment has never been easier. Now you can put down your manual checklists and skillfully: Track SQL Server instance configurations Promptly provide required information to managmement, change configuration or developers Deftly respond to audit change requirements across your entire estate (and impress your auditor with PowerShell; it happened to us!
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 moreSimone
We have now reached more than 370 public functions and nearly 1000 unit and integration tests, all thanks to over 100 community contributors! As you may have noticed, we release a 0.9.x update with bug fixes and new features almost daily, so why haven’t we released 1.0 yet? Shifting From “A Bag of Functions” to a Proper Module We love new functionality, of course, but we must take a step back from new development and consolidate what we have in a properly usable module.
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 morePétur Grétarsson
Pétur Grétarsson, here. Long time dbatools fan, first time blogger. I really love the new Invoke-DbaQuery command and wanted to share how I use it. I have well over 100 Availability Groups to look after in different domains so it can be a bit difficult to check things when needed. We have opened required ports allowing connections from one SQL management server to those for monitoring purposes including using Idera SQL Inventory Manager for basic health checks.
Read moreChrissy LeMaire
We’ve updated the site a bit and wanted to let you know. Getting Started Finally! The Getting Started page has accurate information, way more code samples and useful links. So if you’re a bit lost wondering where to start, I included a slightly modified version of the code I often show at conferences. This code in particular was heavily updated just a few weeks ago for the dbatools presentation in Glasgow.
Read moreStart typing to search
Search across posts, pages, and commands
dbatools