Creating an Analysis Services Project in Visual Studio 2008
Microsoft SQL Server Analysis Services allows the developers to provide a unified access of data for analytical analysis and reporting. Developers can manage and aggregate the queries from multiple subject areas. This can be achieved by creating a cube in Visual Studio 2008. This post defines and explains the terms used in creating an analysis project in VS 2008.
Related Posts:
No commentsSilverlight sample in Visual Studio 2008
This post explains the tools required to start working with the Silverlight 3 in VS 2008. Also explains the sample Silverlight application building in Visual Studio 2008 environment.
Related Posts:
No commentsTable Expressions in SQL server
Table Expressions are sub-queries where a table is expected. There are two types of table expressions. This post explains how to use the Table expressions and their advantages.
- Derived tables
- Common Table Expressions
Related Posts:
No commentsSQL 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:
No 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:
No commentsWebForms 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:
No commentsDynamic 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
![Recommend [kalyanms1]](http://s3.amazonaws.com/arkayne-media/img/badge/02me.png){kind=icon}
