How to delete personal data for GDPR & CCPA compliance
Deleting a customer’s personal data under GDPR or CCPA means erasing it everywhere it’s stored — not just the primary database, but replicas, backups, caches, search indexes, logs, and every third-party tool that touched it — usually within 30 to 45 da …
Détecter des opérations spécifiques sur une capacité Microsoft Fabric
« Nous avons créé une capacité Copilot dédiée. Mais comment savoir que Copilot s’exécute réellement dessus, et nulle part ailleurs ? » C’est une question qu’un administrateur Fabric m’a récemment posée, quelques semaines après le déploiement de Copilot …
[Video] Office Hours on Mount Charleston
For this episode, I’m up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the weekend at Mount Charleston. Let’s go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 …
How to avoid demo fails when presenting at tech conferences
Roughly two out of every three tech conference session demos fail — that’s according to experienced attendee and presenter Greg Low, who has seen it all happen first-hand. That means simply having your demo work as planned puts you ahead of most speake …
Database Animations: How SQL Server’s JSON Indexes Work
By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to store practically schema-less JSON blobs as part of each row, and have it too by querying specific values quickly. (The common phrase is to “have your cake and …
Bi-directional logical replication in PostgreSQL: a practical guide
Logical replication has long been a feature of many database management systems. It’s the simple process of copying and maintaining identical data across multiple database servers. The methods taken to achieve this process, however, are quite varied – …
Set Your Application Names Before You Wish You Had.
When you run monitoring queries like sp_BlitzWho and sp_WhoIsActive, you wanna see the program names that are running the queries. It’s super useful when you’ve got multiple apps running on the same servers, or when you’ve got apps scattered across end …
How to mirror data from SQL Server to Microsoft Fabric: complete guide
Mirroring in Microsoft Fabric is useful when you need to make SQL Server data available in Fabric. Perhaps in OneLake, for example, if you need to use the data for reporting, analytics, notebooks, or another Fabric workload. However, it’s not suitable …
[Video] Office Hours: Stoicism in the Home Office
I’m back in the home office this week, covering your top-voted questions from https://pollgab.com/room/brento, and we finish up the session with a discussion of the stoic habit I use to start my mornings. Here’s what we discussed: 00:00 Start 01:42 Spi …
Learning PostgreSQL with Grant: Preparing for the PostgreSQL certification
I want to be up front and honest: I suspect I’ll fail this. However, I’m going to try. I’m registered for it, so no backing out now. In this article, I’ll run through everything I’m doing to prepare…for the exam. That’s right – exam. And a PostgreSQL o …
Who’s Hiring Database People? September 2026 Edition
Is your company hiring for a database position as of September 2026? Do you wanna work with the kinds of people who read this blog? Let’s make a love connection. If your company is hiring, leave a comment. The rules: Your comment must include the job t …
SQL Server login failures: how to monitor, report, and alert on them (complete guide)
Failed logins are one of the clearest early-warning signs of trouble on a SQL Server – whether that’s a misconfigured connection string, an expired password, or an actual unauthorized access attempt. Yet, by default, SQL Server won’t proactively tell y …
Free Webcast: You Shouldn’t Use SQL Agent for Batch Processes.
SQL Server Agent is a solid scheduler for database administration and simple, database-local automation. In a small to midsize shop, it is the right tool for backing up databases, checking for corruption, and maintaining statistics. But as a shop grows …
Is AI already learning from our old, poor-quality code?
In this Simple Talk opinion piece, Greg Low unpacks how AI models actually filter and weigh training data, why the most common answer isn’t always the best one, and why truth itself can depend on timing and context — not just quality. A while back, I w …
Why SQL Server’s default trigger execution model is a security flaw – and what Microsoft should do about it
In my previous article, I described a privilege escalation scenario involving Azure Arc-enabled SQL Server and a database-level DDL trigger created by a database-scoped principal. This database-level DDL trigger was later fired by a highly-privileged A …