Monday, November 29, 2010

UML Tutorial

http://www.tutorialspoint.com/uml/
http://atlas.kennesaw.edu/~dbraun/csis4650/A&D/UML_tutorial/

Sunday, November 21, 2010

.Net framework Interview Questions

http://www.andymcm.com/dotnetfaq.htm#13.5
http://www.andymcm.com/dotnetfaq.htm
http://www.andymcm.com/csharpfaq.htm#3.7
Anonymous Methods in C# 2.0
http://www.c-sharpcorner.com/UploadFile/DipalChoksi/anonmethod_cs20_dc09192006162337PM/anonmethod_cs20_dc.aspx

Are C# parameters passed by reference or by value?
All parameters are passed by value by default in C#. However, know that when passing a reference type, a reference is being passed—by value—rather than an object itself. The Java language works in the same way.

Friday, November 19, 2010

SQL Server Reporting Services(SSRS) Interview Questions

http://www.datawarehousingguide.com/microsoft-bi-interview-questions/14-sql-server-reporting-servicesssrs-interview-questions-.html

http://www.careerride.com/Reporting-services-advantages.aspx


1. Explain the flow from a report request to report delivery.
2. Where does connection string of a report exists? Can we read it?
3. Where does reporting services stands as a BI tool compared to BO, Cognos, Crystal reports, Hyperion etc?
4. What is Subreport control used for?
5. What is the difference between Matrix control & Table control?
6. What are the different aggregate functions available in SSRS?
7. How to change the format of the currency field?
8. What are report parameters?
9. What are the different types of parameters used in SSRS, explain each one of them.
10. How to add a cascading parameter to a report?
11. How to create a drilldown report? Explain the steps.
12. How to add page breaks in a report?
13. What is data driven subscription? How to implement this?
14. What services in windows need to run for SSRS to run properly?
15. What is the report history in SSRS manager means? How to enable history?
16. Explain the security architecture of SSRS
17. Mention some of the in built security roles in SSRS
18. Why do we use Reporting services configuration manager tool? What are the tasks we achieve in this?

Q.What are the drawbacks of SSRS?
Ans-For many years Microsoft had no direct solution for reporting with the SQL server except their dependency on Crystal Reports. With SQL Server 2005 onwards they have come up with SSRS – SQL Server Reporting Services, but as such this is no better than Crystal Reports although it comes bundled with the Server. The components of this are:
1. Report Builder
2. Report Designer
3. Report Server
4. Report Manager
5. Datasource
6. Report Server Database

The drawbacks are (that you can reply in your interview):
1. It is complex as of now to understand the complete functionality and structure of this new component
2. Users are still depending on Crystal reports as they are more confident as used to compared to SSRS
3. Report Designer is for developers for standard reports and report builder is for end users for designing their simple formatted reports.
4. Complete understanding and exposure to both is important to utilize both functions fully and extensively
5. For end users using report builder, data models or report models are used
6. Report model generation rules building is a complex process
7. Report exporting to excel beyond a particular size results in loss of data

Q.What can SQL Server Reporting Services do?

With Reporting Services,

* You can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources.
* You can publish reports, schedule report processing, or access reports on-demand.
* You can create ad hoc reports based on predefined models and interactively explore data within the model.
* You can select from a variety of viewing formats, export reports to other applications, and subscribe to published reports.
* You can view the reports created over a Web-based connection or as part of Windows application.
***************************************************************************************
SQL Server - how to send a SSRS report from SSIS? - Feb 27, 2010 at 11:50 AM by Shuchi Gauri
How to send a SSRS report from SSIS?

Steps to send a SSRS report from SSIS:

* Create a subscription to the report from Report Manager.
* At subscription level, mention the report format and email address of the recipient user. When a schedule is created for SSRS report, an SQL Server agent job is created.
* Execute the SSRS report subscription using sp_start_job with the appropriate report name.

SQL Server - how to send a SSRS report from SSIS? - May 05, 2009 at 22:00 PM by Rajmeet Ghai
How to send a SSRS report from SSIS?

SSIS has the ability to send SSRS report in different formats like Excel, PDF etc. This is achieved by creating a report subscription using the Report manager. In the report subscription, the format of the SSRS report can be mentioned along with the email address of the recipient. sp_start_job is used to execute the report subscription.

SQL Server - how to send a SSRS report from SSIS? - June 21, 2009 at 09:00 PM by Amit Satpute

