Welcome to DataEasy123.Com!

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 [...]
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 [...]

A summary of CURRENT IT News related to Webinars/Data/App/Management.