Posts by Tag

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

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

Back to Top ↑

automation

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

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

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

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

Back to Top ↑

automate

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

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

Back to Top ↑

box-of-tricks

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

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

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

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 ↑

sql

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

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 ↑

adsnotebook

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

Back to Top ↑

databases

Back to Top ↑

roles

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

Back to Top ↑

documentation

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

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

Back to Top ↑

script

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

Back to Top ↑

excel

Back to Top ↑

permissions

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

Back to Top ↑

backups

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 ↑

github

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 ↑

PowerShell

Back to Top ↑

snippet

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

Back to Top ↑

community

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

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 ↑

docker

Back to Top ↑

pester

Back to Top ↑

Notebooks

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 ↑

Terraform

Back to Top ↑

Azure SQL Database

Back to Top ↑

terraform

Back to Top ↑

Azure DevOps

Back to Top ↑

SQL Agent Jobs

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

Back to Top ↑

Microsoft

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

Back to Top ↑

Secret Management

Back to Top ↑

Import-CliXml

Back to Top ↑

oracle

Back to Top ↑

development

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 ↑

document

Back to Top ↑

learning

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

Back to Top ↑

presenting

Back to Top ↑

endpoint

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 ↑

mirroring

Back to Top ↑

giving back

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 ↑

rationalise

Back to Top ↑

backup

Back to Top ↑

restore

Back to Top ↑

smo

Back to Top ↑

sqlfamily

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 ↑

containers

Back to Top ↑

Azure

Back to Top ↑

Visual Studio Code

Back to Top ↑

pwsh

Back to Top ↑

dbatoolsmol

Back to Top ↑

dbatoolsMoL

Back to Top ↑

net

Back to Top ↑

dotnet interactive

Back to Top ↑

dbastackexchange

Back to Top ↑

Teams

Back to Top ↑

SQL Agent

Back to Top ↑

chat

Post: Chat

2 minute read

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

Back to Top ↑

Post Formats

Post: Chat

2 minute read

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

Back to Top ↑

The Start

Back to Top ↑

blogging

Back to Top ↑

sql dba

Back to Top ↑

SQLBrit

Back to Top ↑

domain

Back to Top ↑

google

Back to Top ↑

names

Back to Top ↑

paperwork

Back to Top ↑

scripts

Back to Top ↑

server

Back to Top ↑

spof

Back to Top ↑

nottingham

Back to Top ↑

laerte

Back to Top ↑

mvp

Back to Top ↑

powerdoc

Back to Top ↑

patching

Back to Top ↑

ping

Back to Top ↑

rdp

Back to Top ↑

outlook

Back to Top ↑

logins

Back to Top ↑

migration

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

Back to Top ↑

napalmgram

Back to Top ↑

notifications

Back to Top ↑

operators

Back to Top ↑

error

Back to Top ↑

users

Back to Top ↑

properties

Back to Top ↑

processes

Back to Top ↑

Event Log

Back to Top ↑

account

Back to Top ↑

Users

Back to Top ↑

buttons

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

Back to Top ↑

gui

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

Back to Top ↑

files

Back to Top ↑

Windows Updates

Back to Top ↑

sqlbits

Back to Top ↑

msdb

Back to Top ↑

profiler

Back to Top ↑

sqlrelay

Back to Top ↑

for

Back to Top ↑

foreach

Back to Top ↑

SSMS

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 ↑

sponsors

Back to Top ↑

database

Back to Top ↑

audit

Back to Top ↑

Invoke-SqlCmd2

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

Back to Top ↑

Configuration

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

Back to Top ↑

Availability Group

Back to Top ↑

refresh

Back to Top ↑

html

Back to Top ↑

report

Back to Top ↑

indexes

Back to Top ↑

file groups

Back to Top ↑

snippets

Back to Top ↑

SMO

Back to Top ↑

data table

Back to Top ↑

colour

Back to Top ↑

VLF

Back to Top ↑

autogrowth

Back to Top ↑

email

Back to Top ↑

disk space

Back to Top ↑

alerting

Back to Top ↑

jonathan

Back to Top ↑

SQL Alerts

Back to Top ↑

SQL Assessment

Back to Top ↑

Operational Insights

Back to Top ↑

SCOM

Back to Top ↑

Change Log

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

Back to Top ↑

User Groups

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 ↑

SQL Saturdays

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 ↑

SQLBits

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 ↑

Events

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 ↑

Exeter

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 ↑

Christmas

Back to Top ↑

Fun

Back to Top ↑

test

Back to Top ↑

dataindevon

Back to Top ↑

Global Azure Bootcamp

Back to Top ↑

volumes

Back to Top ↑

poshrsjob

Back to Top ↑

Adventure Works

Back to Top ↑

Automation

Back to Top ↑

Testing

Back to Top ↑

Github

Back to Top ↑

Source Control

Back to Top ↑

IaaC

Back to Top ↑

aks

Back to Top ↑

kubernetes

Back to Top ↑

pipeline

Back to Top ↑

templates

Back to Top ↑

AKS

Back to Top ↑

DevOps

Back to Top ↑

Azure SQL VM

Back to Top ↑

Linux

Back to Top ↑

linux

Back to Top ↑

markdown

Back to Top ↑

SQL Notebooks

Back to Top ↑

Glenn Berry

Back to Top ↑

Diagnostic Notebooks

Back to Top ↑

writing

Back to Top ↑

BDFL

Back to Top ↑

MEAP

Back to Top ↑

Installation

Back to Top ↑

insiders

Back to Top ↑

extensions

Back to Top ↑

workspace

Back to Top ↑

Incident Response

Back to Top ↑

Azure Dev Ops

Back to Top ↑

Open Source

Back to Top ↑

PowerShell Core

Back to Top ↑

Stack Overflow

Back to Top ↑

iisresetme

Back to Top ↑

regex

Back to Top ↑

MVP

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

Back to Top ↑

jaap

Back to Top ↑

psconfeu

Back to Top ↑

Jaap Brasser

Back to Top ↑

Joel Bennett

Back to Top ↑

ssms

Back to Top ↑

VS Code

Back to Top ↑

SPN

Back to Top ↑

Key Vault

Back to Top ↑

Chrissy LeMaire

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

Back to Top ↑

First Post

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

Back to Top ↑

Migration

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

Back to Top ↑

SSIS

Back to Top ↑

Agent Jobs

Back to Top ↑

StreamLabs

Back to Top ↑

SLOBS

Back to Top ↑

streaming

Back to Top ↑