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...
Wednesday, 7 September 2016

Native JSON Support in SQL Server 2016

›
When it comes to modern web development, JSON is one of the well known technologies when you require to exchange information between differe...
3 comments:
Tuesday, 23 August 2016

DROP IF EXISTS in SQL Server 2016 (DIE)

›
  Prior to SQL Server 2016, when we need to drop a SQL Object, it's the best practice to check whether the respective object exists or ...
Saturday, 13 August 2016

Connecting to an MS SQL Instance using NodeJS (Fixing ConnectionError: Port for SQLServer not found in ServerName & Failed to connect to localhost:undefined in 15000ms)

›
After few debates and discussions on new technologies in the market and how to adapt to them, during the weekend I thought of exploring Node...
1 comment:
Wednesday, 9 March 2016

String or binary data would be truncated / Arithmetic overflow error converting numeric to data type numeric – Workaround

›
  There’s nothing more annoying than getting the error ‘String or binary data would be truncated’ or ‘Arithmetic overflow error converting ...