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…

Video for SSIS Starter kit

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…

SSIS – Starter kit for the uninitiated – Foreachloop

I was up at 3:00 AM in the morning and felt that the world needs to know where all the airports are and how you could use SSIS and PowerView to display this information in a clean and concise way. This need was so powerful that I spent the next 4 hours writing an SSIS…

Training DBA from other countries

Technology is a universal language so training DBAs from other countries is not really a challenge when covering technical aspects. But here are a few things to keep in mind. Time zones- lunch breaks are different for different people. Office hours – Availability of daylight usually impacts office hours and typically there is a difference…

Single Partition online rebuild in SQL 2014

If you have a large database then you probably have table partitioning implemented. While I have already blogged a lot about partitioning one feature that is really useful in SQL 2014 is the ability to rebuild an individual partition online. Previously for VLDB that contain partitions you either had to rebuild the index on the…

Bangalore – Bengaluru Slowly Changing Dimensions

I would like to introduce Type 6 EBS Modified SCD and get your feedback. I couldn’t find any documentation explaining this approach so I guess this is a first, please prove me wrong. So it’s finally happened Bangalore is now officially Bengaluru. Naturally this means a lot of the changes on the road and Highways…

Game Theory and Databases

CASE 1 Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with the other. The police admit they don’t have enough evidence to convict the pair on the principal charge. They plan to sentence both to a year in…

sys.dm_db_log_space_usage

Another DMV that is available in SQL server 2012 is the sys.dm_db_log_space_usage DMV, this DMV is useful when trying to decide the current state of the Log file. And if there is any use trying to shrink the database. This DMV could also help the DBA understand if the log file is constantly running out…