Tag Archives: Preview

Released: Public Preview for SQL Server Management Packs Update (6.7.34.0)

We are getting ready to update the SQL Server Management Packs. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final product so much better.

Please download at:

Microsoft System Center Management Packs (Community Technical Preview) for SQL Server

Included in the download are Microsoft System Center Management Packs for SQL Server 2008/2008 R2/2012/2014/2016 (6.7.34.0).

New SQL Server 2008-2012 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Added debug information to Always On monitoring scripts
  • Disabled the alerting rule for event #18456 by default
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks

New SQL Server 2014 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Implemented “MSSQL 2014/16: HTTP Storage: Avg. Bytes/Transfer” performance rule
  • Added debug information to Always On monitoring scripts
  • Disabled the alerting rule for event #18456 by default
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks

 New SQL Server 2016 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Added debug information to Always On monitoring scripts
  • Implemented “MSSQL 2014/16: HTTP Storage: Avg. Bytes/Transfer” performance rule
  • Enabled Memory-Optimized workflows for all editions of SQL Server 2016 by default, so far as all editions now support Memory-Optimized Data since SP1
  • Disabled the alerting rule for event #18456 by default
  • Optimized ProbeAction for User Resource Pool Memory workflows
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks
  • Fixed issue: “XTP Configuration” monitor is in healthy state when XTP filegroup container and the transaction log are placed on different volumes of a physical disk
  • Fixed issue: Incorrect publishers’ names for SSIS EventCollection rules (SQL2016)
  • Fixed issue: GetSQL2016DBEngineWinServState.js crashes when getting neither “true” nor “false” as the second parameter (CheckStartupType)

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.
We are looking forward to hearing your feedback at sqlmpsfeedback@microsoft.com.

Let’s block ads! (Why?)

SQL Server Release Services

Released: Public Preview for SQL Server 2017+ and Replication Management Pack (RC)

We are happy to announce SQL Server 2017+ Management Pack Release Candidate with new features is ready (6.7.65.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com).

NEW: Version Agnostic SQL Server MPs

We understand that with many SQL Server versions in market and with new server releases becoming more frequent, it is becoming harder to manage a separate MP for each server version. We are moving to version agnostic MPs to address this issue. This will be valid going forward. The new MP is named SQL Server 2017+. The ‘+’ in the name indicates that it will be used to monitor SQL Server 2017 and the releases that come after that. Current in-market MPs (2008 through 2016) will not be changed and the 2017+ MP cannot be used to monitor older releases. We are making this change for SQL Server and Replication MPs. It would be great to get your feedback on this public preview before we reach GA.

Please download the public preview bits at:

Microsoft System Center Management Pack (Release Candidate 1) for SQL Server 2017+

Microsoft System Center Management Pack (Release Candidate 1) for SQL Server 2017+ Replication

New Features and Fixes for SQL Server 2017+ Windows and Linux MP (6.7.65.0)

  • The management pack was reimplemented in order to enable monitoring SQL Server 2017 and all upcoming SQL Server versions
  • Reduced the number of files in the management pack
  • Removed dependency on SQL Server Dashboards management pack
  • Introduced a number of fixes and improvements to functionality, performance, and display strings

New Features and Fixes for SQL Server 2017+ Replication Windows MP (6.7.65.0)

  • The management pack was reimplemented in order to enable monitoring SQL Server 2017 and all upcoming SQL Server versions
  • Reduced the number of files in the management pack
  • Introduced a number of fixes and improvements to functionality, performance, and display strings
