Archives: March 2017
The dbatools module (for those that don’t know) is a PowerShell module written by amazing folks in the community… Read more
With SQL Server vNext CTP 1.4 now available and providing SQL Agent capability on Linux, I wrote here about using Ola Hallengrens scripts on Linux SQL Servers so can Test-DbaLastBackup work… Read more
Pester provides a framework for running unit tests to execute and validate PowerShell commands from within PowerShell.…
With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it on Ubuntu you need to upgrade your SQL Server to CTP 1.4. On Ubuntu you do this with
sudo apt-get update sudo apt-get install mssql-server
Once you have CTP 1.4… Read more
Today I thought I would take it a little further and show you how PowerShell can be used to transmit or store this information in the manner you require
Test-DBALastBackup returns an object of… Read more
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from a directory using the dbatools module. Maybe it is a good idea to look at for disaster recovery scenarios but even PowerShell is going to be useless if your backups… Read more
All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This gives a folder structure like this
In my lab I had installed SQL 2016 on a server running Server 2016 TP5 which expired so I needed to… Read more
In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The process is exactly the same for a PowerShell job step.
As before I gathered the required jobs using Get-SQLAgentJob command from the sqlserver module which you can get by installing… Read more
Just a quick post, as much as a reminder for me as anything, but also useful to those that attended my sessions last week where I talked about snippets in PowerShell ISE
I love using… Read more
One of the most visited posts on my blog is nearly two and half years old now – Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users. I thought it was time to update it and use the latest sqlserver module and the dbatools… Read more