Posts by Tag

1on1s (1) AppVeyor (1) Application Insights (2) Automation (1) Azure Monitor (1) Azure (16) Benchmark (3) Blog (8) C# (10) COVID-19 (1) Database Mail (1) DevOps (4) Digital Garden (1) Eleventy (3) Emotion (1) EventHubs (3) Excel (1) Firestore (3) Foam (1) Function Apps (7) Gatsby (2) GatsbyJS (7) Git (1) GitHub (1) JavaScript (10) Links (7) Log Analytics (5) Management (4) Markdown (4) Monzo (1) Netlify (1) Nextjs (1) OMS (4) Pester (9) PowerBI (3) PowerShell (19) Predictions (1) Presentation (1) Productivity (2) Pulumi (1) React (7) Recruiting (2) Remark (1) SQL (18) SQLChecks (4) SSRS (2) Security (1) Service Broker (2) Slack (3) Tailwind CSS (3) Temporal Tables (1) VSCode (2) Vercel (1) dotnet (4) tsqlScheduler (1)

1on1s

1. Tips for 1 on 1s during COVID-19 May 31, 2020

AppVeyor

1. Adding Pester tests to a PowerShell module and scheduling CI with AppVeyor June 25, 2018

Application Insights

1. Keeping Application Insights Costs Under Control May 31, 2019
2. Troubleshooting a slow application with Application Insights August 5, 2018

Automation

1. Should I Automate It? April 30, 2019

Azure Monitor

1. Understanding space usage in Azure Monitor logs March 31, 2019

Azure

1. Deploy an Azure AD protected App Service Website with Pulumi October 23, 2021
2. Run Pester 5 tests in Azure Pipelines and publish test results September 30, 2021
3. Keeping Application Insights Costs Under Control May 31, 2019
4. Understanding space usage in Azure Monitor logs March 31, 2019
5. Auto scale down all Event Hub namespaces with Azure Functions February 28, 2019
6. Overhead of Event Hub outputs with Azure Function Apps January 31, 2019
7. SQL Managed Backups and Operating System Error 87 November 16, 2018
8. Saving and reporting on Pester Infrastructure test results in Log Analytics September 23, 2018
9. Getting started with Log Analytics and PowerShell logging August 26, 2018
10. Troubleshooting a slow application with Application Insights August 5, 2018
11. Auto deflating Event Hubs with a function app December 10, 2017
12. Simplifying alert configuration in the OMS to Slack function app November 8, 2017
13. Building an OMS metric alert to Slack bridge with Azure functions August 29, 2017
14. Migrating function app scripts to a class library August 23, 2017
15. Analysing blob storage metrics with Power BI August 12, 2017
16. Building better OMS alerts with function apps August 6, 2017

Benchmark

1. Benchmarking .NET’s Dictionary.TryGetValue by key length and runtime February 28, 2022
2. Benchmarking different versions of NuGet packages July 16, 2021
3. Run benchmarks using multiple runtimes with BenchmarkDotNet June 8, 2021

Blog

1. Half a year to complete the migration to Eleventy. What will I do with the rest of it? April 22, 2023
2. The next time you see me I will be Eleventy October 13, 2022
3. Spell checking your Markdown blog posts with cspell February 28, 2021
4. Updating to Tailwind Typography to style markdown posts August 31, 2020
5. Link Roundups November 30, 2019
6. Adding cover images to your Gatsby blog October 20, 2019
7. Migrating from Jekyll to Gatsby September 30, 2019
8. Styling markdown posts with Tailwind CSS in GatsbyJS August 31, 2019

C#

1. Benchmarking different versions of NuGet packages July 16, 2021
2. Run benchmarks using multiple runtimes with BenchmarkDotNet June 8, 2021
3. Auto scale down all Event Hub namespaces with Azure Functions February 28, 2019
4. Overhead of Event Hub outputs with Azure Function Apps January 31, 2019
5. Visualising stored procedure call trees with SQLSpelunker December 23, 2017
6. Auto deflating Event Hubs with a function app December 10, 2017
7. Simplifying alert configuration in the OMS to Slack function app November 8, 2017
8. Building an OMS metric alert to Slack bridge with Azure functions August 29, 2017
9. Migrating function app scripts to a class library August 23, 2017
10. Building better OMS alerts with function apps August 6, 2017