Feature/Workflow
CTP1 (6.7.18.0)
CTP2 (6.7.40.0)
CTP3 (6.7.55.0)
CTP4 (6.7.60.0)
RC (6.7.65.0)
Core objects
DB Engine Discovery W/L W/L W/L W/L W/L
Local DB Engine Discovery (windows only feature) W W W W
SQL Cluster instances W W W W W
DB Discovery W/L W/L W/L W/L W/L
DB Filegroup Discovery W/L W/L W/L W/L W/L
DB File Discovery W/L W/L W/L W/L W/L
DB Log file Discovery W/L W/L W/L W/L W/L
DB Policy Discovery W/L W/L W/L W/L
Filestream Filegroup Discovery W W W W
Memory-Optimized Data Filegroup Discovery W/L W/L W/L W/L
Memory-Optimized Data Filegroup Containers Discovery W/L W/L W/L W/L
DB Engine Resource pool Discovery W/L W/L W/L
SQL Agent Discovery W/L W/L W/L
Always On Discovery W W/L W/L
Features
Agentless Monitoring W/L W/L W/L W/L W/L
Mixed monitoring (windows only feature) W W W W W
Agent Monitoring (windows only feature) W W W W W
SQL Credentials W/L W/L W/L W/L W/L
AD Credentials W W W W/L W/L
In-memory OLTP support W/L W/L W/L W/L
SQL Server Express support W W W W/L W/L
MSSQL LogReader module W/L W/L W/L W/L
Support long names (windows only feature) W W W W W
Wizard multithreading W/L W/L W/L W/L
Tasks Execution W/L W/L W/L
Docker Support L L L
Monitoring Scenarios
DB Engine Health Status Monitoring W/L W/L W/L W/L W/L
DB Engine Performance Monitoring W/L W/L W/L W/L W/L
DB Engine Service Pack Compliance Monitoring W/L W/L W/L W/L
DB Configuration Monitoring W/L W/L W/L W/L W/L
DB Memory-Optimized Data Filegroup Performance Monitoring W W W/L W/L
CPU Monitoring and performance metrics W W W W/L
Log Shipping monitoring W W W W/L
WMI Health Monitoring W/NA W/NA W/NA W/NA
Event Base monitoring (400+ Alert rules) W/L W/L W/L W/L
DB Space Monitoring and performance metrics collection W W W W/L W/L
DB Space Monitoring and performance metrics collection for Filestream objects W W W W
DB Space Monitoring and performance metrics collection for Hekaton objects W W W W/L
SQL Full-text Filter Daemon Launcher Service Monitoring W/L W/L W/L W/L
SQL Agent Monitoring W/L W/L W/L
Always On Monitoring W W/L W/L

Legend

Completed

W – Supported on Windows

L – Supported on Linux

W/L – Supported on Windows and Linux

W/NA – Supported on Windows but no applicable to Linux

All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack.

We are looking forward to hearing your feedback (sqlmpsfeedback@microsoft.com).

Let’s block ads! (Why?)

SQL Server Release Services

Power BI Report Server August 2017 Preview now available

Greetings from SQLSaturday in Vancouver, Canada!

Today, we’re excited to release a preview of the next version of Power BI Report Server. This preview release contains some great new self-service BI capabilities, including support for data sources other than SQL Server Analysis Services and viewing and interacting with Excel Workbooks.

Download Power BI Report Server August 2017 Preview!

Publish Power BI reports with imported data

The June 2017 version of Power BI Report Server gave users the ability to create and publish Power BI reports on-premises by connecting to SQL Server Analysis Services data sources. Since then, we’ve heard repeatedly from customers about their need to publish Power BI reports created against other data sources and are pleased to give you an early preview of our progress.

With this August 2017 preview, users can create Power BI reports in Power BI Desktop that connect to any data source, and publish their reports to Power BI Report Server. There’s no special configuration required to enable this functionality — simply install and configure the August 2017 preview version of Power BI Report Server on your machine, and you’re ready to go. You can then use the included Power BI Desktop application to connect to your data source(s), create your report, and publish it directly to the report server to share it with your users.

153b0b04 817a 4c1a b293 55a6b5513c72 Power BI Report Server August 2017 Preview now available

Since this is an early preview, there are a few limitations to keep in mind as you try it out. Please note that we plan to support all the below scenarios when we make the GA release available in later in 2017. Some current limitations are:

  • Scheduled data refresh is currently not available for reports using imported data.
  • Direct Query data connections are not currently supported.
  • Scale-out environments for Power BI Report Server are not officially supported using the preview release.
  • Reports must be smaller than 50 MB in size.

View and interact with Excel Workbooks

Excel and Power BI contain a portfolio of tools that is unique in the industry. Together, they enable business analysts to more easily gather, shape, analyze, and visually explore their data. In addition to viewing Power BI reports in the web portal, business users can now do the same with Excel workbooks in the new version of Power BI Report Server, giving them a single location to publish and view their self-service Microsoft BI content.

To do this, customers can take advantage of Office Online Server (OOS), a separate download from Microsoft Office to render Office documents that you can view in your browser. Customers with a Volume Licensing account can download OOS from the Volume License Servicing Center at no cost and will have view-only functionality. We’ve published an easy-to-follow walkthrough of how to add Office Online Server to your Power BI Report Server preview environment. Once configured, users can view and interact with Excel workbooks that:

  • Have no external data source dependencies.
  • Have a live connection to an external SQL Server Analysis Services data source.
  • Have a PowerPivot data model.

4e035ef2 cac7 4ed9 87b0 e3779cd8a22b Power BI Report Server August 2017 Preview now available

To learn about these and other new features in the August preview, including support for the new table and matrix visuals, make sure you read the release notes and supporting documentation we’ve published to the Power BI website. We’re looking forward to hearing your feedback in the comments below or in the Power BI forums.

Try it now

Download Power BI Report Server (Preview)

Check out the preview documentation

Read more about Power BI Report Server at PowerBI.com

Follow @MSPowerBIon Twitter

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Visio custom visual is now in Public Preview and available in the store

We are pleased to announce the Public preview of the Visio custom visual for Power BI.

The Visio custom visual will allow you to visualize data using Microsoft Visio diagrams from within Power BI dashboards and reports. Any Power BI user can add Visio custom visual from the store (get it from the store) to start using this capability right away.

With Visio, you can create illustrative diagrams, such as interconnected workflows and real-world layouts, to pursue operational intelligence. Using Visio and Power BI together, you can illustrate and compare data both as diagrams and as traditional Power BI visuals in one place, driving operational and business intelligence to understand the overall picture.

Note: The Public Preview of Visio custom visual is currently supported in the Power BI service and Power BI Desktop. Support for Power BI Mobile apps will arrive soon.

With this new visual, you can connect to a Visio diagram hosted on SharePoint or OneDrive for Business. The underlying Power BI data is then automatically and intelligently linked to the diagram based on its shape properties, eliminating the need to do this manually. In just a few clicks, Visio diagrams become yet another interactive Power BI visualization that can help you make informed decisions faster.

Try it out now in an embedded report:

Let’s look at this with a fictitious example. Contoso is a large retailer working to improve its inventory management. Using Power BI, the current inventory per store can be represented in a series of visualizations, including a tree-map that shows stock by item (left-side chart in the image below).

52dba25a df26 4acc ae96 039ccf61865a Visio custom visual is now in Public Preview and available in the store

The visuals are perfect for an all-up view of inventory at this store. But what if Contoso needs more nuanced details, such as sales and inventory data for specific clothing racks? What if it needs to understand where each rack is located in the store and how they are positioned relative to one another? Using a Visio diagram of the store’s layout, Contoso can overlay the data in Power BI on Visio’s diagram of the clothing racks. The resulting Power BI dashboard provides an accurate, up-to-date representation of the overall store inventory, while also maintaining the ability to drill into specific items.

eac27730 e76f 4694 a957 3fc07f107c5d Visio custom visual is now in Public Preview and available in the store

The treemap was replaced with individual item racks that have been color-coded and labeled based on the inventory levels from Power BI data. For example, when “Tea Dresses” is clicked in the Visio diagram, you quickly see that sales are very strong, which helps explain why inventory is low. Similarly, when “Suit Coats” is clicked in the Power BI bar chart, you see the item is well below its sales target and inventory is still high. You can also see that the suit coat rack is located in a back corner of the store, making it less accessible to customers. Based on this information, the Contoso team might decide to use more rack space for tea dresses and less for suit coats, or reposition the racks for greater accessibility.

There are endless types of Visio diagrams that can offer more detailed insights with Power BI, including:

  • Flow charts for identifying interdependencies
  • Fishbone diagrams for root-cause analysis
  • Organizational charts for assessing the impact of hierarchies on process decisions and people management

f19326a6 23e6 4560 b04c 42c0a1f9fd89 Visio custom visual is now in Public Preview and available in the store

Visio flowchart illustrating a sample home loan approval process for a bank. Using the Power BI charts, the bank sees that actual ticket response times for performing property risk assessments are higher than expected. In the Visio diagram, that process step is highlighted in red indicating that, because it’s so early in the process, it could affect other steps in the future if the ticket processing issue isn’t resolved soon.

b73ae579 3fa3 4d1d b8f5 8855a2f0675a Visio custom visual is now in Public Preview and available in the store

Fishbone chart showing that poor working conditions — specifically excessive noise and temperature, which are highlighted in red in the Visio diagram — are the root cause of diminished product quality. The diagram relies on the employee ratings of operational categories depicted in the Power BI charts on the right.

9be15e92 d60d 4146 a7bc 5c82fdc92f80 Visio custom visual is now in Public Preview and available in the store

Dashboard showing how certain people and departments, illustrated by the Visio hierarchy diagram in the upper left, affect different organizational processes. In this case, the marketing and sales department is over budget on tele sales and tele call efforts, all of which are highlighted in red.

Known limitations of the Public Preview:

  • To access the Visio diagram from the Visio custom visual, you will need to sign into the host SharePoint with your organizational ID. The visual will prompt you with a sign-in window.
  • To include a Visio visual in a Publish to Web report, you must use an authenticated Visio diagram. Refer to the documentation for details.
  • The Visio visual public preview is not yet supported for Power BI Mobile apps, Power BI Embedded, exporting to PowerPoint, or email subscriptions.

Visio and Power BI are visual tools—each helps you to dissect data in new, meaningful ways. Together, they can uncover even more insights.

Get the Visio custom visual for Power BI from the Office store, or search for it in the integrated store in your Power BI Desktop or Power BI service.

To know more about Visio Power BI custom visual, please refer step-by-step help articles

Please visit our UserVoice site to submit your suggestions for improving Visio-Power BI connectivity. For questions about this and other features, email us at tellvisio@microsoft.com

Lastly, you can follow us on Facebook, YouTube and Twitter for the latest Visio news.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Released: Public Preview for SQL Server 2017 and Replication Management Pack (CTP4)

We are happy to announce SQL Server 2017 Management Pack CTP4 bits with new features are ready (6.7.60.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com).

Please download the public preview bits at:

Microsoft System Center Management Pack (Community Technical Preview 4) for SQL Server 2017

Microsoft System Center Management Pack (Community Technology Preview 4) for SQL Server 2017 Replication

New Features and Fixes for SQL Server 2017 Windows and Linux MP (6.7.60.0)

  •   Implemented Always On monitoring on Windows and Linux
  •   Implemented Disk Latency workflows
  •   Added new “Login failed” alerting rule for SQL Server event #18456
  •   Added support for AD Credentials in Agentless Mode on Windows
  •   Added DB Space Forecast report
  •   Fixed issue: different file location info from “sys.master_files” and “sysfiles” causes error when Availability Group secondary database files are in different path
  •   Fixed issue: workflows cannot connect to an instance when only Shared Memory protocol is enabled
  •   Introduced a number of improvements to the management pack

New Features and Fixes for SQL Server 2017 Replication Windows MP (6.7.60.0)

  • Added a number of monitors and performance rules to create the same Health model as presented in SQL Server 2008-2016 Replication MPs
  • Improved and refactored the management pack modules
  • Fixed a number of issues
Feature/Workflow CTP1 (6.7.18.0) CTP2 (6.7.40.0) CTP3 (6.7.55.0) CTP4 (6.7.60.0)
Core objects
DB Engine Discovery W/L W/L W/L W/L
Local DB Engine Discovery (windows only feature) W W W
SQL Cluster instances W W W W
DB Discovery W/L W/L W/L W/L
DB Filegroup Discovery W/L W/L W/L W/L
DB File Discovery W/L W/L W/L W/L
DB Log file Discovery W/L W/L W/L W/L
DB Policy Discovery W/L W/L W/L
Filestream Filegroup Discovery W W W
Memory-Optimized Data Filegroup Discovery W/L W/L W/L
Memory-Optimized Data Filegroup Containers Discovery W/L W/L W/L
DB Engine Resource pool Discovery W/L W/L
SQL Agent Discovery W/L W/L
Always On Discovery W W/L
         
Features      
Agentless Monitoring W/L W/L W/L W/L
Mixed monitoring (windows only feature) W W W W
Agent Monitoring (windows only feature) W W W W
SQL Credentials W/L W/L W/L W/L
AD Credentials W W W W
In-memory OLTP support W/L W/L W/L
SQL Server Express support W W W W
MSSQL LogReader module W/L W/L W/L
Support long names (windows only feature) W W W W
Wizard multithreading W/L W/L W/L
Tasks Execution W/L W/L
Docker Support L L
         
Monitoring Scenarios        
DB Engine Health Status Monitoring W/L W/L W/L W/L
DB Engine Performance Monitoring W/L W/L W/L W/L
DB Engine Service Pack Compliance Monitoring W/L W/L W/L
DB Configuration Monitoring W/L W/L W/L W/L
DB Memory-Optimized Data Filegroup Performance Monitoring W W W
CPU Monitoring and performance metrics W W W
Log Shipping monitoring W W W
WMI Health Monitoring W/NA W/NA W/NA
Event Base monitoring (400+ Alert rules) W/L W/L W/L
DB Space Monitoring and performance metrics collection W W W W
DB Space Monitoring and performance metrics collection for Filestream objects W W W
DB Space Monitoring and performance metrics collection for Hekaton objects W W W
SQL Full-text Filter Daemon Launcher Service Monitoring W W W
SQL Agent Monitoring W/L W/L
Always On Monitoring W W/L

Legend

Completed

W – Supported on Windows

L – Supported on Linux

W/L – Supported on Windows and Linux

W/NA – Supported on Windows but no applicable to Linux

All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack. Full functionality will be available with SQL Server 2017 GA. This CTP release only covers a subset of monitors and rules. We will work towards full functionality as we release new CTPs.

We are looking forward to hearing your feedback (sqlmpsfeedback@microsoft.com).

Let’s block ads! (Why?)

SQL Server Release Services

Released: Public Preview for SQL Server 2017 Management Pack (CTP3)

We are happy to announce SQL Server 2017 Management Pack CTP3 bits with new features are ready (6.7.55.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com). On the download page, you will see references to SQL Server vNext instead of 2017. We will update all references to vNext with 2017 in our next CTP, planned for June.

Please download the public preview bits at:

Microsoft System Center Management Pack (Community Technical Preview 3) for SQL Server 2017

New Features and Fixes in CTP3

  • Implemented new workflows:

    • Discoveries for SQL Server Agent and SQL Server Agent Jobs
    • Unit and rollup monitors for SQL Server Agent
    • Performance rules for Resource Pools
    • Alerting rules for SQL Server Agent on Windows
    • Tasks for the Database
    • Tasks for starting/stopping Windows services
    • Monitors and performance rules for Memory-Optimized Tables
    • Always On discoveries
    • “Resource Pool Memory Consumption” monitor
    • “Discover Database Custom User Policy on Windows and Linux” and Discover Database Engine Resource Pools on Windows and Linux” discoveries
    • Console tasks on Windows and Linux
  • Improved SQL queries in the resource pool and database discovery
  • Added discovery of “SQL Server vNext Resource Pool Group on ” to DB Engine discoveries
  • Fixed issue: “Failed to replace parameter while creating the alert for monitor state change” warnings for workflows of Memory-Optimized Tables containers
  • Fixed log reader issues
  • Fixed “SPN Configuration” issue
