The fine print related to SQL Server 2014 in the April 2014 edition of the Microsoft’s Volume Licensing Product User Rights (Doc link) has some significant ramifications for punters who want to deploy their dev/test SQL Server environments to the cloud or want to have a passive SQL Server running in the Cloud.
Have you ever wondered why BI projects are so different to the traditional IT development projects?
I found this article 8 Ways that Business Intelligence Projects are Different (here) by Analytics8 that succinctly outlines the differences and what to watch out for when taking on a BI project.
I had a request from the client on how to enable SSL connections to their production SQL Server 2008 R2 instance to ensure that all network traffic between client application and related database is encrypted. The requirement came out of a PCI audit that dictated that Credit Card numbers should not be transported over the