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
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 a "try this for all data flow performance...
2012-10-22
79 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
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
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
SQL Server Locking Overview
Locking is a necessary part of transaction processing when working in a multi-user Online Transaction Processing (OLTP) environment. You use...
2012-10-21
12,350 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
Ask The Unicorn: SQL Saturday Registration Is Closed
Right before the last Minnesota SQL Saturday, I was asked a few questions about learning about SQL Server which led...
2012-10-20
772 reads
fn_OBJECT_TYPE
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,258 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