AppVeyor (1) Application Insights (2) Automation (1) Azure (14) Azure Monitor (1) Blog (1) C# (3) Database Mail (1) DevOps (3) Emotion (1) EventHubs (3) Excel (1) Firestore (1) Function Apps (7) GatsbyJS (1) JavaScript (1) Log Analytics (4) Management (2) Monzo (1) OMS (4) Pester (7) PowerBI (3) PowerShell (16) Productivity (1) React (1) Recruiting (2) SQL (18) SQLChecks (4) SSRS (2) Security (1) Service Broker (1) Slack (3) Tailwind (1) Tailwind CSS (1) Temporal Tables (1) VSCode (1) tsqlScheduler (1)

 AppVeyor (1)

Adding Pester tests to a PowerShell module and scheduling CI with AppVeyor

 Application Insights (2)

Keeping Application Insights Costs Under Control
Troubleshooting a slow application with Application Insights

 Automation (1)

Should I Automate It?

 Azure (14)

Keeping Application Insights Costs Under Control
Understanding space usage in Azure Monitor logs
Auto scale down all Event Hub namespaces with Azure Functions
Overhead of Event Hub outputs with Azure Function Apps
SQL Managed Backups and Operating System Error 87
Saving and reporting on Pester Infrastructure test results in Log Analytics
Getting started with Log Analytics and PowerShell logging
Troubleshooting a slow application with Application Insights
Auto deflating Event Hubs with a function app
Simplifying alert configuration in the OMS to Slack function app
Building an OMS metric alert to Slack bridge with Azure functions
Migrating function app scripts to a class library
Analysing blob storage metrics with Power BI
Building better OMS alerts with function apps

 Azure Monitor (1)

Understanding space usage in Azure Monitor logs

 Blog (1)

Styling markdown posts with Tailwind CSS in GatsbyJS

 C# (3)

Auto scale down all Event Hub namespaces with Azure Functions
Visualising stored procedure call trees with SQLSpelunker
Auto deflating Event Hubs with a function app

 Database Mail (1)

Cleaning up database mail profiles and accounts

 DevOps (3)

Saving and reporting on Pester Infrastructure test results in Log Analytics
Getting started with Log Analytics and PowerShell logging
Troubleshooting a slow application with Application Insights

 Emotion (1)

Create React App, Emotion, and Tailwind CSS starter app

 EventHubs (3)

Auto scale down all Event Hub namespaces with Azure Functions
Overhead of Event Hub outputs with Azure Function Apps
Auto deflating Event Hubs with a function app

 Excel (1)

Should I Automate It?

 Firestore (1)

Allowing only specified users to access Cloud Firestore

 Function Apps (7)

Auto scale down all Event Hub namespaces with Azure Functions
Overhead of Event Hub outputs with Azure Function Apps
Auto deflating Event Hubs with a function app
Simplifying alert configuration in the OMS to Slack function app
Building an OMS metric alert to Slack bridge with Azure functions
Migrating function app scripts to a class library
Building better OMS alerts with function apps

 GatsbyJS (1)

Styling markdown posts with Tailwind CSS in GatsbyJS

 JavaScript (1)

Allowing only specified users to access Cloud Firestore

 Log Analytics (4)

Understanding space usage in Azure Monitor logs
Saving and reporting on Pester Infrastructure test results in Log Analytics
Getting started with Log Analytics and PowerShell logging
Monitoring disk, CPU, and memory with OMS

 Management (2)

Should I Automate It?
What makes an excellent database engineer?

 Monzo (1)

Better expenses with Monzo and PowerShell

 OMS (4)

Simplifying alert configuration in the OMS to Slack function app
Building an OMS metric alert to Slack bridge with Azure functions
Monitoring disk, CPU, and memory with OMS
Building better OMS alerts with function apps

 Pester (7)

Ensuring your Describe Tags are unique in Pester tests
Adding Pester tests to a PowerShell module and scheduling CI with AppVeyor
Improving database Pester tests - per-database checks
SQLChecks v1 Released
Using the SQLChecks library for SQL Server configuration management
Using the SQL Infrastructure Tests repo in your environment
Checking SQL Agent job ownership with Pester

 PowerBI (3)

Getting funnel metrics right with Power BI when applying filters
Creating recruitment funnel metrics in Power BI
Analysing blob storage metrics with Power BI

 PowerShell (16)

Keeping Application Insights Costs Under Control
Auto scale down all Event Hub namespaces with Azure Functions
Overhead of Event Hub outputs with Azure Function Apps
Adding caching to your PowerShell scripts
Saving and reporting on Pester Infrastructure test results in Log Analytics
Getting started with Log Analytics and PowerShell logging
Ensuring your Describe Tags are unique in Pester tests
Adding Pester tests to a PowerShell module and scheduling CI with AppVeyor
Setting sp_configure values with SQLChecks
Better expenses with Monzo and PowerShell
Improving database Pester tests - per-database checks
Changing the owner of an SSRS subscription with PowerShell
SQLChecks v1 Released
Using the SQLChecks library for SQL Server configuration management
Using the SQL Infrastructure Tests repo in your environment
Checking SQL Agent job ownership with Pester

 Productivity (1)

Keeping a work journal with VS Code

 React (1)

Create React App, Emotion, and Tailwind CSS starter app

 Recruiting (2)

Getting funnel metrics right with Power BI when applying filters
Creating recruitment funnel metrics in Power BI

 SQL (18)

Resumable Online Index Rebuilds - SQL 2017's Silver Bullet
SQL Managed Backups and Operating System Error 87
Mitigating SERVICE_BROKER_WAITFOR_MANAGER latch waits
Setting sp_configure values with SQLChecks
Cleaning up database mail profiles and accounts
Improving database Pester tests - per-database checks
Pattern - SQL Server as a shared cache for expensive stored procedures
Partitioned Clustered Columnstores - Mind your deltastores!
Service Broker, Temporal Tables, and the 'Data modification failed' error
Changing the owner of an SSRS subscription with PowerShell
SQLChecks v1 Released
Visualising stored procedure call trees with SQLSpelunker
Using the SQLChecks library for SQL Server configuration management
Troubleshooting an SSRS slowdown - portal delays, PREEMPTIVE_OS_LOOKUPACCOUNTSID, and bad plans
Caching replica state to eliminate HADR_CLUSAPI_CALL waits on dm_hadr_availability_replica_states
View currently executing tasks in tsqlScheduler
Using the SQL Infrastructure Tests repo in your environment
Checking SQL Agent job ownership with Pester

 SQLChecks (4)

Setting sp_configure values with SQLChecks
Improving database Pester tests - per-database checks
SQLChecks v1 Released
Using the SQLChecks library for SQL Server configuration management

 SSRS (2)

Changing the owner of an SSRS subscription with PowerShell
Troubleshooting an SSRS slowdown - portal delays, PREEMPTIVE_OS_LOOKUPACCOUNTSID, and bad plans

 Security (1)

Allowing only specified users to access Cloud Firestore

 Service Broker (1)

Service Broker, Temporal Tables, and the 'Data modification failed' error

 Slack (3)

Simplifying alert configuration in the OMS to Slack function app
Building an OMS metric alert to Slack bridge with Azure functions
Building better OMS alerts with function apps

 Tailwind (1)

Styling markdown posts with Tailwind CSS in GatsbyJS

 Tailwind CSS (1)

Create React App, Emotion, and Tailwind CSS starter app

 Temporal Tables (1)

Service Broker, Temporal Tables, and the 'Data modification failed' error

 VSCode (1)

Keeping a work journal with VS Code

 tsqlScheduler (1)

View currently executing tasks in tsqlScheduler