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