16

Nov

SQL Server 2014 Service Pack 3 is now available
SQL Server 2014 Service Pack 3 is now available

The SQL Server team is excited to bring you the third service pack release for SQL Server 2014. This service pack is now available for download from the Microsoft Download Center as well as the Microsoft Update Catalog, Microsoft Developer Network, Microsoft Evaluation Center, MBS Partner Source, and the Volume Licensing Service Center. As part of our commitment to software excellence, this upgrade is available to all customers with existing SQL Server 2014 deployments.

SQL Server 2014 Service Pack 3 (SP3) features improvements centered around performance, scalability, and diagnostics based on the feedback from customers and the SQL community. These improvements enable SQL Server 2014 to perform faster and scale out-of-the-box on modern hardware design.

Key aspects of this release include: Improved database backup performance on large memory machines and improved database restore performance for compressed backups Support enhancements for CLONEDATABASE with a new DBCC option and Service Broker support Support enhancements for Showplan XML in scalar user-defined functions and exposed information about memory fractions

This release includes over eight improvements and 21 support and diagnostic enhancements.

Find more information on SQL Server 2014 SP3 in our KB article, and download the new server pack today by visiting

Share

16

Nov

Taboola Improves customer experiences with Azure Data Explorer
Taboola Improves customer experiences with Azure Data Explorer

How can you take billions of lines of log data, explore it to identify those hidden gems of information, and act on those insights instantly to improve your customers’ experience, enhance your products, and maintain a competitive advantage in a digital-first world?

This past week at PASS Summit 2018, Taboola, a discovery platform, shared how they are tackling this with the help of Azure Data Explorer, a lightning fast service optimized for data exploration. Azure Data Explorer allows users to get instant visibility into very large, raw datasets in near-real time to analyze performance, identify trends and anomalies, and diagnose problems.

Staying competitive

Taboola delivers personalized recommendations to more than one billion users every month, rendering 3 billion web pages daily on many of the web’s most innovative and highly visited websites. Thousands of leading publishers, marketers, and agencies utilize Taboola’s predictive technology to increase user engagement, monetize their traffic, and distribute their content to engaged audiences across the web. Ensuring customers achieve maximum success from their campaigns is crucial to Taboola’s success.

Taboola’s data generates more than 22 billion records of edge delivery logs daily. Taboola needed a way to quickly, simply, and cost-effectively analyze this edge delivery log

Share

16

Nov

On-premises data gateway November update is now available
On-premises data gateway November update is now available

https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-update-is-now-available-2/Source: https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-update-is-now-available-2/           We are happy to announce that we have just released the November update for the On-premises data gateway (version 3000.0.155.1)            &…

Share

15

Nov

Modeling View in Power BI Desktop
Modeling View in Power BI Desktop

https://powerbi.microsoft.com/en-us/blog/modeling-view-in-power-bi-desktop/Source: https://powerbi.microsoft.com/en-us/blog/modeling-view-in-power-bi-desktop/           The new modeling view in Power BI Desktop is designed to work with enterprise datasets that grow in complexity

Share

15

Nov

Analysis Services is 20 years old!
Analysis Services is 20 years old!

https://powerbi.microsoft.com/en-us/blog/analysis-services-is-20-years-old/Source: https://powerbi.microsoft.com/en-us/blog/analysis-services-is-20-years-old/           Happy 20th birthday Analysis Services!

Share

15

Nov

SSMS 18.0 Public Preview 5 Released
SSMS 18.0 Public Preview 5 Released

We are very excited to announce the release of Public Preview 5 of SQL Server Management Studio (SSMS) 18.0. This release has a number of new features and capabilities and several bug fixes across SQL Server Management Objects (SMO), UI, etc.

You can download SSMS 18.0 Public Preview 5 here.

New features include: Static Data Masking Query Tuning Assistant Ability to launch Azure Data Studio from SSMS SSMS improvements include: SSMS – Exposed “Maximum size for error log files” under “Configure SQL Server error logs” SSMS/Object Scripting – Adding new menu items for “CREATE OR ALTER” when scripting objects Database Compatibility Level Upgrade New option under <Database Name> Tasks> Database Upgrade. This will start the new Query Tuning Assistant to guide the user through the process of: Collecting a performance baseline before upgrading the database compatibility level Upgrading to the desired database compatibility level Collecting a second pass of performance data over the same workload Detecting workload regressions and providing tested recommendations to improve workload performance

 

SSMS Query Store Improved usability of some reports New Query Wait Statistics report

Vulnerability Assessment – Enabled Vulnerability

Share

15

Nov

Update 18.11 for Azure Sphere in public preview
Update 18.11 for Azure Sphere in public preview

In September 2018, Azure Sphere was released for public preview. Today, we are pleased to announce the 18.11 update to the Azure Sphere Operating System, Azure Sphere Security Service, and Visual Studio development environment. This release includes substantial investments in our security infrastructure and our connectivity solutions, and it incorporates some of your feedback.

This is the first update to our public preview release, and we plan to release additional updates quarterly. Notification of software updates, new product features, tips and tricks, termination of support for older preview software, and other useful information will be posted on the Azure Updates website. Subscribe to Azure Update notifications through the RSS Feed to stay up to date with the latest Azure Sphere news.

Features in the 18.11 release

This release features strategic improvements in our internal security mechanism to allow devices that have been offline for an extended period to easily reconnect to the Azure Sphere Security Service. After manufacture, connected devices might spend months in a warehouse, during which root certificates stored on the device could expire. The Azure Sphere Security Service now seamlessly handles expired root certificates to ensure that devices that are intermittently connected or are disconnected for long

Share

15

Nov

Help shape the future of Power BI
Help shape the future of Power BI

https://powerbi.microsoft.com/en-us/blog/help-shape-the-future-of-power-bi/Source: https://powerbi.microsoft.com/en-us/blog/help-shape-the-future-of-power-bi/          

Share

15

Nov

Four operational practices Microsoft uses to secure the Azure platform

This is the fourth blog in a 4-part blog post series on how Microsoft Azure provides a secure foundation.

Microsoft provides you with a secure foundation to host your infrastructure and applications. In the last blog in this series on infrastructure security, I shared top customer concerns about high investment without clear ROI and challenges of retaining security experts. In this blog, I discuss how Microsoft Azure can help you gain security expertise without additional investment through our operational best practices and a global team of over 3,500 cybersecurity experts. Today, we are going to look at the different operational practices our security experts follow to help ensure your data is secure.

1. Secure deployment practices

The Security Development Lifecycle (SDL) is a collection of industry-recognized best practices that address the seven-phases of software development. It helps our developers build more secure software and meet security compliance requirements.

Our developers follow the SDL to ensure they are meeting core security principles throughout development, resolving security issues before their code is deployed, and adhering to the security standards used by all software developed for the Azure platform.

The SDL is a repeatable process that all software development teams within Azure use

Share

15

Nov

Monitor your Azure Open Source Databases (PostgreSQL and MySQL) using Azure Monitor

Collecting insights using Azure Monitor

Azure Database for PostgreSQL and MySQL service is a fully managed, enterprise-ready cloud service which emits the performance metrics and telemetry log to Azure Monitor service. Using Azure Monitor, you can collect, analyze, and take action on telemetry data gathered from your cloud environments. This then helps you understand how the application is behaving, get deep insights into application and database behavior, get alerts, and build remediation action to respond to the alerts. Azure Monitor collects data from various monitored Azure resources, including Azure Database for PostgreSQL and MySQL. From the metrics and data collected, the tool service enables various operations including streaming data into external partner systems.

 

You are able to monitor your applications running on Azure Database for PostgreSQL or MySQL via the Azure portal. For each of the Azure Database for PostgreSQL or a MySQL server, a full suite of metrics is available to monitor throughput, storage, availability, and latency. Here are the various metrics available for you in Azure Database for PostgreSQL and MySQL to get insights on server’s behavior. You can also set alerts to monitor these metrics and log data using the Azure Portal or Azure CLI. For

Share