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 ...
Thursday, 19 November 2015

Capturing and Analyzing deadlocks in SQL Server

›
Technorati Tags: SQL Server , SQL Deadlocks , Capture SQL Server Deadlocks No matter how perfect your code and how optimized the way you ha...
Monday, 26 October 2015

Elevate permission on a SQL login having read only access to Execute Stored Procedures and to View Database Schemas

›
Due to an unavoidable situation, it was decided that all the write access to a particular server (SQL Server) was required to be removed imm...