Home » SQL Free Tools included

SQL Free Tools included

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 … Read the rest

The Activity Monitor in SQL Server Management Studio is a great tool which can be used by DBA’s and database developers to get a quick overview of SQL Server system performance and connections or in simple words it is one of the free sql server performance monitoring tools. The Activity Monitor tool in SQL Server older versions than 2008 used to display information related to Processes, Lock by Objects and Locks by Process. There are many enhancements in Activity Monitor in SQL Server 2008 onwards like graphical display of Processor Time, Processes, Waiting Tasks, Database I/O’s, Data File I/O’s,Batch Requests, Resource Waits and also information on most expensive queries.

It is Best SQL Monitoring software / Application which ships free … Read the rest