Table of contents for the dbatools.io = command-line SQL Server Management Studio series.
An overview of how to start using dbatools to run queries against your SQL Server instance.
dbatools: Connect, Query and Save
If you want to look at your SQL instance and see your objects here is how you can do it.
dbatools: Let me see
Adding new objects to your SQL instance has never been easier.
dbatools: Something new
There are times where you need to drop something from your SQL instance.
dbatools: Drop it
OK, so it is all set up. Now, change it.
dbatools: Request for change
Do you have a backup?
Do you need to run queries against multiple servers? Maybe just keep your SQL Server instance inventory in one place?
dbatools: Registered Servers/CMS
Every time one builds a new server or inherits an unknown beast would need to do some analysis. Being able to save the existing SQL configuration and restore it is really helpful.
dbatools: SQL configuration
Do you need to create a new AlwaysOn Availability Group, or add a listener or perform the fail-over? See how you can achieve that with fewer clicks.
dbatools: AlwaysOn Availability Groups
Import/Export tasks are an important part of the job. It is good we have tools to support us. Check this out and see how simple it may be with dbatools.
The SQL Server contains of many objects and services that sometimes need starting and sometimes need stoping and restarting.
There is a bunch of security objects in SQL Server, that need T-SQL to be managed as SQL Server Management Studio does not offer too many options.
dbatools: Keys & Certificates
Thank you, Mikey