The feature “Scale out deployment” is not available in this edition of Reporting Services

When you migrate your SSRS installation to a new host or instance, additional records can get added to [dbo].keys in the ReportingServices database. This is the source of the error. Assuming you do not intend to use scale-out RS– in which case, you need to check the Edition you are installing– the solution is to delete all but the newest record. Keep reading…

AWS really does make the Pain of Purchasing Servers go away

I have thought a lot about how I used to provision traditional IT resources, and how differently I would provision Amazon Web Services resources in the cloud today. Maybe you can benefit from my perspective, based on experience, that keeps it plain and simple.

In the past, I had to think about how much hardware and software I could buy with a given budget. I would over-engineer the architecture, since I would have to live with it for several years. It was better to be safe with more than I could use, than be sorry trying to explain why the money already spent wasn’t enough. Building a whole test system up front to prove it would work would also increase costs, (more…)

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…