top of page


Automatic SQL Patch Metadata - Scrape it off my shoe.
Patching, we all know how important it is, for those of us with a presence on prem that is, or even SQL on Azure VM, without the correct...
Feb 276 min read


Statistics IO. IO... IO... it's off to parse we go.
Again, this is another one of those little bits of functionality that has been present since year dot. Unfortunately, it seems to be...
Jul 15, 20246 min read


SQL Auditing. Guilty as charged! Or not, as the case may be.
This is a finger pointing situation that i've witnessed in the past regarding native SQL Auditing, and the potential for edge case false...
Jun 12, 20244 min read


Reasons to Match Datatypes #39 - Table Partitioning
Ok, so I may have exaggerated and jumped a few just slightly with the numbering there for effect, but they all matter. Assume a heavily...
May 30, 20243 min read


Azure Managed Instance SQL 2022 Update Policy. Well that potentially sucks.
Ah, SQL 2022, the release that finally brought box SQL and Azure managed instance closer together. We have wonderful toys such as...
May 28, 20244 min read


Azure Elastic Jobs - The NonPlastic, Elastic Fantasic
After a lengthy period in Public Preview it seems, the boffins at Microsoft have finally pushed Elastic Jobs for SQL Azure DB to general...
Apr 29, 20246 min read


Checking SQL Server Estate Connectivity with Powershell Jobs...parallel technicolour.
In my previous post Running Powershell for SQL Use* in Parallel - POshRBAR no more. (sqlrod.com) , I discussed the use of powershell...
Feb 13, 202412 min read


Running Powershell for SQL Use* in Parallel - POshRBAR no more.
*Or any use for that matter... This is one that I should have learnt way earlier than I actually did if i'm being completely honest. One...
Jan 30, 20245 min read


T-SQL Tuesday #170 - Learning from abandoned projects
This month's TSQL Tuesday is kindly hosted by Reitse Eskens (L/T), and is a really interesting one for me. We all strive to learn, but...
Jan 9, 20245 min read


DBATools Favourite functions - Why use your hands, when you have a hammer...
DBATools is the best thing since sliced bread, i'm sure alot of us gluten tolerant people can all agree on that. Powershell makes...
Jan 4, 20243 min read


SP_WHO are you...
"Who who, Who who... ... I really want to know ..?" OK, we all have our servers, and that they always work absolutely magnificently, we...
Aug 8, 20236 min read


Monitoring SQL Server for FREE with Telegraf, Influxdb & Grafana. The wonderful thing about TIGgers.
... Is Tiggers are wonderful things. So, I love monitoring. I openly admit to having a thing about data and graphs that are showing me at...
Jul 25, 202314 min read


T-SQL Tuesday - Code that makes you go 'mmmmm'
This one is in response to the current T-SQL Tuesday topic being hosted by Erik Darling (https://twitter.com/erikdarlingdata / Erik...
Jul 12, 20233 min read
bottom of page