21 June 2021
21 June 2021

Microsoft SQL Server Database Security, Disaster Recovery & High Availability

Microsoft SQL Server is a relational database management system (RDBMS) and it is one of the most popular and powerful Database software used worldwide. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer … Read more
15 June 2021
15 June 2021

Microsoft SQL Server to Oracle Database Connectivity from SSIS using Attunity Connector

Almost every environment now a days need to source data from different source system. Here is how you can establish connection using Attunity Connector from Microsoft SQL Server to Oracle Database  from SSIS. This method is extremely fast if you want to land millions and millions of records on the fly from Oracle to SQL Server. … Read more
12 March 2021
12 March 2021

Ways to get and deal with invalid node identifiers in SQL Server Edge references

One of the weirder things about graph tables in SQL Server is the mysterious backend implementation. The values you see when working with these objects look like this: {“type”:”node”,”schema”:”dbo”,”table”:”Node1″,”id”:0}, but when you get errors, you don’t see the json, you see what this represents (two integers for the object_id and unique id in the graph … Read more
17 April 2020
17 April 2020

SQL Agent Job Generator: Scheduling A Job

In this last entry in the initial series of posts on building a SQL Agent Job Generator, I am going to add the ability to schedule the jobs that we generated in the previous post. The code that is available here in github: https://github.com/drsqlgithub/SSISDeployTool/tree/e8c44505bba6b3c764531c8b489101b39b5c27a7, is likely sufficient for some smaller organization’s needs with jobs. (Future … Read more
01 March 2020
01 March 2020

Identity column vs ETL Process

Creating ETL process can pose so many challenges we will only fully discover them when really building the ETL. Before you complain about modelling, the example here has no relation to data warehouse modelling. The ETL in question was a migration from a data source to another. The need for executing multiple times was mainly … Read more