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...
‹
›
Home
View web version
