working with sql client aliases
Want your app servers to connect to your newly migrated SQL Server without modifying connection strings within your application? Or use easy-to-remember names for your docker containers? SQL Client Aliases can help.
Vote for these SQLBits 2020 PowerShell sessions
SQLBits 2020 is back in London, 31st March – 4th April 2020 and session voting is now open! You must be logged into the site to vote. The complete listing …
working with file sizes in dbatools
You may notice our file sizes are pretty and human-readable, but they’re also packed with usable data behind-the-scenes.
Learn dbatools in a Month of Lunches
After nearly 10 months of work, early access to Learn dbatools in a Month of Lunches is now available from our favorite publisher, Manning Publications! For years, people have asked …
migrating super old app databases
Recently, a colleague asked me to assist with the migration of some older, customized application databases to a SQL Server 2017 instance.
dbatools advanced configuration
Some dbatools functionality that has not been talked about much on the blog are our internal configuration options. This functionality was added back in October 2017. Kind of like how …
dbatools & sql on linux
dbatools and linux As a long-time Linux user and open-source advocate, I was beyond excited when PowerShell and SQL Server came to Linux. A few of the decisions I made …
Using Set-DbaCmConnection to reset credentials and cached connection status
Hi, I am Gareth N – a SQL Server DBA in the UK. I have started to blog over at ifexists.blog – today I want to share some information around …
dbatools 1.0 has arrived 🎉
We are so super excited to announce that after 5 long years, dbatools 1.0 is publicly available! Our team had some lofty goals and met a vast majority of them …
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 …