keeping availability group logins in sync automatically
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 companies. My focus is …
30 day countdown to 1.0 starts today!
Today marks the 30 day countdown to dbatools 1.0, which we will be debuting at Data Grillen in Lingen, Germany! These next 30 days are important and I’m writing to …
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 …