dbatools

🚀 SQL Server automation and instance migrations have never been safer, faster or freer

MIT License

Stars

2.3K

Committers

View Code on GitHub Visit Website

Ecosystems: PowerShell, sql-server

Bot releases are hidden (Show)

dbatools - v1.1.28

Published by potatoqualitee almost 3 years ago

added CU 27 for SQL 2017 & On-demand hotfix for SQL 2016 SP3 by @MikeyBronowski
Add-DbaAgReplica - standardize $ConnectionModeInSecondaryRole options by @LowlyDBA
Improve clarity in docs by @wbowlin
Move-DbaDbFile - Return on failed status change by @andreasjordan
Save-DbaKbUpdate - Add parameter Language by @andreasjordan
Get-DbaDatabase - Fix some issues with -NoBackup parameters by @andreasjordan
Save-DbaCommunitySoftware - Add code to download SQLWATCH by @andreasjordan

dbatools - v1.1.27

Published by potatoqualitee almost 3 years ago

Better shutdown: Only remove runspaces on ISE by @andreasjordan
Add Set/New/Remove-DbaRgWorkloadGroup commands by @LowlyDBA

dbatools - v1.1.26

Published by potatoqualitee almost 3 years ago

Explicitly require implicitly required .NET version 4.6.2 by @potatoqualitee
Move-DbaDbFile - Add support for logical names with dashes by @andreasjordan
Get-DbaDbBackupHistory - Fix for more than one database with same database_guid by @andreasjordan
Issues Forms - Add Out-String to PowerShell Host Version Sample Code by @andreasjordan
Remove-DbaServerRoleMember - new command by @MikeyBronowski

dbatools - v1.1.25

Published by potatoqualitee almost 3 years ago

Connect-DbaInstance - Remove azurevm check to remove call to http, fix Microsoft.Identity.Client by @potatoqualitee
Backup-DbaDatabase - Add extra caution by @potatoqualitee
Connect-DbaInstance - Make AccessToken more convenient by @potatoqualitee
Backup dbadatabase filepath name fix by @jamesyip22
Remove-RgResourcePool - Fix piped inputs by @LowlyDBA
Remove-DbaAgentAlert - new command by @MikeyBronowski

dbatools - v1.1.24

Published by potatoqualitee about 3 years ago

Invoke-DbaDbLogShipRecovery - update help examples by @jpomfret
Get-DbaAgentProxy adds ExcludeProxy parameter by @MikeyBronowski
fix missing resource pool default param values by @LowlyDBA
*-DbaDbSequence - renaming parameter Name to Sequence by @MikeyBronowski

dbatools - v1.1.23

Published by potatoqualitee about 3 years ago

added CU 13 for SQL 2019 by @MikeyBronowski
Corrects parameter name in examples and WhatIf outputs by @MikeyBronowski
Remove-DbaNetworkCertificate - Fix output of RemovedThumbprint by @andreasjordan
New-DbaDbMailAccount, New-DbaDbMailProfile - renaming parameter name to Account, Profile respectively by @MikeyBronowski
Update-DbaBuildReference - Set offline_time on first copy by @andreasjordan
Add-DbaAgDatabase - Fix seeding reporting: Select only latest seeding stats by @andreasjordan
Update Remove-DbaAgDatabase.ps1 typo in docs by @wbowlin

dbatools - v1.1.22

Published by potatoqualitee about 3 years ago

Get-DbaDbMailAccount - corrections to command help and examples by @MikeyBronowski
Add-DbaServerRoleMember - corrections to command help and examples by @MikeyBronowski
Remove-DbaDbMailAccount - new command by @MikeyBronowski
Find-DbaLoginInGroup, fix #7820 by @niphlod
Remove-DbaDbMailProfile - new command by @MikeyBronowski
Get-DbaDbMailProfile produces duplicate results by @MikeyBronowski
Stop-DbaService - Fix EnableException / Silent issue by @potatoqualitee

dbatools - v1.1.21

Published by potatoqualitee about 3 years ago

split using simplematch functionality not regex by @MarkIannucci

dbatools - v1.1.20

Published by potatoqualitee about 3 years ago

new resource pool commands by @LowlyDBA
Test-DbaDbDataMaskingConfig - Added missing data types by @sanderstad

dbatools - v1.1.19

Published by potatoqualitee about 3 years ago

added SP3 for SQL 2016 by @MikeyBronowski
Get-DbaService - Add Credential when calling Get-DbaCmObject by @PsPsam
Test-DbaLastBackup - Test MaxSize before CopyFile by @andreasjordan
added CU 26 for SQL 2017 by @MikeyBronowski

dbatools - v1.1.18

Published by potatoqualitee about 3 years ago

Get-DbaDbBackupHistory - Do not cast anymore by @andreasjordan
Test-DbaWindowsLogin, fix #7528 by @niphlod

dbatools - v1.1.17

Published by potatoqualitee about 3 years ago

Fix Get-DbaDbBackupHistory -Last when executed against an instance with log-shipping secondary databases by @potatoqualitee

dbatools - v1.1.16

Published by potatoqualitee about 3 years ago