Feature/Workflow CTP1 (6.7.18.0) CTP2 (6.7.40.0) CTP3 (6.7.55.0)
Core objects
DB Engine Discovery W/L W/L W/L
Local DB Engine Discovery (windows only feature) W W
SQL Cluster instances W W W
DB Discovery W/L W/L W/L
DB Filegroup Discovery W/L W/L W/L
DB File Discovery W/L W/L W/L
DB Log file Discovery W/L W/L W/L
DB Policy Discovery W/L W/L
Filestream Filegroup Discovery W W
Memory-Optimized Data Filegroup Discovery W/L W/L
Memory-Optimized Data Filegroup Containers Discovery W/L W/L
DB Engine Resource pool Discovery W/L
SQL Agent Discovery W/L
Always On Discovery W
Features
Agentless Monitoring W/L W/L W/L
Mixed monitoring (windows only feature) W W W
Agent Monitoring (windows only feature) W W W
SQL Credentials W/L W/L W/L
AD Credentials W W W
In-memory OLTP support W/L W/L
SQL Server Express support W W W
MSSQL LogReader module W/L W/L
Support long names (windows only feature) W W W
Wizard multithreading W/L W/L
Tasks Execution W/L
Docker Support L
Monitoring Scenarios
DB Engine Health Status Monitoring W/L W/L W/L
DB Engine Performance Monitoring W/L W/L W/L
DB Engine Service Pack Compliance Monitoring W/L W/L
DB Configuration Monitoring W/L W/L W/L
DB Memory-Optimized Data Filegroup Performance Monitoring W W
CPU Monitoring and performance metrics W W
Log Shipping monitoring W W
WMI Health Monitoring W/NA W/NA
Event Base monitoring (400+ Alert rules) W/L W/L
DB Space Monitoring and performance metrics collection W W W
DB Space Monitoring and performance metrics collection for Filestream objects W W
DB Space Monitoring and performance metrics collection for Hekaton objects W W
SQL Full-text Filter Daemon Launcher Service Monitoring W W
SQL Agent Monitoring W/L
Always On Monitoring W

Legend

Completed

W – Supported on Windows

L – Supported on Linux

W/L – Supported on Windows and Linux

W/NA – Supported on Windows but no applicable to Linux

All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack. Full functionality will be available with SQL Server 2017 GA. This CTP release only covers a subset of monitors and rules. We will work towards full functionality as we release new CTPs.

We are looking forward to hearing your feedback (sqlmpsfeedback@microsoft.com)

Let’s block ads! (Why?)

SQL Server Release Services

Released: Public Preview for SQL Server Management Packs Update (6.7.30.0)

We are getting ready to update the SQL Server Management Packs. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final product so much better. We are introducing a new monitor in this release (see the first bullet below) based on customer feedback. You have now a better solution for monitoring backups of AG databases.

Please download at:

Microsoft System Center Management Packs (Community Technical Preview) for SQL Server

Included in the download are Microsoft System Center Management Packs for SQL Server 2008/2008 R2/2012/2014/2016 (6.7.30.0).

New SQL Server 2008-2012 MP Features and Fixes

  • Added new “Availability Database Backup Status” monitor in Availability Group to check the existence and age of the availability database backups (this monitor is disabled by default)
  • “Database Backup Status” monitor has been changed to return only “Healthy” state for the databases that are Always On replicas, since availability database backups are now watched by the dedicated monitor
  • Fixed issue: “Active Alerts” view does not show all alerts
  • Fixed issue: DB space monitoring scripts fail with “Cannot connect to database” error.
  • Fixed issue: PowerShell scripts fail with “Cannot process argument because the value of argument ‘obj’ is null” error
  • Fixed issue: Alert description of “Disk Ready Latency” and “Disk Write Latency” monitors displays the sample count instead of the performance value that was measured
  • Fixed issue: Different file location info from “sys.master_files” and “sysfiles” causes error when Availability Group secondary database files are in different path
  • Fixed issue: “DB Transaction Log Free Space Total” rules return wrong data
  • Introduced minor updates to the display strings

