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 ...
Thursday, 3 March 2016

Extracting Date (Excluding Time) from a DateTime value in SQL Server

›
  SQL Server supports many data types where we can store the Date along with the time, such as DateTime SmallDateTime DateTimeOffset D...
Tuesday, 16 February 2016

Index REBUILD vs. REORGANIZE in SQL SERVER

›
Couple of days back there was an interesting statement (or rather a question) was brought up by one of the colleagues in the company. Ultima...
Wednesday, 20 January 2016

Error accessing Oracle Database Objects via Linked Server in SQL Server (The OLE DB provider "OracleOLEDB.Oracle" for linked server reported an error. Access denied.)

›
In one of the project we are working these days, there was a requirement to fetch some details, directly from the Oracle Database via VIEWS...
Wednesday, 25 November 2015

Analyzing SQL Server Error Logs / Agent Logs using T-SQL

›
Even though you design our SQL Scripts with the best methods using best practices, or configure the SQL Server to perform correctly and in ...
Sunday, 22 November 2015

Enabling Instant File Initialization in SQL Server

›
Technorati Tags: MicroSoft SQL Server Every time the SQL data file or log file expands, it fills the newly allocated (expanded) space with ...