Rob Sewell

Rob was a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people. He is a Cloud and Data Center MVP and a Data Platform MVP, an officer for the PASS DevOps Virtual Chapter, co-leader of Data South West and PSConf EU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and Powershell communities.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter.

He has a fabulous beard

Twitter: @@SQLDbaWithBeard
LinkedIn: https://linkedin.com/in/robsewellsqldba

Pester 4.2.0 has a Because…… because :-)

by Rob Sewell

SQL DBA With A Beard

I was going through my demo for the South Coast User Group meeting tonight and decided to add some details...

2018-01-18

376 reads

Using the AST in Pester for dbachecks

by Rob Sewell

SQL DBA With A Beard

TagLine – My goal – Chrissy will appreciate Unit Tests one day
Chrissy has written about dbachecks the new up and coming...

2018-01-15

338 reads

Converting a Datarow to a JSON object with PowerShell

by Rob Sewell

SQL DBA With A Beard

This is just a quick post. As is frequent with these they are as much for me to refer to...

2018-01-05 (first published: 2017-12-18)

1,682 reads

Handling Missing Instances when Looping with Pester

by Rob Sewell

SQL DBA With A Beard

In my previous posts about writing your first Pester Test and looping through instances I described how you can start...

2017-11-30

684 reads

2 Ways to Loop through collections in Pester

by Rob Sewell

SQL DBA With A Beard

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

2017-11-28

399 reads

Comparing Agent Jobs across Availability Group Replicas with PowerShell

by Rob Sewell

SQL DBA With A Beard

On the plane home from PAS Summit I was sat next to someone who had also attended and when he...

2017-11-27 (first published: 2017-11-10)

1,536 reads

Using Plaster To Create a New PowerShell Module

by Rob Sewell

SQL DBA With A Beard

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

Tracey Boggiano T | B came along to our...

2017-11-22 (first published: 2017-11-09)

1,477 reads

Write Your first Pester Test Today

by Rob Sewell

SQL DBA With A Beard

I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group@SQLGlasgow and presenting sessions with Andre...

2017-11-16

443 reads

TSQL2sDay – Folks Who Have Made a Difference

by Rob Sewell

SQL DBA With A Beard

This months TSQL2sDay is an absolute brilliant one hosted by Ewald Cress
the opportunity to give a shout-out to people (well-known...

2017-11-14

270 reads

dbatools with SQL on Docker and running SQL queries

by Rob Sewell

SQL DBA With A Beard

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

2017-11-07

622 reads

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By Meagan Longoria

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By Eduardo Pivaral

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

SQL Password enforcing

By Andre 425568

Hi to all We have situation at a client where someone is illegally changing...

SQL Password enforcing

By Andre 425568

Hi to all We have situation at a client where someone is illegally changing...

BRI KANCA JAMBI WhatsApp 08980343752

BRI KANCA JAMBI WhatsApp 08980343752 Jl. Dokter Sutomo No.12, Ps. Jambi, Kec. Ps. Jambi,...

Visit the forum

Question of the Day

Creating a JSON Document III

I have this data in a table called dbo.NFLTeams

TeamID  TeamName       City             YearEstablished
------  --------       ----             ---------------
1       Cowboys        Dallas           1960
2       Eagles         Philadelphia     1933
3       Packers        Green Bay        1919
4       Chiefs         Kansas City      1960
5       49ers          San Francisco    1946
6       Broncos        Denver           1960
7       Seahawks       Seattle          1976
8       Patriots       New England      1960

If I run this code, how many rows are returned?

SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers