Monthly Archives: July 2017

Connecting to a Pre-SQL 2012 SSIS Instance with SQL 2012 SSMS

I was recently trying to do some development work with SSIS. I had SQL 2012 installed on a development VM and had issues connecting to an SSIS 2008 R2 instance on a different server. You can either install multiple versions...
Continue Reading →

Andy Null and Data Cleansing Fun

Have you ever thought of changing your name to “Blank Null”? Would you still have to pay taxes? Could you even get a job? How many report writers and ETL cleansers would classify you as bad data and toss you...
Continue Reading →

SQL Server 2017

Well it seems like just yesterday (well maybe a year ago) that we were talking about SQL 2016. With Microsoft’s Azure first strategy it seems that we may be back to more frequent releases than every 2 years for on-premise...
Continue Reading →

Health Care Providers Must Stop Wasting Patients’ Time

I read a thought provoking article from HBR last weekend and thought I would share it. It starts… In 2014 Jess Jacobs, a director in an innovation lab, started blogging about her experience as she received treatment for two rare...
Continue Reading →

SSMS 2017 CTP2 is not compatible with VS 2013

If you were like me and wanted to get SSMS 2016 to connect to later versions of SQL server or Azure you probably went to the SSMS 2016 page to get it. However,  the download package they actually give you...
Continue Reading →