Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or ...

Recently, my good friend and co-worker Aaron Bertrand and I were producing a video for the upcoming PASS Summit 2015 event. (Learn more about the international SQL ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work ...

Microsoft SQL Server has come a long way since the release of Ashton-Tate/Microsoft SQL Server 1.0 on May 8, 1989, which had been announced by Ed Esber and Bill Gates on January 13, 1988 at a New York ...

CAMBRIDGE, United Kingdom--(BUSINESS WIRE)--Red Gate Software has released a new tool called SQL Object Level Recovery Native that enables individual database objects to be recovered from native SQL ...