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

Adding a PowerShell Job Step to an existing SQL Agent Job Step with PowerShell

by Rob Sewell

SQL DBA With A Beard

In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The...

2017-03-13

1,136 reads

SQL VNext sp_configure on Windows and Linux with dbatools

by Rob Sewell

SQL DBA With A Beard

This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I...

2017-03-07 (first published: 2017-02-27)

2,095 reads

Adding a T-SQL Job Step to a SQL Agent Job with PowerShell

by Rob Sewell

SQL DBA With A Beard

In my last post, I explained how to alter an existing job step across many servers. I also had cause...

2017-02-23 (first published: 2017-02-20)

3,147 reads

Altering a Job Step on Hundreds of SQL Servers with PowerShell

by Rob Sewell

SQL DBA With A Beard

I flew to Utrecht last week to present with Chrissy LeMaire and Sander Stad to present to the joint Dutch...

2017-02-13

413 reads

Using the PowerShell SQL Provider with SQL Authentication

by Rob Sewell

SQL DBA With A Beard

Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL...

2017-01-12

1,916 reads

Running SQL Queries with Visual Studio Code

by Rob Sewell

SQL DBA With A Beard

Reading this blog post by Shawn Melton Introduction of Visual Studio Code for DBAs reminded me that whilst I use...

2017-01-10 (first published: 2017-01-05)

5,585 reads

A Whole Day of PowerShell and SQL – Join Chrissy LeMaire & I at #sqlsatvienna

by Rob Sewell

SQL DBA With A Beard

SQL Saturday Vienna 2017 is only just around the corner.
On Friday, January 20, 2017, a lot of local and international...

2017-01-09

405 reads

2016 – That was a Year :-)

by Rob Sewell

SQL DBA With A Beard

Its the time of year for reflection and I have had the most amazing 2016, I am blessed that I love...

2017-01-02

497 reads

Deploying a Windows Data Science Virtual Machine to Azure with PowerShell easily

by Rob Sewell

SQL DBA With A Beard

This weekend (10 December 2016), I went to Slovenia for a SQL Saturday. As always, it was an amazing event...

2016-12-18

819 reads

Enabling Cortana for dbareports PowerBi

by Rob Sewell

SQL DBA With A Beard

Last week at the Birmingham user group I gave a presentation about PowerShell and SQL Server

It was a very packed...

2016-11-16 (first published: 2016-11-13)

1,825 reads

Blogs

A Cloud Dependency Failure from Amazon

I went to sleep while reading a Kindle book on my phone. I know...

Deploying AI in logistics (the unfiltered version)

By Joyful-Craftsmen

A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...

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

Read the latest Blogs

Forums

BCA KCP Kramat Jaya Telp/WA.0821°3111°179

Telp/WA.0821°3111°179 Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara,...

SPAM Issues May 2026

By Steve Jones - SSC Editor

We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...

SQL Password enforcing

By Andre 425568

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

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