Feeds:
Posts
Comments

Posts Tagged ‘SQL Reporting’

SQL SERVER – Migrate a SQL Server Reports from one server to another server

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged on May 5, 2012 | 3 Comments »

How many time you have felt that there should be need of the tool which help you to migrate SQL Server Reports from one server to another server. Well, I am glad to see this migration tool for migrating reports from SQL Server 2008 R2 and later version. This tool uses powershell for migration  script. Here is the requirement of source server and target server. Source server must be native mode using Windows authentication. Target server must be SharePoint integrated mode. The web application must be using Windows classic authentication mode.

You can migrate it using any of the following methods.

  1. Command-line tool (RSMigrationTool.exe)
  2. GUI tool (RSMigrationUI.exe)

Either of the tool will generate a powershell script which will migrate the reports. This tool also generates the log file which provides the additional details regarding the migration.

Here is the link to Download the SQL Server Reporting Migration Tool.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

Read Full Post »

SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005

Posted in Pinal Dave, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged , on April 13, 2010 | 13 Comments »

This article was written as a response to T-SQL Tuesday #005 – Reporting.

The three most important components of any computer and server are the CPU, Memory, and Hard disk specification. This post talks about  how to get more details about these three most important components using the Management Data Collection. Management Data Collection generates the reports for the three said components by default. Configuring Data Collection is a very easy task and can be done very quickly.

Please note:
There are many different ways to get reports generated for CPU, Memory and IO. You can use DMVs, Extended Events as well Perfmon to trace the data.
Keeping the T-SQL Tuesday subject of reporting this post is created to give visual tutorial to quickly configure Data Collection and generate Reports.

From Book On-Line:

The data collector is a core component of the Data Collection platform for SQL Server 2008 and the tools that are provided by SQL Server. The data collector provides one central point for data collection across your database servers and applications. This collection point can obtain data from a variety of sources and is not limited to performance data, unlike SQL Trace.

Let us go over the visual tutorial on how quickly Data Collection can be configured. Expand the management node under the main server node and follow the direction in the pictures.

This reports can be exported to PDF as well Excel by writing clicking on reports.

Now let us see more additional screenshots of the reports. The reports are very self-explanatory  but can be drilled down to get further details. Click on the image to make it larger.

Well, as we can see, it is very easy to configure and utilize this tool. Do you use this tool in your organization?

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005

Posted in Pinal Dave, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology, tagged , on April 13, 2010 | Leave a Comment »

If you are following my blog, you already know that I am more of “T-SQL and Performance Tuning” type of person. I do have a good understanding of Business Intelligence suit and I also do certain training sessions on the same subject. When I was writing the blog post for T-SQL Tuesday #005 – Reporting, I realized that I have written a post that clearly explains how to generate reports using SQL Server Management Studio.

Here is a quick recap on how one can use SSMS and out-of-the-box reports which can help many developers.

Please note that they can be resource-intensive as well, so please use SSMS carefully.

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS

SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005

Junior developers and DBA can use these reports right away and can also start learning and exploring most database performance issues with the help of Sr. DBAs.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »