Script Out Foreign Keys With Multiple Keys
It's easy enough to use sys.foreign_keys and sys.foreign_key_columns to identify foreign keys. But what if you want to script out your foreign...
2013-02-18
1,194 reads
Inserting Binary Data
There are a number of articles on dealing with the insertion of binary data into SQL Server using BULK INSERT,...
2013-02-17
20,841 reads
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,543 reads
A year of SQL Lunchs
Time does fly, and happy birthday SQL Lunch UK.
It has been a year since the first SQLLunch UK, and over...
2013-02-17
701 reads
A Month of PowerShell – Day 17 (Databases: Views)
Welcome to Day 17 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-17
691 reads
Fun with dates
Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it...
2013-02-17
794 reads
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
970 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
944 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
893 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
746 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers