SQL server Joins or Subqueries?
Select statements that use join operator and join statements can be written in Subqueries and similarly Subqueries can be written in Joins. Writing the Select statements with Join operator can help database engine to find more efficient strategy for retrieving the appropriate data. However each having their own advantage over other. Some problems can be easily solve with Subqueries and some can be solve with Joins. More about SQL Joins can read here.
Related Posts:
No commentsSQL Server Reports Integration with SharePoint 2007
This post explains how to Deploy the SQL server Reports to Office SharePoint Server 2007. SQL Server Reporting Services can operate in two modes, either in Native Mode or Share Point Integration Mode.
Related Posts:
No commentsReport Builder 2.0 in SQL Server 2008
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
Related Posts:
No commentsLog Parser usage
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>.
Related Posts:
3 commentsSSIS Package Configuration in SQL server 2008
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
Related Posts:
1 commentWebForms Routing in ASP.NET 4
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
Related Posts:
1 commentDynamic Metadata using 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
Related Posts:
No commentsWCF Discovery with UDP
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
Related Posts:
No commentsRemote Desktop Sessions from Commandline
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
Related Posts:
No commentsWCF Service using ASP.NET AJAX Library
More often, the data to shown in an AJAX page is retrieved from the Web server using a Web service, a Windows Communication Foundation (WCF) service. The services that can also return JavaScriptObjectNotation(JSON) are potential candidates for AJAX pages.
This post explains about calling a WCF service using ASP.NET AJAX Library Data View control. The following are the steps to create and call the service using ASP.NET AJAX Library.
1. Creating a AJAX enabled WCF service
2. Loading the required scripts
3. Calling a service using ASP.NET AJAX Data View Control
![Recommend [kalyanms1]](http://s3.amazonaws.com/arkayne-media/img/badge/logo-recommend-badge-medium.png){kind=icon}
