Azure Data factory’s “Copy Activity” has an option for using PolyBase to achieve best performance for loading data into Azure Synapse (formerly Azure SQL ...
Dear Readers, It has been more than two years since my last post was published. A company who originally motivated me to start blogging and learn with technical community, now ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
[vc_row][vc_column][vc_column_text]Error can be resolved by either of followings: netsh winsock reset if 1st option does not help then try instruction available at ...
Scenario: Installed SQL Server Enterprise Edition 2008 database engine along with Integration Service on four node clusters running on Windows Server 2008 . I am unable to ...