SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL DBA With A Beard

Rob is a SQL Server DBA currently supporting several hundred databases ranging from SQL 2000 to SQL 2012. Rob has a fabulous beard and loves to use Powershell to make his life easier.

Hitting the Wall – #TSQL2sDay

Photo by Farrel Nobel on Unsplash

Welcome to another edition of T-SQL Tuesday!

This T-SQL Tuesday is hosted by Wayne Sheffield ( blog | twitter ) and he has asked us to talk about

[…] a time when you ran up against your own brick wall, and how you worked…

Read more

0 comments, 74 reads

Posted in SQL DBA With A Beard on 14 August 2018

A PowerShell Conference In A Book

A Question

Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b | t contacted me with a question.

Interested in writing a chapter in a PowerShell book?
I was intrigued and read on.

A Conference in a Book

There was…

Read more

1 comments, 173 reads

Posted in SQL DBA With A Beard on 1 August 2018

A PowerShell Pester Check for parsing SQL scripts

I like to write Pester checks to make sure that all is as expected! This is just a quick post as much to help me remember this script

This is a quick Pester test I wrote to ensure that some SQL Scripts in a directory would parse so there was… Read more

3 comments, 295 reads

Posted in SQL DBA With A Beard on 25 July 2018

dbachecks – Dark Mode Historical Validation PowerBi

in my last post I showed how you can save the results of dbachecks to a database and created a PowerBi report. Inspired by Frank Henninger in the #dbachecks slack channel and Shawn Melton who explained the difficulties with red/green colour blind I then created this one

You can find… Read more

4 comments, 1,621 reads

Posted in SQL DBA With A Beard on 28 May 2018

dbachecks – Save the results to a database for historical reporting

I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got asked was will you write a command to put the results of the checks into a database for historical reporting.

The answer is no and here is the reasoning. The… Read more

1 comments, 2,635 reads

Posted in SQL DBA With A Beard on 23 May 2018

dbachecks – Improved Descriptions

With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are trusted thanks to Cláudio Silva b | t

To get the latest release you will need to run

Update-Module dbachecks

You should do this regularly as we release new improvements… Read more

1 comments, 2,106 reads

Posted in SQL DBA With A Beard on 19 May 2018

dbachecks – Which Configuration Item For Which Check ?

I love showing dbachecks to people. It’s really cool seeing how people will use it and listening to their experiences. I was showing it to a production DBA a month or so ago and he said

How Do I Know Which Checks There Are?

OK you just need to run Read more

1 comments, 193 reads

Posted in SQL DBA With A Beard on 15 May 2018

Creating SQL Server Containers for versions 2012-2017

I am working on my dbatools and dbachecks presentations for SQL Saturday Finland, SQLDays, SQL Saturday Cork and SQLGrillen I want to show the two modules running against a number of SQL Versions so I have installed

  • 2 Domain Controllers
  • 2 SQL 2017 instances on Windows 2016 with…

Read more

1 comments, 197 reads

Posted in SQL DBA With A Beard on 10 May 2018

#tsql2sday – Giving Back – Reprise

It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us two options here (as well as the side option of your favorite 2017 improvement). Pick a way that you’d like to give… Read more

2 comments, 128 reads

Posted in SQL DBA With A Beard on 8 May 2018

Visual Studio Code Live Sharing Set-Up

There was an announcement on the Visual Studio Code blog about the public preview of Live Share. This enables you to easily collaborate on code by securely sharing your coding session.

It is remarkably easy to set up


Open Visual Studio Code, open the Extensions side bar (CTRL +… Read more

0 comments, 1,711 reads

Posted in SQL DBA With A Beard on 8 May 2018

Version Update, Code Signing and publishing to the PowerShell Gallery with VSTS

At the fabulous PowerShell Conference EU I presented about Continuous Delivery to the PowerShell Gallery with VSTS and explained how we use VSTS to enable CD for dbachecks. We even released a new version during the session

Read more

2 comments, 278 reads

Posted in SQL DBA With A Beard on 1 May 2018

Professional and Proficient PowerShell: From Writing Scripts to Developing Solutions at PASS Summit

PASS Summit is the largest conference for technical professionals who leverage the Microsoft Data Platform. PASS Summit 2018 is happening November 5th – 9th 2018 in Seattle. It is an amazing conference. I attended last year and thoroughly enjoyed every minute. It is a whole week of opportunities… Read more

0 comments, 209 reads

Posted in SQL DBA With A Beard on 11 April 2018

Checking Availability Groups with dbachecks

It’s been 45 days since we released dbachecks

Since then there have been 25 releases to the PowerShell Gallery!! Today release 1.1.119 was released There have been over 2000 downloads of… Read more

3 comments, 1,783 reads

Posted in SQL DBA With A Beard on 8 April 2018

Easily Splatting PowerShell with VS Code

So I always like to show splatting PowerShell commands when I am presenting sessions or workshops and realised that I had not really blogged about it. (This blog is for @dbafromthecold who asked me to )

What is Splatting?

Well you will know that when you call a PowerShell function… Read more

2 comments, 270 reads

Posted in SQL DBA With A Beard on 11 March 2018

dbachecks – Configuration Deep Dive

Today is the day that we have announced dbachecks  a PowerShell module enabling you to validate your SQL Instances. You can read more about it here where you can learn how to install it and see some simple use cases

108 Configurations

One of the things I have been talking… Read more

10 comments, 418 reads

Posted in SQL DBA With A Beard on 22 February 2018

Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances

For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks. This open source PowerShell module will enable you to validate your SQL Instances. Today it is released for you all to start to use

Validate Your SQL Instances?

Read more

10 comments, 2,364 reads

Posted in SQL DBA With A Beard on 22 February 2018

VS Code – Terminal crashes when formatting script

I love VS Code. I love being able to press ALT + SHIFT + F and format my code.

The Problem

Yesterday all I got when I pressed ALT + SHIFT + F was this

I could reproduce it will. This was very frustrating.

Turning on Verbose Logging

To turn… Read more

0 comments, 343 reads

Posted in SQL DBA With A Beard on 10 February 2018

How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi

Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in Hanover and this year it is on April 17-20, 2018. The agenda has just been released and you can find it on the website http://www.psconf.eu/

I ended up creating an… Read more

1 comments, 502 reads

Posted in SQL DBA With A Beard on 3 February 2018

How to write a PowerShell function to use Confirm, Verbose and WhatIf

In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the commands within the script have been written to use the common parameters Confirm, Verbose and WhatIf.

Someone asked me how to make sure that any functions that they write will… Read more

1 comments, 1,183 reads

Posted in SQL DBA With A Beard on 25 January 2018

How to run a PowerShell script file with Verbose, Confirm or WhatIf

Before you run a PowerShell command that makes a change to something you should check that it is going to do what you expect. You can do this by using the WhatIf parameter for commands that support it. For example, if you wanted to create a New SQL Agent Job… Read more

2 comments, 248 reads

Posted in SQL DBA With A Beard on 23 January 2018

Older posts