-->
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.

Handling Missing Instances when Looping with Pester

In my previous posts about writing your first Pester Test and looping through instances I described how you can start to validate that your SQL Server is how YOU want it to be.

Unavailable machines

Once you begin to have a number of tests for a number of instances you… Read more

0 comments, 115 reads

Posted in SQL DBA With A Beard on 30 November 2017

2 Ways to Loop through collections in Pester

In my last post I showed you how to write your first Pester test to validate something. Here’s a recap

  • Decide the information you wish to test
  • Understand how to get it with PowerShell
  • Understand what makes it pass and what makes it fail
  • Write a Pester Test

You probably… Read more

0 comments, 122 reads

Posted in SQL DBA With A Beard on 28 November 2017

Write Your first Pester Test Today

I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group @SQLGlasgow and presenting sessions with Andre Kamman, William Durkin and Chrissy LeMaire

I presented “Green is Good Red is Bad – Turning your checklists into Pester Tests”. I had to make sure I… Read more

1 comments, 165 reads

Posted in SQL DBA With A Beard on 16 November 2017

TSQL2sDay – Folks Who Have Made a Difference

This months TSQL2sDay is an absolute brilliant one hosted by Ewald Cress

the opportunity to give a shout-out to people (well-known or otherwise) who have made a meaningful contribution to your life in the world of data.

Fabulous, fabulous idea Ewald, I heartily approve

Now this is going to be… Read more

1 comments, 108 reads

Posted in SQL DBA With A Beard on 14 November 2017

Comparing Agent Jobs across Availability Group Replicas with PowerShell

On the plane home from PAS Summit I was sat next to someone who had also attended and when he saw on my laptop that I was part of the SQL Community we struck up a conversation. He asked me how he could compare SQL Agent Jobs across availability group… Read more

1 comments, 921 reads

Posted in SQL DBA With A Beard on 10 November 2017

Using Plaster To Create a New PowerShell Module

Chrissy, CK and I presented a pre-con at PASS Summit in Seattle last week

Tracey Boggiano T | B came along to our pre-con and afterwards we were talking about creating PowerShell modules. In her blog post she explains how she creates modules by copying the code from another module… Read more

0 comments, 891 reads

Posted in SQL DBA With A Beard on 9 November 2017

dbatools with SQL on Docker and running SQL queries

I had a question from my good friend Andrew Pruski dbafromthecold on twitter or SQL Container Man as I call him

How do you guys run SQL Commands in dbatools

I will answer that at the bottom of this post, but during our discussion Andrew said he wanted to show… Read more

1 comments, 189 reads

Posted in SQL DBA With A Beard on 7 November 2017

A Pretty PowerBi Pester Results Template File

I have left the heat and humidity of Singapore where I have been presenting at the PowerShell Conference Asia and DevOpsDays Singapore to travel to Seattle for PASS Summit. During my Green is Good – Red is Bad session someone asked me if the PowerBi that I showed at the… Read more

0 comments, 185 reads

Posted in SQL DBA With A Beard on 29 October 2017

TSQL2sDay – Get-PostRoundup

First an apology, this round up is late!

The reason for that is an error in the PowerShell testing module Pester (That’s not completely true as you shall see!!)

I spoke in Stuttgart at the PowerShell Saturday last weekend and had intended to write this blog post whilst travelling, unfortunately… Read more

2 comments, 869 reads

Posted in SQL DBA With A Beard on 20 September 2017

#TSQL2sDay – Starting Out with PowerShell

This months TSQL2sday is hosted by me!

Surprise! – I chose PowerShell

I am really looking forward to seeing what other people post. Some advanced scripts that will help you and show you how you can use PowerShell to save you time and hopefully some beginner posts explaining experiences or… Read more

3 comments, 202 reads

Posted in SQL DBA With A Beard on 12 September 2017

Automatically updating the version number in a PowerShell Module – How I do regex

I am presenting Continuous Delivery for your PowerShell Module to the PowerShell Gallery at PSDayUK in London. Go and register if you will be close to London on Friday 22nd September.

In 45 minutes we will

– Use Plaster to create our module framework
– Use GitHub for Version Control Read more

1 comments, 259 reads

Posted in SQL DBA With A Beard on 9 September 2017

TSQL2sday #94 Lets get all Posh!

Write-Output "What are you going to automate today?"

 

Welcome to T-SQL Tuesday for September 2017!

T-SQL Tuesday is a chance for you to join in the SQL Server community and write a blog post on a suggested topic. It makes for a great way to find a bunch of… Read more

72 comments, 194 reads

Posted in SQL DBA With A Beard on 5 September 2017

PSDay.UK Tickets are on sale

Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we are pleased to announce that the PSDay.UK tickets are now on sale.

If you just want to go and get a ticket click here

PSDay.UK

The first of the PSDay… Read more

0 comments, 202 reads

Posted in SQL DBA With A Beard on 13 August 2017

Using PowerShell to check if your password has been in a breach

We know that we need to keep our credentials secure. We know that we should not re-use our passwords across different services. Hopefully, by now, most readers of this blog are aware of Troy Hunts excellent free service https://haveibeenpwned.com/ which will notify you if your email has been found in… Read more

10 comments, 1,293 reads

Posted in SQL DBA With A Beard on 9 August 2017

I Hate Interviews – TSQL2sDay

This month’s T-SQL Tuesday is hosted by Kendra Little and is on the topic of interviews 

I hate interviews as an interviewee. I have had many memorable experiences with them. Even writing this blog post has been challenging as I relive some of them. I haven’t shared a lot of… Read more

6 comments, 292 reads

Posted in SQL DBA With A Beard on 8 August 2017

Presentation Nerves

My previous post on interviews and a number of conversations this year inspired me to write this post. I am lucky enough to have been selected to speak at numerous events over the past few years and I am really lucky because I thoroughly enjoy doing them. The feedback I… Read more

3 comments, 272 reads

Posted in SQL DBA With A Beard on 8 August 2017

Announcing PSDay.UK – Whats a PSDay?

On Thursday evening I attended the joint London WinOps and PowerShell User Group. It was an excellent evening with two great sessions by Jaap Brasser and Filip Verloy.

PSDay.UK

There was also an exciting announcement about PSDay.UK  https://psday.uk

Read more

2 comments, 250 reads

Posted in SQL DBA With A Beard on 24 July 2017

Writing Dynamic and Random Tests Cases for Pester

I have written a module SQLDiagAPI for consuming the SQL Server Diagnostics API with PowerShell. I blogged about how I used Pester to develop one of the functions . Whilst writing Get-SQLDiagFix I wrote some Pester Tests to make sure that the output from the code was as expected.

Pester

Read more

1 comments, 236 reads

Posted in SQL DBA With A Beard on 6 July 2017

Using Get-SQLDiagFix to get information from the SQL Server Diagnostic API with PowerShell

The SQL Server Diagnostics Preview was announced just over a week ago It includes an add-on for SQL Server Management Studio to enable you to analyse SQL Server memory dumps and view information on the latest SQL Server cumulative updates for supported versions of SQL Server. Arun Sirpal has written… Read more

1 comments, 1,211 reads

Posted in SQL DBA With A Beard on 4 July 2017

Creating a PowerShell Module and TDD for Get-SQLDiagRecommendations

Yesterday I introduced the first command in the SQLDiagAPI module. A module to consume the SQL Diagnostics API.

I have been asked a few times what the process is for creating a module, using Github and developing with Pester and whilst this is not a comprehensive how-to I hope it… Read more

4 comments, 390 reads

Posted in SQL DBA With A Beard on 30 June 2017

Older posts