Refactoring Existing Code and the Double Check In
The topic of refactoring code was brought up during our development team meetings concerning coding standards. In this post I will summarize the point I made in that meeting here using......
SQL Management Studio 17.1
Starting in 2016 SQL Server Management Studio got its own team at Microsoft and after many years of very little improvement we are starting to see some pretty consistent......
On Extrapolation
This week I did not have time to fully prep a blog post so I thought I would pass along this little graphic I have had logged in one note......
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......
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......
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......
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......
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......
Cerner and American Well to Embed Telehealth Capabilities into Cerner EHR
This week I thought I would post this news release that I came across on Telehealth related to Cerner for those that may not have seen it. November 14, 2016......
When is Select * ok
Generally speaking SELECT * should be avoided. There are multiple reasons for this, including: Requesting columns you do not need may force the optimizer to use more objects than needed......