Building Databases: One Man’s Best Practice?
One man’s meat is often another man’s poison. In this editorial Tony Davis looks at why a migrations-based approach to database version control might not always be best practice.
2015-09-07
6,262 reads
Database version control
Blogs
Speaking at the 2025 PASS Data Community Summit
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
The Book of Redgate: Motivation
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
A Six Week Break
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Forums
Three Times a Day
Comments posted to this topic are about the item Three Times a Day
SUM([value]) and highest record type
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
should i expect data types in task->export data from ssms?
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
Question of the Day
Multiple Defaults
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers