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…

SQL Server Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14

SQL Server Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14 Details of Error: Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates…

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

Login failed for [SQLSTATE 28000] (Error 18456) the step failed SQL Server

Login failed for [SQLSTATE 28000] (Error 18456) the step failed SQL Server Details of Error: Executed as user: Domain\LoginName. Login failed for user ‘Domain\LoginName’. [SQLSTATE 28000] (Error 18456). The step failed. or below ODBC Data Source SQL Server Connection – Login Failed For User Connection failed: SQLState: ‘28000’ SQL Server Error: 18456 [Microsoft][ODBC SQL Server…

SQL Server Error: 18456 Severity: 14 State: 12 Connection Error

SQL Server Error: 18456 Severity: 14 State: 12 Connection Error Unable to Connect to SQL Server Due to Error: 18456, Severity: 14, State: 12 Details: SQL Server Error: 18456 Severity: 14 State: 12 or Error: 18456, Severity: 14, State: 12 Login failed for user ‘Username’ issue is caused by permissions issue. The following error appears…

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…

SQL Server Tsql CTE Common Table Expressions

CTE: CTE’s (SQL Common Table Expression ) are more like temporary views than anything else. When you look at the execution plan, you’ll see that they are substituted/inlined into the query but not materialized and stored anywhere. With the exception of recursion, they’re more to make queries simpler to write than faster to run. CTE: CTE’s…

SQL Server TSQL Table Variables

Table Variables In SQL Server: These tables behave very much like other variables in their scoping rules. They are created when they are declared and are dropped when they go out of scope. They cannot be explicitly dropped. Like with temp tables, table variables also reside in TempDB. They are also generally accessed only from…