August 2020

dbatools commands used in this post: Enable-DbaAgHadr Disable-DbaAgHadr New-DbaAvailabilityGroup Add-DbaAgReplica Add-DbaAgDatabase Add-DbaAgListener Remove-DbaAgListener Get-DbaAgDatabase Set-DbaAgReplica Invoke-DbaAgFailover Suspend-DbaAgDbDataMovement Resume-DbaAgDbDataMovement Sync-DbaAvailabilityGroup AlwaysOn Availability Groups The feature that has been introduced in SQL 2012 is quite an important one. Also, it requires a number of clicks there and there in SSMS. Luckily for us dbatools have set of…

dbatools commands used in this post: Get-DbaSpConfigure Export-DbaSpConfigure Set-DbaSpConfigure Import-DbaSpConfigure Set-DbaMaxDop Set-DbaMaxMemory SQL Server configuration / sp_configure SQL Server allows its users to configure a lot of things. From ‘Ad Hoc Distributed Queries’ through ‘max degree of parallelism’ to ‘xp_cmdshell’. Some of those can be done via SQL instance properties or the famous sp_configure. With…

dbatools commands used in this post: Add-DbaRegServer Add-DbaRegServerGroup Get-DbaRegServer Get-DbaRegServerGroup Move-DbaRegServer Move-DbaRegServerGroup Remove-DbaRegServer Remove-DbaRegServerGroup Export-DbaRegServer Import-DbaRegServer Create registered servers or Central Management Servers The built-in feature of the SSMS allows us to configure a group of SQL instances and run queries against multiple instances at once. With the registered servers you can also build a…

dbatools commands used in this post: Backup-DbaDatabase Restore-DbaDatabase Get-DbaDbBackupHistory Get-DbaBackupInformation Get-DbaLastBackup Get-DbaDbRestoreHistory Measure-DbaBackupThroughput New-DbaDbSnapshot Get-DbaDbSnapshot Restore-DbaDbSnapshot Remove-DbaDbSnapshot Backup Taking backup is an essential task for everyone working with any kind of data. SSMS offers a wide range of options for taking backups, and at least the same you can achieve using dbatools. SSMS dbatools: Backup-DbaDatabase…