Tag Archives: CREATE

VM and IP Configurations

By | September 18, 2015

Recently there was a post on DB mirroring not working on a VM, in the post I had suggested checking the network connectivity and NIC configurations in the VM software since there are different ways that the VM software assigns IP to the Virtual devices. For the purpose of this post I am using VMware… Read More »

Combining Results from multiple datasets in SSRS – performance comparison

By | September 7, 2015

Recently at a training I was asked how to combine the results from two different datasets, while I have used this function before I couldn’t recollect how much of a performance difference it made to look up within SSRS vs performing the join directly with the dataset query. In this blog I try to find… Read More »

Lock, Latches, Waits and Deadlocks explained weirdly (like never before)!!!

By | August 27, 2015

When conducting MS SQL Server Trainings I often resort to weird examples to explain how certain things work. Over the years I have some favorites that I use over and over. The most disgusting by far would be the one I use to explain Locking, blocking and deadlocks. There are some definite advantages to doing… Read More »

SSIS – Fuzzy grouping task

By | August 18, 2015

It’s warm, fuzzy and brings similar data together helping correct typos, different titles for the same role and much more. Today I present a short video explaining how to configure a Fuzzy Grouping task within SSIS. It carries forward from my previous post on exporting LinkedIn contacts information to created Analytics on contacts information. The… Read More »

SSIS – Starter kit for the uninitiated Data Flow Task

By | August 7, 2015

In this post we explore how to use the DFT (Data Flow Task) to load data from an XML file into the database. For previous post on how we got till this step please click here. Step Screenshot Double Click and open the DFT we had added in the previous post. Drag and Drop an… Read More »

SSIS – Starter kit for the uninitiated Foreachloop – for each file enumerator

By | August 7, 2015

In this post we continue from where we left off in the last post, with the xml files now formatted properly it’s time to load the data into the database. To achieve this I am going to use the foreach loop container once more and this time use the for each file enumerator. Step Screenshot… Read More »