Basic Patterns for Mobile Navigation September 12, 2016
Error 15581 – Please create a master key in the database or open the master key in the session before performing this operation June 19, 2015
Recently I was working with a client, when a unique issue was brought to my notice. As per the client, when they are tying to restore a TDE enabled database to another server, they cannot perform the restore using SSMS User interface. They were able to restore the database using T-SQL though.
Now this sounded a bit funny, but then the customer showed it to me. Since I did not have any answers at that time, I decided to try it out later and check and see if anything they are doing is wrong or not.
To begin with, I checked their scripts for enabling Transparent Database Encryption on the databases and also their backup scripts for the master key and certificates.
Sample code for the screen provided by the customer is provided below.
View original post 492 more words
SQL SERVER – Fix – Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) May 15, 2015
I got this error when trying to install Microsoft SQL Server 2012, on Windows 2008 Server Virtual Machine.
This error happened when I unzipped the iso file for SQL Server 2012 and ran Setup.exe manually.
The solution as mentioned in above page, is to load the iso file as image in cd/dvd drive on Virtual Machine and do installation.
I hope this will save time for you.
In praise of “boring” technology May 11, 2015
In this article I will explain how Spotify uses different mature and proven technologies in our backend service eco-system and architecture, and why we do so. In addition, this article will also attempt to explain when Spotify has chosen not to use certain proven technologies, the reasons why and the associated pitfalls associated with each.
More often than not, the right tool for the job is piece of software that has been around for some time, with proven success. One example would be writing a backend service in Java or Python instead of Go or Node.JS. Another example would be storing data in MySQL or PostgreSQL instead of MongoDB or Riak.
View original post 1,850 more words