New SQL Server 2014 MP Features and Fixes

  • Added new “Availability Database Backup Status” monitor in Availability Group to check the existence and age of the availability database backups (this monitor is disabled by default)
  • “Database Backup Status” monitor has been changed to return only “Healthy” state for the databases that are Always On replicas, since availability database backups are now watched by the dedicated monitor
  • Fixed issue: “Active Alerts” view does not show all alerts
  • Fixed issue: DB space monitoring scripts fail with “Cannot connect to database” error.
  • Fixed issue: PowerShell scripts fail with “Cannot process argument because the value of argument ‘obj’ is null” error
  • Fixed issue: Alert description of “Disk Ready Latency” and “Disk Write Latency” monitors displays the sample count instead of the performance value that was measured
  • Fixed issue: Different file location info from “sys.master_files” and “sysfiles” causes error when Availability Group secondary database files are in different path
  • Fixed issue: “DB Transaction Log Free Space Total” rules return wrong data
  • Introduced minor updates to the display strings
  • Deprecated “Garbage Collection” monitor and the appropriate performance rule
  • Resource Pool Discovery is disabled by default for pools not containing databases with Memory-Optimized Tables
  • “XTP Configuration” monitor now supports different file path types (not only those starting with C:, D:, etc.)
  • Fixed issue: “Resource Pool State” view shows incorrect set of objects

 New SQL Server 2016 MP Features and Fixes

  • Added new “Availability Database Backup Status” monitor in Availability Group to check the existence and age of the availability database backups (this monitor is disabled by default)
  • “Database Backup Status” monitor has been changed to return only “Healthy” state for the databases that are Always On replicas, since availability database backups are now watched by the dedicated monitor
  • Fixed issue: “Active Alerts” view does not show all alerts
  • Fixed issue: DB space monitoring scripts fail with “Cannot connect to database” error.
  • Fixed issue: PowerShell scripts fail with “Cannot process argument because the value of argument ‘obj’ is null” error
  • Fixed issue: Alert description of “Disk Ready Latency” and “Disk Write Latency” monitors displays the sample count instead of the performance value that was measured
  • Fixed issue: Different file location info from “sys.master_files” and “sysfiles” causes error when Availability Group secondary database files are in different path
  • Fixed issue: “DB Transaction Log Free Space Total” rules return wrong data
  • Introduced minor updates to the display strings
  • Deprecated “Garbage Collection” monitor and the appropriate performance rule
  • Resource Pool Discovery is disabled by default for pools not containing databases with Memory-Optimized Tables
  • “XTP Configuration” monitor now supports different file path types (not only those starting with C:, D:, etc.)
  • Fixed issue: “Resource Pool State” view shows incorrect set of objects
  • Fixed issue: Invalid group discovery in SQL Server 2016 Always On

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.
We are looking forward to hearing your feedback at sqlmpsfeedback@microsoft.com.

Let’s block ads! (Why?)

SQL Server Release Services

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 BI reports on-premises with the included Power BI Report Server.

Today, we’re excited to make available a preview of Power BI Report Server.

Download Power BI Report Server (Preview)

With Power BI Desktop and Power BI Report Server, you can:

1. Create beautiful, interactive reports using Power BI Desktop

2. Publish reports to Power BI Report Server

3. View and interact with reports in your web browser or in Power BI Mobile on your phone or tablet

1519e3fc 1150 4691 9113 025c884f2d2d Power BI Report Server preview now available

At launch, Power BI Report Server will support most Power BI report features, included but not limited to:

  • Create reports in Power BI Desktop
  • Connect to Analysis Services data models (Tabular or Multidimensional)
  • Visualize data using built-in or custom visuals
  • View and interact with reports in your web browser
  • Export report data to CSV
  • Print a report page
  • View and interact with reports in Power BI Mobile

With this first release, you connect directly to an Analysis Services data model, which in turn can connect to a variety of other data sources, including SQL Server, Oracle, Teradata, and more. We aim to extend direct connectivity to the other Power BI Desktop data sources, targeting later this year.

In addition to its self-service BI capabilities, Power BI Report Server includes the enterprise reporting capabilities of SQL Server Reporting Services (SSRS), so you can generate the precisely-formatted reports your business needs.

Power BI Report Server will be generally available along with Power BI Premium late in the second quarter of 2017.

Try it now

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Data Connector SDK Developer Preview

As part of the Microsoft Build event, we are announcing a developer preview of the Data Connector SDK. You can begin to create your own custom data connectors.

