T-SQL Tuesday #200 - I Bet It's Bad if I See...

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Brent Ozar
(blog) asks us to fill in the blank:

When I’m looking at...

Monday Monitor Tips: Virtual Machine Usage and Cost

One of the things I’ve been requesting for a number of years is cost information. I could see this coming in 2015 with the move to the cloud and...

Project Management – Part 1

The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related and grouped as follows: Process Group[49] Knowledge Area with Process I will write detail blog...

T-SQL Tuesday #200: Bad Query signals

NO AI was used to generate this content. Grammarly was used to check and correct language and sentences in parts. I just managed to get a post in for...

WITH clause gets a 26ai boost!

By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause. The reason I like it is that it lets you...

A New Word: Attriage

attriage – n. the state of having lost all control over how you feel about someone – not even trying to quench the flames anymore, but lighting other fires...

Automatic Index Compaction

Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.

Setting Up a Mac for Data Engineering and AI Work

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac with Apple Silicon is genuinely one of the best machines you can have as a...

Capturing My Own Metrics: #SQLNewBlogger

A customer was trying to compare two tables and capture a state as a performance metric. In this case, they were wanting to use Redgate Monitor and custom metrics,...

Fabric for Operational Reporting & SQL Endpoint Trap

With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting build entirely in Fabric where you can have almost live data in reports. The pitch...