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 […]
SSIS – Starter kit for the uninitiated – Data enrichment
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 […]
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 […]
SSIS – Starter kit for the uninitiated Foreachloop – for each file enumerator
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 […]