T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup

When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what kind of stories would come out of it.
The topic was simple:
That one SQL Server outage...

A Last Minute Trip to the EU

My life has some crazy travel stretches for sure. Between speaking, office visits, customer trips, I can be on the road a lot. As it is, I’ve flown across...

Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency

In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with edges, and uses greedy graph traversal to avoid comparing a query against every vector in...

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

I’m excited to announce the release of a new open-source project that fully automates HammerDB benchmarking for SQL Server using Docker. If you’ve ever needed to run TPC-C or...

T-SQL Snapshot Backups on Availability Group Secondary Replicas

One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups. The ability to leverage the snapshot capabilities of modern storage arrays to take application consistent...

The Book of Redgate: Hours

I have said and written this many times: Redgate Software is the type of company I’d want to build if I founded another company. It’s a great place, and...

How to Check TDE Progress and Elapsed Time in SQL Server

How to Check TDE Progress and Elapsed Time in SQL Server

Transparent Data Encryption (TDE) protects SQL Server data and log files while they are stored...

PostgreSQL Support in the Data API Builder

Next week I’m at VS Live in San Diego (register and join me) and one of my talks is on the Data API Builder. I want to show how...

Ten Years of PowerShell

Ten years ago today, I filmed a Pluralsight Play by Play on open source PowerShell. I was standing between Jason Helmick and Jeffrey Snover, trying very hard not to...

T-SQL Tuesday #202: 100 Hours

It’s time for T-SQL Tuesday again and this is a great prompt to start writing. I might have written about this before, but it’s a story that sticks with...