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 […]
Articles by dataea5_wp
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
SQL Security
MS SQL Server Security Model Review – Questions on Configurations – and Vulnerabilities
Information is found on PDF document: ms-sql-server-security-model-review-questions-on-configurations-and-vulnerabilities
DB Architecture
HOW TO SETUP FILESTREAM FEATURE ON MICROSOFT SQL SERVER 2008/2012/2014
Gratitude: Many thanks to Jacob Sebastian, DBA-presents, and VoiceOfTheDBA for providing info on this topic. I have started putting all my material in PDFs. Please Click on PDF to load: how-to-setup-filestream-feature-on-microsoft-sql-server-2008 Videos:
BI
How to force an SSIS Package to complete without reporting any errors?
Ok! First off, let’s do a quick review of SSIS! Microsoft SSIS (SQL Server Integration Services) is just one of the database tools provided by Microsoft within SQL Server Data Tools (SSDT) –as we know […]
BI
What is Business Intelligence?
In brief (and ridiculously simplified), “Business Intelligence (BI)” is a technology which allows users to transform raw data into meaningful information which could then serve to advance a business’ end-goal or mission. The term “Business […]