Category: Data and Analytics

Consolidating Azure SQL Vulnerability Scan Reports Across Databases
As business today is increasingly advancing its online presence, the associated threats for security breaches is also looming larger and organizations are constantly looking [···]

How Azure Blob Storage is Redefining Big Data Platform?
As the Big Data landscape has evolved over the last decade, we have seen a gradual but a definitive shift in the design of [···]

A Complete Walkthrough of Azure Cosmos DB and Why Should You Use It
Azure Cosmos DB is Microsoft’s fully managed, globally distributed and horizontally scalable cloud service. It’s a multi-model NoSQL database that provides independent scaling across [···]

How to Change Linked Server Name in Stored Procedures
When we restore on-premise SQL database from one environment to another environment, we may need to change linked server names which exist in the [···]

Four Reasons to Deploy Microsoft Power BI in Your Enterprise
You may recall a recent blog where we talked about the importance of integrating a business intelligence (BI) strategy as part of your enterprise’s [···]

SQL Server 2016 In-Memory OLTP
With the release of SQL Server 2016 RC0, last month, I thought it would be pertinent to review the New Features and Enhancements being [···]

Retrieve Records in SSIS Script Task
You are developing an SSIS package. You want to work with a record in a Script Task. This blog discusses how you can get [···]

HBase – Overview of Architecture and Data Model
In this article, we will briefly look at the capabilities of HBase, compare it against technologies that we are already familiar with and look [···]

NoSQL Databases – A Primer
In this blog, I will be discussing about NoSQL databases, how different are NoSQL Databases compared with Relational databases, different types of NoSQL Databases.

Microsoft’s Big Data Strategy
A number of people thought that Microsoft was not paying much attention to the Big Data space and that all developments were happening in [···]

What is Big Data?
Big Data has been a topic of intense discussion and media hype during the last year or two. A number of people have asked [···]

How Search Based Applications solve ‘Big Data’ problems
Key facts: IDC estimates that in 2010 alone we generated enough digital information worldwide to fill a stack of DVDs reaching from the earth [···]