Showing posts with label Reporting. Show all posts
Showing posts with label Reporting. Show all posts

Wednesday, August 21, 2013

Free eBook #1 of the day: Windows Azure SQL Reporting Succinctly

Syncfusion - Windows Azure SQL Reporting Succinctly


Windows Azure SQL Reporting provides a flexible platform for managing and viewing reports. Its cloud-based architecture means that its services are instantly scalable for any number of users—adding and removing servers through Windows Azure is significantly simpler than managing on-site servers—and maintenance costs are kept to a minimum. With Windows Azure SQL Reporting Succinctly by Stacia Misner, you'll learn how to set up a SQL Database server, migrate your existing data to the cloud, design report items, and deploy complete reports to the server. Instruction is also provided for managing user roles and creating reusable report parts.

Table of Contents

  1. Introduction to SQL Reporting
  2. Getting Started
  3. Report Development
  4. Report Management
  5. Report Parts
  6. Security
  7. Report Access

NOTE: They ask for your name, email address and phone. Based on past experience, have a care with what information you provide (which is not validated or really used for the download) [cough... possible spam alert... cough] But remember, free isn't free...


Related Past Post XRef:
Need some help up the WPF learning curve? "WPF Succinctly" from Syncfusion is now available (and free :)
TypeScript Succinctly - Free [Name/email-ware] eBook
Getting sharp with F# with the free "F# Succinctly" eBook [reg-ware]
Syncfusion helps shed a little succinct light on LightSwitch with "LightSwitch Succinctly" (Reg-ware)
"JavaScript Succinctly" - Another free (reg-ware) eBook from Syncfusion
Get into sync with HTTP with the new free (reg-ware) Syncfusion Succinctly eBook, "HTTP Succinctly"
Spelunk the technical details of the PDF format with "PDF Succinctly" from Syncfusion (Free/reg-ware PDF/Mobi ebook)
"Git Succinctly" Free/reg-ware PDF/Mobi ebook)
jQuery Succinctly - Free eBook (reg-ware, PDF and/or Mobi)

Thursday, April 26, 2012

"The SQL Server is slow..." - Try starting with the free SQL Server 2012 Performance Dashboard Reports

MS SQL Tips - Install SQL Server 2012 Performance Dashboard Reports


SQL Server 2012 Performance Dashboard Reports are Custom Reports which Microsoft has developed to quickly give an overview of the overall performance of SQL Server 2012 instance. Keep in mind that in order to use the Performance Dashboard Reports you don’t need to install SQL Server Reporting Services. In this tip we will take a look at how to install and use these built-in SQL Server Reporting Services Reports.


SQL Server 2012 Performance Dashboard Reports can be downloaded from the following link: The Microsoft Documentation states that “The SQL Server 2012 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem. The Dashboard reports basically retrieve information from SQL Server Dynamic Management Views and hence there is no additional overhead when using these reports.”

Common performance problems that the Performance Dashboard Reports may help to resolve include:

  • CPU bottlenecks
    • What queries are consuming the most CPU?
  • IO bottlenecks
    • What queries are performing the most IO operations?
  • Index recommendations generated by the query optimizer
    • What are the potential missing indexes?
  • Blocking
    • What blocking is occurring?
  • Latch contention
    • What are the volume of latches?

Once you have successfully downloaded the SQL Server 2012 Performance Dashboard Reports then the next step will be to install the reports. Follow the steps below to complete the installation process.


Note that there's more to just installing the MSI to use these reports (there's a setup.SQL you need to run per server and you need to select the main dashboard report manually). Read the above post as it covers it all in easily to read details.

Since I'm pushing for SQL Server 2012 at my day job, I thought I should mention these reports. Sure we've got production cross-server monitoring tools and all, but sometimes you just need some simpler. And these will be great for our Dev/QA/Stage servers.

Here's a snap of the Performance Dashboard report (reporting against a SQL Server running on my notebook);


And a few snaps of a few of the other reports;





As you can kind of see, much of the data is linked, so you can click down to additional details. And remember, this is all free...


Related Past Post XRef:
SQL Server 2012 RTM Day Download Link Round-up
SQL Server 2005 Performance Dashboard Reports

Tuesday, January 10, 2012

Silverlight Reporting example project from Pete Brown updated for Silverlight 5 - Silverlight Reporting Open Source Printing/Reports Example Updated for Silverlight 5

"I recently posted an updated version of Silverlight reporting on codeplex. Here's the overview.

This project, a unofficial project by Pete Brown of Microsoft, provides a a very basic framework for building simple, short, multi-page reports using Silverlight 5.

