Step 1 – Ensure your EC2 instance is running Step 2 – Get EC2 instance name or public ip . Step 3 – Locate your Key Pair ( you must need keypair to connect to AWS services programmatically ) Step 4 – grant sufficient access chmod 400 myKeypair.pem Step 4 – ssh to your ec2… Read More How to connect AWS EC2 instance through terminal
input [a,b,c,d] [b,c] [f,g,h] output a b c d b c f g h with NS AS ( select 1 as n union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9… Read More Redshift – How to flatten JSON data in redshift
Issue – Where Replication Agents job Locate Resolution – While troubleshooting replication issue; it’s always good to know which server have which job. In transnational replication scenario. Snapshot agent Log Reader agent Distribution agent If Publisher and Distribution Server is same and you have configured Push subscription; all the job reside Publisher\Distributor server. If Publisher and… Read More Replication – Agents Job Location
Issue – Replication Monitor could not open the Detail Window. Cause – When you have SQL 2012 as a Publisher and distribution as SQL 2014 and when you try to launch replication monitor through SQL 2014; you will get this error message. Resolution – Launch replication monitor through SQL 2012 i.e. Publisher
Issue – Replication Log Reader agent was failing with below error messages. 2018-04-24 19:33:07.854 Status: 32768, code: 53044, text: ‘Validating publisher’. 2018-04-24 19:33:07.873 Status: 4096, code: 20024, text: ‘Initializing’. 2018-04-24 19:33:07.873 The agent is running. Use Replication Monitor to view the details of this agent session. 2018-04-24 19:33:07.879 Status: 0, code: 20011, text: ‘The process… Read More Replication Issue – Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.
Issue – My BI developer informed me; They are no longer able to connect oracle data sources they have created in their cube. Troubleshooting – As I am aware; In order to connect to Oracle; you should have oracle client installed properly. As it was working earlier hence my first impression was; they definitely have… Read More Issues related to Oracle Client in SQL Server.
Issue – How to create ODBC connection from text file. Resolution – Step 1 – Create the text file and ensure extension is enabled. Step 2 – If you don’t know how to enable extension. select your file ( in my case odbc ) and click on view on Top Navigation bar and select File name… Read More How to create ODBC connection from text file.
