Best Practices for SQL Server Deployment in Healthcare

Though this article is specific about SQL Server security in health care,  we can apply the same principals for other environments as well,

Read more at http://healthitsecurity.com/news/best-practices-for-sql-server-deployment-in-healthcare

SQL Server 2017 to add Python support

One of the major announcements from Data Amp event was that SQL Server 2017 will add Python as a supported language.

Read more at http://blog.revolutionanalytics.com/2017/04/sql-2017-python.html

Magic Quadrant for Data Management Solutions for Analytics

Microsoft was leading in the Gartner quarter for while and Oracle was not promising in this. However, with the 2017 results, landscape has changed.



You can read the details at https://www.gartner.com/doc/reprints?id=1-3T5J67S&ct=170209&st=sb

Microsoft Brings New Capabilities to HDInsight and DocumentDB

Microsoft is headed to San Jose this week where they will be announcing new features for HDInsight and DocumentDB at Strata Hadoop + World. Additionally, the company is also announcing a new preview for SQL Server as well.

DocumentDB is Microsoft’s fully-managed NoSQL database service that is designed to help developers build highly scalable applications. The service, which offers guaranteed single-digit millisecond low latency at the 99th percentile, is adding support for Apache Spark.

Read more at https://www.petri.com/microsoft-brings-new-capabilities-hdinsight-documentdb

 

Confused with Big Data, Data Science and Data Analytics

Often people confused with Big Data, Data Science and Data Analytics. Are they same or different.
This link will give you an idea about what are they, what skills you need and what are the salary levels.

Read more to get further details https://intellipaat.com/blog/compare-big-data-data-science-data-analytics/

The Future of Managing Databases in a Hybrid IT World

When you work in information technology long enough, you get to see how people react when something new comes along. Some people embrace change, even to the point of being an early adopter. Others might use a wait-and-see approach. And then there is the group of people who are afraid of change in any form. 

Read more at http://sqlmag.com/sql-server/future-managing-databases-hybrid-it-world

DB-Engines Ranking

It is very common to compare the databases for marketing or for fun. http://db-engines.com/en/ranking has done the ranking for the database engine.

SQL Server has the major gain while Oracle has the major slip though it is still gaining the number one position. Following is the trend for the ranking of Database Engine. 

Point in Time Recovery with SQL Server

Read my latest article on Point in Time Recovery. 
http://www.sqlshack.com/point-in-time-recovery-with-sql-server

Azure SQL Data Warehouse with Improved Loading and Monitoring in Azure Portal and SSMS

Azure SQL Data Warehouse has received some significant changes in the Azure Portal, including Azure Data Factory integration, a new troubleshooting blade, and changes to the query drill-down blade

Read more https://winbuzzer.com/2016/12/20/microsoft-updates-azure-sql-data-warehouse-improved-loading-monitoring-azure-portal-ssms-xcxwbn/.

Microsoft R Server 9.0 now available

Microsoft today announced the availability of R Server 9.0 on MSDN and Visual Studio Dev Essentials. This new release is built on top of the latest open source R engine, and comes with several new capabilities. In MRS 9.0, you can combine the algorithms delivered in this package with pre-existing parallel external memory algorithms such as the RevoScaleR package as well as open source tech like CRAN R packages to deliver the best predictive analytics.

Read more at https://mspoweruser.com/microsoft-r-server-9-0-now-available-download/

http://www.cio.com/article/3147822/analytics/microsoft-pushes-r-sql-server-integration.html