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
There are a number of methods to import PowerShell modules into Azure automation as described in the documentation here
It started with a tweet from Benni De Jagere Blog Twitter about how to show the keystrokes on the screen.
It won’t start!
The last post showed how we created an easy process to update a web-page using a GitHub Issue and two GitHub Actions.
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...
How do data platform events find Training Day/Pre-Con speakers?
Broken Link
The job name Deploy_Function_App appears more than once
Can't find loc string for key: JS_InvalidFilePath
Using a private module repository
I REALLY needed to see the values
Want to play before GA ?
Starting working out?
A different method for my own site
Do I use Notebooks?
Data Saturdays Has New Clothes!
Creating a New Data Saturdays Event
What Happens Next?
Tooling for TSQL2sDay
It started with a tweet
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...
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
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.
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
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...
Following on from my last post about the Secret Management module. I was asked another question.
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...
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...
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...
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing my previous blog post!
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
I enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
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...
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...
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell 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.
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...
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
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...
It’s been a busy time!
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”...
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...
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...
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...
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.
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...
In my last post I showed how to add a folder of scripts to GitHub using Visual Studio Code.
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
With all things containers I refer to my good friend Andrew Pruski. Known as dbafromthecold on twitter he blogs at https://dbafromthecold.com
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...
Saturday 27th April is Global Azure Bootcamp day
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...
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...
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...
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...
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...
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
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...
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
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...
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 & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There s...
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...
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,...
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 ...
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...
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. ...
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...
So you have read up on VLFs
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good tip
A short post today to pass on a script I wrote to fulfil a requirement I had.
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 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 ...
I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
A very short blog today just to pass on this little script.
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 ...
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...
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...
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...
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...
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...
This post could also have been titled confusion with foreach or For-EachObject
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.
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 ...
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 ...
Yesterdays Post Show-WindowsUpdatesLocal does enable you to search for an installed update as follows
I wanted to be able to quickly show the Windows Updates on a server. This came about during a discussion about auditing.
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...
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...
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
Another post in the PowerShell Box of Tricks series.
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...
The latest post in the PowerShell Box of tricks series is here.
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...
Another day another PowerShell Box of Tricks post Auditors, managers and bosses often want proof of following processes successfully so when they come knocki...
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...
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...
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...
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...
As you may have noticed, I love PowerShell!
This morning I have been setting up my Azure Servers in preparation for my presentation to the Cardiff SQL User Group this month.
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
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...
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....
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...
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...
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...
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...
As some of you may know, I love 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. ...
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...
It was patching time this week at MyWork so I thought I would share some Powershell scripts I use to speed up the process.
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...
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...
Or, How SQLBits put me in touch with Laerte and solved a problem
The quality of the speakers and sessions is exceptional http://sqlbits.com/information/Agenda.aspx
Changing Domain Names in a Column
Abbott: Strange as it may seem, they give ball players nowadays very peculiar names.
There are a number of methods to import PowerShell modules into Azure automation as described in the documentation here
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...
It started with a tweet
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...
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...
Following on from my last post about the Secret Management module. I was asked another question.
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...
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...
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing my previous blog post!
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 C:\Program Files\dotnet\dotnet.exe error when deploying to the PowerShell Gallery using Azure De...
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...
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell 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.
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...
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
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...
It’s been a busy time!
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”...
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...
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
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...
Saturday 27th April is Global Azure Bootcamp day
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...
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...
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...
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...
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...
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
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...
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.
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.
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...
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...
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...
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...
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance Solution.
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
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...
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...
A slightly different topic today.
This week I was reading Pinal Daves post about Autogrowth Events
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 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 ...
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
There are a number of methods to import PowerShell modules into Azure automation as described in the documentation here
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.
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
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...
Following on from my last post about the Secret Management module. I was asked another question.
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...
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
I enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell notebooks with PowerShell.
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...
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
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...
It’s been a busy time!
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”...
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...
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
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...
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...
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...
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...
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
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 ...
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
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.
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...
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...
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...
It’s been a busy time!
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...
For a later blog post I have been trying to generate some workload against an AdventureWorks database.
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...
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.
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.
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...
Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
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...
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...
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance Solution.
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
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...
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...
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...
This week I was reading Pinal Daves post about Autogrowth Events
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 ...
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
It started with a tweet from Benni De Jagere Blog Twitter about how to show the keystrokes on the screen.
The last post showed how we created an easy process to update a web-page using a GitHub Issue and two GitHub Actions.
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...
How do data platform events find Training Day/Pre-Con speakers?
Broken Link
A different method for my own site
Data Saturdays Has New Clothes!
Creating a New Data Saturdays Event
What Happens Next?
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...
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...
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...
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...
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...
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...
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...
Following on from my last post about the Secret Management module. I was asked another question.
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...
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...
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing my previous blog post!
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
I enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
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...
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...
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell 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.
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
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 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...
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...
Following on from my last post about the Secret Management module. I was asked another question.
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...
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...
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing my previous blog post!
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
I enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
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...
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...
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell 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.
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks!
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 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...
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...
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...
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.
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...
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 ...
A quick blog today. I was reading this blog post about How to read the SQL Error Log and I thought I would try some of the examples. I started my Azure VM us...
The last post about Launching Azure VMs with PowerShell made someone ask me to explain how I start my Azure VMs normally so here goes.
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 ...
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...
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...
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
I enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
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...
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 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...
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...
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...
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...
TagLine – My goal – Chrissy will appreciate Unit Tests one day 🙂
The job name Deploy_Function_App appears more than once
Can't find loc string for key: JS_InvalidFilePath
Using a private module repository
I REALLY needed to see the values
Want to play before GA ?
Starting working out?
Do I use Notebooks?
Tooling for TSQL2sDay
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...
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...
The job name Deploy_Function_App appears more than once
Can't find loc string for key: JS_InvalidFilePath
I REALLY needed to see the values
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.
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.
Using a private module repository
Want to play before GA ?
Starting working out?
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...
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.
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.
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...
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...
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...
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
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...
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...
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...
A different method for my own site
Data Saturdays Has New Clothes!
Creating a New Data Saturdays Event
Do I use Notebooks?
Tooling for TSQL2sDay
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...
Broken Link
The last post showed how we created an easy process to update a web-page using a GitHub Issue and two GitHub Actions.
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...
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...
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...
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...
I enjoy maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL ker...
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions.
It started with a tweet
Want to play before GA ?
It won’t start!
It started with a tweet from Benni De Jagere Blog Twitter about how to show the keystrokes on the screen.