COVID-19

1. Tips for 1 on 1s during COVID-19 May 31, 2020

Database Mail

1. Cleaning up database mail profiles and accounts April 24, 2018

DevOps

1. Run Pester 5 tests in Azure Pipelines and publish test results September 30, 2021
2. Saving and reporting on Pester Infrastructure test results in Log Analytics September 23, 2018
3. Getting started with Log Analytics and PowerShell logging August 26, 2018
4. Troubleshooting a slow application with Application Insights August 5, 2018

Digital Garden

1. Migrating my digital garden from WikiLens to Foam, and taking it private July 9, 2022

Eleventy

1. Half a year to complete the migration to Eleventy. What will I do with the rest of it? April 22, 2023
2. The next time you see me I will be Eleventy October 13, 2022
3. Processing images linked from frontmatter with eleventy-img to use in meta tags August 31, 2022

Emotion

1. Create React App, Emotion, and Tailwind CSS starter app June 30, 2019

EventHubs

1. Auto scale down all Event Hub namespaces with Azure Functions February 28, 2019
2. Overhead of Event Hub outputs with Azure Function Apps January 31, 2019
3. Auto deflating Event Hubs with a function app December 10, 2017

Excel

1. Should I Automate It? April 30, 2019

Firestore

1. Migrating from the official Firestore SDK to Firebase-Firestore-Lite January 31, 2021
2. Adding a new field to a Firestore collection December 31, 2019
3. Allowing only specified users to access Cloud Firestore July 31, 2019

Foam

1. Migrating my digital garden from WikiLens to Foam, and taking it private July 9, 2022

Function Apps

1. Auto scale down all Event Hub namespaces with Azure Functions February 28, 2019
2. Overhead of Event Hub outputs with Azure Function Apps January 31, 2019
3. Auto deflating Event Hubs with a function app December 10, 2017
4. Simplifying alert configuration in the OMS to Slack function app November 8, 2017
5. Building an OMS metric alert to Slack bridge with Azure functions August 29, 2017
6. Migrating function app scripts to a class library August 23, 2017
7. Building better OMS alerts with function apps August 6, 2017

Gatsby

1. Half a year to complete the migration to Eleventy. What will I do with the rest of it? April 22, 2023
2. The next time you see me I will be Eleventy October 13, 2022

GatsbyJS

1. Monitoring your GatsbyJS bundle size November 30, 2020
2. You don't have to use graphql to query your Gatsby site's metadata September 30, 2020
3. Updating to Tailwind Typography to style markdown posts August 31, 2020
4. Link Roundups November 30, 2019
5. Adding cover images to your Gatsby blog October 20, 2019
6. Migrating from Jekyll to Gatsby September 30, 2019
7. Styling markdown posts with Tailwind CSS in GatsbyJS August 31, 2019

Git

1. Using GistPad to manage your GitHub digital gardens July 31, 2020

GitHub

1. Using GistPad to manage your GitHub digital gardens July 31, 2020

JavaScript

1. Writing a simple Pocket app in Node.js with no dependencies March 31, 2022
2. Updating babel-eslint to @babel/eslint-parser for React apps March 31, 2021
3. Migrating from the official Firestore SDK to Firebase-Firestore-Lite January 31, 2021
4. Analyze your Create React App bundle size - without ejecting December 31, 2020
5. Monitoring your GatsbyJS bundle size November 30, 2020
6. You don't have to use graphql to query your Gatsby site's metadata September 30, 2020
7. Password protect a Next.js site hosted on Vercel June 30, 2020
8. Absolute imports with React April 25, 2020
9. Swapping implementations at compile time with craco and Create React App February 29, 2020
10. Allowing only specified users to access Cloud Firestore July 31, 2019

Links

1. Interesting Links - November 2021 November 30, 2021
2. Interesting Links - August 2021 August 31, 2021
3. Interesting Links - October 2020 October 31, 2020
4. Interesting Links - February 2020 February 7, 2020
5. More Interesting Links - December 2019 December 19, 2019
6. Interesting Links - December 2019 December 1, 2019
7. Interesting Links - November 2019 November 8, 2019

Log Analytics

