Using Let’s Encrypt certificates for secure SQL Server connections

Let's Encrypt

Since December last year, the Let’s Encrypt initiative has gone into public beta. Let’s Encrypt is a free, automated, and open certificate authority, so you can easily get free official SSL certificates. Primarily it is focused on securing the web, but the requested certificate can be used for every server authenticating. I uses the certificate to encrypt my SQL Server connection and of course use it for Reporting Service.

How does it works

Let’s Encrypt provides certificates that are valid for 90 days. This stimulates the use of tools and scripts as no administrator is reassigning a new certificate every 90 days for each server. primarily Let’s Encrypt is focused on (Linux/Apache) websites,

Continue Reading

What about the future of BI

There is a shift going it the IT world: more and more applications are moving to the cloud. Recent examples, e.g. Office365, shows that the gap between the on-premise version and the cloud version are rapidly closing. Even the promise of Microsoft to put more and more effort in the development of cloud application: every Microsoft product nowadays is ‘cloud-aware’. The big question is: what about BI and the cloud. One thing I know for sure: it will come. Not completely sure is how, but I have an idea and that is the main reason why I started this blog and write this post.

The recent announcement of Microsoft the upcoming beta of SQL Azure Reporting shows the availability

Continue Reading