BigQuery to access data stored in AWS S3

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 offcourse data has to reside on storage within Google infrastructure…

Read details

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 development background. There are many documents available on this subject…

Read details

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. Roll back the transaction. Msg 22830, Level 16, State 1,…

Read details

AWS – Introduction – Part 1

AWS (Amazon Web Services) has been leader in providing Infrastructure services since 2006. You may read about AWS @ http://aws.amazon.com/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 to use AWS. If you are new to AWS and…

Read details

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 requires ZERO admin effort to host.

Tracer Token

Please note that I had authored this article originally for www.sqlservercentral.com 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 connections and helps in measuring latencies between the publisher, distributor…

Read details

Cassandra

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