The MERGE Statement – One Statement for INSERT, UPDATE and DELETE

Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant...

T-SQL HOST_ID and HOST_NAME

HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...

Clustered Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”)

Continuation from the previous 50 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This post is dedicated to usage of...

How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server

Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...

How index gets dropped in Views in SQL Server

Hi Friends, In this blog I am going to tell about dropping of indexes in view in SQL Server. Views...

Heraflux is Hiring

I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development....

On Failure: On Being a Screw-Up

“He’s a screw-up. Always trying things that don’t work.”
I’ll be honest: I used to be afraid of being the person...

On Software and OS Lifecycle Management

An Important Rule: 
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...

Overview of the data visualization books by Stephen Few

I recently finished the book Now You See It: Simple Visualization Techniques for Quantitative Analysis by Stephen Few of Perceptual...

SQLSaturday#380 NYC Event Update - Pre-cons Announced!

Welcome to SQLSaturday #380 - Precons Announced!

In addition to the extraordinary extravaganza SQLSaturday NYC event we have planned for Saturday, May...