Wednesday, 30 May 2018

Computed columns in SQL Server

›
Computed columns are type of columns which the values are derived based on one or more other columns. Hence the data type on the computed c...
Tuesday, 20 March 2018

Data Encryption in SQL Server using T-SQL Functions (ENCRYPTBYPASSPHRASE, DECRYPTBYPASSPHRASE & HASHBYTES)

›
Decade ago data was just an entity which helped business to operate smoothly. By then data was considered as some sort of business related i...
1 comment:
Saturday, 10 March 2018

Strange behaviour converting NVARCHAR(MAX) to BINARY

›
Few days back I was writing a CLR function to be used for hashing string values. The only option was the CLR functions since T-SQL doesn’t h...
1 comment:
Sunday, 3 December 2017

Behaviour of IDENTITY Columns and SEQUENCES with TRANSACTIONS

›
Few days back, I was caught in a discussion with couple of my colleagues, regarding a problem they are facing with an IDENTITY column. The i...
Tuesday, 18 October 2016

Always Encrypted feature in SQL Server 2016

›
With the introduction of SQL Server 2016 in June (Official Final Release), Microsoft had introduced few, new and very useful features in to ...
1 comment:
Sunday, 9 October 2016

Understanding JOINs in SQL Server

›
During my work I get the chance reviewing lots of T-SQL Procedures and Views and I often see that the SQL joins are mis-used in them. When I...
Thursday, 29 September 2016

Enable Code Lense feature on VS 2015 Community Edition

›
As per the Visual Studio 2015 feature comparisson between the editions, Microsoft has clearly mentioned that certain features will only be a...