• Library
    • Data Quality
    • MS SQL
      • DB Copy/Replication
    • Server/DB Information
    • Server Configuration
    • SQL Security
  • Facebook
Welcome to DataEasy123.Com!

Welcome to DataEasy123.Com!

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

  • Team Building
  • DB/App
  • WEBINARS
  • About
News Ticker
  • [ July 20, 2020 ] Compare DB Objects Between two DBs Data Quality
  • [ June 17, 2020 ] Loop Through An Ordered List of Tables – Based On Foreign Keys DB Copy/Replication
  • [ June 11, 2020 ] Xml data type is not supported in distributed queries DB Copy/Replication
  • [ June 9, 2020 ] Merge Script Generator/In-house DB Replication Script DB Copy/Replication
  • [ June 9, 2020 ] DB Usage and Disk Space Info Server/DB Information
HomeLibraryMS SQL

MS SQL

No Picture
DB Copy/Replication

Loop Through An Ordered List of Tables – Based On Foreign Keys

June 17, 2020 dataea5_wp 0

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 – […]

No Picture
DB Copy/Replication

Xml data type is not supported in distributed queries

June 11, 2020 dataea5_wp 0

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

No Picture
DB Copy/Replication

Merge Script Generator/In-house DB Replication Script

June 9, 2020 dataea5_wp 0

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

No Picture
Server/DB Information

DB Usage and Disk Space Info

June 9, 2020 dataea5_wp 0

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

Recent Posts

  • Compare DB Objects Between two DBs
  • Loop Through An Ordered List of Tables – Based On Foreign Keys
  • Xml data type is not supported in distributed queries
  • Merge Script Generator/In-house DB Replication Script
  • DB Usage and Disk Space Info

Recent Comments

  • dataea5_wp on Data – What is the big deal?
  • Alex Nordeen on Data – What is the big deal?
  • PHP Classified Script on Data – What is the big deal?
  • Sanjeev Krishna Thakur Ji on Data – What is the big deal?
  • you can look here on Data – What is the big deal?

Archives

  • July 2020
  • June 2020
  • October 2016
  • September 2016
  • July 2016

Categories

  • BI
  • Data Quality
  • DB Architecture
  • DB Copy/Replication
  • Introduction
  • Library
  • Server Configuration
  • Server/DB Information
  • SQL Security
  • Uncategorized

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2023 | MH Magazine WordPress Theme by MH Themes