Data Flow Optimization - Collapse Sparse Buffers
I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT...
2012-10-22
1,439 reads
Blog Posts
DBA Work Accounting
One thing lots of DBA teams, esp. the DBA managers, feel uncomfortable is that it is difficult to quantify/log DBA’s...
2012-10-22
1,846 reads
Don’t Be That PASS Summit Guy
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,208 reads
Last Weeks Top 10 “Reading” Links #3
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-22
706 reads
Preparing for Certification
One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...
2012-10-22
1,361 reads
Red Gate log shipping
Log shipping is great.
It's basically the act of beginning a restore with no recovery, and then restoring logs (with no...
2012-10-22
2,170 reads
Stockholm in 2013
Come and join me live in Stockholm Sweden early in 2012 where I will be presenting Learning Tree’s2109 SQL Server...
2012-10-22
513 reads
Trace Flag 2371 and Statistics
One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on...
2012-10-22
9,581 reads
What Happened to rowmodctr from Sysindexes?
In my blog series Lost in Translation – Deprecated System Tables, I’ve been going through the compatibility views in SQL Server...
2012-10-22
2,597 reads
Does a Clustered Index really physically store the rows in key order?
The Myth
One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is...
2012-10-21
8,179 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers