Saturday, October 21, 2017

Microsoft Access Database Engine 2016 Redistributable Setup - You cannot install the 32-bit version, You cannot install the 64-bit version

›
In order to access Excel workbook using Integration Services, one component we need to install is Microsoft Access Database Engine 2016 Re...
1 comment:
Friday, October 20, 2017

Azure Marketplace - SQL Server 2016 Virtual Machine - Data Tools cannot be installed

›
As you know, easiest way of getting a SQL Server set up in Azure is, purchasing a Virtual Machine in the Marketplace. There are multiple V...
Wednesday, October 18, 2017

tempdb becomes full when updating Clustered Columnstore index

›
I had a table with 3.5 billion records and wanted to update one column in all records. This table was not partitioned though the design sa...
Monday, October 16, 2017

SQL Server Always Encrypted - Serving applications using Azure Key Vault and Certificate Store

›
Here is my second video related to Always Encrypted. This video discusses the way of configuring CMK for serving multiple applications hos...
Thursday, October 12, 2017

Introduction to Always Encrypted

›
Here is my second video that speaks about Always Encrypted feature. This video shows How Always Encrypted works, how it should be configure...
Monday, October 2, 2017

Introduction to Azure HDInsight

›
I have written few posts on HDInsight and thought to make series of Video on it as well. Here is the first one, with this video, I discuss...
Monday, September 18, 2017

Self-Service Business Intelligence with Power BI

›
Author: Acuity Training - Training Provide for Excel Business Intelligence   Understanding Business Intelligence There was a time ...
Sunday, September 17, 2017

SQL Server 2016 - CREATE/ALTER PROCEDURE must be the first statement in a query batch

›
Everyone knows that SQL Server started supporting CREATE OR ALTER  statement with SQL Server 2016 and it can be used with few objects. How...
1 comment:
Wednesday, September 13, 2017

SQL Server TRY_CONVERT returns an error instead of NULL

›
Can this be happened? The functions TRY_CONVERT and TRY_CAST have been designed for handling errors and they should return NULL when the...
Tuesday, September 12, 2017

Run Hive Queries using Visual Studio

›
Once HDInsight cluster is configured, we generally use either the portal dashboard (Powered by Ambari) or a tool like PuTTY for executing...
Monday, September 11, 2017

SQL Server - Merging Partitions - Does it physically move data from a data file to another?

›
Partitioning is a common practice when maintaining large number of records in tables regardless of the database type: whether the database...
Sunday, September 10, 2017

How to refer files in HDInsight - Azure Storage using different ways

›
If you have started working with Big Data, you surely need to check the Microsoft support on it via Azure platform - HDInsight service. HD...
Friday, September 8, 2017

SQL Server - Dropping Primary Key will drop the Clustered Index?

›
Everyone knows that SQL Server creates a Clustered Index  when we add a Primary Key  if there is no Clustered Index  already exist in the ...
Thursday, September 7, 2017

Dimension with just one attribute - data warehouse design

›
Have you ever come across a situation where you have to design a dimension that has no attributes except the one explain the dimension its...
Wednesday, September 6, 2017

How to Connect HDInsight using Putty

›
I have written many articles on HDInsight Service which is an Azure service that allows us to provision Apache Hadoop Cluster and use it f...
Monday, August 14, 2017

Azure SQL Data Warehouse - Part II - Analyzing Created Databases

›
I started writing on this long time back but had no way of completing it. My first post on this was  Azure SQL Data Warehouse - Part I - C...