SQL Server- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified

SQL Server- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified Error Details: this error message is often encountered when connection to a SQL Server is tried and don’t know where to start to solve the problem. We get this error message only when we are trying to connect to a SQL Server…

SQL Server- a network-related or instance-specific error occurred while establishing a connection to sql server

SQL Server- a network-related or instance-specific error occurred while establishing a connection to sql server Error Details or symptoms: Can not connect to a SQL server and you get a error a network-related or instance-specific error occurred while establishing a connection to sql server This error is seen in SQL Express installation as its installed…

SQL Server error 40 could not open a connection to sql server 2016

SQL Server error 40 could not open a connection to sql server 2016 Error related are: error 40 could not open a connection to sql server named pipes provider could not open a connection to sql server 53 invoke sqlcmd provider named pipes provider error 40 could not open a connection to sql server named…

Microsoft SQL Server Error: SQL SERVER – Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ‘)’ or msg 102 level 15 state 1 line 3 incorrect syntax near ‘ ‘

Microsoft SQL Server Error: SQL SERVER – Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ‘)’ or msg 102 level 15 state 1 line 3 incorrect syntax near ‘ ‘ Details of Error: This error message occurs if we use GETDATE() like function as a parameter to Stored Procedure or Function Statement.…

Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated

Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated Details of Error: String or binary data would be truncated. The statement has been terminated. This error message below occurs when part data is been truncated while loading a table. Actual error message: Msg…

MS SQL Server is going to be available on Linux platforms

MS SQL Server is going to be available on Linux platforms Microsoft has announced the plans to bring MS SQL Server to Linux which is going to be major one. Linux and other linux based platforms are widely used in today’s Cloud which is where this is going to fit. Satya Nadella’s leadership has made…

Microsoft SQL Server Error: 53 or Microsoft SQL Server Error: 11001 or SQL Server error 53 and 40. SQL server error 53 and 17

SQL Server Memory & Storage Technology

SQL Server- Understanding Server Storage Technology Explained First we need to understand the different types of memory below a.Static random access memory (SRAM) comprising L1 and L2 caches for each physical core of a processor,larger but slower shared L3 cache for the entire processor. b. Dynamic random access memory (DRAM) which also our RAM we…

SQL Server 2016 New Features In-Memory OLTP enhancements

SQL Server 2016 New Features In-Memory OLTP enhancements 1. SQL Server In-Memory OLTP – Parallel and heap scan for memory-optimized tables Memory-optimized tables and indexes in In-memory optimized tables are supported to parallel scan. This improves the performance of queries. Heap scan is also supported which can be performed in parallel which is scanning of…

Setup R Services for SQL Server 2016 Step by Step Explained

Setup R Services for SQL Server 2016 Step by Step Tutorial Microsoft purchased Revolution Analytics (around 2015) and with that they were able to give R Services which is the most popular open source programming language for advanced analytics of data inside of SQL Server bringing R processing closer to the data.. By adding R…