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 […]
SQL 2016 – Dynamic Data Mask –& Hacking the feature
After working with PHI for many years now, I can appreciate the importance of data masking. While normally the first approach is to encrypt the data it is […]
SQL 2016 – Stretch database in detail –CTP 2.3 screenshots with BOL corrected now
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 […]
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 […]
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 […]
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
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 […]