I have heard the word Gamificaiton a lot in recent time. This buzzword has been in the air since quite some time and I had this in my mind to explore what is this and what it is all about? I explore this and writing it here from a very basic point of v...

Here are the seven Demo’s that I had posted over the past few weeks, listing them here: Detecting invalid values in Price domain or unrealistic values in Height domain How to standardize data using DQS How to clean records using third-party refere...

Problem The SQL Server Database Engine returns the following error message after a service broker enabled database is restored to the same SQL Server instance with a different database name and the T-SQL command (ALTER DATABASE ‘DatabaseName’...

Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated with the database users do not automatically relocates to the new instance. As a result of this, we end up having orphaned users ins...

In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows Azure SQL database, which is a cloud-based relational database platform that is built on SQL Server technologie...

This post is in continuation towards our learning Google BigQuery. In last few posts we covered What is Google BigQuery and how to create dataset and BigTables. In this post we will learn how we can read data from Google BigTables using Google BigQuery?...

Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL Profiler trace events, Extended Events and Event Notifications. Of these options Extended Events are the most efficient, lowe...

This article describes how to extend the Simple Injector with convension based configuration for primitive constructor arguments.When working with dependency injection, services (classes that contain behavior) depend on other services. The general ide...

When it comes to writing maintainable software, there is no alternative to the five core principles of object oriented design. When software is based on these principles, everything becomes significantly easier. When your software is based on these pri...

This article is in continuation to the last article What is Google BigQuery.Once your access to Google BigQuery is enabled and your billing details are setup, you are all set to store data into Google cloud. The data stored in these BigTables can be acc...