Monday, May 11, 2015

SQL Server and R Integration...

One of the most popular languages in the Data Science Paradigm is the R language, there are plenty of resources and online classes being offered with respect to the R language. Once of the main advantages with the R language is that it is open source and can be downloaded on multiple platforms such as windows/Mac/Linux, also there is a very popular IDE for R called the R-Studio. SQL Server has been expanding to get into different domains one of them now being is Data Science. in SQL Sever 2016 there are lot more integration promised between R and SQL Server. In the mean time there are ways to integrate between R and SQL Server, here is a blog article on Simple talk by SQL Server Expert Feodor Georgiev, the article is titled: Making Data Analytics Simpler: SQL Server and R.
https://www.simple-talk.com/sql/reporting-services/making-data-analytics-simpler-sql-server-and-r/.
The article also provides a brief overview of the R language.

Tuesday, May 5, 2015

SQL Server 2016 Preview...

I am not sure if I have dug enough into SQL Server 2014 but SQL server 2016 Preview is coming this summer. The pace at which technology has been evolving in DB/BI space has been amazing.
Here are some of the Features mentioned to be available in SQL Server 2016:
1. Always Encrypted:
2. Stretch Database
3. Real Time Operational Analytics & In-Memory OLTP
4. Built-in Advanced Analytics, PolyBase and Mobile BI

Additional capabilities in SQL Server 2016 include:
  • Additional security enhancements for Row-level Security and Dynamic Data Masking to round out our security investments with Always Encrypted.
  • Improvements to AlwaysOn for more robust availability and disaster recovery with multiple synchronous replicas and secondary load balancing.
  • Native JSON support to offer better performance and support for your many types of your data.
  • SQL Server Enterprise Information Management (EIM) tools and Analysis Services get an upgrade in performance, usability and scalability.
  • Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore your on-premises databases to Azure and place your SQL Server AlwaysOn secondaries in Azure.
Please refer to the following link for the full details:
http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/sql-server-2016-public-preview-coming-this-summer.aspx