A New Word: los vidados
los vidados – n. the half-remembered acquaintances you knew years ago, who you might have forgotten completely if someone hadn’t happened to mention them again – friends of friends,...
2026-03-20
48 reads
In-Person CISA Training – April 13-16, 2026
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class on April 13-16, 2026, in Columbia, SC.
2026-03-18
85 reads
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is back…it’s all happening on August the 20th! We’ve open our call for speakers, you can...
2026-03-27 (first published: 2026-03-18)
246 reads
The FinOps Lifecycle: From Budgeting to Reporting
Working in DevOps long enough teaches you two universal truths: That’s exactly why I lean heavily on FinOps. For me, it’s not just a framework — it’s the reality...
2026-03-18
67 reads
Finding and Updating Duplicate IDs: #SQLNewBlogger
Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I...
2026-04-01 (first published: 2026-03-18)
256 reads
Optimising Costs: Strategies for Efficient Cloud Resource Management
Over time, I’ve realised that one of the hardest parts of cloud management isn’t deploying infrastructure — it’s balancing performance with cost. The cloud gives us incredible flexibility, but...
2026-03-18
61 reads
Cost Visibility: Tracking and Analysing Your Cloud Spend
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility into cloud costs. In the cloud, resources can be spun up in seconds and scaled...
2026-03-18 (first published: 2026-03-17)
80 reads
Whiling away an afternoon, thinking
I come to Heathrow often. Today is likely somewhere close to 60 trips to this airport in my lifetime. After over 19 years of working with Redgate (plus a...
2026-03-18 (first published: 2026-03-17)
37 reads
T-SQL Tuesday #196 Roundup: What career risks have you taken?
I hosted this month’s T-SQL Tuesday invitation in which I asked, “What career risks have you taken?” I got some great responses which I’ll recap here, Career risks? Rob...
2026-03-17
54 reads
Black Box vs. Gray Box vs. White Box Testing
If your organization is spending money, then meaningful results are a must. Pen testing isn't supposed to be a pat on the back. It's supposed to be a tool...
2026-03-17
57 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers