TechBubbles

Report builder 2.0 is a report authoring tool that we can use to design and publish reports. We can specify the data source, what data to display on report and which layout you prefer to see the report. When you run the report, the report processor takes all the information you specified and retrieves the data and generates each page as you view it. This post explains step-by-step details of creating the report using Report Builder 2.0.

Using Report Builder you can

Read more

Related Posts:

• PIVOT & UNPIVOT Operators in SQL Server 2008
• Date & Time Data Types in SQL Server 2008
• T-SQL TIP in SQL Server 2008
• Table Expressions in SQL server
• SQL server Joins or Subqueries?

Log parser is a free tool from Microsoft where developers and support technicians can use to parse the IIS logs, Event Logs and Active Directory logs. This tool helps the developers to find the root cause for the site related issues. This post explains common commands that we use to look for specific information in IIS logs.

The tool can be downloaded from here

The default location for IIS logs is %windir%\System32\LogFiles\W3SVC<SiteID>.

Read more

Related Posts:

• No Related Posts

SSIS configuration wizard allows you to create configurations for packages. It also allows you to update the properties and objects of the package at run time.

Package Configuration Benefits

• Configuration really helps the developers to smoothly move the packages from Development environment to Production environment.

         Eg: Configuring the source path of the file or updating the database

              connection string.

• Configurations makes it easier when you deploy the packages over different sql servers.
• Using property expressions we can update the value of variable in configuration. More about this can be read here

1. Open the Business Intelligence Development Studio from Start->Programs

Read more

Related Posts:

• Runtime Settings with SSIS Package
• Creating a SSIS package in VS 2008
• PIVOT & UNPIVOT Operators in SQL Server 2008
• Date & Time Data Types in SQL Server 2008
• T-SQL TIP in SQL Server 2008

This post explains about WebForms routing features available in ASP.NET 4. Routing feature originally designed for ASP.NET MVC and now available for Webforms as well. You need to install Visual Studio 2010 ultimate beta2 to try the routing features in ASP.NET 4.

1. Create a ASP.NET Web Application in Visual Studio 2010 as follows

Read more

Related Posts:

• Dynamic Metadata using ASP.NET 4.0
• WCF Service using ASP.NET AJAX Library
• Master-Detail Views using ASP.NET AJAX
• ASP.NET AJAX Library Beta in Visual Studio
• Client IDs in ASP.NET 4.0

This post explains about Dynamically assigning Metadata to a page using code behind in ASP.NET 4.0. Metadata is so important as Search engine optimization considers Metadata keywords and description to index  the page. If you can dynamically assign the metadata to your page then search engine can easily analyze and puts the page in results list.

1. Create a ASP.NET web application in VS 2010 and add a grid view to the page

Read more

Related Posts:

• WCF Service using ASP.NET AJAX Library
• Master-Detail Views using ASP.NET AJAX
• Client IDs in ASP.NET 4.0
• WebForms Routing in ASP.NET 4
• ASP.NET AJAX Library Beta in Visual Studio

Inorder to call the WindowsCommunicationFoundation service, a port or pipe which assigned to the service must be available and the client must know the address endpoints before calling the services.

If the service could use any available address then client can discover that address at runtime. There is a industry standard-based solution which helps in discovering the service addresses.

Address Discovery

Discovery relies on the User Datagram Protocol(UDP). Client uses UDP to broadcast discovery requests for any end-point which supports the contract type. These requests are received by dedicated end-points. The end-points responds back to the client with service-address that support specified contract.

WCF offers a standard discovery endpoint with the type UdpDiscoveryEndpoint

Read more

Related Posts:

• Web services security
• MTOM Support to Web Service
• Digital Signing the SOAP Message
• Adding Security Credentials to SOAP
• Verify SOAP Messages Signed using Username and Password

You will commonly see the following error message when you try to connect windows 2003 server using RemoteDesktopConnection.

“The terminal server has exceeded the maximum of allowed connections ”

You can disconnect the other remotely logged in users if you are a domain Admin user. Most of the users some time not even be using the sessions.

To see the list of remote sessions in the command window, type the following command.

qwinsta /server:<ServerIP>

Example:

qwinsta /server: 192.168.219.2

Read more

Related Posts:

• No Related Posts