Get-DbaPermission - Add brackets around object names to support names with spaces by @andreasjordan
Set-DbaAgentJob - Fixed WhatIf support by @andreasjordan
New-DbaAvailabilityGroup - Fix missing grants for automatic seeding by @andreasjordan
Issue Template: Feature Request: remove errant apostrophe by @LowlyDBA
Add load balanced RORL example. by @ben-thul
Write-DbaDbTableData - Use better constructor to support windows credentials by @andreasjordan
new command: Set-DbaResourceGovernor by @LowlyDBA

dbatools - v1.1.15

Published by potatoqualitee about 3 years ago

Fix unresolvable path on import by @potatoqualitee
Connect-DbaInstance, fix slow SMO enum for jobs by @niphlod
Add ReadOnlyRoutingList param to Set-DbaAgReplica by @ben-thul
Set-DbaPrivilege - include 'log on as a service' right by @andreasjordan
Internal: Replace Connect-SqlInstance by Connect-DbaInstance (part 8) by @andreasjordan

dbatools - v1.1.14

Published by potatoqualitee about 3 years ago

Get-DbaPrivilege - include 'log on as a service' right by @narayana471
Set-DbaAgentOperator - Fix usage of parameter Operator by @tboggiano

dbatools - v1.1.13

Published by potatoqualitee about 3 years ago

Write-DbaDataTable - better check for database by @potatoqualitee
Update Invoke-DbaDbLogShipping to use proper comparison by @gabe-ponti
Update Invoke-DbaDbLogShipping to use SqlCredential instead of Credential by @gabe-ponti

dbatools - v1.1.12

Published by potatoqualitee about 3 years ago

Invoke-DbaQuery - Request non pooled connection when using windows credentials by @andreasjordan
Internal: Added missing Test-FunctionInterrupt calls by @andreasjordan
Internal: Replace Connect-SqlInstance by Connect-DbaInstance (part 7) by @andreasjordan
Internal: Replace Connect-SqlInstance by Connect-DbaInstance (part 6) by @andreasjordan
Sync-DbaLoginPermission - Added output by @andreasjordan
Use new command Save-DbaCommunitySoftware by @andreasjordan
Internal: Replace Connect-SqlInstance by Connect-DbaInstance (part 5) by @andreasjordan

dbatools - v1.1.11

Published by potatoqualitee about 3 years ago

Add Microsoft.Data.SqlClient.SNI.x86 to library import by @potatoqualitee
Internal: Replace Connect-SqlInstance by Connect-DbaInstance (part 4) by @andreasjordan
Publish-DbaDacPackage - Fix for named pipe connections by @andreasjordan
New commands: Update-DbaMaintenanceSolution and Save-DbaCommunitySoftware by @andreasjordan
New function Remove-DbaDbUdf by @MikeyBronowski

dbatools - v1.1.10

Published by potatoqualitee about 3 years ago

Set-DbaAgentOperator : Enhance Failsafe Notification Method Handling by @howarthcd
Set-DBAAgentOperator Failsafe Operator Handling Correction by @howarthcd
Internal: Replace Connect-SqlInstance by Connect-DbaInstance (part 3) by @andreasjordan
Get-DbaProductKey - Fix for version 2016 and newer by @andreasjordan
Use [System.Environment]::NewLine to normalize line endings by @andreasjordan
Get-DbaInstanceInstallDate - Fix failback column check by @potatoqualitee
Internal: Replace Connect-SqlInstance by Connect-DbaInstance (part 2) by @andreasjordan
Get-DbaRegServerGroup - fix split by @potatoqualitee
Update-DbaInstance - trim trailing Path characters by @potatoqualitee
Applying coding standards - proper casing applied variables by @MikeyBronowski

dbatools - v1.1.9

Published by potatoqualitee about 3 years ago

Get-DbaInstanceInstallDate - Add failback check by @potatoqualitee
Check for loaded assembly before attempting to load by @potatoqualitee

Related Projects

DbWebApi

(Migrated from CodePlex) DbWebApi is a .Net library that implement an entirely generic Web API (R...

Get-CMUnusedSources

A PowerShell script that will tell you what folders are not used by Microsoft Endpoint Manager Co...

CheeseTools

Self-developed tools for Lateral Movement/Code Execution

24 Aug 2020 686

Awesome-RedTeam-Cheatsheet

Red Team Cheatsheet in constant expansion.

18 Jan 2022 1,070

dbachecks

✔ SQL Server Environmental Validation

18 Dec 2017 461

AutomatedLab

AutomatedLab is a provisioning solution and framework that lets you deploy complex labs on HyperV...

23 Aug 2016 2,006

Blue-Team-Notes

You didn't think I'd go and leave the blue team out, right?

18 Apr 2021 1,590

D365FFO-PowerShell-scripts

Set of PowerShell scripts to maintain D365FFO (Dynamics 365 for Finance and Operations)

sqlserver-kit

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

22 Sep 2014 1,988

SQLServerLoginMonitor

Brute force attack prevention for remotely accessible SQL Server databases using PowerShell and W...

gsudo

Sudo for Windows

07 Nov 2019 5,198

WindowsPowerShell

Advanced PowerShell scripts and profile enhancements for common use cases

19 Mar 2018 155

PowerShell

Various PowerShell functions and scripts

08 Mar 2014 951

sql-server-vagrant

SQL Server Express Vagrant environment

SPReplicator

♻ Replicates SharePoint Lists