Author : All posts by ilikesql

21

Jan

Test the latest features with SQL Server 2017 Developer Edition

Are you curious how new capabilities in SQL Server will impact your applications? Download and test SQL Server 2017 Developer Edition, a full-featured free edition, licensed for use as a development and test database in a non-production environment. You can browse and access SQL Server code samples at GitHub, and when youre ready, check out your options to move to production.

With SQL Server 2017, you can build modern applications using the language of your choice, on-premises or in the cloud, on Windows, Linux, and Docker containers. Your mission-critical programs will benefit from industry-leading scalability, performance, and availability. And SQL Server 2017 is the only commercial database with AI built-in, enabling you to build intelligent applications using scalable and highly parallelized R and Python. Read the datasheet and white paper for more details.

If youre a Linux developer, SQL Server 2017 brings the database you want to the platform you loveand dont just take our word for it. Browse technical FAQs from your peers in our quick start guide.

SQL Server 2017 Developer Edition does not include a licensed OS, such as a license for Windows 10 included on a new laptop. 90 to 180 day free trials of Windows

Share

21

Jan

Export data in near real-time from Azure IoT Central
Export data in near real-time from Azure IoT Central

We are happy to share that you can now export data to Azure Event Hubs and Azure Service Bus in near real-time from your Azure IoT Central app! Previously, Continuous Data Export enabled exporting your IoT Central measurements, devices, and device templates data to your Azure Blob Storage account once every minute for cold path storage and analytics. Now you can export this data in near real-time to your Azure Event Hubs and Azure Service Bus instances for analytics and monitoring.

For example, an energy company wants to understand and predict trends in energy consumption in different areas over time of day and throughout the week. With electrical equipment connected to IoT Central, they can use Continuous Data Export to export their IoT data to Azure Event Hubs. They run their deployed machine learning models to gain insight over consumption and perform anomaly detection by connecting their Event Hubs to Azure Databricks. They can run highly custom rules for detecting specific outages by sending data from Event Hubs to Azure Stream Analytics. For long term data storage, they can continue to use Continuous Data Export to store all of their device data in Azure Blob Storage.

Continuous Data Export

Share

21

Jan

Azure.Source – Volume 66
Azure.Source – Volume 66

Now in preview Azure Monitor logs in Grafana – now in public preview

Grafana offers great dashboarding capabilities, rich visualizations, and integrations with over 40 data sources. Grafana integration is now available in preview for Microsoft Azure Monitor logs. This integration is achieved through the new Log Analytics plugin, now available as part of the Azure Monitor data source. If you’re already using Grafana for your dashboards, this new plugin can help you create a single pane of glass for your various monitoring needs. The new plugin enables you to display any data available in Log Analytics, such as logs related to virtual machine performance, security, Azure Active Directory which has recently integrated with Log Analytics, and many other log types including custom logs.

HDInsight now supported in Azure CLI as a public preview

Support for HDInsight in Microsoft Azure CLI is now available in public preview. With the addition of the new HDInsight command group, you can now utilize all of the features and benefits that come with the familiar cross-platform Azure CLI to manage your HDInsight clusters.With the addition of the new HDInsight command group, you can now utilize all of the features and benefits that come with

Share

21

Jan

Azure Cognitive Services adds important certifications, greater availability, and new unified key

One of the most important considerations when choosing an AI service is security and regulatory compliance. Can you trust that the AI is being processed with the high standards and safeguards that you come to expect with hardened, durable software systems?

Cognitive Services today includes 14 generally available products. Below is an overview of current certifications in support of greater security and regulatory compliance for your business.

Added industry certifications and compliance

Significant progress has been made in meeting major security standards. In the past six months, Cognitive Services added 31 certifications across services and will continue to add more in 2019. With these certifications, hundreds of healthcare, manufacturing, and financial use cases are now supported. 

The following certifications have been added:

ISO 20000-1:2011, ISO 27001:2013, ISO 27017:2015, ISO 27018:2014, and ISO 9001:2015 certification HIPAA BAA HITRUST CSF certification SOC 1 Type 2, SOC 2 Type 2, and SOC 3 attestation PCI DSS Level 1 attestation

For additional details on industry certifications and compliance for Cognitive Services, visit the Overview of Microsoft Azure Compliance page.

Enhanced data storage commitments

Cognitive Services now offers more assurances for where customer data is stored at rest. These assurances have been enabled by graduating

Share

17

Jan

Microsoft Power Series at the 2019 Power Summit Europe
Microsoft Power Series at the 2019 Power Summit Europe

https://powerbi.microsoft.com/en-us/blog/microsoft-power-series-at-the-2019-power-summit-europe/Source: https://powerbi.microsoft.com/en-us/blog/microsoft-power-series-at-the-2019-power-summit-europe/           In addition to the 20 tracks lead by the community, technical experts and Industry luminaries presenting at the upcoming Power Platform Summit in Amsterdam, the Microsoft Team will be there in full force presenting the READ MORE

Share

17

Jan

Dynamic mission planning for drones with Azure Maps

Real-time location intelligence is critical for business operations. From getting real-time road data, to building asset-tracking solutions for navigating drone fleets. Today, we’re excited to highlight a customer, AirMap, whose software solutions rely on Azure Maps for real-time location intelligence in a new frontier of technology called dynamic mission planning for drones.

AirMap is the leading global airspace management platform for drones. AirMap’s Unmanned Traffic Management (UTM) platform enables the deployment and operations of safe, efficient, and advanced drone operations for enterprises and drone solution providers. Since 2017, AirMap has been part of the Microsoft Ventures portfolio and has chosen Microsoft Azure as its trusted cloud for its cloud-based UTM platform. AirMap offers open, standardized APIs and SDKs that make it easy for software developers to integrate AirMap’s intelligence services and capabilities into third party applications. This includes situational awareness of flight conditions, airspace advisories, and global airspace regulations. The AirMap developer platform also offers easy access to AirMap’s global network of airspace authorities, who offer notification, authorization, and more to drone operators on the AirMap UTM platform.

Figure 1: AirMap dynamically renders polygons representing different geographic areas subject to airspace regulations.

When faced with the decision of selecting

Share

17

Jan

HDInsight now supported in Azure CLI as a public preview
HDInsight now supported in Azure CLI as a public preview

We recently introduced support for HDInsight in Microsoft Azure CLI as a public preview. With the addition of the new HDInsight command group, you can now utilize all of the features and benefits that come with the familiar cross-platform Azure CLI to manage your HDInsight clusters.

Key Features Cluster CRUD: Create, delete, list, resize, and show properties for your HDInsight clusters. Script actions: Execute script actions, list and delete persistent script actions, promote ad-hoc script executions to persistent script actions, and show the execution history of script actions on HDInsight clusters. Operations Management Suite (OMS): Enable, disable, and show the status of OMS/Log Analytics integration on HDInsight clusters. Applications: Create, delete, list, and show properties for applications on your HDInsight clusters. Core usage: View available core counts by region before deploying large clusters. Azure CLI benefits Cross platform: Use Azure CLI on Windows, macOS, Linux, or the Azure Cloud Shell in a browser to manage your HDInsight clusters with the same commands and syntax across platforms. Tab completion and interactive mode: Autocomplete command and parameter names as well as subscription-specific details like resource group names, cluster names, and storage account names. Don’t remember your 88-character storage account key off the top

Share

17

Jan

Announcing Personal Bookmarks in the Power BI Service
Announcing Personal Bookmarks in the Power BI Service

https://powerbi.microsoft.com/en-us/blog/announcing-personal-bookmarks-in-the-power-bi-service/Source: https://powerbi.microsoft.com/en-us/blog/announcing-personal-bookmarks-in-the-power-bi-service/           Earlier last year, we announced bookmarking to be generally available in Power BI Desktop. Bookmarks are currently used by many report authors to share interesting insights, tell a story, and create intuitive navigation READ MORE

Share

16

Jan

Power BI dataflows January updates
Power BI dataflows January updates

https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-january-updates/Source: https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-january-updates/           Happy new year everyone! We are kicking off the new year with an update to Power BI dataflows, focused on the dataflows editor. Power BI dataflows was introduced to public preview in November, READ MORE

Share

16

Jan

Azure Data Explorer plugin for Grafana dashboards
Azure Data Explorer plugin for Grafana dashboards

Are you using Azure Data Explorer to query vast amounts of data? Are you following business metrics and KPIs with Grafana dashboards? Creating a Grafana data source with Azure Data Explorer has never been easier.

Grafana is a leading open source software designed for visualizing time series analytics. It is an analytics and metrics platform that enables you to query and visualize data and create and share dashboards based on those visualizations. Combining Grafana’s beautiful visualizations with Azure Data Explorer’s snappy ad hoc queries over massive amounts of data, creates impressive usage potential.

The Grafana and Azure Data Explorer teams have created a dedicated plugin which enables you to connect to and visualize data from Azure Data Explorer using its intuitive and powerful Kusto Query Language. In just a few minutes, you can unlock the potential of your data and create your first Grafana dashboard with Azure Data Explorer.

Once you build an Azure Data Explorer data source in Grafana, you can create a dashboard panel and select Edit to add your query.

Kusto Query Language is available for executing queries in the Metrics tab. The built-in intellisense which proposes query term completion, assists in query formulation. You run

Share