[Video] Office Hours at the Barcelona Pavilion
I’ve always wanted to see the Barcelona Pavilion by Mies van der Rohe, and by happy coincidence, I ended up walking right past it while visiting Barcelona! It’s one of the most important beginnings of modern architecture, and I loved it. I brought you …
Securing the Data Layer: Why SQL Developers Should Care About App-Level Vulnerabilities
Editor: This is AI generated, which is against our policy. The Hidden Risks Above the Database In today’s increasingly complex tech stacks, securing the data layer is no longer just about firewalls, access permissions, and stored procedures. SQL develo …
Query Exercise Answers: Returning Routes in the Right Order
In your most recent Query Exercise challenge, I gave you these two tables: DROP TABLE IF EXISTS dbo.Stations; CREATE TABLE dbo.Stations (StationId INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, StationName VARCHAR(50), StationPhysicalOrder INT); INSERT INTO …
SQL Server 2025 : Zstandard Backup Compression
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once 2025 has been released, posts will be kept if the feature hasn’t changed for the final release. For other posts in this series, you can find them in this collect …
Guide to Decoding SQL Server Bulk Insert Error Files
Learn how to work with SQL Server’s ERRORFILE option to isolate problem records, decode cryptic error messages, and avoid duplicate imports when dealing with bulk data loading errors.
TempDB Resource Governor Space Controls in SQL Server 2025
TempDB is a system database in SQL Server that manages temporary objects for all databases on a server. Because it is a shared resource, it can easily become a performance bottleneck., as well as an opportunity for a single database or even a single qu …
SQLBits Added More Capacity to My Workshop! Move Quick.
I’m coming to London this month for SQLBits, and my Thursday workshop “Faster, Cheaper Cloud Databases” workshop sold out right away when it was announced. There’s been a waitlist for months. The short story: they added more capacity to my room! If you …
The good, the bad, and the awful taste muscle memory can have
When I was traveling a while back, I grabbed a small white metal tube out of my toiletry bag. Opened it up and then squeezed a small amount of this white cream on my toothbrush. A few seconds later my power toothbrush was whirring along and I had a tho …
Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore
Performance tuning in Azure SQL Database can feel like solving a puzzle—get it right, and your queries fly; get it wrong, and you’re stuck waiting. Whether you’re dealing with sluggish reports or slow transaction processing, the right indexing strategy …
Sponsoring Scenic City Summit
For the second year in a row, Simple Talk will sponsor Scenic City Summit in Chattanooga, TN, which will be held June 19-21. What is awesome about this year’s Scenic City Summit is that is expanding and will pull from several of the area’s well-establ …
Securing PostgreSQL Against Injection, Misconfiguration, and Privilege Escalation
PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group “takes security seriously,” enabling users to trust it with mission-critical data (PostgreSQL: Security Information). However, simply …
SQL Automate – A DBA’s Time-Saving Toolkit
Introduction Installing SQL Server can be a very boring and time consuming task, especially when you have to repeat the same steps across multiple servers. It not only takes your time, but doing the repetitive things makes it a tiresome activity for an …
Index Scans and Table Scans
The post Index Scans and Table Scans appeared first on SQLServerCentral.
Oracle ASM: A Simple Solution or Another Complexity? (part 1)
For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure complexity grows with Real Application Cluster (RAC), virtualized infrastructure, and multi-tenant database architectures. …
[Video] Office Hours in the Detroit Airport
I’m in the Detroit airport today, en route home after a client gig. I’ve got some time to kill, so let’s go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:39 SQLLearner: Hi Brent! I’m curio …