1. Getting a list of all performance counters ingested to Log Analytics March 31, 2020
2. Understanding space usage in Azure Monitor logs March 31, 2019
3. Saving and reporting on Pester Infrastructure test results in Log Analytics September 23, 2018
4. Getting started with Log Analytics and PowerShell logging August 26, 2018
5. Monitoring disk, CPU, and memory with OMS August 21, 2017

Management

1. Don't mistake their kindness for empathy December 31, 2021
2. Tips for 1 on 1s during COVID-19 May 31, 2020
3. Should I Automate It? April 30, 2019
4. What makes an excellent database engineer? October 9, 2016

Markdown

1. Getting a summary of cspell errors with PowerShell April 30, 2021
2. Spell checking your Markdown blog posts with cspell February 28, 2021
3. Updating to Tailwind Typography to style markdown posts August 31, 2020
4. Styling markdown posts with Tailwind CSS in GatsbyJS August 31, 2019

Monzo

1. Better expenses with Monzo and PowerShell April 22, 2018

Netlify

1. Migrating from Jekyll to Gatsby September 30, 2019

Nextjs

1. Password protect a Next.js site hosted on Vercel June 30, 2020

OMS

1. Simplifying alert configuration in the OMS to Slack function app November 8, 2017
2. Building an OMS metric alert to Slack bridge with Azure functions August 29, 2017
3. Monitoring disk, CPU, and memory with OMS August 21, 2017
4. Building better OMS alerts with function apps August 6, 2017

Pester

1. Run Pester 5 tests in Azure Pipelines and publish test results September 30, 2021
2. Saving and reporting on Pester Infrastructure test results in Log Analytics September 23, 2018
3. Ensuring your Describe Tags are unique in Pester tests July 21, 2018
4. Adding Pester tests to a PowerShell module and scheduling CI with AppVeyor June 25, 2018
5. Improving database Pester tests - per-database checks April 8, 2018
6. SQLChecks v1 Released January 7, 2018
7. Using the SQLChecks library for SQL Server configuration management December 3, 2017
8. Using the SQL Infrastructure Tests repo in your environment July 9, 2017
9. Checking SQL Agent job ownership with Pester April 22, 2017

PowerBI

1. Getting funnel metrics right with Power BI when applying filters October 31, 2017
2. Creating recruitment funnel metrics in Power BI September 10, 2017
3. Analysing blob storage metrics with Power BI August 12, 2017

PowerShell

1. Run Pester 5 tests in Azure Pipelines and publish test results September 30, 2021
2. Getting a summary of cspell errors with PowerShell April 30, 2021
3. Getting a list of all performance counters ingested to Log Analytics March 31, 2020
4. Keeping Application Insights Costs Under Control May 31, 2019
5. Auto scale down all Event Hub namespaces with Azure Functions February 28, 2019
6. Overhead of Event Hub outputs with Azure Function Apps January 31, 2019
7. Adding caching to your PowerShell scripts December 31, 2018
8. Saving and reporting on Pester Infrastructure test results in Log Analytics September 23, 2018
9. Getting started with Log Analytics and PowerShell logging August 26, 2018
10. Ensuring your Describe Tags are unique in Pester tests July 21, 2018
11. Adding Pester tests to a PowerShell module and scheduling CI with AppVeyor June 25, 2018
12. Setting sp_configure values with SQLChecks May 31, 2018
13. Better expenses with Monzo and PowerShell April 22, 2018
14. Improving database Pester tests - per-database checks April 8, 2018
15. Changing the owner of an SSRS subscription with PowerShell January 24, 2018
16. SQLChecks v1 Released January 7, 2018
17. Using the SQLChecks library for SQL Server configuration management December 3, 2017
18. Using the SQL Infrastructure Tests repo in your environment July 9, 2017
19. Checking SQL Agent job ownership with Pester April 22, 2017

Predictions

1. Half a year to complete the migration to Eleventy. What will I do with the rest of it? April 22, 2023

Presentation

1. Remark Slides Starter January 26, 2020

Productivity

1. Early thoughts on switching to Apple silicon and macOS from Windows January 31, 2022
2. Keeping a work journal with VS Code February 28, 2018

Pulumi

1. Deploy an Azure AD protected App Service Website with Pulumi October 23, 2021

React

