MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

As one of the preventive database maintenance tasks, performing database integrity checks on almost every database you...

A New Word: Addleworth

addleworth – adj. unable to settle the question of whether you’re doing okay in life; feeling torn between conflicting value systems and moveable goalposts, which makes you long for...

Using the Pure Storage PowerShellSDK2 - Part 5 - Checking Replication Status

Introduction Welcome back to the fifth installment of our blog series on using the Pure Storage PowerShell SDK2. In this post, we’re diving into a hands-on demonstration of using...

What I actually do at Microsoft

I started working at Microsoft in January 2022. I enjoy it. I even wrote a stream-of-consciousness post about it last year. A significant part of our job in the...

How to use a Script Activity in ADF as a Lookup

In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a typical scenario where you retrieve some metadata from a database and then loop over...

6 Surprising Things You Can Do on WordPress.com Without a Plugin 

Newsletters? Spam protection? Image galleries? We have you covered, no plugin needed.

How I Effortlessly Dockerize Python-Based AWS Lambda Functions

As a Software Engineer, i would like to learn how to dockerize my Python Fast API Framework and use this dockerize application in my lambda function. This will allow...

Talkie - a simple, private, responsive interface for LLMs

Watch this video on YouTube
I like using ChatGPT. But I don't like the $20/month price tag for using OpenAI's app, especially given the API costs fractions of a cent.
So...

Book Review – Fundamentals of Data Engineering

This book was recommended by some of my colleagues, so I decided to give it a try. After finishing the book, I was pleased that I did. As the...

Database Build Error – Incorrect syntax near DISTINCT

I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks if two expressions are equal taking NULL into account....