A New Word: Attriage
attriage – n. the state of having lost all control over how you feel about someone – not even trying to quench the flames anymore, but lighting other fires...
2026-07-10
55 reads
Blog Posts
Automatic Index Compaction
Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.
2026-07-10 (first published: 2026-06-30)
339 reads
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac with Apple Silicon is genuinely one of the best machines you can have as a...
2026-07-10 (first published: 2026-06-25)
447 reads
Capturing My Own Metrics: #SQLNewBlogger
A customer was trying to compare two tables and capture a state as a performance metric. In this case, they were wanting to use Redgate Monitor and custom metrics,...
2026-07-08
468 reads
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting build entirely in Fabric where you can have almost live data in reports. The pitch...
2026-07-08 (first published: 2026-06-23)
334 reads
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another...
2026-07-08 (first published: 2026-06-17)
315 reads
T-SQL Tuesday #200: When I Look at a Query …
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound big, but this is a monthly party (started by Adam Machanic). We have 12 blog...
2026-07-07
77 reads
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems useful, but I have no idea where to start,” this post is for you.
The post...
2026-07-06 (first published: 2026-06-22)
492 reads
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
As a SQL Server DBA with years of experience tuning production environments, I’ve seen the same patterns repeat: nightly index maintenance jobs running for hours, consuming massive CPU and...
2026-07-06 (first published: 2026-06-19)
1,173 reads
Understanding Microsoft Fabric OneLake Security
The idea behind Fabric OneLake Security (which GA’d on April 2026) is to centralize data access controls at the data layer, rather than configuring security separately for every Fabric...
2026-07-06
111 reads
Blogs
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...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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