After the SSIS package has finished loading the data, the SSRS report can be sent to different users in .xls, .pdf, etc formats.

The steps one needs to follow to do this are:

* Creation of an SSRS report subscription from Report Manager.
* Entering the report format and the email address of the recipient in the subscription.
* Creation of a schedule for the SSRS report so that the SQL Server Agent Job gets created.
* Execution of SSRS report subscription from the SSIS by using sp_start_job and providing a relevant job name.
***************************************************************************************

Interview Questions and Answers

http://jaganinfo.blogspot.com/2010/02/dell-net-interview-questions.html
http://www.aired.in/2009/09/c-interview-questions-and-answers-c.html
http://venkatcsharpinterview.blogspot.com/2009/07/c-interview-questions-on-constructors.html

Thursday, November 18, 2010

ASP.NET Session State FAQ

http://www.eggheadcafe.com/articles/20021016.asp
Basic use of Session in ASP.NET (C#):

STORE:
DataSet ds = GetDataSet(whatever parameters);
Session["mydataset")=ds;

RETRIEVE:
DataSet ds = (DataSet)Session["mydataset"];

Storage location

* InProc - session kept as live objects in web server (aspnet_wp.exe). Use "cookieless" configuration in web.config to "munge" the sessionId onto the URL (solves cookie/domain/path RFC problems too!)
* StateServer - session serialized and stored in memory in a separate process (aspnet_state.exe). State Server can run on another machine
* SQLServer - session serialized and stored in SQL server

Performance

* InProc - Fastest, but the more session data, the more memory is consumed on the web server, and that can affect performance.
* StateServer - When storing data of basic types (e.g. string, integer, etc), in one test environment it's 15% slower than InProc. However, the cost of serialization/deserialization can affect performance if you're storing lots
of objects. You have to do performance testing for your own scenario.
* SQLServer - When storing data of basic types (e.g. string, integer, etc), in one test environment it's 25% slower than InProc. Same warning about serialization as in StateServer.


Performance tips for Out-of-Proc (OOP) modes

If you're using OOP modes (State Server or SQL Server), one of your major cost is the serialization/deserialization of objects in your session state. ASP.NET performs the serialization/deserialization of certain "basic" types using an optimized internal method. "Basic" types include numeric types of all sizes (e.g. Int, Byte, Decimal, ... etc), String, DateTime, TimeSpan, Guid, IntPtr and UIntPtr.

If you have a session variable (e.g. an ArrayList object) that is not one of the "basic" types, ASP.NET will serialize/deserialize it using the BinaryFormatter, which is relatively slower.

For performance sake it is better to store all session state data using one of the "basic" types listed above. For example, if you want to store two things, Name and Address, in session state, you can either

(a) store them using two String session variables, or
(b) create a class with two String members, and store that class object in a session
variable. Performance wise, you should go with option (a).


Robustness

* InProc - Session state will be lost if the worker process (aspnet_wp.exe) recycles, or if the appdomain restarts. It's because session state is stored in the memory space of an appdomain. For details, see KB324772.
* StateServer - Solve the session state loss problem in InProc mode. Allows a webfarm to store session on a central server. Single point of failure at the State Server.
* SQLServer - Similar to StateServer. Moreover, session state data can survive a SQL server restart, and you can also take advantage of SQL server failover cluster, after you've followed instructions in KB 311029.


Caveats

InProc - It won't work in web garden mode, because in that mode multiple aspnet_wp.exe will be running on the same machine. Switch to StateServer or SQLServer when using web garden. Also Session_End event is supported only in InProc mode.

StateServer

* - In a web farm, make sure you have the same in all your web servers. See KB 313091 on how to do it.
* - Also, make sure your objects are serializable. See KB 312112 for details.
* - For session state to be maintained across different web servers in the web farm, the Application Path of the website (For example \LM\W3SVC\2) in the IIS Metabase should be identical in all the web servers in the web farm. See KB 325056 for details

SQLServer


- If you specify integrated security in the connection string (e.g. "trusted_connection=true", or "integrated security=sspi"), it won't work if you also turn on impersonation in asp.net. Unfortunately, this bug
isn't reported in KB yet. (There is a QFE fix for it.)
- Also, make sure your objects are serializable. See KB 312112 for details.
- For session state to be maintained across different web servers in the web farm, the Application Path of the website (For example \LM\W3SVC\2) in the IIS Metabase should be identical in all the web servers in the web farm.
See KB 325056 for details.

FAQ's:

Question list:

Q: Session states works on some web servers but not on others.

Q: Why isn't Session_End fired when I call Session_Abandon?

Q: Why are my Session variables lost frequently when using InProc mode?

Q: Why does the SessionID remain the same after the Session times out or abandoned?

Q: Why does the SessionID changes in every request?

Q: Can I share session state between ASP.NET and ASP pages?

Q: What kinds of object can I store in session state?

Q: How come Response.Redirect and Server.Transfer is not working in Session_End?

Q: Do I have a valid HttpContext in Session_End?

Q: How do I use session state with web services?

Q: I am writing my own HttpHandler. Why is session state not working?

Q: I am using a webfarm, and I lost session state when directed to some web servers.

Q: Why isn't session state availabe in the Application_OnAcquireRequestState (or other)

Q: If using "cookieless", how can I redirect from a HTTP page to an HTTPS page?

Q: What isn't Session available in my event handlerin global.asax?

Q: Does session state have a locking mechanism that serialize the access to state?

Answers:

Q: Session states works on some web servers but not on others.
A: Maybe machine name problem. See http://support.microsoft.com/default.aspx?scid=kb;EN-US;q316112 .

Q: Why isn't Session_End fired when I call Session_Abandon?
A: First of all, Session_End event is supported only in InProc mode. In order for Session_End to be fired, your session state has to exist first. That means you have to store some data in the session state and has completed at least one request.

Q: Why are my Session variables lost frequently when using InProc mode?
A: Probably because of application recycle. See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316148

Q: Why does the SessionID remain the same after the Session times out or abandoned?
A:Even though the session state expires after the indicated timeout period, the session ID lasts as long as the browser session. What this implies is that the same session ID can represent multiple sessions over time where the instance of the browser remain the same.

Q: Why does the SessionID changes in every request?
A: This may happen if your application has never stored anything in the session state. In this case, a new session state (with a new ID) is created in every request, but is never saved because it contains nothing.

However, there are two exceptions to this same session ID behavior:
- If the user has used the same browser instance to request another page that uses the session state, you will get the same session ID every time. For details, see "Why does the SessionID remain the same after the Session times out?"
- If the Session_OnStart event is used, ASP.NET will save the session state even when it is empty.

Q: Can I share session state between ASP.NET and ASP pages?
A: Yes! Here is our article on how to do this in either direction using two "intermediate" pages. And here is an article on how to do it with SQL Server.

Q: What kinds of object can I store in session state?
A: It depends on which mode you are using:
- If you are using InProc mode, objects stored in session state are actually live objects, and so you can store whatever object you have created.
- If you are using State Server or SQL Server mode, objects in the session state will be serialized and deserialized when a request is processed. So make sure your objects are serializable and their classes must be marked as so. If not, the session state will not be saved successfully. In v1, there is a bug which makes the problem happen unnoticed. See this KB for more info:
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;q312112

Q: How come Response.Redirect and Server.Transfer is not working in Session_End?
A: Session_End is fired internally by the server, based on an internal timer. Thus, there is no HttpRequest associted when that happens. That is why Response.Redirect or Server.Transferdoes not make sense and will not work.

Q: Do I have a valid HttpContext in Session_End?
A: No, because this event is not associated with any request.

Q: Will my session state be saved when my page hit an error?
No. Unless you call Server.ClearError in your exception handler.

Q: How do I use session state with web services?
A: The extra trick needed is on the caller side. You have to save and store the cookies used by the web service. See the MSDN documentation on HttpWebClientProtocol.CookieContainer property.

However, please note if you're using proxy object to call a web service from your page, the web service and your page cannot share the same session state due to architecture limitation.

This can be done if you call your web service through redirect.

Q: I am writing my own HttpHandler. Why is session state not working?
A: Your HttpHandler has to implement the "marker" interface IRequiresSessionState or IReadOnlySessionState in order to use session state.

Q: I am using a webfarm, and I lost session state when directed to some web servers.
A: For session state to be maintained across different web servers in the web farm, the Application Path of the website (For example \LM\W3SVC\2) in the IIS Metabase should be identical in all the web servers in the web farm.
See KB 325056 for details.

Q: Why isn't session state availabe in the Application_OnAcquireRequestState (or other)
event handler?
A: Session state is available only after the HttpApplication.AcquireRequestState event is called. For details, see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconhandlingpublicevents.asp

Q: If using "cookieless", how can I redirect from a HTTP page to an HTTPS page?
A: Try this:
String originalUrl = "/fxtest3/sub/foo2.aspx";
String modifiedUrl = "https://localhost" + Response.ApplyAppPathModifier(originalUrl);
Response.Redirect(modifiedUrl);
NOTE: Fully qualified URLs in the response.redirect, server.transfer, and FORM action
tags cannot be used with cookiless sessions. Here is an example of a fully qualified
URL: http://www.eggheadcafe.com/default.asp More info here:

Q: What isn't Session available in my event handler in global.asax?
A: It depends on which event you're handling. Session is available only after AcquireRequestState event.

Q: Does session state have a locking mechanism that serialize the access to state?
Session state implements a reader/writer locking mechanism:
- A page (or frame) that has session state write access (e.g. <%@ Page EnableSessionState="True" %>) will hold a writer lock on the session until the request finishes.
- A page (or frame) that has session state read access (e.g. <%@ Page EnableSessionState="ReadOnly" %>) will hold a reader lock on the session until the request finishes.
- Reader lock will block a writer lock; Reader lock will NOT block reader lock; Writer lock will block all reader and writer lock.
- That's why if two frames both have session state write access, one frame has to wait for the other to finish first.

Configuring Web Gardens with IIS 6.0 (IIS 6.0)

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/659f2e2c-a58b-4770-833b-df96cabe569e.mspx?mfr=true


Web gardens are different from Web farms. A Web garden is configured on a single server by specifying multiple worker processes for an application pool. Web farms use multiple servers for a Web site.

ASP.NET Caching: SQL Cache Dependency With SQL Server 2000

http://www.c-sharpcorner.com/uploadfile/mosessaur/sqlcachedependency01292006135138pm/sqlcachedependency.aspx

Passing Values between User Controls and ASPX Page

http://www.c-sharpcorner.com/uploadfile/santhi.m/passingvaluesfrmuctoaspx11212005050040am/passingvaluesfrmuctoaspx.aspx

http://www.dotnetfunda.com/articles/article97.aspx

http://www.beansoftware.com/ASP.NET-Tutorials/User-Control.aspx

Wednesday, November 17, 2010

Good dot net site and blog

http://www.dotnetspark.com/kb/773-what-is-encapsulation.aspx

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

CREATE TABLE [dbo].[tblSalary]
(
[ID] [int] NOT NULL,
[Salary] [INT]
)
ON [PRIMARY]

INSERT INTO [tblSalary] ([ID],Salary) VALUES (1,20000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (1,30000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (2,40000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (3,50000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,60000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,70000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,80000)

select max(salary) from tblSalary
where salary < (select max(salary) from tblSalary)

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

CREATE TABLE [dbo].[tblSalary]
(
[ID] [int] NOT NULL,
[Salary] [INT]
)
ON [PRIMARY]

INSERT INTO [tblSalary] ([ID],Salary) VALUES (1,20000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (1,30000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (2,40000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (3,50000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,60000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,70000)
INSERT INTO [tblSalary] ([ID],[Salary]) VALUES (4,80000)

select max(salary) from tblSalary
where salary < (select max(salary) from tblSalary)

SQL Server Cursor Examples

http://www.mssqltips.com/tip.asp?tip=1599
Cursor Components
http://msdn.microsoft.com/en-us/library/ms180169.aspx

Based on the example above, cursors include these components:

* DECLARE statements - Declare variables used in the code block
* SET\SELECT statements - Initialize the variables to a specific value
* DECLARE CURSOR statement - Populate the cursor with values that will be evaluated
o NOTE - There are an equal number of variables in the DECLARE CURSOR FOR statement as there are in the SELECT statement. This could be 1 or many variables and associated columns.
* OPEN statement - Open the cursor to begin data processing
* FETCH NEXT statements - Assign the specific values from the cursor to the variables
o NOTE - This logic is used for the initial population before the WHILE statement and then again during each loop in the process as a portion of the WHILE statement
* WHILE statement - Condition to begin and continue data processing
* BEGIN...END statement - Start and end of the code block
o NOTE - Based on the data processing multiple BEGIN...END statements can be used
* Data processing - In this example, this logic is to backup a database to a specific path and file name, but this could be just about any DML or administrative logic
* CLOSE statement - Releases the current data and associated locks, but permits the cursor to be re-opened
* DEALLOCATE statement - Destroys the cursor

Delete single row from duplicate rows in SQL Server 2005 and 2000

http://chiragrdarji.wordpress.com/2007/07/23/delete-single-row-from-duplicate-rows-in-sql-server-2005-and-2000/

Lets assume that you are using SQL Server 2005 for your current project. You found that you have few rows which have duplicate data in all the columns. Lets consider that you have table name “Example” which has two columns ID and Name.

CREATE TABLE [dbo].[Example]
(
[ID] [int] NOT NULL,
[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
ON [PRIMARY]

INSERT INTO [Example] ([ID],[Name]) VALUES (1,Chirag)
INSERT INTO [Example] ([ID],[Name]) VALUES (1,Chirag)
INSERT INTO [Example] ([ID],[Name]) VALUES (2,‘Shailesh’)
INSERT INTO [Example] ([ID],[Name]) VALUES (3,‘Dipak’)
INSERT INTO [Example] ([ID],[Name]) VALUES (4,‘Mihir’)
INSERT INTO [Example] ([ID],[Name]) VALUES (4,‘Mihir’)
INSERT INTO [Example] ([ID],[Name]) VALUES (4,‘Piyush’)

Now you want to delete duplicate rows in such a way that only one row will be exist after delete statement. First let me write the query which will give return all the duplicate rows from table.

SELECT
[ID],[NAME],COUNT([ID])
FROM
[Example]
GROUP BY
[ID],[NAME]
HAVING
COUNT([ID]) > 1

Query to identify duplicate rows in table.

Here I have used COUNT([ID]) in select statement as ID is not null filed. You can use any column which is not NULL. If all the columns in your table allows NULL value than you can use COUNT(*). The Difference between COUNT(Column Name) and COUNT(*) is, if your column allows null value and in table you have 5 records with 2 null values in ColumnA. If you use COUNT(ColumnA) it will returns 3 and if you use COUNT(*) it will returns 5. So COUNT(Column Name) ignores NULL value. Lets get back to our query. I have used all the column in SELECT and GROUP BY clause. You also have to write all the columns of your table in SELECT and GROUP BY clause. This way you can identify all the duplicates row from table.

Lets assume that you have to delete the row which has value (1, ‘Chirag’) so that only one row remains. Here is the query, (Note: This will work only in SQL Sever 2005)

DELETE TOP(1) FROM [Example] WHERE [ID] = 1

Fig – (3) Delete single row from duplicate rows.

Here I have used TOP(1) , If you have n rows which has all the values same than you have to use TOP(n-1) so that only 1 row will be remain after delete statement. To delete all the duplicate rows you need to write a cursor as shown below,

DECLARE @ID int
DECLARE @NAME NVARCHAR(50)
DECLARE @COUNT int

DECLARE CUR_DELETE CURSOR FOR
SELECT [ID],[NAME],COUNT([ID]) FROM [Example] GROUP BY [ID],[NAME] HAVING COUNT([ID]) > 1

OPEN CUR_DELETE

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
/* Loop through cursor for remaining ID */
WHILE @@FETCH_STATUS = 0
BEGIN

DELETE TOP(@COUNT -1) FROM [Example] WHERE ID = @ID

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
END

CLOSE CUR_DELETE
DEALLOCATE CUR_DELETE

Fig – (4) Cursor to delete all duplicate records

This is all about deleting duplicate rows in SQL Server 2005.

Now to do the same in SQL server 2000. There is function called ROWCOUNT in SQL. I have used same [Example] table. You can do this by,

SET ROWCOUNT 1
DELETE FROM [Example] WHERE [ID] = 1

Fig – (5) Delete duplicate row in SQL Server 2000

ROWCOUNT function specify that how many rows will be affected by the statement which is immediately written below. Here also you have to write ROWCOUNT (n -1) to delete n duplicate rows such that only 1 row will remain in database.

Wednesday, November 10, 2010

PIVOT queries in SQL Server 2005

http://geekswithblogs.net/lorint/archive/2006/08/04/87166.aspx
http://articles.techrepublic.com.com/5100-10878_11-6143761.html
Previously we are using CASE,GroupBy In place of this concept Sql Server 2005 provide
"PIVOT" concept,
With the new PIVOT operator in SQL Server 2005, the CASE statement and GROUP BY statements are no longer necessary.
(Every PIVOT query involves an aggregation of some type, so you can omit the GROUP BY statement.)
The PIVOT operator provides the same functionality that we tried to achieve with the CASE statement query, but you can achieve it through less code
MSDN states that you cannot pivot two columns
If you want two columns with the same column header, then you cannot achieve it

LIMITATION
The PIVOT operator is useful in many situations, yet there are drawbacks.
"hard code" the fields that you are pivoting into columnar data
You can overcome this by building the PIVOT query through dynamic TSQL statements, but this is not the most desirable solution.

http://www.mssqltips.com/tip.asp?tip=1019

Improves Stored Procedure Performance in SQL Server

1.SET NOCOUNT ON is used in procedure for improve the performance of the store procedure.
put at the top of a stored procedure turns off the messages that SQL Server sends back to the client after each T-SQL statement is executed.
This is performed for all SELECT, INSERT, UPDATE, and DELETE statements.

If you still need to get the number of rows affected by the T-SQL statement that is executing you can still use the @@ROWCOUNT option.  By issuing a SET NOCOUNT ON this function (@@ROWCOUNT) still works and can still be used in your stored procedures to identify how many rows were affected by the statement.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
@Param1 = <Default_Value_For_Param1, , 0>,
@Param2=<Default_Value_For_Param2, , 0>
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
GO


Improving SQL Performance 
http://www.componentace.com/help/absdb_manual/increasesqlperformance.htm  

Extention method

http://www.developer.com/net/csharp/article.php/3592216
Following are the interview questions
1.Difference between asp.net 3.5 and 4.0
2.why we are using Ajax.
3.what is Extention method.
4.how the procedure will faster.
5.how to improve the performance of the SQL Server.
6.What is pivot table.
7.did you know generic.

Tuesday, November 9, 2010

Introduction To Role-Based Security In SQL Server Reporting Services

http://odetocode.com/Articles/215.aspx

InterView Question

1.What is DTS Package in SQL SERVER.
2.What are the sequrities used in the SSRS Report.
3.What is the advantage to use SSIS Package in place of window service. 

Thursday, November 4, 2010

SQL Server 2005 Setup Experience

1.first configure your IIS in your system other wise it is throwing error
2.Control Panel > Add or Remove Programmes >  Click on Add/Remove Windows components
then checked IIS and click next to install IIS.

follow this link
http://frater.wordpress.com/2009/06/14/sql-server-setup-failed-to-obtain-system-account-information-for-the-aspnet-account/

Fix this by registering asp .net with IIS. To do this open a command prompt and go to the following directory:
C:\windows\Microsoft.NET\Framework\v2.0.60727\
This is assuming you’re using .Net 2.0 or higher (3.0, 3.5). Even if you’re using the 3.x series and Visual Studio 2008, you still need to go to the v2.0 directory for this operation – this is because the 3.x series are not a replacement for the 2.x series, but rather extensions. (3.x is a superset of 2.x and there have been no breaking changes to 2.x functionality).

f you want to understand this further, there is an interesting post about it here: http://blogs.msdn.com/vijaysk/archive/2008/03/20/running-asp-net-3-5-on-iis.aspx
For now though, run the following command: aspnet_regiis.exe -i

execute it  "aspnet_regiis.exe -i" in command window

Windows XP Service pack 3 Download site

http://www.microsoft.com/downloads/en/confirmation.aspx?FamilyID=5b33b5a8-5e76-401f-be08-1e1555d4f3d4&displaylang=en

Deploy SSIS Package.....

http://www.protalk.in/sql-server/steps-to-create-and-deploy-ssis-package-as-a-sqlagent-job/
all the information related to SSIS Package
http://technet.microsoft.com/en-us/library/cc966389.aspx 
DTS VS SSIS 
http://decipherinfosys.wordpress.com/2008/03/11/dts-vs-ssis-a-basic-overview/
How to start and stop windows service from SSIS
http://sqlreality.com/blog/ssis/how-to-start-and-stop-windows-service-from-ssis/
Could not execute SSIS package from windows service
http://www.sqldev.org/sql-server-integration-services/could-not-execute-ssis-package-from-windows-service-17034.shtml

New features in SSIS 2008 that can Improve SSIS 2008 Performance over SSIS 2005
http://siddhumehta.blogspot.com/2009/03/new-features-in-ssis-2008-that-can.html
Scheduling SSIS Package using SQL Server Agent
http://www.c-sharpcorner.com/UploadFile/MIkkykumar/3772/Default.aspx 
Executing Remote SSIS Package via Web Service
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_24515667.html 

Profiles In ASP.NET 2.0

http://odetocode.com/Articles/440.aspx
http://www.codersource.net/asp-net/asp-net-2-0/profiles-in-asp-net-2-0.aspx