Monday, 10 September 2018

Applying database principal through out the server (for all databases) for a particular user

›
Ever come across a requirement which you required to give db_datareader access to a specific user across all the databases on a particular S...
Friday, 6 July 2018

Replacing sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities

›
sp_depends have been one of the most used system stored procedures in SQL Server. Infact many of us still use that even though Microsoft had...
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...