What are data connectors? Simply put, they are how you connect to data within Power BI. These are extensions on the connectivity/Mashup engine that powers the “Get Data” experience in Power BI and Excel.

You can see examples of data connectors, within Power BI Desktop, by going to Get Data.

2dc44f97 3257 4a8d a9ec 7c3ad61aabbe Data Connector SDK Developer Preview

Data Connectors for Power BI enable users to connect to and access data from your application, service, or data source, providing them with rich business intelligence and robust analytics over multiple data sources. By integrating seamlessly into the Get Data experience in Power BI Desktop, data connectors make it easy for power users to query, shape and mashup data from your app to build reports and dashboards that meet the needs of their organization.

Data connectors are created using the M language and allow you to define new functions for the M language and can be used to enable connectivity to new data sources.

How to begin

You can begin to use the preview by installing the Power Query SDK from the Visual Studio Marketplace and creating a new Data Connector project. You can define your logic within this project.

2a9fa8c9 faf1 42a3 ad5c 7221d028faa8 Data Connector SDK Developer Preview

Building the project will create an extension file.

You will then want to create a directory called extensions within your Power BI Desktop\bin folder. It should be in C:\Program Files\Microsoft Power BI Desktop\bin\ by default. Then copy the extension file to that directory.

During this preview, you will need to enable an environment variable to enable the use of extensions within Power BI Desktop. Custom Data Connector consumption experiences will be offered as a preview feature within the Power BI Desktop options starting with the June release.

You should see your connector in the Get Data list.

What you can do with a Data Connector

Data Connectors allow you to create new data sources, or customize and extend an existing source. Common use cases include:

  • Creating a business analyst friendly view for a REST API
  • Providing branding for a source supported by an existing connector (such as an OData service, or ODBC driver)
  • Implementing an OAuth v2 authentication flow for a SaaS offering
  • Exposing a limited/filtered view over your data source to improve usability
  • Supporting different authentication modes when creating a Power BI Content Pack
  • Enabling DirectQuery for a data source via an ODBC driver

Currently, Data Connectors are only supported in Power BI Desktop.

More improvements and updates are coming, and you can stay tuned to the Power BI blog for these updates. Please give the preview a try and share your feedback! You can provide feedback, report issues or add feature requests through the GitHub issues page of the Data Connectors repo.

More resources

Data Connectors GitHub repo

Data Connector technical reference

M Library functions

M Language specification

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Released: Public Preview for SQL Server vNext Replication Management Pack (6.7.40.0)

We are happy to announce that public preview for SQL Server vNext Replication Management Pack is ready. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com).

You can download the public preview at: https://www.microsoft.com/download/details.aspx?id=55098

This management pack was thoroughly built from the ground up in accordance with Best Practices for SQL Server vNext. The monitoring provided by the management pack includes performance, availability, and configuration monitoring, as well as performance and events data collection. All monitoring workflows have predefined thresholds and complimentary knowledge base articles. You can integrate the monitoring of SQL Server vNext Replication components into your service-oriented monitoring scenarios.  In addition to health monitoring capabilities, this management pack includes dashboards, diagram views, state views, performance views and alert views that enable near real-time diagnostics and remediation of detected issues.  The management pack automatically selects the monitoring type used by the management pack for SQL Server vNext to monitor the appropriate SQL Server instance. Replication objects discovered and monitored by the management pack are as follows:

  • Distributor
  • Publisher
  • Subscriber
  • Publication
  • Subscription

Feature Summary The following list gives an overview of the features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server vNext Replication. Please refer to Microsoft SQL Server vNext Replication Management Pack Guide for more details. Full functionality will be available with SQL Server vNext GA. This CTP release only covers a subset of monitors and rules. We will work towards full functionality as we release new CTPs.

  • Agentless monitoring is now available along with traditional agent monitoring. Agentless monitoring target is defined by SQL Server vNext Monitoring Pool.
  • Usage of scripts is discontinued in favor of .Net Framework modules.
  • SQL Server Dynamic Management Views and Functions are now used for getting information on health and performance. Previously some of these monitors were using WMI and other system data sources.

We are looking forward to hearing your feedback.

Let’s block ads! (Why?)

SQL Server Release Services