Tag Archives: start

Suspect MSDB and no Backups

By | September 18, 2015

Yesterday I got a call from a client about MSDB being suspect after a drive failure. Unfortunately the client didn’t have any backups. Now the correct and best option is to use a backup and restore the database. This way you don’t lose any of the jobs and other configurations that you may have set… 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 »

Climate change, the Ozone the scientific method and ignorance

By | August 16, 2015

With the recent climate change talks getting less news coverage than previous years I thought I would revisit some data aggregated over the last year. The data basically contains temperature and rainfall measurements for India over a 100 year time period. The problem with the recent trends in Climate change have to do with the… Read More »

Video for SSIS Starter kit

By | August 11, 2015

A video explaining all the tasks (control flow and data flow) for the SSIS series for beginners. https://www.youtube.com/watch?v=zrarG-cU4RQ Here is the list of blogposts that contain the complete list of steps. http://enabledbusinesssolutions.com/blog/ssis-starter-kit-for-the-uninitiated-foreachloop/ I am waiting to modify the package to perform a few additional tasks. If you need the code urgently, please PM me and… Read More »

SSIS – Starter kit for the uninitiated – Data enrichment

By | August 10, 2015

In this last post (after which there will be a video explaining how to bring all this together in Power view) I cover how to convert geo coordinates from 38° 53′ 55.133″ N to Decimal Coordinate system 38.898648. You can find the previous posts here. The calculations is fairly simple the sql for it is… 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 »

SSIS – Starter kit for the uninitiated – Execute process task and PowerShell

By | August 4, 2015

In this fourth part of the series (see previous post here) we proceed to modify the XMl files downloaded from the web service. While this step is not mandatory in most cases where the XML is well formed, in this particular example we see an issue with the file. Namely < And > text is… Read More »