Monitoring SQL Server TRUNCATE TABLE operations has always been a challenge. But I think I've found a workable solution with Extended Events.

Optimizing a table for analytics and maintenance proved trickier than I expected.

For SQL Server metadata, the information schema views may not be suitable for all of your needs. Here is an example involving table constraints.

My SQL Server Agent WMI Alert stopped working. But why?

Differences between your development workstation and a SQL Server host can make SSIS packages challenging. Here's how I overcame one of those obstacles.

A "compact" query showing DDL trigger event group hierarchies.

Implementing a SQL Server temporal table led to a couple of gotchas. But the end result was really good.

Write files to cloud storage with SQL Server's Machine Learning Services

T-SQL has no native support for parquet files. It's R, Python, and Machine Learning Services to the rescue!

External Python and R scripts for SQL Server Machine Learning Services have limited access to the file system.