Blog Post

Did You Really Name That Default?

Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:

SQL Server...

2026-04-17 (first published: )

372 reads

Blog Post

SQL Server Security – TDE Encryption

Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this feature encrypts a physical layer of Database files Data/log files protection at Disk / storage...

2026-04-04 (first published: )

32 reads

Blog Post

Presenting Twice in May 2026

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person twice in May 2026. With summer vacations coming up, this is a perfect time of...

2026-03-30

16 reads

Blogs

Red Flags in Your Query (T-SQL Tuesday #200)

By

When I'm looking at a query, I bet it's bad if I see... a...

T-SQL Tuesday #200: When I Look at a Query …

By

This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...

Reflections on the Life of a DBA

By

The DBA life is fraught with pain. Those battles that we endure are mostly...

Read the latest Blogs

Forums

cons for a dev machine in a different version of sql from our prod server

By stan

hi, im not a dba. For a couple of years our dev sql server...

Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO

By abdalah.mehdoini

Hello, I would like to ask whether it is technically possible to redirect a...

Calculating Geometric Mean in Power BI

By Dinesh Asanka

Comments posted to this topic are about the item Calculating Geometric Mean in Power...

Visit the forum

Question of the Day

TempDB Facts I

Can I set Accelerated Database Recovery on tempdb?

See possible answers