The intent is not to be an all-encompassing reporting solution, or a solution for large reports. Instead, this is a set of code you can build upon to create short (2-5 page) reports from your Silverlight applications.

Currently the sample consists of the full source code of a simple report writer. It includes:

  • automatic pagination
  • support for line items of varying height
  • total page count
  • templating
  • page headers and footers
  • report footer with support for calculated fields
  • events to allow hooking into printing at various stages



Some times simple is all you need. As I often say, "Keep it simple at first because it's going to get complicated all by itself..."

Thursday, June 09, 2011

So what's the big picture in your little part of the twitterverse...? Microsoft Analytics for Twitter

Microsoft Downloads - Microsoft Analytics for Twitter

Microsoft Analytics for Twitter allows users to query Twitter (i.e. Tweeters, #hashtags, @mentions & keywords) and get dashboard views on Twitter statistics inside Microsoft® Office Excel 2010

Microsoft Analytics for Twitter.exe: 2.9MB

Version: 1.2.0

Date Published: 6/9/2011

Microsoft Analytics for Twitter allows users to search Twitter and get dashboard views on Tweet statistics inside Microsoft® Office Excel 2010.
With this FREE add-in, you can:

  • Perform up to 5 parallel Twitter Searches (limited to 1500 results per query per day).
  • Drive ad-hoc analysis of tweets by day, by hour, by tweeters, by #hashtags and @mentions.
  • Customize your views (using slicers, DAX formulas or reference tables).

  1. Please note, that, after Installation, Microsoft Analytics for Twitter will manifest itself as a Microsoft® Excel 2010 file called "Microsoft Analytics for Twitter.xlsx" on your desktop.
  2. Please note that Microsoft Analytics for Twitter works only with the latest versions of Microsoft® Excel 2010 and of Microsoft® PowerPivot for Excel 2010. To download Microsoft® PowerPivot for Excel 2010, please go to



Perform Twitter Search

  1. Open the "Microsoft Analytics for Twitter.xlsx" file on your desktop.
  2. Enter a maximum of 5 comma delimited search queries in the search pane located at the top of the "Topics", "People", "Tone" or "Details" worksheets. See the Twitter Search Syntax section for more information on the search syntax. You only need to enter your search term once to populate all the worksheets. For your convenience, the search pane is located at the top of each sheet.
  3. Click the search icon to retrieve Twitter search queries.
  4. Wait for the "Twitter Search Complete" message box.
  5. Click OK.
  6. Wait for the "Next Steps" message box. If a "Twitter Search Query Clipped" message box precedes this message, note the message and consider refining the affected search query.
  7. Click OK.

Refresh the data
  1. On the PowerPivot tab in Excel, click "Update All".
  2. Wait until PowerPivot Window has refreshed.
  3. Close or minimize the PowerPivot Window.
  4. On the Data tab in Excel click "Refresh All".

Tone Dictionary
The Tone Score is calculated based off of the user defined tone dictionary. This dictionary maps keywords to a tone index which is a sliding scale from very positive to very negative. Users can modify the dictionary to meet the needs of their specific search topic.
  1. On the Tone Dictionary worksheet in Excel, modify the dictionary terms in the right hand column.
  2. Repeat Perform Twitter Search and Refresh Data steps. The Tone Score is calculated as part of the search query process, thus in order to capture dictionary updates the search must be performed after tone dictionary updates.

Search Query Syntax
Microsoft Analytics for Twitter has been designed to support up to 5 concurrent search queries on #hashtags, @mentions, keywords and Tweeters. The search operators' syntax follows Twitter Search syntax see The following examples outline several sample search scenarios.
  • Searching Hashtags
    • #microsoft, #msbi, #sql, #sqlserver, #powerpivot
    • #microsoft AND #bi, #sql OR #sqlserver
  • Searching Mentions
    • @microsoft, @microsoftbi, @powerpivot
    • @microsoft AND @bi, @sql OR @sqlserver
  • Searching Keywords (i.e. freeform text search)
    • microsoft, powerpivot, excel
    • excel AND bi, powerpivot or sql
  • Tweeters
    • from:MicrosoftBITV, from:MicrosoftBI
    • from:MicrosoftBITV OR from:MicrosoftBI
  • Combo Search
    • #msbi, @microsoftbi, MicrosoftBI, from:MicrosoftBI
    • #msbi AND @microsoftbi, MicrosoftBI OR from:MicrosoftBI
  • Twitter search queries are limited to the past 4 - 7 days and a maximum of 1500 tweets per day.

If you need to do analysis of what's happening on Twitter, this seems like something that might come in handy (and free is hard to beat)




Thursday, May 26, 2011

Creating a Windows Sidebar gadget for a SQL Server Reporting Services Report walkthrough

SQL Server Forum Support Team - Walkthrough: Integrating your SQL Server Reporting Services report into Windows 7 Sidebar Gadget

"By default, after installing Window7 operation, there are many powerful and handy little tools in Sidebar Gadget, you can also download some customized Sidebar Gadget, such as: MSDN forum helper. Currently, we have some stock reports to show the real-time status of stock market, we also want to integrate SQL Reporting Services - stock report into window7’s Sidebar Gadget rather than open the IE all the time.

This article will walk you through the processes of integrating SQL Server Reporting Services into Windows 7 Sidebar Gadget.



Been a while since I've done either a SSRS or Sidebar post and since I'm considering using SSRS on a new project.

I can see some use cases/reports where something like this could be a serious "wow factor." Wouldn't use it much, but for mission critical, operational or exception reports I can see this being pretty handy. hum....

Tuesday, February 26, 2008

TFS 2005-vs-2008 Report Differences - New and Removed Reports

Max Yermakhanov's Blog - Fixing TFS reports after an upgrade/migration to TFS 2008

"Microsoft has made quite a few changes to reports in TFS 2008. As you can see form the table below in TFS 2008 we do not only have 6 new reports, but some of the existing reports have been modified/removed (new reports are in red, removed reports are in orange).

TFS 2005 default reports

TFS 2008 default reports

Actual Quality vs Planned Velocity
Bug Rates
Bugs by Priority
Bugs Found Without Corresponding Tests

Load Test Summary
Project Velocity
Quality Indicators
Related Work Items
Remaining Work
Scenario Details
Tests Failing Without Active Bugs
Tests Passing With Active Bugs
Unplanned Work


Actual Quality vs Planned Velocity
Bug Rates
Bugs by Priority
Bugs Found Without Corresponding Tests
Exit Criteria
Issues List
Load Test Detail
Load Test Summary
Project Velocity
Quality Indicators
Related Work Items
Remaining Work
Scenario Details
Tests Failing Without Active Bugs
Tests Passing With Active Bugs
Unplanned Work
Work Item with Tasks
Work Item with TestResults
Work Items

This means that when you upgrade/migrate to Team Foundation Server 2008, your reports will no longer work as the schema has changed. To resolve the issue you need to download the new process template ( and add or update your reports on TFS server.

To add new report:


To update existing report:


This hasn't bitten us yet, but it's good to know. I don't know if I've seen this anywhere else (but given the number of feeds I scan it's very possible I just missed it...) so I'm glad Max noted it (as well as gave instructions on how to add new/update existing reports).

Tuesday, November 27, 2007

Microsoft Report Viewer 2008

Direct Reports (Brian Welcker's Weblog) - Younger Than Yesterday (ReportViewer in VS 2008)

"As most of you probably know by now, Visual Studio 2008 is now available. What you might not have noticed is a new version of the ReportViewer control and local /embedded report editing experience. Included with VS 2008 are the following new features:


  • New Report Projects: Two new project templates for quickly creating reporting applications. When you create a new Report Application project, you get a blank report (.rdlc) and a form with a ReportViewer control bound to the report.
  • ...


Documentation for the new ReportViewer is here. The new version runs SxS with the VS 2005 version. This means to use the new controls, you will need to change the references in your project to use the new ReportViewer control.  We will be writing a KB article about how to do that soon.


If you are going to ship the new ReportViewer with your application, we now have an updated version of the redistributable to the web. The download page is here. For the ClickOnce scenario, the ReportViewer.exe  FWLink is also live. "

Reporting is coming to my work world soon than later so this will come in handy...


Update #1 11/27/2007 @ 10:51AM PST:

Microsoft Downloads - ReportViewer Samples for Microsoft Visual Studio 2008

"Visual Studio 2008 includes ReportViewer controls that you can use to add rich data reporting to Windows forms and ASP.NET applications. This download provides two complete samples so that you can view the control and sample reports in a finished application.

  • The RSSNewsReader sample is a Windows form application written in Visual C#. It retrieves data from live news feeds and presents that data in a report. The report demonstrates how to use parameters to filter the dataset.
  • The Web Log Analyzer is a Windows form application written in Visual Basic. It analyzes log files created by Web servers, such as Microsoft Internet Information Services (IIS). It includes reports that show statistics on page hits, server activity, and referrals from other sites.