Releases: dataplat/dbatools
pieceoftoast
This is really long and I'm sorry, I'm lazy 👎 Please see dbatools.io/pieceoftoast.
snowball for real
This release is all about Backup and Restore - but mostly about Restore - you should see that 🏆 . Read more at dbatools.io/snowball.
New Commands
(many others that will be featured in an upcoming release)
schwifty
This release is all about Service Principal Names. Read more at dbatools.io/schwifty
New Commands
twentyfiveschmeckles
New Commands
- Export-SqlUser
Exports SQL Server Database Users creation script with all database permissions (database and object level) to a T-SQL file. This is a function that is not available in SQL Server Management Studio. - Find-DbaAgentJob
Finds agent job(s) that fit certain search criteria. - Find-DbaDatabase
Search SQL Server instances for database that have either the same name, owner or service broker guid. - Find-DbaStoredProcedure
Returns all stored procedures that contain a specific string or regex pattern. - Get-DbaAgentAlert
Return all SQL Agent alerts on a SQL Server Agent. - Get-DbaAgentOperator
Returns all SQL Agent operators on a SQL Server Agent. - Get-DbaDatabaseState
Gets some common “states” on databases like Read-Write (READ_ONLY or READ_WRITE), Status (ONLINE, OFFLINE, EMERGENCY) and Access options (SINGLE_USER, RESTRICTED_USER, MULTI_USER) - Get-DbaHelpIndex
This function will return detailed information on indexes (and optionally statistics) for all indexes in a database, or a given index should one be passed along. - Get-DbaMemoryUsage
Get amount of memory in use by all SQL Server components and instances. SSAS and SSIS are included. - Get-DbaMsdtc
Displays information about the Distributed Transactioon Coordinator (MSDTC) on a server. - Get-DbaPageFileSetting
Returns detailed information about the Windows page file. - Get-DbaTrigger
Get all existing triggers at instance and database level. - Get-DbaUptime
Returns the uptime of the SQL Server instance. If you want you can get the value for the hosting windows server too. - Get-DbaXEventsSession
Retrieves a list of Extended Events Sessions. - Invoke-SqlCmd2
Runs a T-SQL script. But only captures the first selected result set, such as the output of PRINT statements when Verbose parameter is specified.
A big plus when comparing with native Invoke-SqlCmd cmdlet is that this one supports parameterized queries. - New-DbaDatabaseSnapshot
Do you need to create a database snapshot? This command will do it without hassles. - Out-DbaDataTable
Will creates a DataTable based on an objects properties.
This allows you to easily write to SQL Server tables. - Rename-DbaLogin
It can be a pain to update all of the mappings for a specific user when you rename a SQL login this does it for you, will rename login and database mapping for a specified login. - Restore-DbaFromDatabaseSnapshot
Restores the database from the snapshot, discarding every modification made to the database. - Set-DbaDatabaseState
Want to change a database state? With this command you can chose between ReadOnly, ReadWrite, Online, Offline, Emergency, plus a special “Detached”, SingleUser, RestrictedUser, MultiUser. - Test-DbaOptimizeForAdHoc
Displays information relating to SQL Server Optimize for AdHoc Workloads setting. - Write-DbaDataTable
Quickly and efficiently writes data to a SQL Server Table using a .NET DataTable to a SQL Server table using SQL Bulk Copy.
Improvements
- Test-SqlMigrationConstraint
Added support for SQL Server 2016 SP1 outstanding news! Almost all editions supports what was, until now, Enterprise features only. (#512) - Get-SqlServerKey
Added support for SQL Server 2016 (#610) - Copy-SqlLogin
If you try to transfer a local account (non-domain) you get a "Skipped", because is a local machine account. (#275)
Notable bug fixes
- Copy-SqlDatabase
Fixed an issue where -WithReplace was not working properly (#601) - Expand-SqlTLogResponsibly
Fixed an issue where Expand-SqlTLogResponsibly grew TLog all at once. (#503) - Remove-SqlOrphanUser
Fixed an issue where Remove-SqlOrphanUser fails when the user was the owner of one or more schemas. (#296) - Remove-SqlDatabaseSafely
Remove-SqlDatabaseSafely failed to perform final drop w/ no additional information. (#238)
schleem
New Commands
- Export-DbaAvailabilityGroup
- Get-DbaBackupHistory
- Get-DbaDatabaseSnapshot
- Get-DbaRoleMember
- Read-DbaBackupHeader
- Remove-DbaDatabaseSnapshot
- Resolve-DbaNetworkName
- Test-DbaLastBackup
- Test-DbaMaxMemory
- Test-DbaValidLogin
Selected Bug fixes
Find-DbaOrphanedFile - speed improvements, added trims to remove null bytes for sql2000
Remove-SqlDatabaseSafely - Fixed SQL Agent Running check
Fix Export-SqlLogin not enumerating database permissions
Test-SqlMaxMemory - renamed all the MaxMemory commands
Get-DbaRestoreHistory - output directly to pipeline
Get-DbaBackupHistory - added device type
Copy-SqlLogin SQL Login not migrating when mixed mode not enabled on destination
Get-SqlRegisteredServerName - fix to allow working with nested groups
Testing
Added Appveyor + Pester
antsinmyeyesjohnson
New Commands
Connect-DbaSqlServer
Get-DbaLastBackup
Get-DbaPermission
Get-DbaStartupParameter
Remove-DbaBackup
Bug Fixes & Enhancements
Copy-SqlCredential and Copy-SqlLinkedServer unneeded connect attempts/errors removed
Copy-SqlDatabase - added example, and fixed a filestream check
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.”
Set-SqlMaxMemory - fixed error message
Start-SqlMigration - Corrected error that made Copy-SqlCredential and Copy-SqlLinkedServer only work with Windows auth
Test-SqlNetworkLatency -Fixed a logic bug that produced inaccurate results.
Test-SqlPath - Now works in all languages!
mrmeeseeks v2
New Commands
Copy-SqlSsisCatalog
Find-DbaOrphanedFile
Get-DbaAvailabilityGroup
Get-DbaLastGoodCheckDb
Get-DbaProcess
Get-DbaRunningJob
Set-DbaMaxDop
Test-DbaFullRecoveryModel
Test-DbaMaxDop
Bug Fixes & Enhancements
Fix Test-DbaPowerPlan powerplan language not being native
Set-SqlTempDbConfiguration calculation bug
Test-SqlTempDbConfiguration - Improved output
Copy-SqlLogin - moved kill closer to drop
Get-ParamSqlDatabases - Adding -NoSystem to dynamic parameter to include SystemDB's
Get-DbaDiskSpace - Output format issue bug general tools
Copy-SqlDatabase - Fixed Check for ROWS or LOG
Set-SqlTempDbConfiguration errors when more than 1 data file already exists best practices bug
Set-SqlTempDbConfiguration can't set data file growth
Copy-SqlLogin - Fixed language being dropped in some circumstances
Get-DbaDiskSpace - added bytes as unit, filesystem, fragmentation and -Detailed
install.ps1 to point to updated location
Copy-SqlLogin and Database in Availability Group issue resolved
Get-DbaDatabaseFreeSpace added columns enhancement
Update-SqlPermissions, Sync-SqlLoginPermissions - Fixes for inaccessible databases
tinyrick
Details about this release can be found at dbatools.io/tinyrick
August 2016 Release
This is a test of the GitHub release tagging, we're doing August's version of the master branch and labelling it accordingly. We'll be doing this for real in September.