Sep 302016
 
 Posted on: September 30, 2016  Posted by  No Responses »
Benefits of using latest SSMS

Microsoft released a new version of SQL Server Management studio. This is an integrated environment for managing, administering, developing and accessing all components of SQL Server & offers all latest cloud feature integration. This is compatible with all supported previous versions of SQL Server starting from SQL Server 2008 till SQL Server 2016 & SQLAzure. [Read More]

Jul 202016
 
 Posted on: July 20, 2016  Posted by  No Responses »
Import Export of Column Master Key using CertMgr

Import Export of Column Master Key is a very critical step if your application is not hosted on the same database server. If not done properly the purpose of configuring Always Encrypted might get defeated. You must plan to keep your Column Master Key away from Database Server. This blog is for those who choose [Read More]

Jul 172016
 
 Posted on: July 17, 2016  Posted by  No Responses »
Always Encrypted Wizard Log Report

If you are also amazed at How Always Encrypted works for existing table then this blog may help you find some more details as to what really happens under the hood when we configure always encrypted for a table which has already got some data and how to get Always Encrypted Wizard Log Report. It looks like [Read More]

Jul 132016
 
 Posted on: July 13, 2016  Posted by  No Responses »
Configure Always Encrypted on existing table with data

In the First blog post, we understood the basic concept of Always Encrypted, different keys and the available Encryption types and then in the second post we saw different limitations and not supported column types in Always Encrypted. Now in this blog post let’s see how the actual implementation to see how to configure Always Encrypted [Read More]

Jul 112016
 
 Posted on: July 11, 2016  Posted by  No Responses »

In the last blog post, we understood the basic concept of Always Encrypted, different keys and the available Encryption types. In this blog post we’ll see different Limitations of Always Encrypted feature, in-case you want to move to actual Implementation steps click here to know how to configure Always Encrypted on existing table with data.   Tool Limitations SQL Server [Read More]

Jul 082016
 
 Posted on: July 8, 2016  Posted by  No Responses »

Always Encrypted is a new features introduced in Azure SQL Database and SQL Server 2016. Encryption is not new to SQL Server, it was introduced in SQL Server 2005 but this feature provides by far the best possible security for all those data owners who have outsourced the work to manage their servers to a [Read More]

Jun 072016
 
 Posted on: June 7, 2016  Posted by  No Responses »

MS introduced new Database scoped configurations in SQL Azure (V12) and SQL Server 2016; Need for new Database Scoped Configurations Have you ever faced a situation where one of the database requirements are totally different from other like MAXDOP settings and you wanted to set a different MAXDOP for a single DB; or you wanted [Read More]

Jun 062016
 
 Posted on: June 6, 2016  Posted by  No Responses »
How to get last used timestamp in SQL Azure database?

A timestamp is the time at which an event is recorded (inserted or updated), and timestamp is guaranteed to be unique in the database. So what will you do if for some reason you need to find the last used timestamp in SQL Azure Database? Well, the answer is @@DBTS function. @@DBTS This function is [Read More]

error: Content is protected !!