Monitoring running processes in SQL Server 2008 R2
|
You can view the current connections and processes that running on a sql server instance in two ways
|
 |
Monitoring Process in Activity Monitor
To open the Activity Monitor in SQL Server Management Studio Right click the server then select the Activity Monitor option as shown below
Related Posts:
No commentsFiltering Techniques for SQL Server 2008 R2 Reports
|
It is important to consider to filter report data based on user’s selection criteria as many databases contain large amounts of data. This post discusses different techniques to filter report data using report parameter concepts. By using the filters on reports, it greatly reduces the network traffic and helps the report to render efficiently. |
|
We are using same data source and query that we used to demonstrate the tabular reports demo. You can read the post here.
Filtering by query - You can filter the records in query by adding a where clause to it. Write the following query in query designer as follows
Related Posts:
No commentsChart Reports in SQL Server 2008 R2 reporting services
| Charts are effective way to visualize the aggregated values. This post discuss about creating a chart, Pie and Gauge reports using SQL server 2008 R2 Reporting Services. You will notice a significant difference in chart types in SQL 2008 R2 compared to SQL 2005. | |
Choosing Chart types: The important point while choosing a report type is – choose a chart type that meets the need and adds business value to the report.
You can choose Linear bar and column charts for visualizing the quantitative points. Line Chart may be the best choice when you measure the time on one axis and data values on another axis. Pie chart is suitable when you want to show portions and ratios.
We can use the same dataset that we used for tabular report for creating chart reports. You can read the post here.
Related Posts:
1 commentTabular Reports in SQL Server 2008 R2 Reporting Services
| It is important to understand the reporting options available in SQL Server 2008 R2 to provide an appropriate report layout to meet the business requirements and needs of our end users. This post briefly discusses about different report layout types available and explains in detail the steps to create a Tabular Report. It also explains how to sorting and drilldown features to your report. | |
Different Available Report Layouts are
- Tabular Reports – these reports are defined using table data and organized in to rows and columns. The columns are typically fields in the table. Reporting detail rows can be grouped on various fields, each group can have header, footer , breaks and subtotals.
Related Posts:
2 commentsDatabase Mail Configuration in SQL Server 2008 R2
| This post explains the configuration steps that require to send an email from SQL server 2008 R2. It is useful if we could send an email from SQL Server to our administrators and end users. Database Mail is SQL server component that uses Simple Mail Transfer Protocol (SMTP) to send email messages. After setting up the Database email we can test the email and mail-log. | |
1. Open the SQL server management studio and expand the Management node under the server
Related Posts:
No commentsConfiguring SQL Server Reporting Services in SharePoint 2010
| This post discusses how to configure SQL server reporting services in SharePoint Integration mode. You must do some configuration steps on both report server and SharePoint server to get report viewing on SharePoint sites. |  |
SQL server reporting services can be configured in two modes
Related Posts:
11 commentsData Binding for Silverlight Application
This post explains loading data into Silverlight form using ADO.NET Data Services service. We need to do the following tasks to achieve this
- Creating an ADO.NET Data Services project
- Creating a Silverlight application and referring the created service above
Creating the ADO.NET Data Services project
1. Create an empty web application using Visual Studio 2010 as follows
Related Posts:
No commentsData Binding in Windows Forms
This post demonstrates the different ways of data binding in windows forms. It also discuss the concepts which are key to understanding the things that are new and different in other binding models. We first design the form using Typed Data Set and then modify the form to work with LINQ to SQL and Entity Framework models.
1. Typed Data Set
Create a new windows forms project in Visual Studio and add a typed dataset named AW2008.xsd to project.
Drag the Product, Product Category and Product Subcategory tables to the designer and save the details.
Related Posts:
No commentsBuilding a CUBE in SQL Server 2008
Creating the Project
To create a cube, we need to create a Analysis Services Project in Visual Studio. Start Visual Studio, select File, New Project. In project dialogue box, select Business Intelligence Projects from Project Types and select Analysis Services Project from right in the dialogue box.
Related Posts:
No commentsPIVOT & UNPIVOT Operators in SQL Server 2008
PIVOT is a new T-SQL operator introduced in SQL Server 2008 which can be used to rotate rows into columns and can create a crosstab query. You can specify the PIVOT operator in FROM clause of your query.
Using PIVOT
Specify the desired values that you want to see in SELECT statement and FROM clause contains the PIVOT statement. Let us take an example
