Jun 122014
 
SQL Server Data Files in Windows Azure | Part-2

In first part we discussed this feature and analyzed whether we should use it or not, now let’s see some of the benefits before we’ll discuss the steps to implement it. Apart from being a wonderful & cool looking concept this technology also delivers many benefits like: 1. You get a centralized copy of data [Read More]

Jun 032014
 

This is a brand new technology which is introduced in SQL Server 2014, having said that believe me this is not something which is new to us – we’ve been using this technology since a long time in our daily life like: Streaming music files through internet or saving all your data on One Drive. [Read More]

May 262014
 
Lessons learnt by implementing Backup Encryption

We’ve already discussed Backup Encryption feature in detail, incase you’ve not covered those please find the link: Part-1Part-2Part-3   There are a few things you must know before you implement backup encryption in your environment, here I’ll try to list them: 1. Original Certificate which was used as an encryptor should be available at the [Read More]

May 192014
 
Backup Encryption | Part-3

In Part-1 we discussed the feature of backup encryption and part-2 walks us through the scripts to prepare for the pre-requisites and take an encrypted backup, In part-2 we took the backup of Repro_FGDN Database on MBTEST server. We took the encrypted backup using Certificate as an encryptor and used AES_256 encryption algorithm. In this [Read More]

May 132014
 
Backup Encryption | Part-2

In the first part we discussed the new feature of Backup Encryption which is introduced in SQL Server 2014, the post describes the benefits, restrictions, permissions required etc. Now let’s see this in action, the below mentioned scripts will generate Service Master Key, Database Master key and a Certificate which will act as an encryptor [Read More]

May 062014
 

We’ve been asking for this feature from a long time and it was one of the main reasons why third party tools were being used, they were minting money like anything. Thankfully Microsoft introduced this feature in SQL Server 2014, now you can encrypt the data while creating a backup at runtime and creates an [Read More]

Apr 292014
 

In the last post we discussed about the features of SQL Server Managed Backup to Windows Azure, how it is different from conventional backup schedules, how the backup and container gets named and based on what conditions SQL Server will initiate a Full\Transactional Log backup or skip it.   What are the benefits of using [Read More]

Apr 252014
 

SQL Server Managed backup is a new feature introduced in SQL Server 2014, this feature is simply outstanding – you don’t have to worry about the backup strategy anymore, this feature manages and automates the backup process. This feature uses sort of artificial intelligence – if you see at current scheduling features they just keep [Read More]