2020-01-06
1,054 reads
2020-01-06
1,054 reads
2020-01-03
775 reads
2019-12-31
837 reads
The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.
2019-12-27
2019-12-24
914 reads
2019-12-19
244 reads
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
1,892 reads
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
2019-12-07
298 reads
2019-12-06
721 reads
2019-12-03
1,163 reads
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers