This blog post was authored by Alan Yu, Program Manager, Microsoft SQL Server.
We are excited to announce the January release of SQL Operations Studio is now available.
Download SQL Operations Studio and review the release notes to get started. SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB, and SQL DW from Windows, macOS, and Linux. To learn more, visit our Github.
SQL Operations Studio was announced for public preview on November 15, 2017 at Connect(), and this January release is the second major update since the announcement. If you missed the December release announcement, you can learn more on the SQL Server blog.
The January release includes several major repo updates and feature releases, including:
Enable the HotExit feature to automatically reopen unsaved files. Add the ability to access saved connections from Connection Dialog. Set the SQL editor tab color to match the Server Group color. Fix the broken Run Current Query command. Fix the broken pinned Windows Start Menu icon.
For a complete list of updates, please refer to the release notes.
A highly requested feature for SQL Operations Studio is to remember
https://powerbi.microsoft.com/en-us/blog/1-18-webinar-using-powerapps-and-flow-to-create-line-of-business-portals-by-vishwas-lele/Source: https://powerbi.microsoft.com/en-us/blog/1-18-webinar-using-powerapps-and-flow-to-create-line-of-business-portals-by-vishwas-lele/ Vishwas will showcase a PowerApp application that is essentially a “portal” for existing Line of Business Enterprise Applications (inventory, contracts etc.) and Services ( Dynamics, O365, DropBox etc. )Through the use of PowerApps READ MORE
https://powerbi.microsoft.com/en-us/blog/balanced-scorecards/Source: https://powerbi.microsoft.com/en-us/blog/balanced-scorecards/ While the Power KPI visual has been a necessary building block for us in the presentation of KPIs, by itself it doesn’t provide a scorecard layout. Some users, including executives, really wanted a READ MORE
The first full work week of 2018 was a light week for new Azure functionality since everyone was returning from the holidays, but that won’t last for long.
#Azure #SQLDW, the cost benefits of an on-demand data warehousing – Learn how you can move from an on-premises static and monolithic data warehouse costing US$28k per month to an elastic Hub & Spoke data warehouse in the cloud optimized for performance and accessed by thousands of users with a potential cost saving of 50 percent.
Azure Security Center and Microsoft Web Application Firewall Integration – Azure Security Center now automatically discovers non-ASC provisioned Microsoft Web Application Firewall (WAF) instances. Previously provisioned WAF instances will be displayed in ASC security solutions pane under discovered solutions where the security admin can integrate them with Azure Security Center. Connecting existing Microsoft WAF deployments will help you take advantage of ASC detections regardless of how WAF was provisioned. Additional configuration settings such as custom firewall rules sets are available in the WAF console via links from Azure Security Center.
Manage and Auto-scale your IoT solution with a predictable IoT Cloud – A new sample solution is now available to show how to monitor and
Every second counts when you are under attack. Azure Security Center (ASC) uses advanced analytics and global threat intelligence to detect malicious threats, and the new capabilities empower you to respond quickly. This blog post showcases how an analyst can leverage the Investigation and Log Search capabilities in Azure Security Center to determine whether an alert represents a security breach, and to understand the scope of that breach.
To learn more about the ASC Investigation feature in detail see the article Investigate Incidents and Alerts in Azure Security Center (Preview). Let’s drill into an alert and see what more we can learn using these new features.
Security Center Standard tier users can view a dashboard similar to one pictured below. You can select the Standard tier or the free 90 day trial from the Pricing Tier blade in the Security Center policy. On the below screen click on the Security Alerts graph for a list of alerts. This view will include alerts triggered by Security Center detections as well as integrated alerts from other security solutions. When possible, Security Center combines alerts that are part of chain of an attacker activity into incidents. The three interconnected dots icon highlighted in
https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-january-update/Source: https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-january-update/ Hi everyone, after a short break for the holidays we are back with the latest updates for Power BI Developer community. Don’t forget to check out the November blog post, if you haven’t READ MORE
ADF v2 public preview was announced at Microsoft Ignite on Sep 25, 2017. With ADF v2, we added flexibility to ADF app model and enabled control flow constructs that now facilitates looping, branching, conditional constructs, on-demand executions and flexible scheduling in various programmatic interfaces like Python, .Net, Powershell, REST APIs, ARM templates. One of the consistent pieces of customer feedback we received, is to enable a rich interactive visual authoring and monitoring experience allowing users to create, configure, test, deploy and monitor data integration pipelines without any friction. We listened to your feedback and are happy to announce the release of visual tools for ADF v2. The main goal of the ADF visual tools is to allow you to be productive with ADF by getting pipelines up & running quickly without requiring to write a single line of code. You can use a simple and intuitive code free interface to drag and drop activities on a pipeline canvas, perform test runs, debug iteratively, deploy & monitor your pipeline runs. With this release, we are also providing guided tours on how to use the enabled visual authoring & monitoring features and also an ability to give us valuable feedback.
There’s a revolution underway that is positioning companies to take operational efficiency to new levels and inform the next generation of products and services. This revolution of course, is the Internet of Things (IoT).
Here at Microsoft, we’re committed to helping our customers harness the power of IoT through our Azure IoT solutions. We’re also committed to helping customers take the first steps through our IoT in Action series. Our next delivery is coming February 13, 2018 in San Francisco, which I’d encourage you to attend.
But first, I’d like to introduce you to some recent updates to Azure IoT Suite that are making IoT solutions easier and more robust than ever.
Azure IoT powers the business revolution
With our long history of driving business success and digital transformation for our customers, it’s no surprise that we’re also focused on powering the business revolution through our robust Azure IoT suite of products.
So how does Azure IoT benefit businesses?
First off, it’s a quick and scalable solution. Our preconfigured solutions can accelerate your development process, so you can get up and running quickly. You can connect existing devices and add new ones using our device SDKs for platforms including
Database Compatibility Level 140 is now the default for new databases created in Azure SQL Database across almost all regions. At this point in time, there are already 539,903 databases in Azure SQL Database already running in Compatibility Level 140.
Frequently asked questions related to this announcement:
Why move to database Compatibility Level 140?
The biggest change is the enabling of the adaptive query processing feature family, but there are also query processing related fixes and batch mode improvements as well. For details on what Compatibility Level 140 specifically enables, see the blog post Public Preview of Compatibility Level 140 for Azure SQL Database.
What do you mean by “database Compatibility Level 140 is now the default”?
If you create a new database and don’t explicitly designate COMPATIBILITY_LEVEL, the database Compatibility Level 140 will be used.
Does Microsoft automatically update the database compatibility level for existing databases?
No, we do not update database compatibility level for existing databases. This is up to customers to do at their own discretion. With that said, we highly recommend customers plan on moving to the latest compatibility level in order to leverage the latest improvements.
My application isn’t certified for database Compatibility Level 140
Azure Security Center monitors operating system (OS) configurations using a set of 150+ recommended rules for hardening the OS, including rules related to firewalls, auditing, password policies, and more. If a machine is found to have a vulnerable configuration, a security recommendation is generated. Today, we are pleased to preview a new feature that allows you to customize these rules and add additional rules to exactly match your desired Windows configurations.
The new custom security configurations are defined as part of the security policy, and allow you to:
Enable and disable a specific rule. Change the desired setting for an existing rule (e.g. passwords should expire in 60 days instead of 30). Add a new rule based on the supported rule types including registry, audit policy, and security policy.
Note: OS Security Config customization is available for Security Center users in the Standard tier on subscription level only.
To get started, open Security Center, select Security policy, choose a subscription, and “Edit security configurations (preview)” as shown below.
In the “Edit Security Configurations rules” blade, you can download the configuration file (JSON format), edit the rules, upload the modified file, and save to apply your changes. The customized rule