Better Triage: Getting hospital care delivered properly

If you have seen my recent posts on LinkedIn you probably know that I am looking to interact with healthcare professionals to brainstorm ideas on how Triage can be improved. In this post I will cover what Triage is and some common issues identified with the process and my attempt at a solution. I am…

SSIS – Starter kit for the uninitiated Data Flow Task

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…

A simple change that could save Millions of $$$ in Support services

I recently came across the below error message “An exception was thrown by Target of invocation” What it really means is the application you tried to run has reported an error. This got me thinking about how software has ignored one of the most important yet frustrating aspects of user experience. Easy to understand and…

SSIS – Starter kit for the uninitiated – Web Service Task

Continuing from the last post, we now configure the web Service task. If you visit the web service link you will see the below screen “http://free-web-services.com/web-services/geo/location-info/” Click the Link for Airport Information, it will take you to the below screen where you can find the URL for the web service.   Click the URL to…

Auto Update Statistics when does it occur

I was recently asked when does the actual Auto Update Stats trigger and while I know its during query compile I wasn’t exactly sure what the thresholds were so I did some RnD, the results are anyway well documented in the link in the references but I have still posted the results here because I…

TRACE FLAG 1118 – Proportional Filling and the tempdb

Often when conducting trainings I ask my participants not to take my word for it but try things out for themselves. I was asked a question about the TRACE FLAG 1118 during a recent training for SQL 2012 and wanted to bring attention to the discussion here. The participants had read in a blog that…

IS IT POSSIBLE? Bulk operations in Full recovery model

Here is the reason I am writing this post As per the above entry from MSDN, there cannot be any minimally logged operations in full recovery mode, which is what I have always understood since full recovery model requires point in time recovery. In order to understand my dilemma we need to first define what…

Clustered Index vs Unique Non Clustered Index, which is better performance while still maintaining integrity of the data?

At a training recently we were talking about improving ETL performance for a process that loads about 3 million rows. While the answer is typically to load the data after dropping the indexes, in this case they wanted to load the data with indexes since the data would then be needed to perform looks up…

Using MS SQL Server to work with assemblies (CLR)

A brand new video uploaded on YouTube on how to use CLR assemblies in MS SQL Server. Please share and like and we look forward to comments. https://www.youtube.com/watch?v=5sOlIIC-UXg Oops !!! we forgot the link last time BTW Did you check out our new website !!! built in 24 hours it reflects our new design philosophy

Helpful post on changing wordpress site file upload limit

Recently while migrating a client’s wordpress site from wordpress.com to Amazon AWS we encountered a peculiar problem which should not happen in the real wolrd. The client blog has been around for about a year and had a lot of content on it. When trying to import the content into the WordPress application we encountered…

Which is better Count (*) or Count (id)?

While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so I promised to write a blog about it. Coming right down to it, in almost all cases Count(*) is better. Typically you won’t be able to tell…

SQL Server DEV and SSDT – MINDTREE – CHN – DEC

Some feedback from the training What did you like most about the training? Knowledge on SQL Trainers end to end knowledge about the tool. Explained concepts with hands on. Came to know topic didnt know earlier. Trainer was able to explain the topics covered in training. Performance improvement only by basic stuff(e.g. index) Trainer is…