SSIS – Starter kit for the uninitiated – Dynamic File Paths

Continuing from our previous post here we explore how to configure tasks to behave dynamically. More specifically how to configure the file connection manager to accept dynamic paths to store the output of our web service task. Navigate to the connection managers in the bottom pane of SSIS and right click the Connection manager we…

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…

SQL 2016- Live Query Stats

I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 there is a feature called Live Query Stats being introduced. As its name suggests it provides details on the actual tasks being executed in real time. What…

SQL 2016- Activity monitor – Active Expensive Queries

Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. However I would still hope that everybody is familiar with using sys.dm_exec_requests Plenty of new option popping up all over Management Studio get exploring.

OStress.exe – use it if you aren’t already

I was recently trying to simulate the performance implications of hashing vs encryption and wanted to simulate hundreds of sessions and 1000’s of requested on a username/password table. Most time developers and testers use a test harness for automating this kind of activity or use a load testing tool. I however am not a tester…