This is it. The final chapter of PowerShell Strikes Back. Over the past four weeks, you’ve built a real foundation. You know that single quotes are literal and double...
2026-06-15 (first published: 2026-05-26)
492 reads
Claude is more than a chat window. The desktop experience includes structured workspaces, generated outputs, integrations, execution capabilities, memory and reusable workflows. This is a quick introduction to some...
2026-05-26
29 reads
A sequential scan is not always a problem — PostgreSQL's planner often chooses one correctly for small tables or queries that return most of a table's rows. The dangerous...
2026-05-25
683 reads
I’ve been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to...
2026-06-12 (first published: 2026-05-24)
425 reads
Redgate is a for-profit company. We look to make money by building and selling tools that help you. If we do a good job, we make money. If we...
2026-05-22
50 reads
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my DataGrillen session Building the €100 data warehouse with the Azure Data Platform to Github. If...
2026-05-22
21 reads
If you've ever loaded a 2 GB CSV into pandas just to run a few aggregations — and watched your machine struggle — there's a better tool for the...
2026-06-10 (first published: 2026-05-21)
516 reads
What problem is Fabric Ontology trying to solve? For years, most data conversations have started with tables. We ask where the data lives, what columns are available, how the...
2026-06-10 (first published: 2026-05-20)
362 reads
Recently I ran across some code that used a lot of QUOTENAME() calls. A colleague was having some trouble with the code, but what struck me was that I...
2026-06-08 (first published: 2026-05-20)
442 reads
There are some telltale signs that your growing business has outgrown Excel for your reporting needs. Excel is probably the most adopted piece of software out there, and I...
2026-06-08 (first published: 2026-05-20)
377 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers