18

May

Azure HDInsight: How to run Presto in one simple step and query across data sources such as Cosmos DB, SQL DB & Hive

Source: https://blogs.msdn.microsoft.com/azuredatalake/2017/05/18/azure-hdinsight-how-to-run-presto-in-one-simple-step/   I have seen in past few months many inquiries on how to run Presto in HDInsight. In this post we have provided an easy way for you to install Presto in HDInsight as well as configure various READ MORE

17

May

Webinar with Datameer: Modern Data Preparation, Analytics and Insights – Key ingredients for an ML- and AI-ready organization

Source: https://blogs.msdn.microsoft.com/azuredatalake/2017/05/17/webinar-with-datameer-modern-data-preparation-analytics-and-insights-key-ingredients-for-an-ml-and-ai-ready-organization/   “Excited about using Big Data to build intelligent applications, but unsure of how to proceed?” Join me for a webinar with Andrew Brust (Senior Director at Datameer and a Microsoft Data Platform MVP) who specializes in this READ MORE

17

May

Try new SQL Server command line tools to generate T-SQL scripts and monitor Dynamic Management Views

This post was authored by Tara Raj and Vinson Yu, Program Managers – SQL Server Team

We are excited to announce the public preview availability of two new command line tools for SQL Server:

The mssql-scripter tool enables developers, DBAs, and sysadmins to generate CREATE and INSERT T-SQL scripts for database objects in SQL Server, Azure SQL DB, and Azure SQL DW from the command line. The DBFS tool enables DBAs and sysadmins to monitor SQL Server more easily by exposing live data from SQL Server Dynamic Management Views (DMVs) as virtual files in a virtual directory on Linux operating systems.

Read on for detailed usage examples, try out these new command line tools, and give us your feedback.

mssql-scripter

Mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS.

You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard *nix utilities (for example, sed, awk, grep) for further

17

May

SQL Server 2017 CTP 2.1 now available
SQL Server 2017 CTP 2.1 now available

Microsoft is excited to announce a new preview for the next version of SQL Server (SQL Server 2017). Community Technology Preview (CTP) 2.1 is available on both Windows and Linux. In this preview, we added manageability features to make it easier to configure SQL Server in Docker containers. We’re also introducing some new command line tools for managing SQL Server in our GitHub repo. And, there’s a preview of SQL Server Integration Services on Linux to try! You can try the SQL Server 2017 preview in your choice of development and test environments now: www.microsoft.com/sqlserver2017.

Key CTP 2.1 enhancements

The primary enhancement to SQL Server 2017 in this release is the ability to configure SQL Server configuration settings through environment variables passed in as parameters to docker run. This enables many of the SQL Server configuration scenarios in Docker containers such as setting the collation.

For additional detail on CTP 2.1, please visit What’s New in SQL Server 2017, Release Notes and Linux documentation.

SQL Server Integration Services on Linux

SQL Server Integration Services now supports Linux for the first time! Today we are also releasing a preview of SQL Server Integration Services for Ubuntu. The preview enables you to run

17

May

SQL Server 2017 on Linux surpasses 1 million Docker pulls as the next preview version rolls out

This post was authored by Rohan Kumar, General Manager, Database Systems Group

SQL Server 2017 makes it easier and simpler to work with data, with more deployment options than before and monthly preview releases offering regular innovation and improvements. The momentum behind these new options is clear. We are excited to mark a new milestone: Last week, SQL Server on Linux passed 1 million pulls of its container image! The image has been on Docker Hub for the six months since we first launched the SQL Server on Linux public preview in November 2016, with steadily growing customer use. In fact, we now have customers like dv01 going into production with SQL Server 2017 in Docker containers using the production support agreement from our Early Adoption Program (EAP). The container image is also available in the Docker Store, where it’s currently one of the featured images.

Customer interest in containers is high because of the benefits for production, and especially development and test: consistent and reliable behavior across environments, in a lightweight and easy- to-use format. Containers are fast to set up, can easily be stopped and started, and give users the ability to spin up multiple containers together using

17

May

Power BI Report Server preview now available
Power BI Report Server preview now available

Source: https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-preview-now-available/           On May 3, Microsoft announced Power BI Premium, a capacity-based licensing model that increases flexibility for how users access, share and distribute content. The new offering also introduces the ability to manage Power READ MORE

17

May

Today’s Webinar: Seven Tips to Better Visualization Design

Source: https://powerbi.microsoft.com/en-us/blog/today-s-webinar-seven-tips-to-better-visualization-design/           Join us this morning at 10 a.m. PT for the webinar, Simply Compelling – Seven Tips to Better Visualization Design, presented by Miranda Li. Today she’ll be presenting an introduction to visualization design, READ MORE

16

May

Democratizing AI Through Microsoft Certifications in Data Science & Machine Learning

Posted by Marla Michel, Senior Program Manager for Ecosystem Development & Training at Microsoft.

This blog is the first in a series where we will discuss several new certification exams for data professionals and the resources to prepare for them.

When individuals decide which certification to take, their decision is typically based on their role and – in this particular domain – their relationship with data and analytics. Common role or titles we encounter in our domain include data scientists, data analysts, data engineers, data architects and data developers, although by no means is this list exhaustive. What’s more, with the democratization of artificial intelligence, it is inevitable that almost all current and future data professionals will be using, or will need to be educated about, machine learning and artificial intelligence, and many will want to have certifications to prove their skills.

The Cortana Intelligence Suite is used today by many Microsoft customers who are building end-to-end business solutions, applying the very latest in ML and AI techniques on their big data. Indeed, this powerful set of technologies is all set to drive the next stage in our customers’ digital transformation. Companies and individuals around the world are

16

May

Keeping freight moving in Denmark with SQL Server 2016
Keeping freight moving in Denmark with SQL Server 2016

Efficient data management keeps goods flowing smoothly in Denmark. Danske Fragtmaend, the country’s largest national transport and distribution firm, has been moving freight for more than a century. Today, Danske Fragtmaend delivers more than 40,000 consignments each day throughout Denmark, and businesses from small mom-and-pop operations to factories rely on its services.

The firm handles logistics in a central location, where 200 dispatchers keep an eye on the movement of thousands of trucks and their cargo. Both drivers and dispatchers need the latest information to operate efficiently, so they rely on a data platform based on SQL Server 2016. The storage system includes 160 terabytes of flash memory for fast I/O and high uptimes. Throughout the day, drivers continually scan transactions with PDAs and send shipping information including GPS coordinates to the data platform. Fast access to information is essential. Ulf Preisler, chief information officer at Danske Fragtmaend, says, “When it comes to short-term logistics, you’ve got to think like an air traffic controller more than a traditional radio dispatcher.”

Because the data changes rapidly, asynchronous replication between geographically disparate datacenters was inadequate. Instead, Danske Fragtmaend runs SQL Server on Windows 2016. Windows Server 2016 introduces a new disaster

16

May

SQL Server Command Line Tools for macOS released
SQL Server Command Line Tools for macOS released

This post was authored by Meet Bhagdev, Program Manager, Microsoft

We are delighted to share the production-ready release of the SQL Server Command Line Tools (sqlcmd and bcp) on macOS El Capitan and Sierra.

The sqlcmd utility is a command-line tool that lets you submit T-SQL statements or batches to local and remote instances of SQL Server. The utility is extremely useful for repetitive database tasks such as batch processing or unit testing.

The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.

Install the tools for macOS El Capitan and Sierra

/usr/bin/ruby -e “$(curl – fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)”
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
brew install mssql-tools
#for silent install ACCEPT_EULA=y brew install mssql-tools

Get started

SQLCMD
sqlcmd -S localhost -U sa -P <your_password> -Q “<your_query>”

BCP
bcp <your table>in ~/test_data.txt -S localhost -U sa -P <your password>-d<your database> -c -t ‘,’
bcp <your table>out ~/test_export.txt -S localhost -U sa -P<your password> -d<your database> -c -t ‘,’

For more information, check out