Data Quality
Compare DB Objects Between two DBs
I had created a script that merges two DBs together creating, in a sense, my won DB replication process. You’ll find those scripts in this website. In any case, I needed a script to verify […]
Library
DB Copy/Replication
Loop Through An Ordered List of Tables – Based On Foreign Keys
Hello everyone, The important thing to remember here is that the “sorted list of tables” will change depending on whether you are either Inserting or Deleting data. I like the image used by w3resource – […]
DB Copy/Replication
Xml data type is not supported in distributed queries
The error is: Msg 9514, Level 16, State 1, Line 216 Xml data type is not supported in distributed queries. Remote object [Server_name].[DB_Name].dbo.[table_name]’ has xml column(s). Are you trying to query a remote DB\table which […]
DB Copy/Replication
Merge Script Generator/In-house DB Replication Script
I was in need of migrating a key DB (located on a fragile, never updated SQL 2008 R2) into a SQL 2016 Server hosting a “Fail over/Availability Groups Environment”). There could be no downtime given […]
Server/DB Information
DB Usage and Disk Space Info
I have combined a few scripts into this long one that provides the following columns: The scripts provides many uses:1) In LAB Environment, you can review which DBs have not been accessed and plan to […]
Library
Enable xp_cmdshell
— this turns on advanced options and is needed to configure xp_cmdshell sp_configure ‘show advanced options’, ‘1’ RECONFIGURE — this enables xp_cmdshell sp_configure ‘xp_cmdshell’, ‘1’ RECONFIGURE