Hey! I'm Bonza

I am a C# & Microsoft SQL Server developer based in the U.K currently working within the public sector, I started this blog to share my experiences and things I pick up on my journey as a developer.

I have some projects on GitHub I work on in my spare time.

Photography

Latest Projects

SQL Server Setup

A script to help setup new instances of SQL Server


VeganOwl.me

A repository of everything Vegan, maintained by me


Availability Agent

The Availability Agent stored procedure gives a method of enabling and disabling SQL Server Agent Job depending on the role of the node executing the procedure in an availability group.


Frequent Agent

Frequent Agent is a SQL Server Stored Procedure that will check for frequently running SQL Agent Jobs move their Agent History from MSDB to the JobHistory_Archive table which is created inside the DBA_Tasks database and then purge the data from the MSDB database.