21

Sep

SQL Server PolyBase supports Hadoop.rpc.protection
SQL Server PolyBase supports Hadoop.rpc.protection

This post was authored by Casey Karst; Program Manager II; Data Systems.

We are pleased to announce that PolyBase in SQL Server 2016 and later can connect to Hadoop clusters with the hadoop.rpc.protection configuration set to Integrity, Privacy or Authentication. By default, PolyBase uses the Authentication setting, but to connect to more secure Hadoop clusters Integrity or Privacy are needed.

Supporting this configuration allows PolyBase to connect and query Hadoop clusters that have wire encryption turned on. This enables a secure connection between Hadoop and SQL Server; as well as, among the Hadoop Data Nodes.

To connect to a Hadoop cluster with the hadoop.rpc.protection set to privacy or integrity, you will need to alter the core-site.xml file that is installed with PolyBase. This file is generally found at C:Program FilesMicrosoft SQL ServerMSSQL13.MSSQLSERVERMSSQLBinnPolybaseHadoopconf.

In order to use the new configuration, you will need to add a new property with the name hadoop.rpc.protection and a value of either privacy or integrity. These values must match the hadoop.rpc.protection configuration on your Hadoop cluster.

<!– RPC Encryption information, PLEASE FILL VALUE IN ACCORDING TO HADOOP CLUSTER CONFIG –> <property> <name>hadoop.rpc.protection</name> <value>privacy</value> </property>

Note: When changing XML files, please ensure that you input the correct

20

Sep

Backup Compression for TDE-enabled Databases: Important fixes in SQL 2016 SP1 CU4 and SQL 2016 RTM CU7

Source: https://blogs.msdn.microsoft.com/sql_server_team/backup-compression-for-tde-enabled-databases-important-fixes-in-sql-2016-sp1-cu4-and-sql-2016-rtm-cu7/   Backup Compression and Transparent Data Encryption (TDE) have been two immensely valuable and popular features for customers in SQL Server. In SQL Server 2016, backup compression was enabled for TDE databases where if you backup a TDE READ MORE

20

Sep

Invoking Azure ML Web Services from Excel, Using Power Query
Invoking Azure ML Web Services from Excel, Using Power Query

This post is authored by Amita Gajewar, Senior Data Scientist at Microsoft.

Problem Statement

Microsoft Azure Machine Learning Studio lets data scientists build machine learning models for a variety of problems that require predictive analytics capabilities. The Studio publishes these models as web services which can then be invoked via REST APIs, i.e. to send it data and get back predictions.

For business analysts who spend a lot of time manipulating and visualizing data in spreadsheets, it would very useful to be able to invoke an Azure ML web service from right within that environment, by passing in appropriate parameters and have the results populated back into the spreadsheet. To go one step further, they would be able to process and format the returned results, before displaying them in tables or charts.

In this post, we explain how to accomplish this using Power Query and macros within Excel.

Power Query provides a method to query, combine and refine data across a wide variety of sources including databases, the web, Hadoop and more. For illustration purposes, I create a Power Query to invoke an Azure ML web service that forecasts various financial metrics (e.g., revenue, EPS, etc.) for the 30 Dow

19

Sep

Managing Pipeline & Recurring Jobs in Azure Data Lake Analytics Made Easy

Source: https://blogs.msdn.microsoft.com/azuredatalake/2017/09/19/managing-pipeline-recurring-jobs-in-azure-data-lake-analytics-made-easy/   Azure Data Lake Analytics (ADLA) is a big data job service that enables you to develop and run data transformation and processing jobs over petabytes of data. With no clusters or servers to provision or manage, you READ MORE

19

Sep

Five ways edge computing will transform business
Five ways edge computing will transform business

Source: https://blogs.microsoft.com/iot/2017/09/19/five-ways-edge-computing-will-transform-business/     The Internet of Things (IoT) has been called “the mother of all infrastructures”—and it’s a revolution that has arrived. IoT is no longer just a niche solution for a handful of businesses but a core technology READ MORE

18

Sep

Power BI Developer community September update
Power BI Developer community September update

Source: https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-september-update/           This blog post covers the latest updates for Power BI Developers community. This includes Power BI Embedded updates, changes to custom visuals and R, and improvements to Row-Level Security.

17

Sep

Getting Started with Azure Analysis Services Webinar Sept 21
Getting Started with Azure Analysis Services Webinar Sept 21

Source: https://powerbi.microsoft.com/en-us/blog/getting-started-with-azure-analysis-services-webinar-sept-21/           The Azure Analysis Services team would like to help you get started with this exciting new offering that makes scaling Business Intelligence solutions easier than ever.

15

Sep

On-premises data gateway September update
On-premises data gateway September update

Source: https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-september-update/           We’re very glad to announce that the September update for the On-premises data gateway is now available for download. This update includes the following enhancements: Personal Mode support for…

15

Sep

Don’t miss the Timeline Storyteller custom visual contest!
Don’t miss the Timeline Storyteller custom visual contest!

Source: https://powerbi.microsoft.com/en-us/blog/don-t-miss-the-timeline-storyteller-custom-visual-contest/           Don’t forget: there’s only a few days left to enter the Timeline Storyteller custom visual contest! You could win a Power BI Super Swag Prize Pack. To enter, publish a report in the READ MORE

15

Sep

Power BI in action: using custom connectors
Power BI in action: using custom connectors

Source: https://powerbi.microsoft.com/en-us/blog/power-bi-user-group-custom-connector/           Power BI User groups (PUG) are groups for great people like you (yes, you reading this!) to get together with other awesome people to talk, discuss, and share experiences, questions, and more around READ MORE