1. Updating babel-eslint to @babel/eslint-parser for React apps March 31, 2021
2. Analyze your Create React App bundle size - without ejecting December 31, 2020
3. You don't have to use graphql to query your Gatsby site's metadata September 30, 2020
4. Password protect a Next.js site hosted on Vercel June 30, 2020
5. Absolute imports with React April 25, 2020
6. Swapping implementations at compile time with craco and Create React App February 29, 2020
7. Create React App, Emotion, and Tailwind CSS starter app June 30, 2019

Recruiting

1. Getting funnel metrics right with Power BI when applying filters October 31, 2017
2. Creating recruitment funnel metrics in Power BI September 10, 2017

Remark

1. Remark Slides Starter January 26, 2020

SQL

1. SQL Managed Backups and Operating System Error 87 November 16, 2018
2. Resumable Online Index Rebuilds - SQL 2017's Silver Bullet November 3, 2018
3. Mitigating SERVICE_BROKER_WAITFOR_MANAGER latch waits October 15, 2018
4. Setting sp_configure values with SQLChecks May 31, 2018
5. Cleaning up database mail profiles and accounts April 24, 2018
6. Improving database Pester tests - per-database checks April 8, 2018
7. Pattern - SQL Server as a shared cache for expensive stored procedures March 21, 2018
8. Partitioned Clustered Columnstores - Mind your deltastores! March 10, 2018
9. Service Broker, Temporal Tables, and the 'Data modification failed' error February 17, 2018
10. Changing the owner of an SSRS subscription with PowerShell January 24, 2018
11. SQLChecks v1 Released January 7, 2018
12. Visualising stored procedure call trees with SQLSpelunker December 23, 2017
13. Using the SQLChecks library for SQL Server configuration management December 3, 2017
14. Troubleshooting an SSRS slowdown - portal delays, PREEMPTIVE_OS_LOOKUPACCOUNTSID, and bad plans October 21, 2017
15. Caching replica state to eliminate HADR_CLUSAPI_CALL waits on dm_hadr_availability_replica_states October 4, 2017
16. View currently executing tasks in tsqlScheduler September 3, 2017
17. Using the SQL Infrastructure Tests repo in your environment July 9, 2017
18. Checking SQL Agent job ownership with Pester April 22, 2017

SQLChecks

1. Setting sp_configure values with SQLChecks May 31, 2018
2. Improving database Pester tests - per-database checks April 8, 2018
3. SQLChecks v1 Released January 7, 2018
4. Using the SQLChecks library for SQL Server configuration management December 3, 2017

SSRS

1. Changing the owner of an SSRS subscription with PowerShell January 24, 2018
2. Troubleshooting an SSRS slowdown - portal delays, PREEMPTIVE_OS_LOOKUPACCOUNTSID, and bad plans October 21, 2017

Security

1. Allowing only specified users to access Cloud Firestore July 31, 2019

Service Broker

1. Mitigating SERVICE_BROKER_WAITFOR_MANAGER latch waits October 15, 2018
2. Service Broker, Temporal Tables, and the 'Data modification failed' error February 17, 2018

Slack

1. Simplifying alert configuration in the OMS to Slack function app November 8, 2017
2. Building an OMS metric alert to Slack bridge with Azure functions August 29, 2017
3. Building better OMS alerts with function apps August 6, 2017

Tailwind CSS

1. Updating to Tailwind Typography to style markdown posts August 31, 2020
2. Styling markdown posts with Tailwind CSS in GatsbyJS August 31, 2019
3. Create React App, Emotion, and Tailwind CSS starter app June 30, 2019

Temporal Tables

1. Service Broker, Temporal Tables, and the 'Data modification failed' error February 17, 2018

VSCode

1. Using GistPad to manage your GitHub digital gardens July 31, 2020
2. Keeping a work journal with VS Code February 28, 2018

Vercel

1. Password protect a Next.js site hosted on Vercel June 30, 2020

dotnet

1. Benchmarking .NET’s Dictionary.TryGetValue by key length and runtime February 28, 2022
2. Benchmarking different versions of NuGet packages July 16, 2021
3. Run benchmarks using multiple runtimes with BenchmarkDotNet June 8, 2021
4. Publishing a self-contained single-file .NET 5 executable May 29, 2021

tsqlScheduler

1. View currently executing tasks in tsqlScheduler September 3, 2017