Holy Foreign Keys and Indexes
This article shows an interesting issue with foreign keys and how they are aligned with the base tables in SQL 2005 SP 4.
2011-10-10
5,411 reads
James DiMauro
My Experiences at SQL Saturday 64
A commentary of the experiences of James Dimauro at SQL Saturday #64 in Baton Rouge, LA in August 2011.
2011-08-17
493 reads
Moving Databases with the ALTER Command
A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.
2009-08-26
8,429 reads
A Story of the Deleted Transaction Log
James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)
2009-08-07 (first published: 2008-07-14)
20,307 reads
Blogs
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors...
SSAS Tabular – Process Add memory consumption
For me it’s a bit surprising how little information can be found regarding the...
Forums
Migration sandbox
Inherited about 190 2008 servers I need to migrate. Was going to build 2014/16...
Linked server and SQL Server 2019
Hi, I searched the infomation but I didn't found it so... Is Linked Server...
Ask SSC