Home » sql server 2016

sql server 2016

sql server DBA 999

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 pipes provider could not open a connection to sql server 5 linked server

I have covered this error in another post as well which is here.

Cause of Error:

This error occurs when the SQL Server can’t be found on Network which means either IP address is not reachable or that the TCP port number … Read the rest

sql server DBA 999

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 all the rows in a table using the in-memory heap data structure used for storing the data.

2. SQL Server In-Memory OLTP -Transact-SQL/TSQL Improvements for memory-optimized tables

a.UNIQUE constraints and indexes are supported.
b.FOREIGN KEY references between memory-optimized tables are supported.
c.CHECK constraints are supported.
d. NULL values are allowed
e.Trigger’s are supported.

3. SQL Server 2016 In-Memory OLTP Storage format is now changed

In-Memory … Read the rest

sql server DBA 999

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 processing into SQL Server 2016 which is offered as a new feature that supports enterprise level data services.

What is R (Revolution) Services?

Revolution Analytics (formerly Revolution Computing) is a statistical software company focused on developing open source software for enterprise, academic and analytics customers. Revolution Analytics was founded in 2007. In 2009 the company received nine million in venture capital from Intel along with … Read the rest