In this release (two in one month, woo!), we gained 3 new contributors to the dbatools master repository for a grand total of of 29! We also added a shortcuts reference page for those of you who often visit portions of our site or GitHub and would like the shortlinks.
Commands
We fixed about 10 bugs, made two commands more efficient and added 5 new commands.
- Connect-DbaSqlServer
Creates an SMO SQL Server object. Supports both Windows and SQL Authentication. I imagine mostly SMO programmers will like this one, but check it out anyway. It has a ton of useful parameters. -
Get-DbaLastBackup
Retrieves and compares the date/time for the last known backups, as well as the creation date/time for the database.Default output includes columns Server, Database, RecoveryModel, LastFullBackup, LastDiffBackup, LastLogBackup, SinceFull, SinceDiff, SinceLog, Status, DatabaseCreated, DaysSinceDbCreated.
-
Get-DbaPermission
Get a list of Server and Database level permissions -
Get-DbaStartupParameter
Displays values for a detailed list of SQL Server Startup Parameters including Master Data Path, Master Log path, Error Log, Trace Flags, Parameter String and much more. -
Remove-DbaBackup
T-SQL based maintenance plans can’t safely access Windows file system to determine if a file has been properly archived. PowerShell makes it easy.This command will make it easier to clean up old, archived (and unarchived) backups.
Want to see more or work on a command yourself? We have approved command ideas on the dbatools Trello board. This board shows you what we’re working on and what we’re talking about.
Notable bug fixes
- Copy-DbaCredential and Copy-DbaLinkedServer
Both commands worked properly but made an attempt to connect to the destination that was unnecessary and sometimes generated errors. -
Find-DbaOrphanedFile
Fixed bug that reported some valid directories and files as orphaned. -
Get-DbaTcpPort
Fixed a bug that hid a real exception message behind one that basically said “Something didn’t work right.” -
Test-DbaNetworkLatency
Fixed a logic bug that produced inaccurate results. -
Test-DbaPath
Now works in all languages!
Join us!
Some of these commands are in their infancy. Want to help make them better? Come join the coding party! We’re all hanging out on the SQL Server Community Slack in the #dbatools channel.