Effectively mapping primary key – foreign key relations
This script maps the primary key - foreign key relations regardless if the column names are the same or not.
2012-05-15 (first published: 2007-11-07)
2,854 reads
John Liu
2008-09-02 (first published: 2008-07-10)
2,661 reads
Blogs
Encryption in SQL Server #1 – Column Level Encryption
For one reason or another data security and encryption has been coming up quite...
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
This Saturday: #DataWeekender, DataSaturday Southwest
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Forums
SSIS Import only new values from a CSV without using a staging table
Hello, How can I import a CSV file in SSIS (2016) at the same...
Query store index rebuilds
Recently we experienced a sudden surge in disk I/O every twenty minutes or so....
Group Managed Service Accounts for SQL Server 2017/2019
We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...
Ask SSC