Data compression is not a new feature in SQL Server. In fact it has been around since SQL Server 2008, so why does it matter now? Before SQL Server 2016 SP1 this feature was only available in Enterprise edition. Now that it’s in Standard edition data compression can be an option for far more people.
dbatools has three functions available to help you work with data compression, and in true dbatools style it makes it easy and fast to compress your databases.
We recently released a VS Code extension that lets you highlight terms and search dbatools.io, Microsoft Docs, Google, StackOverflow, DuckDuckGo, Technet or Thwack right from your code! It’s called search from code and you can find it in the Extension Marketplace.
Options and Settings By default, only Google, docs and dbatools are enabled but you can configure whichever providers you’d like in VS Code Settings.
At first, I was just messing around to see what it took to create a VS Code extension, but then I realized that I was actually using it and decided to share.
We’ve made even more progress in the past week! Here are some highlights of 0.9.520.
Non-Breaking Changes Aliases have been added for the changes, so these are not breaking changes:
Mismatched Copy commands have been renamed to match their corresponding Get command names (ie. Copy-DbaCentralManagementServer is now Copy-DbaCmsRegServer). Most parameters named Password have been changed to SecurePassword. They’ve always been a SecureString data type but this makes that clear. The parameters ExcludeAllSystemDb and ExcludeAllUserDb have been changed to ExcludeSystem and ExcludeUser, respectively.
Before I go into the breaking changes introduced in 0.9.518, I wanted to highlight Invoke-dbatoolsRenameHelper which is an awesome command that will help you with a vast majority of our renames. Using it is as simple as:
Get-ChildItem *.ps1 -Recurse | Invoke-dbatoolsRenameHelper
This command even takes care of a couple parameter renames like NetworkShare and UseLastBackups.
Breaking Changes It’s been a busy couple days! Here’s a list of our breaking changes
Thanks to several of our team members, we’re now progressing quickly towards dbatools 1.0! 🙌
The progress is so encouraging, I believe 1.0 is around the corner. Because of this, I wanted to let you all know that tomorrow, we’ll start introducing breaking changes.
Output Changes Things like output and parameter names will change. For example, the output for the command Get-DbaPrivilege will be updated. Currently, it looks like this:
During the month of October 2018 DigitalOcean is again running Hacktoberfest to support open source projects. They are offering a limited edition T-Shirt for any person making five pull requests to any public repo on GitHub.
To get a shirt, you must make five pull requests (PRs) between October 1-31 in any timezone. PRs can be to any public repo on GitHub, not just the ones highlighted. The PR must contain commits you made yourself.
Just a quick note that we’ve made more changes to align with 1.0, now available in version 0.9.453.
Renamed Log Shipping Get-DbaDbLogShipError Invoke-DbaDbLogShipping Invoke-DbaDbLogShipRecovery Test-DbaDbLogShipStatus
Registered Servers (Central Management Server) Add-DbaRegServer Add-DbaRegServerGroup Get-DbaRegServer Get-DbaRegServerGroup Get-DbaRegServerStore Import-DbaRegServer Move-DbaRegServer Move-DbaRegServerGroup Remove-DbaRegServer Remove-DbaRegServerGroup
And don’t forget, you can use Invoke-DbatoolsRenameHelper to rename commands in your scripts.
Get-ChildItem .\scripts | Invoke-DbatoolsRenameHelper New I’ll write about these more soon, but until then, enjoy this piping hot batch of new HA commands.
Now that you’ve convinced your security team that PowerShell improves your security posture, it’s time to learn PowerShell if you haven’t already.
Month of Lunches Learn PowerShell in a Month of Lunches Hands down, the one book most people recommend for learning PowerShell is Learn Windows PowerShell in a Month of Lunches by Don Jones and Jeffrey Hicks. You can buy the 3rd edition from Amazon or directly from Manning.
Last year, during our PASS Summit and SQL Bits precons, we highlighted the reasons that PowerShell is even more secure than GUI administration.
I even created a cute lil logo for it 😊
Recently, our team had a discussion about security in #dbatools-dev and I realized I should probably highlight why PowerShell and dbatools are ideal for every organization, including security-minded organizations.
If you’re questioned about PowerShell or dbatools, here are some handy facts to help prove we can help make your administration more, not less, secure.
Over the weekend, I presented a session in Glasgow called doomsday prepping with dbatools at SQLGLA, a community event hosted by Craig Porteous, sql_bob and Louise Paterson.
It was a lot of fun, even though the audience put no effort into winning the MRE give away
Now I’ve got some ready-to-eat beef tacos when the zombie apocalypse hits!
Down to Business When we talk about Disaster Recovery or DR, it’s often coupled with the term High Availability or HA.
dbatools