Building an inventory view of SQL Servers with dbatools
The situation Hey all, I am Andreas Schubert and I am working as a Principal Consultant and Database Reliability Engineer for SQL Server & Azure for multiple national and international …
dbatools featured on sql with bert
Recently, dbatools contributor Jess Pomfret teamed up with Bert Wager for a super cool video about dbatools. Check it out! They also wrote accompanying blog posts too! Jess wrote a …
a monumental migration to sql server 2016
How do you move eight thousand databases in a reasonable amount of time?
dbatools and docker
We now provide Docker images to help dbatools users easily create a non-production environment to test commands and safely explore our toolset.
multithreading commands
In this age of many companies adopting the ideas of either DevOps or SRE (Site Reliability Engineer) roles, there is constant need for automation. Mundane tasks like collecting metrics, alerts, …
powershell splatting
Splatting in PowerShell makes code easier to read. Instead of typing a bunch of parameters allllll across the screen, you can use an easy-to-read hashtable or array. Argument splatting was …
managing data compression with dbatools
Data compression is not a new feature in SQL Server. In fact it has been around since SQL Server 2008, so why does it matter now? Before SQL Server2016 SP1 …
more on masking
Since our last post, we’ve added new features and fixed a few bugs! Please update to 0.9.730. New features Each table update is now a transaction Support for NULL values …
automated data masking
Static Data Masking is such an important aspect of an organization’s data security posture, I hoped it could somehow be included in dbatools 1.0. I’m excited to report that, thanks …
dbatools extension for visual studio code
We recently released a VS Code extension that lets you highlight terms and search dbatools.io, Microsoft Docs, Google, StackOverflow, DuckDuckGo, Technet or Thwack right from your code! It’s called search …