If you have been following the buzz around MS SQL 2016 you would surely have heard of Stretch database. The concept is interesting and new and probably something […]
The History of War Analyzed
War is an ugly topic, but I wanted to know if we have learnt anything from history and so I downloaded the data for all the wars since […]
Combining Results from multiple datasets in SSRS – performance comparison
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 […]
Training MSBI – Wells Fargo – HYD
On the road once again, this time HYD for MSBI training in Wells Fargo. Looking forward to delivering some new content.
administration / MSSQL / TSQL
Lock, Latches, Waits and Deadlocks explained weirdly (like never before)!!!
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 […]
SQL 2016 -Row level security misuse: – Visual Totals in SSAS
Ever since I heard of Row level security I have been wanting to try it out. Not the usual stuff that I was sure MS would have already […]
Security: Capturing additional login information Trace vs Audit
Recently on a popular SQL Server forum as well as commonly during my trainings people ask about how to get additional security information about logins. Most often the […]
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 […]
SSIS – Fuzzy grouping task
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 […]
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 […]