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