Using PowerShell to Automate StreamLabs OBS and Show Your Webcam in PowerPoint
It started with a tweet
Rob Sewell
Rob was a SQL Server DBA.
Now he just helps people with Powershell, Azure, Automation, and Data.
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 PSConfEU organiser.
He is a proud supporter of the Data and Powershell communities.
He has a fabulous beard
Posts by Tag
- powershell 78
- automation 34
- automate 30
- box-of-tricks 20
- dbatools 19
- SQL Server 14
- Jupyter Notebooks 13
- Azure Data Studio 12
- sql 7
- azure 7
- adsnotebook 7
- databases 6
- roles 6
- dbachecks 6
- pester 6
- documentation 5
- github 5
- script 4
- excel 4
- permissions 4
- backups 4
- tsql2sday 4
- PowerShell 3
- snippet 3
- community 3
- docker 3
- Notebooks 3
- Terraform 3
- Azure SQL Database 3
- terraform 3
- Azure DevOps 3
- SQL Agent Jobs 3
- Microsoft 3
- Secret Management 3
- Import-CliXml 3
- oracle 2
- development 2
- document 2
- learning 2
- presenting 2
- endpoint 2
- mirroring 2
- giving back 2
- rationalise 2
- backup 2
- restore 2
- smo 2
- sqlfamily 2
- SQLBits 2
- Agent Jobs 2
- confirm 2
- verbose 2
- containers 2
- Azure 2
- Visual Studio Code 2
- pwsh 2
- dbatoolsmol 2
- dbatoolsMoL 2
- net 2
- dotnet interactive 2
- dbastackexchange 2
- Teams 2
- SQL Agent 2
- chat 1
- Post Formats 1
- The Start 1
- blogging 1
- sql dba 1
- SQLBrit 1
- domain 1
- google 1
- names 1
- paperwork 1
- scripts 1
- server 1
- spof 1
- nottingham 1
- laerte 1
- mvp 1
- powerdoc 1
- patching 1
- ping 1
- rdp 1
- outlook 1
- logins 1
- migration 1
- napalmgram 1
- notifications 1
- operators 1
- error 1
- users 1
- properties 1
- processes 1
- Event Log 1
- account 1
- Users 1
- buttons 1
- gui 1
- files 1
- Windows Updates 1
- sqlbits 1
- msdb 1
- profiler 1
- sqlrelay 1
- for 1
- foreach 1
- SSMS 1
- sponsors 1
- database 1
- audit 1
- Invoke-SqlCmd2 1
- Configuration 1
- Availability Group 1
- refresh 1
- html 1
- report 1
- indexes 1
- file groups 1
- snippets 1
- SMO 1
- data table 1
- colour 1
- VLF 1
- autogrowth 1
- email 1
- disk space 1
- alerting 1
- jonathan 1
- SQL Alerts 1
- SQL Assessment 1
- Operational Insights 1
- SCOM 1
- Change Log 1
- User Groups 1
- SQL Saturdays 1
- Events 1
- Exeter 1
- Christmas 1
- Fun 1
- AST 1
- Azure SQL Db 1
- Flow 1
- Cognitive Services 1
- Power Bi 1
- PSConfEU 1
- test 1
- dataindevon 1
- Global Azure Bootcamp 1
- volumes 1
- poshrsjob 1
- Adventure Works 1
- Automation 1
- Testing 1
- Github 1
- Source Control 1
- IaaC 1
- aks 1
- kubernetes 1
- pipeline 1
- templates 1
- AKS 1
- DevOps 1
- Azure SQL VM 1
- Linux 1
- linux 1
- markdown 1
- SQL Notebooks 1
- Glenn Berry 1
- Diagnostic Notebooks 1
- writing 1
- BDFL 1
- MEAP 1
- Installation 1
- insiders 1
- extensions 1
- workspace 1
- Incident Response 1
- Azure Dev Ops 1
- Open Source 1
- PowerShell Core 1
- Stack Overflow 1
- iisresetme 1
- regex 1
- MVP 1
- jaap 1
- psconfeu 1
- Jaap Brasser 1
- Joel Bennett 1
- ssms 1
- VS Code 1
- SPN 1
- Key Vault 1
- Chrissy LeMaire 1
- First Post 1
- Migration 1
- SSIS 1
- StreamLabs 1
- SLOBS 1
- streaming 1
powershell
#tsql2sday #130 - Automate your stress away - Getting more SSIS Agent Job information
Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blo...
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Notifying a Teams Channel of a SQL Agent Job result
Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge
Sending a SQL Agent Job results overview to a Microsoft Teams Channel
Microsoft Teams is fantastic for collaboration. It enables groups of people, teams if you like to be able to communicate, collaborate on documents, hold meet...
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
Running Jupyter Notebooks as Agent Jobs
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...
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing [my previous blog post!](https://blog.robsewell.com/net-p...
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
How to fork a GitHub repository and contribute to an open source project
I enjoying maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the p...
Create a PowerShell Notebook for Azure Data Studio with PowerShell
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell notebooks with PowerShell.
Create Azure Data Studio SQL Notebooks with PowerShell
At PASS Summit today I gave a presentation about SQL Notebooks in Azure Data Studio for the DBA. I demo’d the PowerShell module ADSNotebook.
My current VS Code Extensions and using a workspace file
I have been asked a couple of times recently what my Visual Studio Code extensions are at the moment so I thought I would write a quick post and also look at...
PowerShell Notebooks in Azure Data Studio
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
Getting SQL Server installation date with PowerShell using dbatools
Most of my writing time at the moment is devoted to Learn dbatools in a Month of Lunches which is now available but here is a short post following a questio...
MEAP MEAP – #dbatoolsMoL – Live Book edition
It’s been a busy time!
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
Azure SQL Linux VM – configuring SQL, installing pwsh and connecting and interacting with dbatools
In my posts about using Azure Devops to build Azure resources with Terraform, I built a Linux SQL VM. I used the Terraform in this GitHub repository and crea...
#DataInDevon – Getting up to speed with PowerShell or spend a day with one of four other MVPs :-)
Saturday 27th April is Global Azure Bootcamp day
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how he uses containers in Azure to...
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in Hanover and this year it is on April 1...
How to write a PowerShell function to use Confirm, Verbose and WhatIf
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the commands within the script have been written to use the co...
How to run a PowerShell script file with Verbose, Confirm or WhatIf
Before you run a PowerShell command that makes a change to something you should check that it is going to do what you expect. You can do this by using the Wh...
Pester 4.2.0 has a Because…… because :-)
I was going through my demo for the South Coast User Group meeting tonight and decided to add some details about the Because parameter available in the Peste...
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There s...
Making a Change Log Easier With PowerShell
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,...
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received t...
Generating T-SQL Randomly with Powershell
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. ...
Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening I wrote a Powershell script to provide some alerts by em...
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
PowerShell Snippets A Great Learning Tool
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good tip
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh an Availability Group Database.
Refreshing A SQL Mirrored Database Using Powershell
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and although the feature is deprecated it ...
Enable CLR with Powershell
I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
Listing the SQL Server SysAdmins With PowerShell
A very short blog today just to pass on this little script.
Rationalisation of Database with Powershell and T-SQL part one
I have recently been involved in a project to rationalise databases. It is easy in a large organisation for database numbers to rapidly increase and sometime...
Viewing SQL Endpoint Permissions with PowerShell
A quick and simple post today as I have been very busy. I needed to list the users with permissions on mirroring endpoints today so I wrote this script and f...
Using PowerShell to get Azure Endpoint Ports
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...
Dropping All Tables From A SQL Database with PowerShell
This post could also have been titled confusion with foreach or For-EachObject
Starting My Azure SQL Server VMs with PowerShell
The last post about Launching Azure VMs with PowerShell made someone ask me to explain how I start my Azure VMs normally so here goes.
What Runs on the SQL Server when you run a PowerShell script?–Question from #SQLRelay
Last week I ran a PowerShell lab at SQL Relay in Cardiff. There are still a few places available for SQL Relay week 2. Take a look here for more details and ...
Launching Azure VM After Starting With PowerShell
So this morning I decided I was going to run through this blog post on understanding query plans http://sqlmag.com/t-sql/understanding-query-plans. I logged ...
Searching for Installed Windows Update With PowerShell
Yesterdays Post Show-WindowsUpdatesLocal does enable you to search for an installed update as follows
Show Windows Updates Locally With PowerShell
I wanted to be able to quickly show the Windows Updates on a server. This came about during a discussion about auditing.
Finding Text In All Files In A Folder With PowerShell
Whilst writing my PowerShell Box of Tricks GUI I realised that I had hard-coded the path to the sqlservers.txt file in several functions and I wanted one pla...
The PowerShell Box Of Tricks GUI
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...
Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
Creating SQL User and adding to Server Role with PowerShell
Another post in the PowerShell Box of Tricks series.
Creating a Windows User and adding to a SQL Server Role with PowerShell
Another post in the PowerShell Box of Tricks series. In a previous post Checking SQL Server User Role Membership we showed how to check which roles users wer...
Displaying the Windows Event Log with PowerShell
The latest post in the PowerShell Box of tricks series is here.
Showing and Killing SQL Server Processes with PowerShell
Another post in the PowerShell Box of Tricks series. There are much better ways of doing this I admit but as you can do it with PowerShell I created a functi...
Show The Last Backups On A Server with PowerShell
Another day another PowerShell Box of Tricks post Auditors, managers and bosses often want proof of following processes successfully so when they come knocki...
Checking For A Database Backup with PowerShell
Todays PowerShell Box of Tricks Post is about backups I highly recommend you go and read bookmark and come straight back Stuart Moore’s series on Backups wit...
Searching the SQL Error Log with PowerShell
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...
Reading Todays SQL Error Log With PowerShell
Todays post from my PowerShell Box of Tricks series is about the SQL Error Log. DBAs need to read the error log for many reasons and there are different ways...
List Databases (and Properties) on SQL Server with PowerShell
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...
Creating SQL Server Database with PowerShell
This morning I have been setting up my Azure Servers in preparation for my presentation to the Cardiff SQL User Group this month.
Alter SQL Mirroring Endpoint Owner with Powershell
Whilst using my Drop-SQLLogins function, which is one of my PowerShell Box Of Tricks series, it failed to delete logins on some servers with the error
Using PowerShell to find a database amongst hundreds
As you know, I love PowerShell! I have developed a series of functions over time which save me time and effort whilst still enabling me to provide a good ser...
Checking Drive Sizes with PowerShell
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 Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
SQL login object permissions via PowerShell
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...
Checking SQL Server User Role Membership with PowerShell
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
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...
Checking for SQL Server logins with PowerShell
As some of you may know, I love PowerShell!
sp_BlitzIndex™ ouput to Excel with Powershell
I am impressed with the output from sp_BlitzIndex™ and today I tried to save it to an excel file so that I could pass it on to the developer of the service. ...
Powershell can read email & insert excel file attachment into a SQL Database
So at our SQL SouthWest User Group session last week we had sessions from Jonathan @fatherjack and Annette @Mrsfatherjack on SSRS and SSIS respectively. Dur...
Checking SQL Error Logs, Event Logs and Stopping Services with Powershell
It was patching time this week at MyWork so I thought I would share some Powershell scripts I use to speed up the process.
Add Adventure Works Database to Windows Azure VM
This has been an interesting journey. The Adventure Works database is frequently used in blogs and reference books and I wanted to install it in my Windows A...
Lessons Learnt from my first talk at SQL SouthWest
The timing was good enough that I could offer to do a talk based on my previous post on Windows Azure for my SQL User Group SQL SouthWest when Jonathan and A...
Spinning up and shutting down Windows Azure Lab with Powershell
So at SQL Bits I went to Chris Testa-O’Neill’s session on certification. This has inspired me to start working on passing the MCSE exams. My PC at home doesn...
Documenting SQL Server the easy way with Power Doc
You know how it is. Question questions questions. As a DBA you are the fount of all knowledge. You are the protector of the data after all so obviously you k...
Powershell won’t save when running as a scheduled job
Or, How SQLBits put me in touch with Laerte and solved a problem
automation
Using PowerShell to Automate StreamLabs OBS and Show Your Webcam in PowerPoint
It started with a tweet
#tsql2sday #130 - Automate your stress away - Getting more SSIS Agent Job information
Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blo...
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Notifying a Teams Channel of a SQL Agent Job result
Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge
Sending a SQL Agent Job results overview to a Microsoft Teams Channel
Microsoft Teams is fantastic for collaboration. It enables groups of people, teams if you like to be able to communicate, collaborate on documents, hold meet...
Running Jupyter Notebooks as Agent Jobs
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...
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the p...
Using the same Azure DevOps build steps for Terraform with different Pipelines with Task Groups to build an Azure Linux SQL VM
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build the requi...
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
Building Azure SQL Db with Terraform using Azure DevOps
In my last post I showed how to create a Resource Group and an Azure SQL Database with Terraform using Visual Studio Code to deploy.
Making a Change Log Easier With PowerShell
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,...
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received t...
Generating T-SQL Randomly with Powershell
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. ...
Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening I wrote a Powershell script to provide some alerts by em...
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
Refreshing A SQL Mirrored Database Using Powershell
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and although the feature is deprecated it ...
Dropping All Tables From A SQL Database with PowerShell
This post could also have been titled confusion with foreach or For-EachObject
Starting My Azure SQL Server VMs with PowerShell
The last post about Launching Azure VMs with PowerShell made someone ask me to explain how I start my Azure VMs normally so here goes.
Show Windows Updates Locally With PowerShell
I wanted to be able to quickly show the Windows Updates on a server. This came about during a discussion about auditing.
Finding Text In All Files In A Folder With PowerShell
Whilst writing my PowerShell Box of Tricks GUI I realised that I had hard-coded the path to the sqlservers.txt file in several functions and I wanted one pla...
The PowerShell Box Of Tricks GUI
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...
Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
Show The Last Backups On A Server with PowerShell
Another day another PowerShell Box of Tricks post Auditors, managers and bosses often want proof of following processes successfully so when they come knocki...
Searching the SQL Error Log with PowerShell
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...
Dropping SQL Users with PowerShell
As you may have noticed, I love PowerShell!
Creating SQL Server Database with PowerShell
This morning I have been setting up my Azure Servers in preparation for my presentation to the Cardiff SQL User Group this month.
Alter SQL Mirroring Endpoint Owner with Powershell
Whilst using my Drop-SQLLogins function, which is one of my PowerShell Box Of Tricks series, it failed to delete logins on some servers with the error
SQL Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
SQL Express Migration Auto Close Setting
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...
Checking for SQL Server logins with PowerShell
As some of you may know, I love PowerShell!
sp_BlitzIndex™ ouput to Excel with Powershell
I am impressed with the output from sp_BlitzIndex™ and today I tried to save it to an excel file so that I could pass it on to the developer of the service. ...
Checking SQL Error Logs, Event Logs and Stopping Services with Powershell
It was patching time this week at MyWork so I thought I would share some Powershell scripts I use to speed up the process.
Documenting SQL Server the easy way with Power Doc
You know how it is. Question questions questions. As a DBA you are the fount of all knowledge. You are the protector of the data after all so obviously you k...
automate
Using PowerShell to Automate StreamLabs OBS and Show Your Webcam in PowerPoint
It started with a tweet
#tsql2sday #130 - Automate your stress away - Getting more SSIS Agent Job information
Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blo...
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the p...
Making a Change Log Easier With PowerShell
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,...
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received t...
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh an Availability Group Database.
Rationalisation of Database with Powershell and T-SQL part two
In the previous post I showed the script to create an Excel Workbook, colour coded showing the last used date for all of the databases on servers in my sqlse...
Rationalisation of Database with Powershell and T-SQL part one
I have recently been involved in a project to rationalise databases. It is easy in a large organisation for database numbers to rapidly increase and sometime...
Launching Azure VM After Starting With PowerShell
So this morning I decided I was going to run through this blog post on understanding query plans http://sqlmag.com/t-sql/understanding-query-plans. I logged ...
Searching for Installed Windows Update With PowerShell
Yesterdays Post Show-WindowsUpdatesLocal does enable you to search for an installed update as follows
Finding Text In All Files In A Folder With PowerShell
Whilst writing my PowerShell Box of Tricks GUI I realised that I had hard-coded the path to the sqlservers.txt file in several functions and I wanted one pla...
The PowerShell Box Of Tricks GUI
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...
Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
Creating SQL User and adding to Server Role with PowerShell
Another post in the PowerShell Box of Tricks series.
Creating a Windows User and adding to a SQL Server Role with PowerShell
Another post in the PowerShell Box of Tricks series. In a previous post Checking SQL Server User Role Membership we showed how to check which roles users wer...
Checking For A Database Backup with PowerShell
Todays PowerShell Box of Tricks Post is about backups I highly recommend you go and read bookmark and come straight back Stuart Moore’s series on Backups wit...
Searching the SQL Error Log with PowerShell
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...
Reading Todays SQL Error Log With PowerShell
Todays post from my PowerShell Box of Tricks series is about the SQL Error Log. DBAs need to read the error log for many reasons and there are different ways...
List Databases (and Properties) on SQL Server with PowerShell
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...
Dropping SQL Users with PowerShell
As you may have noticed, I love PowerShell!
Creating SQL Server Database with PowerShell
This morning I have been setting up my Azure Servers in preparation for my presentation to the Cardiff SQL User Group this month.
Alter SQL Mirroring Endpoint Owner with Powershell
Whilst using my Drop-SQLLogins function, which is one of my PowerShell Box Of Tricks series, it failed to delete logins on some servers with the error
Using PowerShell to find a database amongst hundreds
As you know, I love PowerShell! I have developed a series of functions over time which save me time and effort whilst still enabling me to provide a good ser...
Checking Drive Sizes with PowerShell
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 Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
SQL login object permissions via PowerShell
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...
Checking SQL Server User Role Membership with PowerShell
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...
Checking for SQL Server logins with PowerShell
As some of you may know, I love PowerShell!
Checking SQL Error Logs, Event Logs and Stopping Services with Powershell
It was patching time this week at MyWork so I thought I would share some Powershell scripts I use to speed up the process.
box-of-tricks
Finding Text In All Files In A Folder With PowerShell
Whilst writing my PowerShell Box of Tricks GUI I realised that I had hard-coded the path to the sqlservers.txt file in several functions and I wanted one pla...
The PowerShell Box Of Tricks GUI
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...
Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
Creating SQL User and adding to Server Role with PowerShell
Another post in the PowerShell Box of Tricks series.
Creating a Windows User and adding to a SQL Server Role with PowerShell
Another post in the PowerShell Box of Tricks series. In a previous post Checking SQL Server User Role Membership we showed how to check which roles users wer...
Displaying the Windows Event Log with PowerShell
The latest post in the PowerShell Box of tricks series is here.
Showing and Killing SQL Server Processes with PowerShell
Another post in the PowerShell Box of Tricks series. There are much better ways of doing this I admit but as you can do it with PowerShell I created a functi...
Show The Last Backups On A Server with PowerShell
Another day another PowerShell Box of Tricks post Auditors, managers and bosses often want proof of following processes successfully so when they come knocki...
Checking For A Database Backup with PowerShell
Todays PowerShell Box of Tricks Post is about backups I highly recommend you go and read bookmark and come straight back Stuart Moore’s series on Backups wit...
Searching the SQL Error Log with PowerShell
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...
Reading Todays SQL Error Log With PowerShell
Todays post from my PowerShell Box of Tricks series is about the SQL Error Log. DBAs need to read the error log for many reasons and there are different ways...
List Databases (and Properties) on SQL Server with PowerShell
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...
Dropping SQL Users with PowerShell
As you may have noticed, I love PowerShell!
Creating SQL Server Database with PowerShell
This morning I have been setting up my Azure Servers in preparation for my presentation to the Cardiff SQL User Group this month.
Alter SQL Mirroring Endpoint Owner with Powershell
Whilst using my Drop-SQLLogins function, which is one of my PowerShell Box Of Tricks series, it failed to delete logins on some servers with the error
Using PowerShell to find a database amongst hundreds
As you know, I love PowerShell! I have developed a series of functions over time which save me time and effort whilst still enabling me to provide a good ser...
Checking Drive Sizes with PowerShell
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 Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
SQL login object permissions via PowerShell
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...
Checking SQL Server User Role Membership with PowerShell
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...
dbatools
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Notifying a Teams Channel of a SQL Agent Job result
Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge
Sending a SQL Agent Job results overview to a Microsoft Teams Channel
Microsoft Teams is fantastic for collaboration. It enables groups of people, teams if you like to be able to communicate, collaborate on documents, hold meet...
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
How to fork a GitHub repository and contribute to an open source project
I enjoying maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
Create a PowerShell Notebook for Azure Data Studio with PowerShell
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell notebooks with PowerShell.
PowerShell Notebooks in Azure Data Studio
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
Getting SQL Server installation date with PowerShell using dbatools
Most of my writing time at the moment is devoted to Learn dbatools in a Month of Lunches which is now available but here is a short post following a questio...
MEAP MEAP – #dbatoolsMoL – Live Book edition
It’s been a busy time!
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
Azure SQL Linux VM – configuring SQL, installing pwsh and connecting and interacting with dbatools
In my posts about using Azure Devops to build Azure resources with Terraform, I built a Linux SQL VM. I used the Terraform in this GitHub repository and crea...
Generating a Workload against AdventureWorks with PowerShell
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
Whats a SQL Notebook in Azure Data Studio?
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...
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how he uses containers in Azure to...
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
Refreshing A SQL Mirrored Database Using Powershell
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and although the feature is deprecated it ...
Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
SQL Server
#tsql2sday #130 - Automate your stress away - Getting more SSIS Agent Job information
Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blo...
Getting SQL Server installation date with PowerShell using dbatools
Most of my writing time at the moment is devoted to Learn dbatools in a Month of Lunches which is now available but here is a short post following a questio...
Generating a Workload against AdventureWorks with PowerShell
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
Using PowerShell to get Azure Endpoint Ports
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...
Dropping All Tables From A SQL Database with PowerShell
This post could also have been titled confusion with foreach or For-EachObject
What Runs on the SQL Server when you run a PowerShell script?–Question from #SQLRelay
Last week I ran a PowerShell lab at SQL Relay in Cardiff. There are still a few places available for SQL Relay week 2. Take a look here for more details and ...
Finding Text In All Files In A Folder With PowerShell
Whilst writing my PowerShell Box of Tricks GUI I realised that I had hard-coded the path to the sqlservers.txt file in several functions and I wanted one pla...
The PowerShell Box Of Tricks GUI
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...
Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
Creating SQL User and adding to Server Role with PowerShell
Another post in the PowerShell Box of Tricks series.
Creating a Windows User and adding to a SQL Server Role with PowerShell
Another post in the PowerShell Box of Tricks series. In a previous post Checking SQL Server User Role Membership we showed how to check which roles users wer...
List Databases (and Properties) on SQL Server with PowerShell
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...
Dropping SQL Users with PowerShell
As you may have noticed, I love PowerShell!
Jupyter Notebooks
#tsql2sday #130 - Automate your stress away - Getting more SSIS Agent Job information
Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blo...
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
Running Jupyter Notebooks as Agent Jobs
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...
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing [my previous blog post!](https://blog.robsewell.com/net-p...
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the p...
Create a PowerShell Notebook for Azure Data Studio with PowerShell
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell notebooks with PowerShell.
Create Azure Data Studio SQL Notebooks with PowerShell
At PASS Summit today I gave a presentation about SQL Notebooks in Azure Data Studio for the DBA. I demo’d the PowerShell module ADSNotebook.
PowerShell Notebooks in Azure Data Studio
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
Whats a SQL Notebook in Azure Data Studio?
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...
Azure Data Studio
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
Running Jupyter Notebooks as Agent Jobs
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...
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing [my previous blog post!](https://blog.robsewell.com/net-p...
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the p...
Create a PowerShell Notebook for Azure Data Studio with PowerShell
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell notebooks with PowerShell.
Create Azure Data Studio SQL Notebooks with PowerShell
At PASS Summit today I gave a presentation about SQL Notebooks in Azure Data Studio for the DBA. I demo’d the PowerShell module ADSNotebook.
PowerShell Notebooks in Azure Data Studio
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
Adding a Folder of Scripts to GitHub with Azure Data Studio
In my last post I showed how to add a folder of scripts to GitHub using Visual Studio Code.
Whats a SQL Notebook in Azure Data Studio?
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...
sql
Making a Change Log Easier With PowerShell
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,...
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received t...
Generating T-SQL Randomly with Powershell
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. ...
Dropping All Tables From A SQL Database with PowerShell
This post could also have been titled confusion with foreach or For-EachObject
Creating SQL User and adding to Server Role with PowerShell
Another post in the PowerShell Box of Tricks series.
Showing and Killing SQL Server Processes with PowerShell
Another post in the PowerShell Box of Tricks series. There are much better ways of doing this I admit but as you can do it with PowerShell I created a functi...
Documenting SQL Server the easy way with Power Doc
You know how it is. Question questions questions. As a DBA you are the fount of all knowledge. You are the protector of the data after all so obviously you k...
azure
Azure SQL Linux VM – configuring SQL, installing pwsh and connecting and interacting with dbatools
In my posts about using Azure Devops to build Azure resources with Terraform, I built a Linux SQL VM. I used the Terraform in this GitHub repository and crea...
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
A look at the SQL Assessment Intelligence Pack in Operational Insights
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data ...
Using PowerShell to get Azure Endpoint Ports
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...
Starting My Azure SQL Server VMs with PowerShell
The last post about Launching Azure VMs with PowerShell made someone ask me to explain how I start my Azure VMs normally so here goes.
Launching Azure VM After Starting With PowerShell
So this morning I decided I was going to run through this blog post on understanding query plans http://sqlmag.com/t-sql/understanding-query-plans. I logged ...
adsnotebook
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
Running Jupyter Notebooks as Agent Jobs
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...
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
How to fork a GitHub repository and contribute to an open source project
I enjoying maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
Create a PowerShell Notebook for Azure Data Studio with PowerShell
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell notebooks with PowerShell.
Create Azure Data Studio SQL Notebooks with PowerShell
At PASS Summit today I gave a presentation about SQL Notebooks in Azure Data Studio for the DBA. I demo’d the PowerShell module ADSNotebook.
databases
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
List Databases (and Properties) on SQL Server with PowerShell
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...
Creating SQL Server Database with PowerShell
This morning I have been setting up my Azure Servers in preparation for my presentation to the Cardiff SQL User Group this month.
Using PowerShell to find a database amongst hundreds
As you know, I love PowerShell! I have developed a series of functions over time which save me time and effort whilst still enabling me to provide a good ser...
SQL Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
Those Pesky ‘s
Changing Domain Names in a Column
roles
Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
Creating SQL User and adding to Server Role with PowerShell
Another post in the PowerShell Box of Tricks series.
Creating a Windows User and adding to a SQL Server Role with PowerShell
Another post in the PowerShell Box of Tricks series. In a previous post Checking SQL Server User Role Membership we showed how to check which roles users wer...
Checking Drive Sizes with PowerShell
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
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...
Checking SQL Server User Role Membership with PowerShell
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...
dbachecks
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
How to fork a GitHub repository and contribute to an open source project
I enjoying maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
Whats a SQL Notebook in Azure Data Studio?
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...
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how he uses containers in Azure to...
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
pester
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how he uses containers in Azure to...
How to run a PowerShell script file with Verbose, Confirm or WhatIf
Before you run a PowerShell command that makes a change to something you should check that it is going to do what you expect. You can do this by using the Wh...
Pester 4.2.0 has a Because…… because :-)
I was going through my demo for the South Coast User Group meeting tonight and decided to add some details about the Because parameter available in the Peste...
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
documentation
Making a Change Log Easier With PowerShell
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,...
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh an Availability Group Database.
SQL Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
Documenting SQL Server the easy way with Power Doc
You know how it is. Question questions questions. As a DBA you are the fount of all knowledge. You are the protector of the data after all so obviously you k...
Those Pesky ‘s
Changing Domain Names in a Column
github
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
How to fork a GitHub repository and contribute to an open source project
I enjoying maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
Whats a SQL Notebook in Azure Data Studio?
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...
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how he uses containers in Azure to...
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in Hanover and this year it is on April 1...
script
Generating T-SQL Randomly with Powershell
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. ...
Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening I wrote a Powershell script to provide some alerts by em...
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
Those Pesky ‘s
Changing Domain Names in a Column
excel
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
Rationalisation of Database with Powershell and T-SQL part one
I have recently been involved in a project to rationalise databases. It is easy in a large organisation for database numbers to rapidly increase and sometime...
sp_BlitzIndex™ ouput to Excel with Powershell
I am impressed with the output from sp_BlitzIndex™ and today I tried to save it to an excel file so that I could pass it on to the developer of the service. ...
Powershell can read email & insert excel file attachment into a SQL Database
So at our SQL SouthWest User Group session last week we had sessions from Jonathan @fatherjack and Annette @Mrsfatherjack on SSRS and SSIS respectively. Dur...
permissions
Listing the SQL Server SysAdmins With PowerShell
A very short blog today just to pass on this little script.
Checking Drive Sizes with PowerShell
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
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...
Checking SQL Server User Role Membership with PowerShell
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...
backups
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh an Availability Group Database.
What Runs on the SQL Server when you run a PowerShell script?–Question from #SQLRelay
Last week I ran a PowerShell lab at SQL Relay in Cardiff. There are still a few places available for SQL Relay week 2. Take a look here for more details and ...
Show The Last Backups On A Server with PowerShell
Another day another PowerShell Box of Tricks post Auditors, managers and bosses often want proof of following processes successfully so when they come knocki...
Checking For A Database Backup with PowerShell
Todays PowerShell Box of Tricks Post is about backups I highly recommend you go and read bookmark and come straight back Stuart Moore’s series on Backups wit...
tsql2sday
#tsql2sday #130 - Automate your stress away - Getting more SSIS Agent Job information
Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blo...
Giving Back – #TSQL2sday
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...
PowerShell
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
Generating a Workload against AdventureWorks with PowerShell
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
snippet
Generating T-SQL Randomly with Powershell
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. ...
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
PowerShell Snippets A Great Learning Tool
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good tip
community
Surprised and Honoured and Proud
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
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...
docker
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
Persisting databases with named volumes on Windows with docker compose
With all things containers I refer to my good friend Andrew Pruski. Known as dbafromthecold on twitter he blogs at https://dbafromthecold.com
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how he uses containers in Azure to...
Notebooks
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the p...
PowerShell Notebooks in Azure Data Studio
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
Whats a SQL Notebook in Azure Data Studio?
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...
Terraform
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Azure SQL Linux VM – configuring SQL, installing pwsh and connecting and interacting with dbatools
In my posts about using Azure Devops to build Azure resources with Terraform, I built a Linux SQL VM. I used the Terraform in this GitHub repository and crea...
Building Azure SQL Db with Terraform with Visual Studio Code
I have been using Terraform for the last week or so to create some infrastructure and decided to bring that knowledge back to a problem that I and others suf...
Azure SQL Database
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Building Azure SQL Db with Terraform using Azure DevOps
In my last post I showed how to create a Resource Group and an Azure SQL Database with Terraform using Visual Studio Code to deploy.
Building Azure SQL Db with Terraform with Visual Studio Code
I have been using Terraform for the last week or so to create some infrastructure and decided to bring that knowledge back to a problem that I and others suf...
terraform
Using the same Azure DevOps build steps for Terraform with different Pipelines with Task Groups to build an Azure Linux SQL VM
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build the requi...
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
Building Azure SQL Db with Terraform using Azure DevOps
In my last post I showed how to create a Resource Group and an Azure SQL Database with Terraform using Visual Studio Code to deploy.
Azure DevOps
Using the same Azure DevOps build steps for Terraform with different Pipelines with Task Groups to build an Azure Linux SQL VM
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build the requi...
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
Building Azure SQL Db with Terraform using Azure DevOps
In my last post I showed how to create a Resource Group and an Azure SQL Database with Terraform using Visual Studio Code to deploy.
SQL Agent Jobs
Running Jupyter Notebooks as Agent Jobs
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...
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing [my previous blog post!](https://blog.robsewell.com/net-p...
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
Microsoft
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
Surprised and Honoured and Proud
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...
Secret Management
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
Import-CliXml
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
oracle
Those Pesky ‘s
Changing Domain Names in a Column
development
Giving Back – #TSQL2sday
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...
Those Pesky ‘s
Changing Domain Names in a Column
document
SQL Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
Those Pesky ‘s
Changing Domain Names in a Column
learning
Generating T-SQL Randomly with Powershell
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. ...
12 Things I learnt at SQLBits XI
The quality of the speakers and sessions is exceptional http://sqlbits.com/information/Agenda.aspx
presenting
Using PowerShell to Automate StreamLabs OBS and Show Your Webcam in PowerPoint
It started with a tweet
Lessons Learnt from my first talk at SQL SouthWest
The timing was good enough that I could offer to do a talk based on my previous post on Windows Azure for my SQL User Group SQL SouthWest when Jonathan and A...
endpoint
Using PowerShell to get Azure Endpoint Ports
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...
Alter SQL Mirroring Endpoint Owner with Powershell
Whilst using my Drop-SQLLogins function, which is one of my PowerShell Box Of Tricks series, it failed to delete logins on some servers with the error
mirroring
Refreshing A SQL Mirrored Database Using Powershell
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and although the feature is deprecated it ...
Alter SQL Mirroring Endpoint Owner with Powershell
Whilst using my Drop-SQLLogins function, which is one of my PowerShell Box Of Tricks series, it failed to delete logins on some servers with the error
giving back
Giving Back – #TSQL2sday
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...
rationalise
Rationalisation of Database with Powershell and T-SQL part two
In the previous post I showed the script to create an Excel Workbook, colour coded showing the last used date for all of the databases on servers in my sqlse...
Rationalisation of Database with Powershell and T-SQL part one
I have recently been involved in a project to rationalise databases. It is easy in a large organisation for database numbers to rapidly increase and sometime...
backup
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh an Availability Group Database.
Rationalisation of Database with Powershell and T-SQL part two
In the previous post I showed the script to create an Excel Workbook, colour coded showing the last used date for all of the databases on servers in my sqlse...
restore
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh an Availability Group Database.
Rationalisation of Database with Powershell and T-SQL part two
In the previous post I showed the script to create an Excel Workbook, colour coded showing the last used date for all of the databases on servers in my sqlse...
smo
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received t...
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
sqlfamily
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There s...
Giving Back – #TSQL2sday
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...
SQLBits
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
Giving Back – #TSQL2sday
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...
Agent Jobs
#tsql2sday #130 - Automate your stress away - Getting more SSIS Agent Job information
Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blo...
How to run a PowerShell script file with Verbose, Confirm or WhatIf
Before you run a PowerShell command that makes a change to something you should check that it is going to do what you expect. You can do this by using the Wh...
confirm
How to write a PowerShell function to use Confirm, Verbose and WhatIf
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the commands within the script have been written to use the co...
How to run a PowerShell script file with Verbose, Confirm or WhatIf
Before you run a PowerShell command that makes a change to something you should check that it is going to do what you expect. You can do this by using the Wh...
verbose
How to write a PowerShell function to use Confirm, Verbose and WhatIf
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the commands within the script have been written to use the co...
How to run a PowerShell script file with Verbose, Confirm or WhatIf
Before you run a PowerShell command that makes a change to something you should check that it is going to do what you expect. You can do this by using the Wh...
containers
Persisting databases with named volumes on Windows with docker compose
With all things containers I refer to my good friend Andrew Pruski. Known as dbafromthecold on twitter he blogs at https://dbafromthecold.com
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how he uses containers in Azure to...
Azure
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Building Azure SQL Db with Terraform with Visual Studio Code
I have been using Terraform for the last week or so to create some infrastructure and decided to bring that knowledge back to a problem that I and others suf...
Visual Studio Code
My current VS Code Extensions and using a workspace file
I have been asked a couple of times recently what my Visual Studio Code extensions are at the moment so I thought I would write a quick post and also look at...
Building Azure SQL Db with Terraform with Visual Studio Code
I have been using Terraform for the last week or so to create some infrastructure and decided to bring that knowledge back to a problem that I and others suf...
pwsh
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
Azure SQL Linux VM – configuring SQL, installing pwsh and connecting and interacting with dbatools
In my posts about using Azure Devops to build Azure resources with Terraform, I built a Linux SQL VM. I used the Terraform in this GitHub repository and crea...
dbatoolsmol
My current VS Code Extensions and using a workspace file
I have been asked a couple of times recently what my Visual Studio Code extensions are at the moment so I thought I would write a quick post and also look at...
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
dbatoolsMoL
Getting SQL Server installation date with PowerShell using dbatools
Most of my writing time at the moment is devoted to Learn dbatools in a Month of Lunches which is now available but here is a short post following a questio...
MEAP MEAP – #dbatoolsMoL – Live Book edition
It’s been a busy time!
net
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
dotnet interactive
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
dbastackexchange
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing [my previous blog post!](https://blog.robsewell.com/net-p...
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
Teams
Notifying a Teams Channel of a SQL Agent Job result
Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge
Sending a SQL Agent Job results overview to a Microsoft Teams Channel
Microsoft Teams is fantastic for collaboration. It enables groups of people, teams if you like to be able to communicate, collaborate on documents, hold meet...
SQL Agent
Notifying a Teams Channel of a SQL Agent Job result
Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge
Sending a SQL Agent Job results overview to a Microsoft Teams Channel
Microsoft Teams is fantastic for collaboration. It enables groups of people, teams if you like to be able to communicate, collaborate on documents, hold meet...
chat
Post: Chat
Abbott: Strange as it may seem, they give ball players nowadays very peculiar names.
Post Formats
Post: Chat
Abbott: Strange as it may seem, they give ball players nowadays very peculiar names.
The Start
Back to Top ↑blogging
Back to Top ↑sql dba
Back to Top ↑SQLBrit
Back to Top ↑domain
Those Pesky ‘s
Changing Domain Names in a Column
Those Pesky ‘s
Changing Domain Names in a Column
names
Those Pesky ‘s
Changing Domain Names in a Column
paperwork
Those Pesky ‘s
Changing Domain Names in a Column
scripts
Those Pesky ‘s
Changing Domain Names in a Column
server
Those Pesky ‘s
Changing Domain Names in a Column
spof
Those Pesky ‘s
Changing Domain Names in a Column
nottingham
12 Things I learnt at SQLBits XI
The quality of the speakers and sessions is exceptional http://sqlbits.com/information/Agenda.aspx
laerte
Powershell won’t save when running as a scheduled job
Or, How SQLBits put me in touch with Laerte and solved a problem
mvp
Powershell won’t save when running as a scheduled job
Or, How SQLBits put me in touch with Laerte and solved a problem
powerdoc
Documenting SQL Server the easy way with Power Doc
You know how it is. Question questions questions. As a DBA you are the fount of all knowledge. You are the protector of the data after all so obviously you k...
patching
Checking SQL Error Logs, Event Logs and Stopping Services with Powershell
It was patching time this week at MyWork so I thought I would share some Powershell scripts I use to speed up the process.
ping
Checking SQL Error Logs, Event Logs and Stopping Services with Powershell
It was patching time this week at MyWork so I thought I would share some Powershell scripts I use to speed up the process.
rdp
Checking SQL Error Logs, Event Logs and Stopping Services with Powershell
It was patching time this week at MyWork so I thought I would share some Powershell scripts I use to speed up the process.
outlook
Powershell can read email & insert excel file attachment into a SQL Database
So at our SQL SouthWest User Group session last week we had sessions from Jonathan @fatherjack and Annette @Mrsfatherjack on SSRS and SSIS respectively. Dur...
logins
Checking for SQL Server logins with PowerShell
As some of you may know, I love PowerShell!
migration
SQL Express Migration Auto Close Setting
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...
napalmgram
SQL Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
notifications
SQL Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
operators
SQL Server Operators and Notifications with Powershell – Strange Enumerate issue fixed by @napalmgram
Alerting of issues across the SQL Server estate is important and recently I needed to audit the operators and the notifications that they were receiving. I c...
error
Creating SQL Server Database with PowerShell
This morning I have been setting up my Azure Servers in preparation for my presentation to the Cardiff SQL User Group this month.
users
Dropping SQL Users with PowerShell
As you may have noticed, I love PowerShell!
properties
List Databases (and Properties) on SQL Server with PowerShell
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...
processes
Showing and Killing SQL Server Processes with PowerShell
Another post in the PowerShell Box of Tricks series. There are much better ways of doing this I admit but as you can do it with PowerShell I created a functi...
Event Log
Displaying the Windows Event Log with PowerShell
The latest post in the PowerShell Box of tricks series is here.
account
Creating SQL User and adding to Server Role with PowerShell
Another post in the PowerShell Box of Tricks series.
Users
Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
buttons
The PowerShell Box Of Tricks GUI
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...
gui
The PowerShell Box Of Tricks GUI
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...
files
Finding Text In All Files In A Folder With PowerShell
Whilst writing my PowerShell Box of Tricks GUI I realised that I had hard-coded the path to the sqlservers.txt file in several functions and I wanted one pla...
Windows Updates
Show Windows Updates Locally With PowerShell
I wanted to be able to quickly show the Windows Updates on a server. This came about during a discussion about auditing.
sqlbits
Back to Top ↑msdb
What Runs on the SQL Server when you run a PowerShell script?–Question from #SQLRelay
Last week I ran a PowerShell lab at SQL Relay in Cardiff. There are still a few places available for SQL Relay week 2. Take a look here for more details and ...
profiler
What Runs on the SQL Server when you run a PowerShell script?–Question from #SQLRelay
Last week I ran a PowerShell lab at SQL Relay in Cardiff. There are still a few places available for SQL Relay week 2. Take a look here for more details and ...
sqlrelay
What Runs on the SQL Server when you run a PowerShell script?–Question from #SQLRelay
Last week I ran a PowerShell lab at SQL Relay in Cardiff. There are still a few places available for SQL Relay week 2. Take a look here for more details and ...
for
Dropping All Tables From A SQL Database with PowerShell
This post could also have been titled confusion with foreach or For-EachObject
foreach
Dropping All Tables From A SQL Database with PowerShell
This post could also have been titled confusion with foreach or For-EachObject
SSMS
Using PowerShell to get Azure Endpoint Ports
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...
sponsors
Why You Should Visit the Sponsors at #SQLSatExeter and Other Community Events
SQL Saturdays and other community events rely on sponsors and you know that you will often get entered into a raffle for a prize in exchange for your contact...
database
Rationalisation of Database with Powershell and T-SQL part one
I have recently been involved in a project to rationalise databases. It is easy in a large organisation for database numbers to rapidly increase and sometime...
audit
Listing the SQL Server SysAdmins With PowerShell
A very short blog today just to pass on this little script.
Invoke-SqlCmd2
Enable CLR with Powershell
I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
Configuration
Enable CLR with Powershell
I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
Availability Group
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh an Availability Group Database.
refresh
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh an Availability Group Database.
html
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
report
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
indexes
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
file groups
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
snippets
PowerShell Snippets A Great Learning Tool
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good tip
SMO
PowerShell Snippets A Great Learning Tool
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good tip
data table
PowerShell Snippets A Great Learning Tool
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good tip
colour
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
VLF
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
autogrowth
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening I wrote a Powershell script to provide some alerts by em...
disk space
Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening I wrote a Powershell script to provide some alerts by em...
alerting
Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening I wrote a Powershell script to provide some alerts by em...
jonathan
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received t...
SQL Alerts
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received t...
SQL Assessment
A look at the SQL Assessment Intelligence Pack in Operational Insights
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data ...
Operational Insights
A look at the SQL Assessment Intelligence Pack in Operational Insights
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data ...
SCOM
A look at the SQL Assessment Intelligence Pack in Operational Insights
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data ...
Change Log
Making a Change Log Easier With PowerShell
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,...
User Groups
Giving Back – #TSQL2sday
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...
SQL Saturdays
Giving Back – #TSQL2sday
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...
Events
Giving Back – #TSQL2sday
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...
Exeter
Giving Back – #TSQL2sday
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...
Christmas
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There s...
Fun
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There s...
AST
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
Azure SQL Db
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in Hanover and this year it is on April 1...
Flow
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in Hanover and this year it is on April 1...
Cognitive Services
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in Hanover and this year it is on April 1...
Power Bi
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in Hanover and this year it is on April 1...
PSConfEU
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in Hanover and this year it is on April 1...
test
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how he uses containers in Azure to...
dataindevon
#DataInDevon – Getting up to speed with PowerShell or spend a day with one of four other MVPs :-)
Saturday 27th April is Global Azure Bootcamp day
Global Azure Bootcamp
#DataInDevon – Getting up to speed with PowerShell or spend a day with one of four other MVPs :-)
Saturday 27th April is Global Azure Bootcamp day
volumes
Persisting databases with named volumes on Windows with docker compose
With all things containers I refer to my good friend Andrew Pruski. Known as dbafromthecold on twitter he blogs at https://dbafromthecold.com
poshrsjob
Generating a Workload against AdventureWorks with PowerShell
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
Adventure Works
Generating a Workload against AdventureWorks with PowerShell
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
Automation
Generating a Workload against AdventureWorks with PowerShell
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
Testing
Generating a Workload against AdventureWorks with PowerShell
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
Github
Adding a Folder of Scripts to GitHub with Azure Data Studio
In my last post I showed how to add a folder of scripts to GitHub using Visual Studio Code.
Source Control
Adding a Folder of Scripts to GitHub with Azure Data Studio
In my last post I showed how to add a folder of scripts to GitHub using Visual Studio Code.
IaaC
Building Azure SQL Db with Terraform with Visual Studio Code
I have been using Terraform for the last week or so to create some infrastructure and decided to bring that knowledge back to a problem that I and others suf...
aks
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
kubernetes
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
pipeline
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
templates
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
AKS
Using Azure DevOps Build Pipeline Templates with Terraform to build an AKS cluster
In the last few posts I have moved from building an Azure SQL DB with Terraform using VS Code to automating the build process for the Azure SQL DB using Azur...
DevOps
Using the same Azure DevOps build steps for Terraform with different Pipelines with Task Groups to build an Azure Linux SQL VM
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build the requi...
Azure SQL VM
Using the same Azure DevOps build steps for Terraform with different Pipelines with Task Groups to build an Azure Linux SQL VM
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build the requi...
Linux
Using the same Azure DevOps build steps for Terraform with different Pipelines with Task Groups to build an Azure Linux SQL VM
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build the requi...
linux
Azure SQL Linux VM – configuring SQL, installing pwsh and connecting and interacting with dbatools
In my posts about using Azure Devops to build Azure resources with Terraform, I built a Linux SQL VM. I used the Terraform in this GitHub repository and crea...
markdown
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
SQL Notebooks
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
Glenn Berry
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
Diagnostic Notebooks
PowerShell in SQL Notebooks in Azure Data Studio
I have done a lot of writing in the last few months but you see no blog posts! My wonderful friend Chrissy and I are writing “dbatools in a Month of Lunches”...
writing
MEAP MEAP – #dbatoolsMoL – Live Book edition
It’s been a busy time!
BDFL
MEAP MEAP – #dbatoolsMoL – Live Book edition
It’s been a busy time!
MEAP
MEAP MEAP – #dbatoolsMoL – Live Book edition
It’s been a busy time!
Installation
Getting SQL Server installation date with PowerShell using dbatools
Most of my writing time at the moment is devoted to Learn dbatools in a Month of Lunches which is now available but here is a short post following a questio...
insiders
PowerShell Notebooks in Azure Data Studio
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
extensions
My current VS Code Extensions and using a workspace file
I have been asked a couple of times recently what my Visual Studio Code extensions are at the moment so I thought I would write a quick post and also look at...
workspace
My current VS Code Extensions and using a workspace file
I have been asked a couple of times recently what my Visual Studio Code extensions are at the moment so I thought I would write a quick post and also look at...
Incident Response
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the p...
Azure Dev Ops
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the p...
Open Source
How to fork a GitHub repository and contribute to an open source project
I enjoying maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
PowerShell Core
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
Stack Overflow
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing [my previous blog post!](https://blog.robsewell.com/net-p...
iisresetme
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing [my previous blog post!](https://blog.robsewell.com/net-p...
regex
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing [my previous blog post!](https://blog.robsewell.com/net-p...
MVP
Surprised and Honoured and Proud
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...
jaap
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
psconfeu
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
Jaap Brasser
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
Joel Bennett
Good Bye Import-CliXML – Use the Secrets Management module for your labs and demos
Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnoteboo...
ssms
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
VS Code
Using Secret Management module to run SSMS, VS Code and Azure Data Studio as another user
Following on from my last post about the Secret Management module. I was asked another question.
SPN
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Key Vault
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case.
Chrissy LeMaire
The first page with GitHub Pages
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
First Post
The first page with GitHub Pages
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
Migration
The first page with GitHub Pages
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
SSIS
#tsql2sday #130 - Automate your stress away - Getting more SSIS Agent Job information
Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blo...
StreamLabs
Using PowerShell to Automate StreamLabs OBS and Show Your Webcam in PowerPoint
It started with a tweet
SLOBS
Using PowerShell to Automate StreamLabs OBS and Show Your Webcam in PowerPoint
It started with a tweet
streaming
Using PowerShell to Automate StreamLabs OBS and Show Your Webcam in PowerPoint
It started with a tweet