SQLBits Agenda and PowerShell, displaying and searching
What is SQLBits? SQLBits is the largest data platform conference in Europe. It has been running every year since 2007 in a different city in the UK providin...
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, co-leader of Data South West UK user group and PSConfEU organiser. One of the Admins for Data Saturdays https://datasaturdays.com
He is a proud supporter of the Data and PowerShell communities.
He has a fabulous beard
Posts by Category
- Blog 219
- PowerShell 48
- dbatools 29
- SQL Server 23
- Community 21
- dbachecks 17
- Jupyter Notebooks 15
- Azure Data Studio 15
- azure 12
- IaC 8
- TSql2sDay 6
- Azure DevOps 5
- Bicep 5
- Power Bi 4
- Azure 3
- SQL Saturday Exeter 3
- Data Saturdays 3
- Speaking 3
- Tools 2
- Dev Containers 2
- GitHub 2
- NewStarNovember 2
- TSQL2sDAY 1
- Developing 1
- PSConfEU 1
- PowerShell Conference Europe 1
- community 1
- DevOps 1
- Visual Studio Code 1
- Source Control 1
- pwsh 1
- Pester 1
- SLOBS 1
- Azure Arc Enabled Data Services 1
- Kubernetes 1
- Presenting 1
- SQLBits 1
- Conference 1
Blog
#NewStarNovember - Being a mentor
Thank you to the ever wonderful Ben for the suggestion to blog. Check out #NewStarNovember for more blog posts. Who was your mentor? I have never had an of...
#NewStarNovember - Getting into Speaking - It was fatherjack and SQLBits
Thank you to the ever wonderful Ben for the suggestion to blog. Check out #NewStarNovember for more blog posts. In the beginning It was around May of 2013 ...
How to import dbatools from a zip file from the GitHub release into Azure Automation Modules without an error
There are a number of methods to import PowerShell modules into Azure automation as described in the documentation here
How Do You Show Keystrokes On Screen
It started with a tweet from Benni De Jagere Blog Twitter about how to show the keystrokes on the screen.
Kubernetes lab certificates expired
It won’t start!
GitHub Action Workflow Protected branch update failed
The last post showed how we created an easy process to update a web-page using a GitHub Issue and two GitHub Actions.
Creating A Training Day Speakers List with GitHub Action from a GitHub Issue
The last post showed the resource that we created to enable speakers to let events know that they have content for pre-cons/training days. This post will des...
Training Day Speakers List
How do data platform events find Training Day/Pre-Con speakers?
GitHub Pages in Dev Containers and Codespaces
Broken Link
Azure DevOps Pipeline Template Job Names and single quotes
The job name Deploy_Function_App appears more than once
What does JS_InvalidFilePath error mean in Azure DevOps?
Can't find loc string for key: JS_InvalidFilePath
Deploying a Bicep Module from a private repository without a connection to the repository
Using a private module repository
When you REALLY want to see your Azure DevOps Secret Variable Values
I REALLY needed to see the values
How to deploy an Azure Arc Enabled SQL Managed Instance in AKS
Want to play before GA ?
Flexing My Bicep - Deploy an Azure SQL Database -Intro to Azure Bicep IaC
Starting working out?
Viewing GitHub Pages Locally With a Remote Theme
A different method for my own site
TSQL2sDay - Do I use Notebooks?
Do I use Notebooks?
Viewing GitHub Pages Locally For Data Saturdays
Data Saturdays Has New Clothes!
Creating a New Data Saturdays event
Creating a New Data Saturdays Event
Microsoft Values The Community
What Happens Next?
Tooling for TSql2sDay
Tooling for TSQL2sDay
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...
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
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...
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...
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!
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions. .NET Notebooks are Jupyter Notebooks that...
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 enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them. To c...
Fixing the Failed to generate the compressed file for module dotnet.exe error when deploying to the PowerShell Gallery using Azure DevOps
Fixing the Failed to generate the compressed file for module C:\Program Files\dotnet\dotnet.exe error when deploying to the PowerShell Gallery using Azure De...
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...
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.
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...
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.
Generating a Workload against AdventureWorks with PowerShell
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
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
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...
#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...
Running Windows and Linux SQL Containers together
Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together. WARNING This is NOT a production ready solution, i...
Getting SQL Services, Starting, Stopping and Restarting them with dbatools
There was a question in the #dbatools slack channel Getting dbatools dbatools enables you to administer SQL Server with PowerShell. To get it simply ope...
SQL Server Availability Group FailoverDetection Utility PowerShell Function Improvements – Named Instances, Archiving Data, Speed
In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by the Tiger Team to analyse availability group...
Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell
30/11/2018 – Function has been updated to deal with named instances. Last week the Tiger Team released their Availability Group Failover Detection Utility w...
Getting the SQL Version from a backup using dbatools ………. on PowerShell Core
Following an upgrade to SQL Server the backup share had a number of backups, some from the old version and some from the newer version. I was asked if I had ...
PASS Summit, SQLTrain and My First US SQL Saturday
Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of those folk having a great time in great...
PASS Summit, SQLTrain and My First US SQL Saturday
Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of those folk having a great time in great...
Checking Trace Flags with dbachecks, online docs and PSPowerHour
It’s been a few weeks since i have blogged as I have been busy with a lot of other things. One of which is preparing for my SQL Pass Summit pre-con which has...
Deploying To a Power Bi Report Server with PowerShell
Just a quick post to share some code that I used to solve a problem I had recently. I needed to automate the deployment of some Power Bi reports to a Power ...
Using the PowerShell AST to find a ForEach Method
In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including the ‘type’ of check. This...
Hitting the Wall – #TSQL2sDay
Photo by Farrel Nobel on Unsplash Welcome to another edition of T-SQL Tuesday! This T-SQL Tuesday is hosted by Wayne Sheffield ( blog ...
A PowerShell Conference In A Book
A Question Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b t conta...
A PowerShell Pester Check for parsing SQL scripts
I like to write Pester checks to make sure that all is as expected! This is just a quick post as much to help me remember this script 🙂 This is a quick Pest...
dbachecks – Dark Mode Historical Validation PowerBi
in my last post I showed how you can save the results of dbachecks to a database and created a PowerBi report. Inspired by Frank Henninger in the #dbachecks ...
dbachecks – Save the results to a database for historical reporting
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got asked was will you write a command to put the results of the...
dbachecks – Improved Descriptions
With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are trusted thanks to Cláudio Sil...
dbachecks – Which Configuration Item For Which Check ?
I love showing dbachecks to people. It’s really cool seeing how people will use it and listening to their experiences. I was showing it to a production DBA a...
Creating SQL Server Containers for versions 2012-2017
I am working on my dbatools and dbachecks presentations for SQL Saturday Finland, SQLDays, SQL Saturday Cork and SQLGrillen I want to show the two modules ru...
Visual Studio Code Live Sharing Set-Up
There was an announcement on the Visual Studio Code blog about the public preview of Live Share. This enables you to easily collaborate on code by securely s...
#tsql2sday – Giving Back – Reprise
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us two options here (as well as the side optio...
Version Update, Code Signing and publishing to the PowerShell Gallery with VSTS
At the fabulous PowerShell Conference EU I presented about Continuous Delivery to the PowerShell Gallery with VSTS and explained how we use VSTS to enable CD...
Professional and Proficient PowerShell: From Writing Scripts to Developing Solutions at PASS Summit
PASS Summit is the largest conference for technical professionals who leverage the Microsoft Data Platform. PASS Summit 2018 is happening November 5th – 9th ...
Checking Availability Groups with dbachecks
It’s been 45 days since we released dbachecks Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQ pic.t...
Easily Splatting PowerShell with VS Code
So I always like to show splatting PowerShell commands when I am presenting sessions or workshops and realised that I had not really blogged about it. (This ...
dbachecks – Configuration Deep Dive
Today is the day that we have announced dbachecks a PowerShell module enabling you to validate your SQL Instances. You can read more about it here where you...
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances
For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks. This open source PowerShell module ...
VS Code – Terminal crashes when formatting script
I love VS Code. I love being able to press ALT + SHIFT + F and format my code. The Problem I could reproduce it will. This was very frustrating. Turni...
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...
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂 Chrissy has written about dbachecks the new up and coming community driven open source Powe...
Converting a Datarow to a JSON object with PowerShell
This is just a quick post. As is frequent with these they are as much for me to refer to in the future and also because the very act of writing it down will ...
Handling Missing Instances when Looping with Pester
In my previous posts about writing your first Pester Test and looping through instances I described how you can start to validate that your SQL Server is how...
2 Ways to Loop through collections in Pester
In my last post I showed you how to write your first Pester test to validate something. Here’s a recap Decide the information you wish to test Understa...
2 Ways to Loop through collections in Pester
In my last post I showed you how to write your first Pester test to validate something. Here’s a recap Decide the information you wish to test Understa...
TSQL2sDay – Get-PostRoundup
First an apology, this round up is late! The reason for that is an error in the PowerShell testing module Pester (That’s not completely true as you shall se...
PSDay.UK Tickets are on sale
Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we are pleased to announce that the PSDay.UK ti...
Using PowerShell to check if your password has been in a breach
We know that we need to keep our credentials secure. We know that we should not re-use our passwords across different services. Hopefully, by now, most reade...
Presentation Nerves
My previous post on interviews and a number of conversations this year inspired me to write this post. I am lucky enough to have been selected to speak at nu...
I Hate Interviews – TSQL2sDay
This month’s T-SQL Tuesday is hosted by Kendra Little and is on the topic of interviews I hate interviews as an interviewee. I have had many memorable ex...
Announcing PSDay.UK – Whats a PSDay?
On Thursday evening I attended the joint London WinOps and PowerShell User Group. It was an excellent evening with two great sessions by Jaap Brasser and Fil...
Writing Dynamic and Random Tests Cases for Pester
I have written a module SQLDiagAPI for consuming the SQL Server Diagnostics API with PowerShell. I blogged about how I used Pester to develop one of the func...
Using Get-SQLDiagFix to get information from the SQL Server Diagnostic API with PowerShell
The SQL Server Diagnostics Preview was announced just over a week ago It includes an add-on for SQL Server Management Studio to enable you to analyse SQL Ser...
Creating a PowerShell Module and TDD for Get-SQLDiagRecommendations
Yesterday I introduced the first command in the SQLDiagAPI module. A module to consume the SQL Diagnostics API. I have been asked a few times what the proce...
PowerShell Module for the SQL Server Diagnostics API – 1st Command Get-SQLDiagRecommendations
I saw this blog post about the SQL Server Diagnostics add-on to SSMS and API and thought I would write some PowerShell to work with it as all of the examples...
VSCode – PowerShell extension 1.4.0 new command Out-CurrentFile
Yesterday David Wilson announced version 1.4.0 of the PowerShell extension for VSCode Just released #PowerShell for VS @Code 1.4.0 with new code formatti...
dbatools at #SQLSatDublin
This weekend SQL Saturday Dublin occurred. For those that don’t know SQL Saturdays are free conferences with local and international speakers providing great...
VS Code – Automatic Dynamic PowerShell Help
VS Code is my coding tool of choice. I love that one lightweight editor can do so much and as PowerShell is usually the language that I write in I really lov...
Pester for Presentations – Ensuring it goes ok
Whilst I was at PSCONFEU I presented a session on writing pester tests instead of using checklists. You can see it here During the talk I showed the pester ...
Pester Test Inception and the Show Parameter
My fantastic friend Andre Kamman b t and I presented at PSConfEu last week .jpg](/assets/uploads/2017/05/c_edtk0xoaa1pl7-2.jp...
PowerShell Function – Validating a Parameter Depending On A Previous Parameter’s Value
I was chatting on the SQL Community Slack with my friend Sander Stad b t about some functions he is writing for the amazing PowerShell S...
PowerShell Function – Validating a Parameter Depending On A Previous Parameter’s Value
I was chatting on the SQL Community Slack with my friend Sander Stad b t about some functions he is writing for the amazing PowerShell S...
Setting the default file type for a new file in VS Code
Just a short post today. When you open a new file in VS Code (Using CTRL + N) it opens by default as a plain text file. To change the language for the file ...
Using Twitter with VS Code
So today I saw this tweet from Mathias in reply to Stefan and Amanda That looks cool. Twitter in VS Code, one less programme to open Here how it works Op...
Why VS Code Increases my Productivity
Last week I was showing a co-worker some PowerShell code and he asked what the editor was that I was using. Visual Studio Code I said. Why do you use that? W...
Why Volunteer at SQLBits ?
WARNING – Contains Orange and light-hearted photos 😉 I have returned home from SQLBits 2017 The Disco Edition. I am exhausted, my body is pointing out to me...
Export SQL User Permissions to T-SQL script using PowerShell and dbatools
NOTE - Updated November 2022 for this site and the correct command name. There are times when DBA’s are required to export database user permissions to a fi...
Testing SQL Server Access to a share with PowerShell using dbatools
A good security practice is to backup our SQL Servers to a network share but not allow users to be able to browse the share. How can we ensure that our SQL S...
Testing the Identity Column usage in SQL Server with PowerShell and dbatools
SQL Server uses identity columns to auto generate values, normally keys. When you create an identity column, it has a data type and that data type has a maxi...
Using Pester with Get-DbaLastGoodCheckDb from dbatools
In my last post I showed Get-DbaLastGoodCheckDb from dbatools. This module is a community based project written by excellent, brilliant people in their own ...
Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC CheckDB. This will be frequently schedule...
Test the SQL Server database collation with PowerShell and dbatools
If your server collation is different to your database collation then you may find that you get an error similar to this Cannot resolve the collation con...
Max Length of a column in a DataTable in PowerShell
Whilst I was writing my Test-DbaLastBackup Posts I ran into a common error I get when importing datatables into a database I was using this table and whe...
Getting SQL Server File Sizes and Space Used with dbatools
I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet and wondered how much I could do with the dbatools mo...
Test your Sqlserver backups on Linux with PowerShell and dbatools
I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts. With SQL Server vNext CTP 1.4 now available and pro...
Using Pester with dbatools Test-DbaLastBackup
In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the results. Today we will look at using Pester with ...
Taking dbatools Test-DbaLastBackup a little further
In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup Today I thought I would take it a little further and show you how P...
Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution
With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it on Ubuntu you need to upgrade your SQL Server to CTP 1.4....
Testing Your SQL Server Backups the Easy Way with PowerShell & dbatools
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from a directory using the dbatools module. Maybe it is a goo...
Restoring an entire SQL Server user databases with PowerShell using dbatools
All the good DBAs backup their databases. A significant amount of SQL DBAs use [Ola Hallengrens maintenance solution](https://ola.hallengren.com/) to do so....
Adding a PowerShell Job Step to an existing SQL Agent Job Step with PowerShell
In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The process is exactly the same for a PowerShell job step. As before I ga...
VS Code PowerShell Snippets
Just a quick post, as much as a reminder for me as anything, but also useful to those that attended my sessions last week where I talked about snippets in Po...
Quickly Creating Test Users in SQL Server with PowerShell using the sqlserver module and dbatools
One of the most visited posts on my blog is nearly two and half years old now – Add User to SQL Server Database Role with PowerShell and Quickly Creating Tes...
SQL VNext sp_configure on Windows and Linux with dbatools
This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I could test some scenarios and build an availability group. ...
Adding a T-SQL Job Step to a SQL Agent Job with PowerShell
In my last post, I explained how to alter an existing job step across many servers. I also had cause to add a T-SQL Job step to a large number of jobs as wel...
Altering a Job Step on Hundreds of SQL Servers with PowerShell
I flew to Utrecht last week to present with Chrissy LeMaire and Sander Stad for the joint Dutch SQL and PowerShell User Groups. Whilst I was sat at the airpo...
Using the PowerShell SQL Provider with SQL Authentication
Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL Authentication. I had no idea but sai...
A Whole Day of PowerShell and SQL – Join Chrissy LeMaire & I at #sqlsatvienna
SQL Saturday Vienna 2017 is only just around the corner. On Friday, January 20, 2017, a lot of local and international speakers will gather to deliver ses...
Running SQL Queries with Visual Studio Code
Reading this blog post by Shawn Melton Introduction of Visual Studio Code for DBAs reminded me that whilst I use Visual Studio Code (which I shall refer to a...
Deploying a Windows Data Science Virtual Machine to Azure with PowerShell easily
This weekend (10 December 2016), I went to Slovenia for a SQL Saturday. As always, it was an amazing event well organised by Mladen Prajdic, Dejan Sarka, and...
Enabling Cortana for dbareports PowerBi
Last week at the Birmingham user group I gave a presentation about PowerShell and SQL Server It was a very packed session as I crammed in the new sqlserve...
%5D(/assets/uploads/2016/10/powerbi6.png)
PowerBi and API – Visualising my Checkins
For my own amusement and also to show my wife where I have been I use the Swarm check-in app on my phone and check-in to places. Also for my own amusement I ...
PowerShell, Pester and Ola Hallengrens Maintenance Solution
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and click the link and look at the easiest way to ensure t...
The SQL Server Community Collaborative GitHub Organisation is born
My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called dbatools and dbareports If you ar...
Converting SQL Agent Job Duration to TimeSpan using PowerShell
When you look in msdb for the SQL Agent Job duration you will find that it is an int. This is also the same when you look at Get-SQLAgentJobHistory from t...
Making Start-Demo work with multi-line commands without a backtick
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the PowerShell Conference in Hanover I started ...
Remove-SQLDatabaseSafely My First Contribution to DBATools
What is DBA Tools? A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now grown into a collection of variou...
Using the new SQLServer Powershell module to get SQL Agent Job Information
So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here As I mentioned in my previous post the name ...
Some Pester Tests for SQL Defaults
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the slides and code here) I found out about Irwi...
%5D(/assets/uploads/2016/05/tweets.png)
DBA Database scripts are on Github
It started with a tweet from Dusty The second session I presented at the fantastic PowerShell Conference Europe was about using the DBA Database to automa...
Using PowerShell to set Extended Events Sessions to AutoStart
When you look after more than a few SQL Servers you will need to perform the same actions against a number of them and that is where PowerShell will be of g...
Backing up to URL container name – case is important
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name case is important So BACKUP LOG [DatabaseNa...
PowerShell Pester – The script failed due to call depth overflow.
This error caught me out. I am putting this post here firstly to remind me if I do it again and also to help others who may hit the same issue. I also have ...
Instances and Ports with PowerShell
Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them
Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm GMT 12pm EDT and also at the Cardiff SQL User...
Uploading a Source Folder to Azure File Storage
Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB. You can fid out further details here
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...
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,...
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 ...
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...
#tsql2sday #60 – Something New Learned – Problem Step Recorder
What is T-SQL Tuesday? T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam ...
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.
How I Check Hundreds of SQL Agent Jobs in 60 Seconds with Powershell
Editors Note This is still all valid but nowadays you would be much better off using dbatools to gather the information and the ImportExcel module to add it ...
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...
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...
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 ...
#TSQL2sDay Why My Head is Always in The Cloud
Todays post is my first for the TSQL2sDay series. For those not familiar this is rotating blog party that was started by Adam Machanic (@AdamMachanic blog)...
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...
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...
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...
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 I have a scheduled Powershell job which I use to create an Excel file colour coded for back...
12 Things I learnt at SQLBits XI
The quality of the speakers and sessions is exceptional http://sqlbits.com/information/Agenda.aspx The Helpers are awesome ...
Those Pesky ‘s
Changing Domain Names in a Column
Post: Chat
Abbott: Strange as it may seem, they give ball players nowadays very peculiar names.
PowerShell
SQLBits Agenda and PowerShell, displaying and searching
What is SQLBits? SQLBits is the largest data platform conference in Europe. It has been running every year since 2007 in a different city in the UK providin...
How to import dbatools from a zip file from the GitHub release into Azure Automation Modules without an error
There are a number of methods to import PowerShell modules into Azure automation as described in the documentation here
Creating A Training Day Speakers List with GitHub Action from a GitHub Issue
The last post showed the resource that we created to enable speakers to let events know that they have content for pre-cons/training days. This post will des...
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...
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...
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!
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...
Fixing the Failed to generate the compressed file for module dotnet.exe error when deploying to the PowerShell Gallery using Azure DevOps
Fixing the Failed to generate the compressed file for module C:\Program Files\dotnet\dotnet.exe error when deploying to the PowerShell Gallery using Azure De...
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...
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...
#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...
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂 Chrissy has written about dbachecks the new up and coming community driven open source Powe...
Power Bi, PowerShell and SQL Agent Jobs
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs - The SQL Agen...
Populating My DBA Database for Power Bi with PowerShell - Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database.
Populating My DBA Database for Power Bi with PowerShell - SQL Info
Following my post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database.
Use Twitter to get #PowerShell help
A quick post today just to add some weight to something that Mike Fal b t has kicked off. The #SQLHelp hashtag is well known and well us...
Populating My DBA Database for Power Bi with PowerShell - Server Info
Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my databas...
Setting Up and Using Azure VM SQL Automated Backup (and Restore)
This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots. I have always used my PowerShell scripts described h...
Installing and upgrading default scripts automation - part one - Introduction
First I must say thank you to all of the wonderful people who have put time and effort into providing free tools and scripts to enable not only myself but al...
Scheduling Ola Hallengrens Maintenance Solution Default Jobs with PowerShell
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance Solution.
Instances and Ports with PowerShell
Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to get information from the SQL Saturday web sit...
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to get some schedule information t...
Triggering a System Center Configuration Manager deployment task
A slightly different topic today.
Show AutoGrowth Events with PowerShell to CSV
This week I was reading Pinal Daves post about Autogrowth Events
Uploading a Source Folder to Azure File Storage
Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB. You can fid out further details here
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
dbatools
How to import dbatools from a zip file from the GitHub release into Azure Automation Modules without an error
There are a number of methods to import PowerShell modules into Azure automation as described in the documentation here
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 enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them. To c...
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.
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...
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...
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 🙂 Chrissy has written about dbachecks the new up and coming community driven open source Powe...
Testing the Identity Column usage in SQL Server with PowerShell and dbatools
SQL Server uses identity columns to auto generate values, normally keys. When you create an identity column, it has a data type and that data type has a maxi...
Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC CheckDB. This will be frequently schedule...
Max Length of a column in a DataTable in PowerShell
Whilst I was writing my Test-DbaLastBackup Posts I ran into a common error I get when importing datatables into a database I was using this table and whe...
Getting SQL Server File Sizes and Space Used with dbatools
I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet and wondered how much I could do with the dbatools mo...
Altering a Job Step on Hundreds of SQL Servers with PowerShell
I flew to Utrecht last week to present with Chrissy LeMaire and Sander Stad for the joint Dutch SQL and PowerShell User Groups. Whilst I was sat at the airpo...
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
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.
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...
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...
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!
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.
Power Bi, PowerShell and SQL Agent Jobs
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs - The SQL Agen...
Populating My DBA Database for Power Bi with PowerShell - Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database.
Populating My DBA Database for Power Bi with PowerShell - SQL Info
Following my post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database.
Populating My DBA Database for Power Bi with PowerShell - Server Info
Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my databas...
Using Power Bi with my DBA Database
Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
Setting Up and Using Azure VM SQL Automated Backup (and Restore)
This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots. I have always used my PowerShell scripts described h...
Installing and upgrading default scripts automation - part one - Introduction
First I must say thank you to all of the wonderful people who have put time and effort into providing free tools and scripts to enable not only myself but al...
Scheduling Ola Hallengrens Maintenance Solution Default Jobs with PowerShell
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance Solution.
Instances and Ports with PowerShell
Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them
Checking SQL Server User Role Membership with PowerShell
Please go and check the New SQL Bloggers posting here https://twitter.com/search?q=%23sqlnewblogger There are some brilliant new and older bloggers adding g...
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to get some schedule information t...
Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm GMT 12pm EDT and also at the Cardiff SQL User...
Show AutoGrowth Events with PowerShell to CSV
This week I was reading Pinal Daves post about Autogrowth Events
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
Community
SQLBits Agenda and PowerShell, displaying and searching
What is SQLBits? SQLBits is the largest data platform conference in Europe. It has been running every year since 2007 in a different city in the UK providin...
#NewStarNovember - Being a mentor
Thank you to the ever wonderful Ben for the suggestion to blog. Check out #NewStarNovember for more blog posts. Who was your mentor? I have never had an of...
#NewStarNovember - Getting into Speaking - It was fatherjack and SQLBits
Thank you to the ever wonderful Ben for the suggestion to blog. Check out #NewStarNovember for more blog posts. In the beginning It was around May of 2013 ...
How Do You Show Keystrokes On Screen
It started with a tweet from Benni De Jagere Blog Twitter about how to show the keystrokes on the screen.
GitHub Action Workflow Protected branch update failed
The last post showed how we created an easy process to update a web-page using a GitHub Issue and two GitHub Actions.
Creating A Training Day Speakers List with GitHub Action from a GitHub Issue
The last post showed the resource that we created to enable speakers to let events know that they have content for pre-cons/training days. This post will des...
Training Day Speakers List
How do data platform events find Training Day/Pre-Con speakers?
GitHub Pages in Dev Containers and Codespaces
Broken Link
Viewing GitHub Pages Locally With a Remote Theme
A different method for my own site
Viewing GitHub Pages Locally For Data Saturdays
Data Saturdays Has New Clothes!
Creating a New Data Saturdays event
Creating a New Data Saturdays Event
Microsoft Values The Community
What Happens Next?
Use Twitter to get #PowerShell help
A quick post today just to add some weight to something that Mike Fal b t has kicked off. The #SQLHelp hashtag is well known and well us...
Spinach and Database Development- SQLSatExeter Keynote
Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we were delighted to have a world exclusive keynote vid...
Checking SQL Server User Role Membership with PowerShell
Please go and check the New SQL Bloggers posting here https://twitter.com/search?q=%23sqlnewblogger There are some brilliant new and older bloggers adding g...
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to get information from the SQL Saturday web sit...
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to get some schedule information t...
Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm GMT 12pm EDT and also at the Cardiff SQL User...
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 enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them. To c...
Fixing the Failed to generate the compressed file for module dotnet.exe error when deploying to the PowerShell Gallery using Azure DevOps
Fixing the Failed to generate the compressed file for module C:\Program Files\dotnet\dotnet.exe error when deploying to the PowerShell Gallery using Azure De...
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...
Checking Trace Flags with dbachecks, online docs and PSPowerHour
It’s been a few weeks since i have blogged as I have been busy with a lot of other things. One of which is preparing for my SQL Pass Summit pre-con which has...
dbachecks – Dark Mode Historical Validation PowerBi
in my last post I showed how you can save the results of dbachecks to a database and created a PowerBi report. Inspired by Frank Henninger in the #dbachecks ...
dbachecks – Save the results to a database for historical reporting
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got asked was will you write a command to put the results of the...
dbachecks – Improved Descriptions
With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are trusted thanks to Cláudio Sil...
dbachecks – Which Configuration Item For Which Check ?
I love showing dbachecks to people. It’s really cool seeing how people will use it and listening to their experiences. I was showing it to a production DBA a...
Checking Availability Groups with dbachecks
It’s been 45 days since we released dbachecks Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQ pic.t...
dbachecks – Configuration Deep Dive
Today is the day that we have announced dbachecks a PowerShell module enabling you to validate your SQL Instances. You can read more about it here where you...
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances
For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks. This open source PowerShell module ...
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 🙂 Chrissy has written about dbachecks the new up and coming community driven open source Powe...
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!
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions. .NET Notebooks are Jupyter Notebooks that...
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 enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them. To c...
Fixing the Failed to generate the compressed file for module dotnet.exe error when deploying to the PowerShell Gallery using Azure DevOps
Fixing the Failed to generate the compressed file for module C:\Program Files\dotnet\dotnet.exe error when deploying to the PowerShell Gallery using Azure De...
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
#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!
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions. .NET Notebooks are Jupyter Notebooks that...
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 enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them. To c...
Fixing the Failed to generate the compressed file for module dotnet.exe error when deploying to the PowerShell Gallery using Azure DevOps
Fixing the Failed to generate the compressed file for module C:\Program Files\dotnet\dotnet.exe error when deploying to the PowerShell Gallery using Azure De...
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
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.
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...
Deploying a Windows Data Science Virtual Machine to Azure with PowerShell easily
This weekend (10 December 2016), I went to Slovenia for a SQL Saturday. As always, it was an amazing event well organised by Mladen Prajdic, Dejan Sarka, and...
Backing up to URL container name – case is important
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name case is important So BACKUP LOG [DatabaseNa...
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 ...
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...
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...
IaC
Azure DevOps Pipeline Template Job Names and single quotes
The job name Deploy_Function_App appears more than once
What does JS_InvalidFilePath error mean in Azure DevOps?
Can't find loc string for key: JS_InvalidFilePath
Deploying a Bicep Module from a private repository without a connection to the repository
Using a private module repository
When you REALLY want to see your Azure DevOps Secret Variable Values
I REALLY needed to see the values
How to deploy an Azure Arc Enabled SQL Managed Instance in AKS
Want to play before GA ?
Flexing My Bicep - Deploy an Azure SQL Database -Intro to Azure Bicep IaC
Starting working out?
TSql2sDay
TSQL2sDay - Do I use Notebooks?
Do I use Notebooks?
Tooling for TSql2sDay
Tooling for 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...
#tsql2sday #60 – Something New Learned – Problem Step Recorder
What is T-SQL Tuesday? T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam ...
Azure DevOps
Azure DevOps Pipeline Template Job Names and single quotes
The job name Deploy_Function_App appears more than once
What does JS_InvalidFilePath error mean in Azure DevOps?
Can't find loc string for key: JS_InvalidFilePath
When you REALLY want to see your Azure DevOps Secret Variable Values
I REALLY needed to see the values
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.
Bicep
Deploying a Bicep Module from a private repository without a connection to the repository
Using a private module repository
How to deploy an Azure Arc Enabled SQL Managed Instance in AKS
Want to play before GA ?
Flexing My Bicep - Deploy an Azure SQL Database -Intro to Azure Bicep IaC
Starting working out?
Power Bi
Power Bi, PowerShell and SQL Agent Jobs
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs - The SQL Agen...
Populating My DBA Database for Power Bi with PowerShell - Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database.
Populating My DBA Database for Power Bi with PowerShell - SQL Info
Following my post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database.
Populating My DBA Database for Power Bi with PowerShell - Server Info
Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my databas...
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...
Setting Up and Using Azure VM SQL Automated Backup (and Restore)
This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots. I have always used my PowerShell scripts described h...
Uploading a Source Folder to Azure File Storage
Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB. You can fid out further details here
SQL Saturday Exeter
Spinach and Database Development- SQLSatExeter Keynote
Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we were delighted to have a world exclusive keynote vid...
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to get information from the SQL Saturday web sit...
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to get some schedule information t...
Data Saturdays
Viewing GitHub Pages Locally With a Remote Theme
A different method for my own site
Viewing GitHub Pages Locally For Data Saturdays
Data Saturdays Has New Clothes!
Creating a New Data Saturdays event
Creating a New Data Saturdays Event
Speaking
SQLBits Agenda and PowerShell, displaying and searching
What is SQLBits? SQLBits is the largest data platform conference in Europe. It has been running every year since 2007 in a different city in the UK providin...
#NewStarNovember - Being a mentor
Thank you to the ever wonderful Ben for the suggestion to blog. Check out #NewStarNovember for more blog posts. Who was your mentor? I have never had an of...
#NewStarNovember - Getting into Speaking - It was fatherjack and SQLBits
Thank you to the ever wonderful Ben for the suggestion to blog. Check out #NewStarNovember for more blog posts. In the beginning It was around May of 2013 ...
Tools
TSQL2sDay - Do I use Notebooks?
Do I use Notebooks?
Tooling for TSql2sDay
Tooling for TSQL2sDay
Dev Containers
Creating A Training Day Speakers List with GitHub Action from a GitHub Issue
The last post showed the resource that we created to enable speakers to let events know that they have content for pre-cons/training days. This post will des...
GitHub Pages in Dev Containers and Codespaces
Broken Link
GitHub
GitHub Action Workflow Protected branch update failed
The last post showed how we created an easy process to update a web-page using a GitHub Issue and two GitHub Actions.
Creating A Training Day Speakers List with GitHub Action from a GitHub Issue
The last post showed the resource that we created to enable speakers to let events know that they have content for pre-cons/training days. This post will des...
NewStarNovember
#NewStarNovember - Being a mentor
Thank you to the ever wonderful Ben for the suggestion to blog. Check out #NewStarNovember for more blog posts. Who was your mentor? I have never had an of...
#NewStarNovember - Getting into Speaking - It was fatherjack and SQLBits
Thank you to the ever wonderful Ben for the suggestion to blog. Check out #NewStarNovember for more blog posts. In the beginning It was around May of 2013 ...
TSQL2sDAY
Back to Top ↑Developing
Running SQL Queries with Visual Studio Code
Reading this blog post by Shawn Melton Introduction of Visual Studio Code for DBAs reminded me that whilst I use Visual Studio Code (which I shall refer to a...
PSConfEU
Pester for Presentations – Ensuring it goes ok
Whilst I was at PSCONFEU I presented a session on writing pester tests instead of using checklists. You can see it here During the talk I showed the pester ...
PowerShell Conference Europe
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...
community
#tsql2sday – Giving Back – Reprise
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us two options here (as well as the side optio...
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...
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...
Source Control
How to fork a GitHub repository and contribute to an open source project
I enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them. To c...
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...
Pester
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions. .NET Notebooks are Jupyter Notebooks that...
SLOBS
Using PowerShell to Automate StreamLabs OBS and Show Your Webcam in PowerPoint
It started with a tweet
Azure Arc Enabled Data Services
How to deploy an Azure Arc Enabled SQL Managed Instance in AKS
Want to play before GA ?
Kubernetes
Kubernetes lab certificates expired
It won’t start!
Presenting
How Do You Show Keystrokes On Screen
It started with a tweet from Benni De Jagere Blog Twitter about how to show the keystrokes on the screen.
SQLBits
SQLBits Agenda and PowerShell, displaying and searching
What is SQLBits? SQLBits is the largest data platform conference in Europe. It has been running every year since 2007 in a different city in the UK providin...
Conference
SQLBits Agenda and PowerShell, displaying and searching
What is SQLBits? SQLBits is the largest data platform conference in Europe. It has been running every year since 2007 in a different city in the UK providin...