BigQuery to access to data stored in AWS S3 — Part 1

BigQuery, a google's product that can enable data users to perform interactive analytics on massively large datasets within Google Cloud Platform (GCP). It is very similar to Redshift from AWS, DashDB from IBM but it is serverless. In order to use it, GCP account is needed and […]

[Amazon](500310) Invalid operation: CREDENTIALS argument is not supported when loading from file system

Sometimes, we missed to notice reason for an error with small oversight. That's what exactly happened with me when I was loading data from S3 to Redshift. I researched on google to find out an answer and had no luck. Finally, I realized the mistake […]

Writing Stored Procedure in Netezza

Intent of this article to help those who want to write stored procedure with multiple DML operations and do not have SP development background using Netezza. I did not find any article that could help new developer to write stored procedure in Netezza with OLTP […]

Unable to enable CDC

Problem: Unable to enable CDC due to either of following errors even when database owner is SA. Error Description #1 Msg 3930, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 178 The current transaction cannot be committed and cannot support operations that write to the log file. […]

AWS – Introduction – Part 1

March 5, 2015 by Cloud Services No Comments

AWS (Amazon Web Services) has been leader in providing Infrastructure services since 2006. You may read about AWS @ Intent of this video is to introduce you with AWS and provide high level introduction to some of the key services that you may need if decided […]

AWS – Redshift

Amazon Redshift is one of the leading DWH solution in cloud which is fast, and fully managed data warehouse solution based on shared nothing parallel processing columnar store database that supports columnar compression. Like any other services with AWS, Redshift is also fully managed system that […]

Tracer Token

Please note that I had authored this article originally for that was featured in "Best of SQLServerCentral, Volume 6". SQL Server 2005 has lot of new and improved components, and the Tracer Token in replication is one of them. It allows us to validate […]


Non Relational (NoSQL/BigData) database systems are designed to address 3V (Variety, Velocity, Volume) of data with high availability and scalability without compromising perfomance. In this short presentation, you will get to know few important facts about non relational database systems, theory behind it and main focus around Cassandra.

Database Unit Testing – SQL Server – Part1

Microsoft introduced SQL Server Data Tools with Visual Studio 2010 and bundled improved version with Visual Studio 2013 which can be used by Database Developer to perform Database Unit Testing.  Lets look at following presentation:[…]

Attempted to read or write protected memory while connecting to SQL Server

Error can be resolved by either of followings: netsh winsock reset if 1st option does not help then try instruction available at