SQL Server: Practical SQL Server Encryption - TDE, Always Encrypted, and When to Use Each blog.greglow.com/2026/02/01/s...

Wow - have been tidying up old blog posts, removing any invalid info, fixing images, and code, removing dead links, etc. Can't believe how much work it has been. I'm nearly finished with posts up to 2008. I do a little bit each day but such a long way to go...

Fabric RTI 101: Event-Driven vs Request-Driven Systems blog.greglow.com/2026/01/31/f...

30/01/2026 How SQL Server Really Uses the Service Master Key blog.greglow.com/2026/01/30/s...

Fabric RTI 101: What is the Real-Time Hub? blog.greglow.com/2026/01/29/f...

If you are running technical events, please make it clear whether they are hybrid or in-person only (or even online only)

Wow. Ouyen (here in Victoria) was 48.9 C (120.2 F) today

Fabric RTI 101: What are Actions? blog.greglow.com/2026/01/27/f...

SQL Server: Tempdb, Temporary Tables, and Collation: A Design Trap You Can Avoid blog.greglow.com/2026/01/26/s...

SQL: Common Anti-Patterns that Stop Parallelism blog.greglow.com/2026/01/26/s...

Fabric RTI 101: What is Processing? blog.greglow.com/2026/01/25/f...

Data Tales 13: The case of the invisible brake blog.greglow.com/2026/01/24/d...

Fabric RTI 101: What is Ingestion? blog.greglow.com/2026/01/23/f...

Opinion: Why penguins don't explode and the need for basic research blog.greglow.com/2026/01/22/o...

Fabric RTI 101: What are Streams? blog.greglow.com/2026/01/21/f...

SQL Interview 104: Backup restore time blog.greglow.com/2026/01/20/s...

Fabric RTI 101: What are Events? blog.greglow.com/2026/01/19/f...

SQL Interview 112: Trigger and constraint execution order blog.greglow.com/2026/01/18/s...

Fabric RTI 101: What does Microsoft Fabric Real-Time Intelligence provide? blog.greglow.com/2026/01/17/f...

SQL Interview 111: Simple recovery and log truncation blog.greglow.com/2026/01/16/s...

Fabric RTI 101: Batch Processing vs Streaming blog.greglow.com/2026/01/15/f...

SQL Interview 110: Long restores and restarts blog.greglow.com/2026/01/14/s...

Fabric RTI 101: Latency vs Freshness Trade-Offs blog.greglow.com/2026/01/13/f...

SQL Interview: 109 Simple recovery and logging blog.greglow.com/2026/01/12/s...

Fabric RTI 101: Why Real-Time Matters blog.greglow.com/2026/01/11/f...

SQL Interview 108: Increasing memory consumption blog.greglow.com/2026/01/10/s...

Fabric RTI 101: What is Real-Time Intelligence? blog.greglow.com/2026/01/09/f...

SQL Interview 107: Timestamp data type and time blog.greglow.com/2026/01/08/s...

SQL Interview 100: Query duration vs execution plan cost blog.greglow.com/2026/01/07/s...

SQL Interview 106: Database backup and log shrinking blog.greglow.com/2026/01/06/s...

SQL Server: Stop connecting applications as dbo or sa blog.greglow.com/2026/01/05/s...

I'm not complaining about the lowering of the price, but as an industry, we really are happy to push out nonsense to customers aren't we? How exactly was this calculated?

SQL Interview 105: Database mail dependency on Exchange blog.greglow.com/2026/01/04/s...

SSMS Tips and Tricks 8.3: Using split screens blog.greglow.com/2026/01/03/s...

Writing SQL Queries for Db2 Course Released ! blog.greglow.com/2026/01/02/w...

Happy New Year to all my readers ! blog.greglow.com/2026/01/01/g...

SQL Interview 113: model database blog.greglow.com/2025/12/31/s...

Reassuring to see that peanuts may be present in the peanuts.

SQL Interview 103: Stored procedures and transactions blog.greglow.com/2025/12/30/s...

Opinion: User Groups (and conferences) must avoid ever increasing depth blog.greglow.com/2025/12/29/o...

SQL Interview 102: Checkpoint writes blog.greglow.com/2025/12/28/s...

SQL Interview 114: master database blog.greglow.com/2025/12/27/s...

SQL Interview 101: Restoring successful backups blog.greglow.com/2025/12/26/s...

Merry Christmas to all my readers ! blog.greglow.com/2025/12/25/g...

SQL Server: The most frequently misunderstood query plan operators blog.greglow.com/2025/12/24/s...

Writing SQL Queries for Oracle Course Released blog.greglow.com/2025/12/23/w...

With SSIS, we often used to use it to orchestrate T-SQL to do the manipulation, rather than getting SSIS to do the transformation. Databases are good at getting a lot of things done in parallel and in a hurry.

SQL Server: Parallel Programming In TSQL: Is It In Our Future? blog.greglow.com/2025/12/22/s...