Posts by Category

Blog

The first page with GitHub Pages

less than 1 minute read

Last night I started the experiment that has been in my head for a while now, to move from SQL Dba With A Beard to RobSewell.com

Surprised and Honoured and Proud

1 minute read

I have always been extremely proud to be a Cloud and Datacenter Management MVP, and lucky enough to be involved with both the PowerShell community as well as...

Running Jupyter Notebooks as Agent Jobs

4 minute read

Azure Data Studio is a great tool for connecting with your data platform whether it is in Azure or on your hardware. Jupyter Notebooks are fantastic, you can...

Whats a SQL Notebook in Azure Data Studio?

5 minute read

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, Mac...

Hitting the Wall – #TSQL2sDay

1 minute read

Photo by Farrel Nobel on Unsplash Welcome to another edition of T-SQL Tuesday! This T-SQL Tuesday is hosted by Wayne Sheffield ( blog  ...

A PowerShell Conference In A Book

3 minute read

A Question Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b t conta...

dbachecks – Improved Descriptions

1 minute read

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

Visual Studio Code Live Sharing Set-Up

2 minute read

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

#tsql2sday – Giving Back – Reprise

4 minute read

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

Checking Availability Groups with dbachecks

4 minute read

It’s been 45 days since we released dbachecks Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQ pic.t...

Easily Splatting PowerShell with VS Code

2 minute read

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

dbachecks – Configuration Deep Dive

17 minute read

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

I Hate Interviews – TSQL2sDay

6 minute read

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

Announcing PSDay.UK – Whats a PSDay?

2 minute read

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

Instances and Ports with PowerShell

less than 1 minute read

Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them

Giving Back – #TSQL2sday

8 minute read

T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a different person each month. The host sele...

Making a Change Log Easier With PowerShell

2 minute read

Having a Change Log is a good thing. A quick and simple place to find out what has changed on a server and when. This can be invaluable when troubleshooting,...

Generating T-SQL Randomly with Powershell

4 minute read

I have a lab on my laptop running various servers so that I can problem solve and learn and recently I wanted to add several months of data into a database. ...

Enable CLR with Powershell

1 minute read

I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter

Using PowerShell to get Azure Endpoint Ports

less than 1 minute read

A quick blog today. I was reading this blog post about How to read the SQL Error Log and I thought I would try some of the examples. I started my Azure VM us...

The PowerShell Box Of Tricks GUI

2 minute read

When I started as a DBA at MyWork I faced a challenge. Many hundreds of databases, dozens of servers and no idea what was on where. It was remembering this s...

Searching the SQL Error Log with PowerShell

1 minute read

Another post in the PowerShell Box of Tricks series. Here is another script which I use to save me time and effort during my daily workload enabling me to sp...

Checking Drive Sizes with PowerShell

1 minute read

I have developed a series of PowerShell functions over time which save me time and effort whilst still enabling me to provide a good service to my customers....

SQL login object permissions via PowerShell

2 minute read

As you know, I love PowerShell! I use it all the time in my daily job as a SQL DBA and at home whilst learning as well. Not only do I use PowerShell for auto...

SQL Express Migration Auto Close Setting

1 minute read

With over 700 databases to look after at MyWork automation is high on my list of priorities. I have two PowerShell scripts which run regularly checking SQL E...

Post: Chat

2 minute read

Abbott: Strange as it may seem, they give ball players nowadays very peculiar names.

Back to Top ↑

PowerShell

Running Jupyter Notebooks as Agent Jobs

4 minute read

Azure Data Studio is a great tool for connecting with your data platform whether it is in Azure or on your hardware. Jupyter Notebooks are fantastic, you can...

Whats a SQL Notebook in Azure Data Studio?

5 minute read

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, Mac...

Power Bi, PowerShell and SQL Agent Jobs

7 minute read

Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs - The SQL Agen...

Use Twitter to get #PowerShell help

1 minute read

A quick post today just to add some weight to something that Mike Fal b t has kicked off. The #SQLHelp hashtag is well known and well us...

Instances and Ports with PowerShell

less than 1 minute read

Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them

Back to Top ↑

dbatools

Whats a SQL Notebook in Azure Data Studio?

5 minute read

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, Mac...

Back to Top ↑

SQL Server

Power Bi, PowerShell and SQL Agent Jobs

7 minute read

Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs - The SQL Agen...

Instances and Ports with PowerShell

less than 1 minute read

Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them

Back to Top ↑

Community

Use Twitter to get #PowerShell help

1 minute read

A quick post today just to add some weight to something that Mike Fal b t has kicked off. The #SQLHelp hashtag is well known and well us...

Back to Top ↑

dbachecks

Whats a SQL Notebook in Azure Data Studio?

5 minute read

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, Mac...

dbachecks – Improved Descriptions

1 minute read

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

Checking Availability Groups with dbachecks

4 minute read

It’s been 45 days since we released dbachecks Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQ pic.t...

dbachecks – Configuration Deep Dive

17 minute read

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

Back to Top ↑

Jupyter Notebooks

Running Jupyter Notebooks as Agent Jobs

4 minute read

Azure Data Studio is a great tool for connecting with your data platform whether it is in Azure or on your hardware. Jupyter Notebooks are fantastic, you can...

Whats a SQL Notebook in Azure Data Studio?

5 minute read

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, Mac...

Back to Top ↑

Azure Data Studio

Running Jupyter Notebooks as Agent Jobs

4 minute read

Azure Data Studio is a great tool for connecting with your data platform whether it is in Azure or on your hardware. Jupyter Notebooks are fantastic, you can...

Whats a SQL Notebook in Azure Data Studio?

5 minute read

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, Mac...

Back to Top ↑

azure

Using PowerShell to get Azure Endpoint Ports

less than 1 minute read

A quick blog today. I was reading this blog post about How to read the SQL Error Log and I thought I would try some of the examples. I started my Azure VM us...

Back to Top ↑

IaC

Back to Top ↑

TSql2sDay

Giving Back – #TSQL2sday

8 minute read

T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a different person each month. The host sele...

Back to Top ↑

Azure DevOps

Back to Top ↑

Bicep

Back to Top ↑

Power Bi

Power Bi, PowerShell and SQL Agent Jobs

7 minute read

Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs - The SQL Agen...

Back to Top ↑

Azure

Back to Top ↑

SQL Saturday Exeter

Back to Top ↑

Data Saturdays

Back to Top ↑

Tools

Back to Top ↑

Dev Containers

Back to Top ↑

GitHub

Back to Top ↑

NewStarNovember

Back to Top ↑

Speaking

Back to Top ↑

TSQL2sDAY

Back to Top ↑

PowerShell Conference Europe

Back to Top ↑

community

#tsql2sday – Giving Back – Reprise

4 minute read

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

Back to Top ↑

DevOps

Back to Top ↑

Visual Studio Code

Back to Top ↑

Source Control

Back to Top ↑

pwsh

Back to Top ↑

Pester

Back to Top ↑

SLOBS

Back to Top ↑

Azure Arc Enabled Data Services

Back to Top ↑

Kubernetes

Back to Top ↑

Presenting

Back to Top ↑