SQL Server Admin Archives - Page 2 of 5 - SQL Server DBA - Dedicated Blog for all DBA and Developers

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…

SQL Server, SQL Server Admin, SQL Server Administration, SQL Server Errors Vamshi B March 31, 2017 @ 9:47 am

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

Microsoft SQL Server Error: 53 or Microsoft SQL Server Error: 11001 or or SQL Server error 53 and 40. SQL server error 53 and 17 Details of Error: Can not connect to SQL Server error which can be Error Number: 11001 or Error Number:53, Severity: 20, State: 0 or SQL Server error 53 and 40.…

Connectivity Issues, SQL Server, SQL Server Admin, SQL Server Administration, SQL Server Security Vamshi B February 24, 2017 @ 10:56 pm

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 Admin, SQL Server Administration, SQL Server Errors, SQL Server Security Vamshi B February 20, 2017 @ 11:40 am

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 Admin, SQL Server Administration, SQL Server Errors, SQL Server Security Vamshi B @ 10:48 am

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, SQL Server Admin, SQL Server Administration, SQL Server Architecture Vamshi B February 16, 2017 @ 7:20 pm

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…

In-Memory OLTP, SQL Server, SQL Server Admin, SQL Server Administration Vamshi B @ 5:22 pm

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…

New Features, Reporting Services, Revolution Analytics, SQL Server, SQL Server Admin, SQL Server Administration, SQL Server Architecture Vamshi B February 7, 2017 @ 8:16 pm

SQL Server Database Mail Configuration Step by Step

SQL Server Database DB Mail Configuration Step by Step: This Article will help Configuring SQL Server Database mail in SQL Server for Alerts and Notifications. Database Mail is very Useful and powerful ability in SQL Server. Send email in SQL Server is one of the best ability for monitoring SQL Server One can configure SQL…

Database Mail, Database Maintenance, SQL Server, SQL Server Admin, SQL Server Administration, SQL Server Alerts and Notifications Vamshi B September 19, 2016 @ 11:34 am

SQL Server 2014 Compared to older versions

SQL Server 2014 Compared to older versions Features Feature Description SQL Server 2014 SQL Server 2012 SQL Server 2008ÿR2 SQL Server 2008 Performance In-memory OLTP* Yes No No No In-memory ColumnStore* Yes Yes No No Buffer pool extension to SSD Yes No No No Resource Governor Yes Yes Yes Yes Availability AlwaysOn*…

New Features, SQL Server Admin, SQL Server Administration Vamshi B April 20, 2015 @ 1:49 pm

SQL Server 2014 released..New features

SQL Server 2014 released… Let’s discover what’s new in SQL Server 2014 now. There are versions in SQL Server out of which Express version is still free . Download SQL Server from Microsoft Site or your company volume licensing depending on your version you require. New features will be listed here which are really fantastic…. Note: Database…

SQL Server, SQL Server Admin, SQL Server Administration, Uncategorized VRB April 4, 2014 @ 9:35 am