How to migrate a Microsoft SQL database back to an older version of SQL

There are situations where you might need to migrate newer-version SQL Server databases to older versions of the MSSQL engine, such as in various QA or testing scenarios, or after an upgrade that for any number of reasons calls for a rollback but needs to keep existing data. Unfortunately, backup/restore does not work when going from a newer to an older version of Microsoft SQL Server– it is not possible to restore a SQL 2012 database backup into a SQL 2005 server, for example. So in order to accomplish this, we have to take a different approach. Keep reading…

Pay the Piper – Software Licensing and Audits

Once upon a Wikipedia safari, I found myself sucked into the article on the Pied Piper of Hamelin. I read that contrary to popular belief, the expression “pay the piper” actually comes not from the Pied Piper, but from the phrase “He who pays the piper calls the tune.” You learn something new every day, I thought to myself. You see, over the years, I have advised employers, clients, and contemporaries that when it comes to software licensing, it is best to “pay the piper.” It was an expression I learned as a kid in the Boston area. Keep reading…

“http 401.1 Access denied” error after Dynamics CRM 2015 upgrade

We found a case where after upgrading a Microsoft Dynamics CRM 2013 on-premise installation that uses Windows Authentication to Microsoft Dynamics CRM 2015, even the Deployment Administrator started getting

http 401.1  Access denied

The upgrade process runs fairly easily (after you back up your encryption key Keep reading…

FRESH orange juice will go with hot sauce, donuts, OR toast!

Logical processing order (a.k.a. binding order) of a SELECT query in Microsoft SQL Server T-SQL is fundamental.  This is because it has direct bearing on what results (data) you get, which is the whole reason for querying in the first place.  Unfortunately for us, it looks almost nothing like the order we have to remember to use when writing T-SQL syntax.  Keep reading…