Using Foreign Keys to Determine Table Insertion Order
Here's a script to determine, based on your database's foreign key relationships, what the insertion order would be for, say,...
2013-02-17
1,538 reads
Blog Posts
A Month of PowerShell – Day 16 (Databases: Triggers)
Welcome to Day 16 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-16
968 reads
I’m dropping the book project
Update:
This book project got its second life. I am now collaborating with another author to bring this book to completion....
2013-02-16
940 reads
23 Pieces of News and Fluffery (Feb 9-15)
I have a news segment on DBAs@Midnight (our live weekly webshow, tune in tonight at 11pm Central time), but there’s...
2013-02-15
744 reads
A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)
Welcome to Day 15 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-15
731 reads
I’ve got mad SQLSkills
Digging the new logo
Last week I was fortunate enough to attend SQLSkills IE1 class in Tampa. Fortunate to have an...
2013-02-15 (first published: 2013-02-11)
2,488 reads
Overconfidence – How it Almost Cost Me and What You Can Do to Avoid It
It was early one morning and I was working on a production deployment to add a new Subscriber to an...
2013-02-15 (first published: 2013-02-05)
3,770 reads
Reblog: February 8 to February 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-15
892 reads
T-SQL Gotcha
I came across an interesting issue a few days ago that I thought I would blog about. The issue is...
2013-02-15
1,602 reads
“DBA: Transitioning to a BI Role” Presentation Slides
Thanks to everyone who attended my presentation “DBA: Transitioning to a BI Role” at the PASS Professional Development Virtual Chapter. The recording...
2013-02-14
1,767 reads
Blogs
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers