Table Variable and Temp Tables in Sql Server 2005

Here I am using Temp Table and Table Variable.
This code is using iteration logic (loop through).

--- tempLocations table which conists Id,LocationId ( 1,30 | 2,31 | 3,32 | 4,33 | 5,34 | 6, 35 )

Table variable:

declare table @TempLocations (Id int identity, LocationId int)

Temp Table :
declare table #TempGrid
(countOfCurrentPostalCode int, LocationId int, PostalCode varchar(20))

declare @loop int
set @loop = (select min(Id) from @TempLocations)
declare @LocationId int
WHILE @loop IS NOT NULL
BEGIN
select @LocationId = LocationId from @TempLocations where id = @loop
insert into #TempGrid
select top 200 count(PostalCode) as counter , locationid, postalcode from TempFinal where locationId = @LocationId group by locationid, postalcode order by counter desc
set @loop = (Select min(Id) from @TempLocations where Id > @loop )
END


select * from #TempGrid
select * from #tempLocations

How to write Transactional Error Messages into a Error Log Table in Sql Server 2005?

A TRY Block - the TRY block contains the instructions that might cause an exception

A CATCH Block - if an exception occurs from one of the statements in the TRY block, control is branched to the CATCH block, where the exception can be handled, logged, and so on.


BEGIN TRY
BEGIN TRAN
INSERT Query COMMIT TRAN
END TRY

BEGIN CATCH
ROLLBACK TRAN
INSERT dbo.ErrorLog([ErrorNumber],[ErrorMessage],[ErrorSource],[ErrorLine])
VALUES (ERROR_NUMBER(), ERROR_MESSAGE(),ERROR_PROCEDURE(),ERROR_LINE())
END CATCH

How to Display First 10 Records only from a Result set in Sql Server 2005?

How to display first 10 records from a result set?


Here I used CTE (Common Table Expression), and Row_Number() function in Sql Server 2005.

USE AdventureWorks;
GO
WITH OrderedOrders AS
(SELECT ROW_NUMBER() OVER (order by OrderDate)as RowNumber,*
FROM Sales.SalesOrderHeader )



SELECT *
FROM OrderedOrders
WHERE RowNumber <= 10

How to Embed Audio/Video/PDF files within Sharepoint Application?

Hi,
I found 2 links for doing this operations.

Here they are

playing audio/video files within Sharepoint

Showing PDF document content in Sharepoint

Learning Sharepoint Step By Step

Introduction
Introduction to libraries
Intro to lists
OOB Sharepoint Sites
View
Versioning in Sharepoint
Configuring alerts and Email
Meeting and Document WorkSpace
Security Features
Customization the Sharepoint Sites
Web Parts
Site Column and Content Types
Workflow
Business Intelligence



Click Here to get all info

SQL Server Interview Questions and Answers

SQL Server Interview Questions and Answers -Introduction
SQL Server Interview Questions and Answers - Part 1
SQL Server Interview Questions and Answers - Part 2
SQL Server Interview Questions and Answers - Part 3
SQL Server Interview Questions and Answers - Part 4
SQL Server Interview Questions and Answers - Part 5
SQL Server Interview Questions and Answers - Part 6
SQL Server Interview Questions and Answers Complete List Download


Click Here to get all the things

C# Interview Questions

1. Does C# support multiple-inheritance?
No.

2. Who is a protected class-level variable available to?
It is available to any sub-class (a class inheriting this class).

3. Are private class-level variables inherited?
Yes, but they are not accessible. Although they are not visible or accessible via the class interface, they are inherited.

4. Describe the accessibility modifier “protected internal”.
It is available to classes that are within the same assembly and derived from the specified base class.

5. What’s the top .NET class that everything is derived from?
System.Object.

6. What does the term immutable mean?
The data value may not be changed. Note: The variable value may be changed, but the original immutable data value was discarded and a new data value was created in memory.

7. What’s the difference between System.String and System.Text.StringBuilder classes?
System.String is immutable. System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.

8. What’s the advantage of using System.Text.StringBuilder over System.String?
StringBuilder is more efficient in cases where there is a large amount of string manipulation. Strings are immutable, so each time a string is changed, a new instance in memory is created.

9. Can you store multiple data types in System.Array?
No.

10. What’s the difference between the System.Array.CopyTo() and System.Array.Clone() ?
The Clone() method returns a new array (a shallow copy) object containing all the elements in the original array. The CopyTo() method copies the elements into another existing array. Both perform a shallow copy. A shallow copy means the contents (each array element) contains references to the same object as the elements in the original array. A deep copy (which neither of these methods performs) would create a new instance of each element's object, resulting in a different, yet identacle object.

11. How can you sort the elements of the array in descending order?
By calling Sort() and then Reverse() methods.

12. What’s the .NET collection class that allows an element to be accessed using a unique key?
HashTable.

13. What class is underneath the SortedList class?
A sorted HashTable.

14. Will the finally block get executed if an exception has not occurred?
Yes.

15. What’s the C# syntax to catch any possible exception?
A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

16. Can multiple catch blocks be executed for a single try statement?
No. Once the proper catch block processed, control is transferred to the finally block (if there are any).

17. Explain the three services model commonly know as a three-tier application.
Presentation (UI), Business (logic and underlying code) and Data (from storage or other sources).

SQL Interview Questions

Why is a UNION ALL faster than a UNION?

UNION ALL faster than a UNION because for union operation server needs to remove the duplicate values but for union all its not. Thats why the UNOIN ALL is fater than UNION Operation. It is recommended that if you know that the union set operation never returns duplicate values than you must use UNION ALL instead of UNION.

How many types of data models are there?

There are no standards in this area. Authors and theorists make it up as they go. The entity-relationship model (ER) has hundreds of derivitives (bachman, chen, ibm, IDEF1x etc.). the most popular of the OO models is Unified Modeling Language (UML). Actually UML and IDEF1x are closest to becoming a standard that can support software products. Rational already has products and IDEF1x is the language of ERwin.
Don't be fooled by these variations. They all represent the same things, you have to be very careful that you understand all of the non-standard symbols or you will surely make mistakes in interpreting what the pictures mean.

What is denormalization and when would you go for it?

As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.

What's the difference between a primary key and a unique key?

Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn't allow NULLs, but unique key allows one NULL only.

Define candidate key, alternate key, composite key.

A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys.

A key formed by combining at least two or more columns is called composite key.

What are defaults? Is there a column to which a default can't be bound?
A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can't have defaults bound to them. See CREATE DEFUALT in books online.

Whar is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quicker.

Indexes are of two types. Clustered indexes and non-clustered indexes. When you craete a clustered index on a table, all the rows in the table are stored in the order of the clustered index key. So, there can be only one clustered index per table. Non-clustered indexes have their own storage separate from the table data storage. Non-clustered indexes are stored as B-tree structures (so do clustered indexes), with the leaf level nodes having the index key and it's row locater. The row located could be the RID or the Clustered index key, depending up on the absence or presence of clustered index on the table.

If you create an index on each column of a table, it improves the query performance, as the query optimizer can choose from all the existing indexes to come up with an efficient execution plan. At the same t ime, data modification operations (such as INSERT, UPDATE, DELETE) will become slow, as every time data changes in the table, all the indexes need to be updated. Another disadvantage is that, indexes need disk space, the more indexes you have, more disk space is used.

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

Cursors allow row-by-row prcessing of the resultsets.

Types of cursors: Static, Dynamic, Forward-only, Keyset-driven. See books online for more information.

Disadvantages of cursors: Each time you fetch a row from the cursor, it results in a network roundtrip, where as a normal SELECT query makes only one rowundtrip, however large the resultset is. Cursors are also costly because they require more resources and temporary storage (results in more IO operations). Furthere, there are restrictions on the SELECT statements that can be used with some types of cursors.

Most of the times, set based operations can be used instead of cursors. Here is an example:

If you have to give a flat hike to your employees using the following criteria:

Salary between 30000 and 40000 -- 5000 hike
Salary between 40000 and 55000 -- 7000 hike
Salary between 55000 and 65000 -- 9000 hike

In this situation many developers tend to use a cursor, determine each employee's salary and update his salary according to the above formula. But the same can be achieved by multiple update statements or can be combined in a single UPDATE statement as shown below:

UPDATE tbl_emp SET salary =
CASE WHEN salary BETWEEN 30000 AND 40000 THEN salary + 5000
WHEN salary BETWEEN 40000 AND 55000 THEN salary + 7000
WHEN salary BETWEEN 55000 AND 65000 THEN salary + 10000
END


Another situation in which developers tend to use cursors: You need to call a stored procedure when a column in a particular row meets certain condition. You don't have to use cursors for this. This can be achieved using WHILE loop, as long as there is a unique key to identify each row. For examples of using WHILE loop for row by row processing,

What is a join and explain different types of joins?

Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table.

Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.

What is a Stored Procedure?

Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.

What is the basic difference between clustered and a non-clustered index?

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.

What are cursors?

Well cursors help us to do an operation on a set of data that we retreive by commands such as Select columns from table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retreival one by one and remove rows which have duplicate values.

Which TCP/IP port does SQL Server run on?

SQL Server runs on port 1433 but we can also change it for better security.

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

No. We cannot use Truncate command on a table with Foreign Key because of referential integrity.


What is the use of DBCC commands?


DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks.

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.

What is a Linked Server?

Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements.

Can you link only other SQL Servers or any database servers such as Oracle?

We can link any server provided we have the OLE-DB provider from Microsoft to allow a link. For Oracle we have a OLE-DB provider for oracle that microsoft provides to add it as a linked server to the sql server group.

How do you troubleshoot SQL Server if its running very slow?

First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes.

What is log shipping?

Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

For restoring the master db we have to stop the SQL Server first and then from command line we can type SQLSERVER .m which will basically bring it into the maintenance mode after which we can restore the master db.

What is BCP? When do we use it?

BulkCopy is a tool used to copy huge amount of data from tables and views. But it won’t copy the structures of the same.

What is the difference between oracle,sql and sql server ?

Oracle is based on RDBMS.
SQL is Structured Query Language.
SQL Server is another tool for RDBMS provided by MicroSoft.
why you need indexing ? where that is stroed and what you mean by schema object? For what purpose we are using view?

We cant create an Index on Index.. Index is stoed in user_index table.Every object that has been created on Schema is Schema Object like Table,View etc.If we want to share the particular data to various users we have to use the virtual table for the Base table...So tht is a view.

indexing is used for faster search or to retrieve data faster from various table. Schema containing set of tables, basically schema means logical separation of the database. View is crated for faster retrieval of data. It's customized virtual table. we can create a single view of multiple tables. Only the drawback is..view needs to be get refreshed for retrieving updated data.

Difference between Store Procedure and Trigger?

we can call stored procedure explicitly.
but trigger is automatically invoked when the action defined in trigger is done.
ex: create trigger after Insert on
this trigger invoked after we insert something on that table.
Stored procedure can't be inactive but trigger can be Inactive.
Triggers are used to initiate a particular activity after fulfilling certain condition.It need to define and can be enable and disable according to need.

What is the advantage to use trigger in your PL?

Triggers are fired implicitly on the tables/views on which they are created. There are various advantages of using a trigger. Some of them are:

Suppose we need to validate a DML statement(insert/Update/Delete) that modifies a table then we can write a trigger on the table that gets fired implicitly whenever DML statement is executed on that table.
Another reason of using triggers can be for automatic updation of one or more tables whenever a DML/DDL statement is executed for the table on which the trigger is created.
Triggers can be used to enforce constraints. For eg : Any insert/update/ Delete statements should not be allowed on a particular table after office hours. For enforcing this constraint Triggers should be used.
Triggers can be used to publish information about database events to subscribers. Database event can be a system event like Database startup or shutdown or it can be a user even like User loggin in or user logoff.
What the difference between UNION and UNIONALL?

Union will remove the duplicate rows from the result set while Union all does'nt.

What is the difference between TRUNCATE and DELETE commands?

Both will result in deleting all the rows in the table .TRUNCATE call cannot be rolled back as it is a DDL command and all memory space for that table is released back to the server. TRUNCATE is much faster.Whereas DELETE call is an DML command and can be rolled back.

Which system table contains information on constraints on all the tables created ?
yes,
USER_CONSTRAINTS,
system table contains information on constraints on all the tables created

Explain normalization ?
Normalisation means refining the redundancy and maintain stablisation. there are four types of normalisation :
first normal forms, second normal forms, third normal forms and fourth Normal forms.

How to find out the database name from SQL*PLUS command prompt?
Select * from global_name;
This will give the datbase name which u r currently connected to.....

What is the difference between SQL and SQL Server ?

SQLServer is an RDBMS just like oracle,DB2 from Microsoft
whereas
Structured Query Language (SQL), pronounced "sequel", is a language that provides an interface to relational database systems. It was developed by IBM in the 1970s for use in System R. SQL is a de facto standard, as well as an ISO and ANSI standard. SQL is used to perform various operations on RDBMS.

What is diffrence between Co-related sub query and nested sub query?

Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value from the row selected by the outer query.

Nested subquery runs only once for the entire nesting (outer) query. It does not contain any reference to the outer query row.

For example,

Correlated Subquery:

select e1.empname, e1.basicsal, e1.deptno from emp e1 where e1.basicsal = (select max(basicsal) from emp e2 where e2.deptno = e1.deptno)

Nested Subquery:

select empname, basicsal, deptno from emp where (deptno, basicsal) in (select deptno, max(basicsal) from emp group by deptno)

WHAT OPERATOR PERFORMS PATTERN MATCHING?
Pattern matching operator is LIKE and it has to used with two attributes

1. % and

2. _ ( underscore )

% means matches zero or more characters and under score means mathing exactly one character

1)What is difference between Oracle and MS Access?
2) What are disadvantages in Oracle and MS Access?
3) What are feratures&advantages in Oracle and MS Access?

Oracle's features for distributed transactions, materialized views and replication are not available with MS Access. These features enable Oracle to efficiently store data for multinational companies across the globe. Also these features increase scalability of applications based on Oracle.

What is database?
A database is a collection of data that is organized so that itscontents can easily be accessed, managed and updated. open this url : http://www.webopedia.com/TERM/d/database.html

What is cluster.cluster index and non cluster index ?
Clustered Index:- A Clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table may have only one clustered index.Non-Clustered Index:- A Non-Clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows in the disk. The leaf nodes of a non-clustered index does not consists of the data pages. instead the leaf node contains index rows.

How can i hide a particular table name of our schema?
you can hide the table name by creating synonyms.

e.g) you can create a synonym y for table x

create synonym y for x;

What is difference between DBMS and RDBMS?
The main difference of DBMS & RDBMS is

RDBMS have Normalization. Normalization means to refining the redundant and maintain the stablization.
the DBMS hasn't normalization concept.

What are the advantages and disadvantages of primary key and foreign key in SQL?

Primary key

Advantages

1) It is a unique key on which all the other candidate keys are functionally dependent

Disadvantage

1) There can be more than one keys on which all the other attributes are dependent on.

Foreign Key

Advantage

1)It allows refrencing another table using the primary key for the other table

Which date function is used to find the difference between two dates?
datediff

for Eg: select datediff (dd,'2-06-2007','7-06-2007')

output is 5

Sharepoint Frequently Asked Questions

Where can I see some other sites using MOSS?
Can I try out MOSS for free?
What exams can I do to be certified in SharePoint?
Would I give up using File Shares and move to SharePoint?

Is SharePoint accessable to the disabled?
How Does MOSS integrate with CRM?
How do I get started learing SharePoint?
What solution providers are there for MOSS?

Can Excel 2007 syncronize with SharePoint Lists?
Is MOSS DoD certified?
How do I get started with Workflows for MOSS and WSS 3.0?
How do I know work out the licencing for MOSS 2007, especially with an Internet facing site?

What is the difference between MOSS 2007 Standard version and MOSS 2007 Enterprise version?
What are the most common sharepoint interview questions?
How would I migrate eRooms, Windows File Services and Exchange Public folders to SharePoint?
How to Search SharePoint via MSN Desktop Search?


Click here to get Answers for the questions

Download .NET, SQL Server Interview question and C#, ASP.NET projects Ebooks

.NET Interview Questions Free Ebook Download

400 Decent Interview questions on Basic .NET Framework , NET Interoperability , Threading , Remoting and Webservices , Caching Concepts , OOPS , ASP.NET , .NET Architecture , ADO.NET , SQL SERVER , UML , Project Management

http://www.questpond.com/SampleDotNetInterviewQuestionBook.zip

SQL Server Interview Questions Free EBook Download

200 Decent Interview questions on Database Concepts , SQL , .NET Integration , ADO.NET , Notification Services , Service Broker , XML Integration , Data Warehousing/Data Mining , Integration Services/DTS , Replication , Reporting Services , Database Optimization , Transaction and Locks http://www.questpond.com/SampleSQlServer.zip.

C# and ASP.NET projects Free Ebook Download


Download full C# and ASP.NET projects ebook , Covers projects like Chat application , Job Site application , Accounting module and lot more with Full SDLC , Estimation , Design documentation and proper test plans. http://www.questpond.com/CSharpProjects.zip.

Thanks to Mr. Shivprasad Koirala, author of these good books.

hope this helps.

How to clear all the selected Items from a Check Box List in asp.net 2.0?

How to clear all the selected Items from a Check Box List in asp.net 2.0?


Here is the sample code for doing this operation


for (int i = 0; i < chkSubCategories.Items.Count; i++)
{
chkSubCategories.Items[i].Selected = false;
}

How to pass XML content as Parameter to back end in asp.net?

How to pass XML content as Parameter to back end in asp.net?

here strXML is input parameter. here we are going to write XML content into Sql server 2005.



protected void XMLWRITER(string strXML)
{
try
{
string strCon = "server=myServer;database=myDB;User ID=vbtc;Password=vbtc";
string strSql = "UPDATE Sites SET Categories = @Categories where SNo = @SNo";
SqlConnection objCon = new SqlConnection(strCon);
objCon.Open();
SqlCommand objCmd = new SqlCommand();
objCmd.Connection = objCon;
objCmd.CommandType = CommandType.Text;
objCmd.CommandText = strSql;
SqlParameter objParaSNo = new SqlParameter("@SNo", System.Type.GetType("System.Int32"));
SqlParameter objParaCategory = new SqlParameter("@Categories", System.Type.GetType("System.Xml"));
objCmd.Parameters.Add(objParaSNo);
objCmd.Parameters.Add(objParaCategory);

objParaSNo .Value = int.Parse(txtSNo.Text);
objParaCategory.Value = strXML;
objCmd.ExecuteNonQuery();

objCon.Close();
}
catch (Exception ee)
{
Response.Write(ee.Message + " " + ee.StackTrace);
}
}

How to iterate SortedList values one by one?

How to iterate SortedList values one by one in ASP.net

using System.Collections; ---> Namespace must be added;
objL ---> a SortedList with values.

IDictionaryEnumerator ide = objL.GetEnumerator();
while (ide.MoveNext())
{
string strVal = ide.Value.ToString();
}

Adding all selected Items from CheckBox List to SortedList

Adding all selected Items from CheckBox List to SortedList in ASP.net 2.0

chkSubCategories --> A CheckBoxList Control which is already populated with some values.



using System.Collections;

SortedList objL = new SortedList();
for (int i = 0; i < chkSubCategories.Items.Count; i++)
{
if (chkSubCategories.Items[i].Selected == true)
{
objL.Add(chkSubCategories.Items[i].Value, chkSubCategories.Items[i].Text);
}
}

Blogs in Plain English

How to post images in a blogger blog post

Customizing Your Blogger Template

Adding Google adSense to a Blogger Blog

a quick tutorial on Blogger, Adsense and Analytics

Blogger Tutorial - How to Start Blogging with Blogger

How to display a confirm box while deleting an item in Gridview?

Confirm delete for GridView's Link Button using JavaScript

Here is the code using Asp.net 2.0


<script type="text/javascript">

function confirm_delete()

{

if (confirm("Are you sure you want to delete the contact?")==true)

return true;

else

return false;

}

</script>





<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
OnRowDeleting="GridView1_RowDeleting">

<Columns>

<asp:BoundField DataField="ID" SortExpression="ID" HeaderText="ID" />

<asp:BoundField DataField="Name" SortExpression="Name" HeaderText="Name" />

<asp:BoundField DataField="City" SortExpression="City" HeaderText="City" />

<asp:TemplateField HeaderText="Delete">

<ItemTemplate>

<asp:LinkButton ID="lnkDelete" runat="server" CommandName="Delete" Text="Delete"
OnClientClick="javascript : return confirm('Do you really want to \ndelete the
item?');"></asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

How to Display Date in mm/dd/yyyy format in sql server?

Displaying Date in yyyy/mm/dd format in Sql Server 2005

SELECT CONVERT(VARCHAR(19),CreatedDate,111)AS [Created Date] FROM tblSample

select convert(varchar(19),getdate(),111)



Displaying Date in mm/dd/yyyy format in Sql Server 2005

select CONVERT (CHAR(19),CreatedDate,101) AS [Created Date] FROM tblSample

select convert(varchar(19),getdate(),101)


Enjoy SQL Coding..

Dinamalar - Computer Malar


Dinamalar - Computer Malar:

Computing Special Edition in Tamil - Tips, Tricks, Word, Hard Drive, Disk Access, Password, Microsoft, Protect, Security

Many Interesting things about Computer, Latest Technology and Trends are available in this Computer Malar from Dinamalar.

Enjoy Reading Technologies..

Click Here to View

How to display Top 10 commentators in your blog?

Hi.

How to display Top 10 commentators in your blog?

Here is the javascript code for displaying top 10 commentators with number of comments.

<script type="text/javascript">

function pipeCallback(obj)

{

document.write("<ol>");



for (var i = 0; i < parseInt(obj.count) ; i++)

{

var href = "'" + obj.value.items[i].link + "'";

var item = "<li>" + "<a href=" + href + ">" + obj.value.items[i].title + "</a>
</li>";

if ( item.search("TamilNenjam") < 0 )

{

document.write(item);

}

}

document.write("</ol>");

}



</script>

<script src="http://pipes.yahoo.com/pipes/pipe.run?_render=json&_callback=pipeCallback&

_id=c92ac21897d8b56e61cfa85930dd89a1&url=http%3A%2F%2Ftamizh2000.blogspot.com&num=12"


type="text/javascript"></script>



url=YOUR BLOG URL&num=NUMBER OF COMMENTATORS TO BE DISPLAYED"

If you do not want to display your name in the list, please attach this code.
if ( item.search("YOUR NAME") < 0 )

{

document.write(item);

}


Make some appropriate changes for your convenience.


Please Click Here to get the Source code

Converting VARCHAR to FLOAT in SQL Server 2005

How to Convert from VARCHAR into FLOAT in Sql Server 2005?

In many places we are converting one dataype into different data type.
Here is the example code for converting VARCHAR into FLOAT datatype.

SELECT
CONVERT(decimal(17,7),varcharField)
FROM
sampleTable



DECLARE @Y VARCHAR(20)
SELECT @Y = convert(decimal(17,11),Code) FROM TestTable
PRINT @Y --I want Y to be 521698.98999999999


Enjoy SQL Coding...

How to Display a Random Post in your Blog?

When a User Clicks on an Image, It will load a Random Post.
Just add the following Script in your Blog.



<div id="myLuckyPost"></div> <script type="text/javascript"> function
showLucky(root){ var feed = root.feed; var entries = feed.entry || []; var entry
= feed.entry[0]; window.location = entry.link[0].href;} function fetchLuck(luck){
script = document.createElement('script'); script.src = '/feeds/posts/summary?start-index='+luck+'&max-results=1&alt=json-in-script&callback=showLucky';
script.type = 'text/javascript'; document.getElementsByTagName('head')[0].appendChild(script);
} function feelingLucky(root){ var feed = root.feed; var total = parseInt(feed.openSearch$totalResults.$t,10);
var luckyNumber = Math.floor(Math.random()*total);luckyNumber++; a =
document.createElement('a'); a.href = '#random'; a.rel = luckyNumber; a.onclick
= function(){fetchLuck(this.rel);}; a.innerHTML = '<img src="http://1.bp.blogspot.com/_aOVUVB-gmBA/SLVrcI5Zw6I/AAAAAAAAAmo/oi5iK_m_lxQ/s320/dice.PNG">';
document.getElementById('myLuckyPost').appendChild(a); } </script> <script src="/feeds/posts/summary?max-results=0&amp;alt=json-in-script&amp;callback=feelingLucky"></script>



Just change the Image URL for different Image other than Dice.

Comma Separated Values using COALESCE function in Sql Server 2005

Comma Separated Values using COALESCE function in Sql Server 2005

DECLARE @ItemList VARCHAR(MAX)
SELECT @ItemList = COALESCE(cast(@ItemList as varchar(max)) + ', ', '') + cast(Ratings.RatingType as VARCHAR(100)) + ':' + cast(SiteRating.Count as VARCHAR(100) )
FROM Ratings INNER JOIN
SiteRating ON Ratings.RatingID = SiteRating.RatingID INNER JOIN
Sites ON SiteRating.SiteID = Sites.SiteID
where Sites.SiteID = 4

PRINT @ItemList

Result : Upper:2.75, Middle:3, Lower:2.75

Step By Step Procedure for Full Text Search in Sql Server 2005

Step By Step Procedure for Full Text Search in Sql Server 2005

Step 1: Enable Full Text Search

EXEC sp_fulltext_database 'enable'

Step 2: Create a Catalog

CREATE FULLTEXT CATALOG mySites

Step 3: Create Full Text Index for columns

CREATE FULLTEXT INDEX ON Sites
(
SiteName,
Categories,
Address1,
Address2
)
KEY INDEX PK_Sites ON mySites
WITH CHANGE_TRACKING AUTO

Step 4:

Example for CONTAINS search...

SELECT SiteName
FROM Sites
WHERE CONTAINS(Categories, '"LIC India"')

Example for Free Text search...


DECLARE @SearchWord varchar(30);
SET @SearchWord ='LIC India';
SELECT SiteName FROM Sites
WHERE FREETEXT(Categories, @SearchWord)



Step By Step Procedure for Full Text Search in Sql Server 2005

Google Mobile App for iPhone

Gmail Theater

Gmail Theater Act 1


Gmail Theater: Why Use Gmail?

Freez 3GP Video Converter


Freez 3GP Video Converter is a 3GP-converting tool for mobile phone users. With Freez 3GP Video Converter, you can convert batches of video files to 3gp, 3g2 formats to be played on mobile phones.

Freez 3GP Video Converter supports most popular video formats to be converted to 3gp video, including AVI, DivX, Xvid, MPEG 1/2/4, VOB, WMV, ASF, MP4, MOV, RM, RMVB, Flv, SWF etc. You can create both 3GPP and 3GPP2 video files. The output video codecs include MPEG4, XVID and H263; the audio codecs include AMR-NB and AAC-LC.

You can set the video size, quality, framerate, audio bitrate, frequency, and channel. And there are two zoom modes: Stretch and Letterbox, which will add black letterbox on output video to keep aspect ratio.

Freez 3GP Video Converter is easy-to-use, fast and creates good quality. Have fun with it!

Click Here for More

Freez Flv to AVI MPEG WMV Converter


Freez Flv to AVI/MPEG/WMV Converter is a tool to convert Flash FLV video files to AVI, MPEG, WMV video files so that they can be played in Windows Media Player or edited by video editing software.

You can set output video's bitrate, framerate, output audio's bitrate. Convert batches of Flv files to AVI/MPEG/WMV files with high speed. The simple and friendly interface make the program very easy to use.

Click Here for More

Freez Flv to Mp3 Converter


Freez Flv to MP3 Converter is a tool to convert Flash FLV files to MP3 files so that they can be played in Windows Media Player.

You can set the output MP3 audio's bitrate, frequency, channels, or simply set the values same as Flv's audio stream.

With just a few clicks, you can convert batches of Flv files to MP3 files at a high speed. The simple and friendly interface makes the program very easy to use.

Click Here For More

Freez Screen Video Capture


Freez Screen Video Capture is a screen-capture & screen-recording tool to record screen activities and sounds into standard AVI video files.

You can record any part of the screen's activities and the cursor's movements, using a microphone to narrate your screen recordings. You can choose the output video's compressor (such as Microsoft Video 1, MPEG-4, DivX...), quality, framerate, audio format (such as PCM, ADPCM, MP3, OGG...), and volumn. You can also start, pause, and stop screen recording with hotkeys.

Use Freez Screen Video Capture to create screen demos, training videos, animated tutorials, animated presentations etc. Enjoy it!

Click Here for More

Freez DVD Ripper


Freez DVD Ripper is a DVD ripping tool to rip your favorite DVD movies to popular DivX/Xvid AVI files, H.264 MP4 files, and even iPod MP4 video files with fast DVD ripping speed and excellent quality.

With Freez DVD Ripper, you can choose which titles and chapters, audio tracks, and subtitle tracks of the DVD you want to rip. You can also choose the output video format from AVI (DivX MPEG4), AVI (Xvid), MP4 (H264) or iPod MP4 Video. You can also set the video size, bitrate and framerate, audio channel, bitrate and frequency.

Freez DVD Ripper has a user-friendly interface and you can rip DVD with only a few clicks. Enjoy it!

Click Here for More

Freez iPod Video Converter


Freez iPod Video Converter is a video conversion program that can convert batches of video files to MP4 video files to be played on your iPod.

Freez iPod Video Converter supports most popular video formats that can be converted into iPod video. These include AVI, MPEG, WMV, ASF, MOV, RM, RMVB, DivX, Flv, SWF, VOB, 3GP etc. You can choose the output iPod MP4 video's video encoder (MPEG-4/H.264), video size, video bitrate, audio bitrate, audio channel, volumn etc.

Freez iPod Video Converter has easy-to-use interface and can convert video files at high speed. Have fun with it!

# Can set output video bitrate (up to 769 Kbps for H.264 video, up to 2500 Kbps for MPEG-4 video), audio bitrate, audio channel, and adjust audio volumn.
# Can set iPod MP4 file's title.
# Convert batches of video files to iPod MP4 video with high speed.
# User-friendly interface without any complicated settings.
# Free to use and free registration.

Click Here for More

Paging in SQL Server 2005 using Common Table Expression

Here is the Code for Paging Operation in SQL Server 2005 using CTE.

declare @start int,@end int

select @start = 1, @end = 20;

WITH SiteInfo AS
(
SELECT SiteName, Latitude,Longitude,
ROW_NUMBER() OVER (ORDER BY CityID) AS SNo
FROM Sites
)
SELECT SNo,SiteName, Latitude,Longitude
FROM SiteInfo
WHERE SNo BETWEEN @start AND @end

SQL Interview Questions EBook For U

A PDF EBook for SQL Questions and Answers is here

Enjoy SQL Programming..

How to Perform Paging Operation in SQL Server 2005?

Paging Operation in SQL Server 2005

Here I have 2 parameters @start, @end

declare @start int

declare @end int



set @start = 10

set @end = 20



SELECT * FROM

(SELECT ROW_NUMBER() OVER(ORDER BY [CityID]) AS SNo,

SiteName, Latitude,Longitude FROM Sites) as Result

WHERE SNo >= @start AND SNo <= @end

How to get An Application's Previous Versions?

Upgrading to a new version is best thing.

But, If your machine is not compatible with new version of the same application, what will happen?

You will become confusion.

If you want to get previous versions of a Application you can consider the following sites.

Visit here to get Previous versions of an application.

http://www.old-software.com/
http://www.oldapps.com
http://www.oldversion.com


Here you can get Previous versions of Fire Fox.

http://www.old-software.com/software-119-firefox.html
http://www.oldversion.com/program.php?n=firefox
http://www.oldapps.com/mozilla.htm

How to add a serial number with a Query's Result Set?

In SQL Server 2005, We have ROW_NUMBER() function.

Here is the sample code:
It will display a serial number with a result set of a SQL's Select Query.

SELECT ROW_NUMBER()
OVER (ORDER BY SiteName) as ID,
SiteName,Latitude,Logitude, CityID
FROM
Sites

EditPad Lite


EditPad Lite is a general-purpose text editor, designed to be small and compact, yet offer all the functionality you expect from a basic text editor.

EditPad Lite works with Windows NT4, 98, 2000, ME, XP and Vista.

EditPad Lite is free for non-commercial use. That is, you may use EditPad Lite if you do not get paid, directly or indirectly, for the work you do with EditPad Lite. Registered charities may also use EditPad Lite.

If you want more editing power or need a text editor to use at work, check out EditPad Pro.

Click Here for More

VirtualDub


VirtualDub is a video capture/processing utility for 32-bit Windows platforms (95/98/ME/NT4/2000/XP), licensed under the GNU General Public License (GPL).

It lacks the editing power of a general-purpose editor such as Adobe Premiere, but is streamlined for fast linear operations over video.

It has batch-processing capabilities for processing large numbers of files and can be extended with third-party video filters. VirtualDub is mainly geared toward processing AVI files, although it can read (not write) MPEG-1 and also handle sets of BMP images.

Click Here for More

Jokes Assorted

Tourist: Whose skeleton is that?

Santa: Tipu's skeleton.

Tourist: Whose that smaller skeleton next to it?

Santa: That was Tipu's skeleton when he was child



Boss: Where were you born?

sardar : Punjab ..

Boss : which part ?

sardar : Kya which part ? Whole body born in PUNJAB.



2 sardar were fixing a bomb in a car.

Sardar 1 : What would you do if the bomb explodes while fixing.

sardar 2 : Dont worry, I have one more.



Sardar : What is the name of your car ?

Lady : I forgot the name, but is starts with 'T'.

Sardar : Oye Kamaal ki gaadi hai, Tea se start hoti hai. Hamaara gaadi

petrol se start hoti hai.



Sardar was busy removing a wheel from his auto. A man asks sardar why are
you removing a wheel from your auto.

sardar : Cant you read the board. Parking is only for 2 wheeler.



Sardar got into a bus on 1st April when conductor asked for ticket. He gave
Rs.10/- and took the ticket and said April fool. I have pass.



Sardar joined new job. 1st day he worked till late evening on the computer.


Boss was happy and asked what you did till evening.

Sardar : Keyboard alphabets were not in order, so I made it alright.



On a romantic day sardar's girlfriend asks him. Darling on our engagement
day will you give me a ring.

Sardar : Ya sure, from landline or mobile.



In an interview,

Interviewer: How does an electric motor run?

Santa: Dhhuuuurrrrrrrrrr. .....

Inteviewer shouts: Stop it.

Santa: Dhhuurrrr dhup dhup dhup...



Doctor to patient : You will die within 2 hours. Do you want to see any one
before you die?

Patient : Yes. A good doctor.



Banta: U cheated me.

Shopkeeper: No, I sold a good radio to u.

Banta: Radio label shows Made in Japan but radio says This is all India
Radio!



Museum Administrator: That's a 500-year-old statue u've broken.

Banta: Thank God! I thought it was a new one.



How will you destroy a submarine full of sardars ?

Simple. Just knock the door and they will open it....



A man to Santa: Aao ji chess khelein

Santa: Tu chal mein sports shoes pehen kar aaya.



At the scene of an accident a man was crying: O God! I have lost my hand,
oh!

Santa: Control yourself. Don't cry. See that man. He has lost his head. Is
he crying?



Santa was getting bitten by mosquitoes the whole night. He got irritated...


drank poison & said, Ab kaato saalon, sab maroge!

Jokes Assorted

A father was approached by his small son who told him proudly,
'I know what the Bible means!'
His father smiled and replied, 'What do you mean, you 'know'
What the Bible means?
The son replied, 'I do know!'
'Okay,' said his father. 'What does the Bible mean?'
'That's easy, Daddy...' the young boy replied excitedly,' It stands for 'Basic
Information Before Leaving Earth.'

There was a very gracious lady who was mailing an old family Bible to her
brother in another part of the country.
'Is there anything breakable in here?' asked the postal clerk.
'Only the Ten Commandments.' answered the lady.


'Somebody has said there are only two kinds of people in the world.
There are those who wake up in the morning and say, 'Good morning, Lord,'
and there are those who wake up in the morning and say,
'Good Lord, it's morning.'

A minister parked his car in a noparking zone in a large city because he
was short of time and couldn't find a space with a meter.
Then, he put a note under the windshield wiper that read: 'I have circled
the block 10 times. If I don't park here, I'll miss my appointment. Forgive
us our trespasses.' When he returned, he found a citation from a police
officer along with this note 'I've circled this block for 10 years. If I
don't give you a ticket I'll lose my job. Lead us not into temptation.'

There is the story of a pastor who got up one Sunday and announced
to his congregation: 'I have good news and bad news. The good news is, we
have enough money to pay for our new building program. The bad news is, it's
still out there in your pockets.'


While driving in Pennsylvania, a family caught up to an Amish carriage.
The owner of the carriage obviously had a sense of humour, because attached
to the back of the carriage was a hand printed sign... 'Energy efficient
vehicle: Runs on oats and grass.
Caution: Do not step in exhaust.'

A minister waited in line to have his car filled with gas just before a long
holiday weekend. The attendant worked quickly, but there were many cars
ahead of him. Finally, the attendant motioned him toward a vacant pump.
'Reverend,' said the young man, 'I'm so sorry about the delay. It seems as
if everyone waits until the last minute to get ready for a long trip.'
The minister chuckled, 'I know what you mean. It's the same in my business.'

People want the front of the bus, The back of the church, And The
centre of attention.


Sunday after church, a Mom asked her very young daughter what the lesson was
about.
The daughter answered, 'Don't be scared, you'll get your quilt.' Needless to
say, the Mom was perplexed. Later in the day, the pastor stopped by for tea
and the Mom asked him what that morning's Sunday school lesson was about. He
said, 'Be not afraid, thy comforter is coming.'


The minister was preoccupied with thoughts of how he was going to ask the
congregation to come up with more money than they were expecting for repairs
to the church building. Therefore, he was annoyed to find that the regular
organist was sick and a substitute had been brought in at the last minute. The
substitute wanted to know what to play.
'Here's a copy of the service,' he said impatiently. 'But, you'll have to think
of something to play after I make the announcement about the finances.'
During the service, the minister paused and said, 'Brothers and Sisters, we
are in great difficulty; the roof repairs cost twice as much as we expected
and we need $4,000 more. Any of you who can pledge $100 or more, please
stand up.'
At that moment, the substitute organist played, 'O Canada.'
And that is how the substitute became the regular organist!

You Think English is Easy???

1) The bandage was wound around the wound.

2) The farm was used to produce produce.

3) The dump was so full that it had to refuse more refuse.

4) We must polish the Polish furniture.

5) He could lead if he would get the lead out.

6) The soldier decided to desert his dessert in the desert.

7) Since there is no time like the present, he thought it was
time to present the present.

8) A bass was painted on the head of the bass drum.

9) When shot at, the dove dove into the bushes.

10) I did not object to the object.

11) The insurance was invalid for the invalid.

12) There was a row among the oarsmen about how to row.

13) They were too close to the door to close it.

14) The buck does funny things when the does are present.

15) A seamstress and a sewer fell down into a sewer line.

16) To help with planting, the farmer taught his sow to sow.

17) The wind was too strong to wind the sail.

18) Upon seeing the tear in the painting I shed a tear.

19) I had to subject the subject to a series of tests.

20) How can I intimate this to my most intimate friend?



Let's face it - English is a crazy language. There is no egg in eggplant,
nor ham in hamburger; neither apple nor pine in pineapple. English muffins
weren't invented in England or French fries in France. Sweetmeats are
candies while sweetbreads, which aren't sweet, are meat.



We take English for granted, but if we explore its paradoxes, we find that
quicksand can work slowly, boxing rings are square and a guinea pig is
neither from Guinea nor is it a pig. Ship by truck and send cargo by ship?
Have noses that run and feet that smell? How can a slim chance and a fat
chance be the same, while a wise man and a wise guy are opposites?



You have to marvel at the unique lunacy of a language in which your house
can burn up as it burns down, in which you fill in a form by filling it out
and in which, an alarm goes off by going on.



English was invented by people, not computers, and it reflects the
creativity of the human race, which, of course, is not a race at all. That
is why, when the stars are out, they are visible, but when the lights are
out, they are invisible. You lovers of the English language might also enjoy
this: There is a two-letter word that perhaps has more meanings than any
other two-letter word.


That is 'UP.' It's easy to understand UP, meaning toward the sky or at the
top of the list, but when we awaken in the morning, why do we wake UP? At a
meeting, why does a topic come UP? Why do we speak UP and why are the
officers UP for election and why is it UP to the secretary to write UP a
report? We call UP our friends. And we use it to brighten UP a room, polish
UP the silver, we warm UP the leftovers and clean UP the kitchen. We lock UP
the house and some guys fix UP the old car. At other times the little word
has real special meaning. People stir UP trouble, line UP for tickets, work
UP an appetite, and think UP excuses. To be dressed is one thing but to be
dressed UP is special. And this UP is confusing: A drain must be Opened UP
because it is stopped UP. We open UP a store in the morning but we close it
UP at night. We seem to be pretty mixed-UP about UP! To be knowledgeable
about the proper uses of UP, look the word UP in the dictionary. In a
desk-sized dictionary, it takes UP almost 1/4thof the page and can add UP to
about thirty definitions. If you are UP to it, you might try building UP a
list of the many Ways UP is used. It will take UP a lot of your time, but if
you don't give UP, you may wind UP with a hundred or more. When it threatens
to rain, we say it is clouding UP When the sun comes out we say it is
clearing UP .When it rains, it wets the earth and often messes things UP.
When it doesn't rain for awhile, things dry UP .One could go on and on, but
I'll wrap it UP , for now my time is UP ,so... time to shut-UP!_

Total Video Player - A Freeware Application




No need install any video codecs with this small size's tool to play almost any media formats!
Absolutely free, very powerful!

Total Video Player is a media player supporting 3gp, Mp4, H264, Mov, Flv and all other popular video and audio formats (Mp3, Wma, Ogg, Mpeg-1,Mpeg-2, etc.) as well as DVDs, CD Audio and Swf Flash Files.

Supports the following file formats:

Video Formats:

* MPEG4 (.mp4)
* H264/AVC mpeg4(.mp4)
* 3gp(.3gp, 3g2)
* WMV (.wmv)
* Zune (.wmv)
* ASF (.asf)
* SAMSUNG L55W DC (.mp4)
* CASIO (.avi)
* KODAK DC V550 (.mov)
* iPod mpeg4 mov (.mov)
* iPod mpeg4 (.mp4)
* iPod H264 (.mp4)
* iPhone mpeg4 (.mp4)
* iPhone H264 (.mp4)
* Apple TV mpeg4 (.mp4)
* Apple TV H264 (.mp4)
* Game Psp (.mp4)
* Nokia cellphone (.mp4, .3gp)
* Sony cellphone (.mp4, .3gp)
* Ms Mpeg4 AVI (.avi)
* Divx AVI (.avi)
* Xvid AVI (.avi)
* H264 AVI (.avi)
* Mjpeg AVI (.avi)
* HuffYUV AVI (.avi)
* Swf Video (.swf)
* FLV video(.flv)
* Gif Animation (.gif)
* NTSC, PAL DVD
* NTSC, PAL SVCD
* NTSC, PAL VCD
* Mpeg4 Mov (.mov)
* Apple Quicktime (.mov)
* HD Mpeg TS (.ts)
* MPEG1 (.mpg, mpeg)

Audio Formats:

* WAV
* CD disc
* MPEG audio(.mp3, mp2)
* Ms WAV (.wav)
* Ms WMA (.wma)
* OGG (.ogg)
* Amr audio (.amr)
* Awb audio (.awb)
* AC3 (.ac3)
* SUN AU format (.au)
* m4a (mp4 audio)
* aac (aac audio)
* mmf (mmf audio)
* Flac (flac audio)

Click Here for More

Defraggler - A Free Application



Defraggler differs from other defrag tools on the market, by enabling you to quickly and simply defrag the files you want to, without having to process the whole drive. Simply run it, select the file and defragment in seconds. No more struggling with the Windows defragmentation tool!

And remember like all Piriform products, Defraggler is completely free for both corporate and individual use.

Defrag Individual Files
Most defragmentation tools only let you defrag the whole drive. Defraggler gives you the power to select individual files and folders to defrag. So you can get the job done in seconds, rather than waiting for the whole drive to complete. Of course if you want to defrag the whole drive Defraggler will let you do that too.

Compact and Portable
Defraggler was written in the same compact architecture as other Piriform products (CCleaner and Recuva). This results in a compact single EXE application, which can be copied to a thumbdrive and then used whenever you need it, without a complex installation process. The EXE itself is less than 1MB!

Vista Support
Defraggler supports all OSs released since Windows 2000, this includes Windows 2000, 2003, XP and Vista. 64-bit support has also just been added! Additionally Defraggler supports both NTFS and FAT32 file systems.

Locate Files on the Drive
After analysis Defraggler lists all the fragmented files on the drive. Selecting one or many will highlight their location on the disk. Allowing you to visually see the location of files on the disk.

Freeware
Why pay hundreds of dollars for a commercial defragmentation tool, when you can use Defraggler for free! This includes corporate use as well!

Click Here for More Info

Fairytale Audio Books for Children

The Littlest Angel
Goldilocks & the Three Bears
The Three Little Pigs
101 Dalmations
The Fool and the Flying Ship

Fox in Socks
Green Eggs And Ham
Grimm’s Fairy Tale
Hansel & Gretel
Jack and the Beanstalk

Peter And The Wolf
Pinocchio
Sparky’s Magic Piano
The Jungle Book
The Little Mermaid

The Night the Animals Talked
The Rainbow Fish
The Three Billy Goats Gruff
The Ugly Duckling
Thomas The Tank Engine - The Trouble With Mud

Three Little Kittens
Too Many Daves
T’was The Night Before Christmas
What Was I Scared Of
Winnie the Pooh and the Hefalump

Winnie the Pooh and The Honey Tree
Disney’s Dumbo
The Tortoise and the Hare
Thomas the Tank Engine, Henry & the Elephant
Thomas the Tank Engine, Train Stops Play


Rapidshare:
http://rapidshare.com/files/134995650/books.part1.rar

http://rapidshare.com/files/134994895/books.part2.rar

http://rapidshare.com/files/134994903/books.part3.rar

Password: 12

Microsoft Sharepoint : An Administrator Point of View

I found 2 ebooks for Administrating Microsoft Sharepoint 2007.

Configuration Study Guide Exam

Administrator's Companion

If it is asking for user name and password: please register there with your user credentials.

http://www.pdfchm.com/register/?join

http://www.pdfchm.com/login/?my

While you were entering this world who was departing?

While you were entering this world who was departing?

Just enter your DOB here : http://www.oneplusyou.com/bb/death

This site will tell details about : While you were entering this world who was departing?

15 Classic Slide Puzzle

In the late 19th century this puzzle drove the entire world crazy. When Sam Loyd introduced the game to the public in 1878 he used a trick to arouse interest for it - he offered a thousand dollars to the one who could solve it. The puzzle consisted of a little box with 15 numbered square pieces that could be slid around to be arranged in rows from 1 in the upper left corner to 15 last on the bottom row.
But then only the last two tiles 14 and 15 were scrambled which made the puzzle mathematically unsolvable and made people rack their brains in vain.

This 15 Classic Slide Puzzle game is more humanistic. There is always a solution. The software implements a shuffling algorithm that performs scrambling by random moving, not by random placing. So you can enjoy the game having in mind that "there is always a light at the end of the tunnel".

Besides, you can use some simple effects for a change. The software offers the option of turning on simple sound effects and using different color schemes. You can choose colors for the play-field and tiles yourself or use predefined schemes. You can move tiles or you can use a right click of the mouse button to shift them. It makes the game fun to use even if it is quite simple.

Those who had the 15 slide puzzle in childhood will not fail to try the game in the digital format again. For the younger generation it will be an exciting discovery.

Some say that this game has a therapeutical effect and tile sliding calms down. Well, download and judge yourself.

The program is a freeware and runs on Windows platforms.

Click here to download

Free Astrology Software for Download


The free software available online with the best features everyone looks for is Jagannatha Hora - Vedic Astrology Software. P.V.R. Narasimha Rao, a graduate in engineering from IIT-Chennai, a top engineering institute of India, designed this software. He is a Sanskrit scholar and a Jyotish Guru at Sri Jagannath Centre.

Requirements: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000 and Windows XP computers.

Features:
Computes all the divisional charts including Rasi chart and Navamsa chart.
Gives the positions of nine planets, ascendant [lagna], special lagnas like bhava lagna and 11 upagrahas/sub-planets. You can find the position of these in ALL the twenty divisional charts.
Shows Arudha padas of all the houses in ALL the 20 divisional charts
Computes Ashtakavarga and sodhya pindas
Gives the details of Vimsottari dasa up to pratyantardasas
Also, gives other dasa details like Ashtottari dasa, Kalachakra dasa and Narayana dasa
Annual horoscopy [Tajaka varsha system]
Gives charts in Prasna mode with prasna lagna obtained from a number between 1 and 108
Panchanga of a day with all the details like tithi, nakshatra, yoga, karana, horas, Rahu kalam etc
Select the ayanamsa you prefer for calculation from Lahiri Ayanmasa, KP Ayanamsa, Raman Ayanamsa etc.

Click here for download

Traceless

While you are surfing the net, websites and companies are placing cookies in your computer to track where you have been and what you have visited. All the websites you have visited are logged and listed in your internet history.

People and organizations can see what you have been doing. Protect your privacy with Traceless. Traceless is one of a kind, boasting outstanding features while being 100% Freeware.

Traceless aims to be easy-to-use yet powerful for everyday internet users and version 1.16 improves upon this already popular privacy solution.

A tip for current (and intending) users of this software:
Remember to check for updates frequently (at least monthly) as this is the most effective way to ensure you have the most stable, feature packed and efficient build of the software. Information on how to check for updates is available in the help file.


Key Features
Clear History
Clear Temporary Internet Files
Clear Cookies
Clear Recent Documents List
Password protected
Run at Startup
Keep your homepage
Schedule to run when you want
Run quickly from Taskbar
Easy to install and uninstall
Comprehensive help file
100% Freeware

Click Here to Download

Custom Test Tool


Custom Test allows you to create, modify and run custom-made tests. You can apply time limits, select from different types of question and test your self and others.

This tool is great for educational purposes, in particular simple quizzes for the classroom or home.

Best of all, this easy-to-use and useful utility is 100% freeware! A more functional professional edition is in planning/early development.

Click Here for More

SQL Injection

What is SQL Injection ?

SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution.

“SQL Injection” is subset of the an unverified/unsanitized user input vulnerability (“buffer overflows” are a different subset), and the idea is to convince the application to run SQL code that was not intended.

Why SQL injection works ?
The reason SQL injection works is that whereas most systems separate code and data, SQL combines them together. All a hacker needs to do is include some of his own code with the data he sends to a website, then he can gain control of the website.

Watch this Video

Sharepoint Interview Questions and Answers EBook 4 U

Here is the Ebook for sharepoint interview questions and answers in PDF format

Enjoy Sharepoint Programming....

Free Subscription Of ZoneAlarm ForceField Firewall



ZoneAlarm ForceField, a security software that allows you to safely perform online banking transaction without worrying about phishers, key loggers and other online identity thieves is available as a free download until 6 AM 13th August 2008 Pacific Time

Click here to get it

This offer expires on
Chennai, Mumbai, Delhi (India) - 6:30 PM on Wednesday, 8/13/2008

Some Logical Thoughts and Statements

Whenever you find the key to success, someone changes the lock.


To Err is human, but to forgive is not a COMPANY policy.


The road to success??.. Is always under construction.


Alcohol doesn't solve any problems, but if you think again, neither does
Milk.


In order to get a Loan, you first need to prove that you have ability to
repay back.


All the desirable things in life are either illegal, expensive or fattening.



Since Light travels faster than Sound, people appear brighter before you
hear them speak.


Everyone has a scheme of getting rich?.. Which never works.


If at first you don't succeed?. Destroy all evidence that you ever tried.


You can never determine which side of the bread to butter. If it falls down,
it will always land on the buttered side.


Anything dropped on the floor will roll over to the most inaccessible
corner.


42.7% of all statistics is made on the spot.


As soon as you mention something?? If it is good, it is taken?. If it is
bad, it happens.


He who has the gold, makes the rules Murphy's golden rule.


If you come early, the bus is late. If you come late?? The bus is still
late.


Once you have bought something, you will find the same item being sold
somewhere else at a cheaper rate.


When in a queue, the other line always moves faster and the person in front
of you will always have the most complex of transactions.


If you have paper, you don't have a pen. If you have a pen, you don't have
paper. If you have both, no one calls.


Especially for engg. Students : If you have bunked the class, the professor
has taken attendance.


You will pick up maximum wrong numbers when on roaming.


The door bell or your mobile will always ring when you are in the bathroom.


After a long wait for bus no.20, two 20 number buses will always pull in
together and the bus which you get in will be crowded than the other.


If your exam is tomorrow, there will be a power cut tonight.


Irrespective of the direction of the wind, the smoke from the cigarette will
always tend to go to the nonsmoker


Before borrowing money from a friend, decide whether you need more.


There are three sides to every argument: your side, my side and the right
side.


An expert is someone who takes a subject you understand and makes it sound
confusing.


Many things can be preserved in alcohol. Dignity is not one of them.


Never argue with a fool. People might not know the difference.


When you're right, no one remembers. When you're wrong, no one forgets.


Always remember that you are absolutely unique. Just like everyone else.


Well done is better than well said .


Everyone makes mistakes. The trick is to make them when nobody is looking.


Where there is a WILL, there is a WAY, Where there is MONEY, there are many
WAYS.


Where there is MONEY, there are many FRIENDS and RELATIVES.


Everybody wants to go to heaven, but nobody wants to die.

Moffsoft FreeCalc



Moffsoft FreeCalc is a great replacement for your existing Windows® calculator.

Features:

Adjustable calculator size -
Make it any size you want and Moffsoft FreeCalc will remember the size and position next time you use it.

Tape -
Save, print, or clear the simulated paper history tape.

Color schemes -
Select a color combination or use your Windows color settings.

New keys -
Clear Tape {CT}, double zero {00}, triple zero {000}, and memory subtract {M-} keys have been added.

Visible memory value -
You'll always know what's in memory because it's displayed on the calculator status bar.

Option settings -
Flat buttons, always on top, tray icon, run on startup, and hiding the tape are some of the calculator options.

Click here for More

Paint.Net




Paint.NET is free image and photo editing software for computers that run Windows. It features an intuitive and innovative user interface with support for layers, unlimited undo, special effects, and a wide variety of useful and powerful tools.

An active and growing online community provides friendly help, tutorials, and plugins.

The programming language used to create Paint.NET is C#, with a small amount of C++ for installation and shell-integration related functionality.

The source code is available under the terms of the MIT License.

click here to download it

Technical Videos For Engineering Students

I was searching in Youtube for technology based videos. I found this link there. It may be useful for Engineering Students.

More and More Lectures about IT and other Department based things are there.

Feel free to visit here

For Better Life

1. Take a 10-30 minutes walk every day. And while you walk, smile.
2. Sit in silence for at least 10 minutes each day.
3. Sleep for 7 hours.
4. Live with the 3 E’s — Energy, Enthusiasm, and Empathy.
5. Play more games.
6. Read more books than you did in 2007.
7. Make time to practice meditation, yoga, and prayer. They provide us with daily fuel for our busy lives.
8. Spend time with people over the age of 70 & under the age of 6.
9. Dream more while you are awake.
10. Eat more foods that grow on trees and plants and eat less food that is manufactured in plants.
11. Drink plenty of water.
12. Try to make at least three people smile each day.
13. Don’t waste your precious energy on gossip.
14. Forget issues of the past. Don’t remind your partner with his/her mistakes of the past. That will ruin your present happiness.
15. Don’t have negative thoughts or things you cannot control. Instead invest your energy in the positive present moment.
16. Realize that life is a school and you are here to learn. Problems are simply part of the curriculum that appear and fade away like algebra class but the lessons you learn will last a lifetime.
17. Eat breakfast like a king, lunch like a prince and dinner like a beggar.
18. Smile and laugh more.
19. Life is too short to waste time hating anyone. Don’t hate others.
20. Don’t take yourself so seriously. No one else does.
21. You don’t have to win every argument. Agree to disagree.
22. Make peace with your past so it won’t spoil the present.
23. Don’t compare your life to others’. You have no idea what their journey is all about. Don’t compare your partner with others.
24. No one is in charge of your happiness except you.
25. Forgive everyone for everything.
26.. What other people think of you is none of your business.
27. However good or bad a situation is, it will change.
28. Your job won’t take care of you when you are sick. Your friends will. Stay in touch.
29. Get rid of anything that isn’t useful, beautiful or joyful.
30. Envy is a waste of time. You already have all you need.
31. The best is yet to come.
32. No matter how you feel, get up, dress up and show up.
33. Do the right thing!
34. Call your family often.
35. Your inner most is always happy. So be happy.
36. Each day give something good to others.
37. Don’t over do. Keep your limits.

Olymbic 2008 Live Streaming Links

* USA - http://www.nbcolympics.com/ (NBC)

* United Kingdom - http://bbc.co.uk/olympics (BBC)

* Australia - http://www.abc.net.au/olympics/ (ABC)

* Canada - http://www.cbc.ca/olympics/ (CBC)


YouTube Channel to view highlights - Beijing Olympics 2008
http://www.youtube.com/beijing2008

How to Upload your favorite photos to Picasa Web Albums?

Human Brain Analysis

Women - Multiple process
Women's brains designed to concentrate multiple task at a time.

Women can Watch a TV and Talk over phone and cook the new recipe.

Men - Single Process
Men's brain designed to concentrate only one work at a time. Men can not watch a TV and talking in phone same time. He stops the TV while Talking. He can either watch TV or talk over phone or cook.

LANGUAGE.
Women can easily learn many languages. Her brain set up. But can not find the solutions to problems Men can not easily learn languages; he can easily solve the problems.

3 year old gal has three times higher vocabulary than 3 year old boy.

ANALYTICAL SKILL
Men's brain has lot of space for handling the analytical process. So easily he can analyze and find the solution for a process.

He can design (blue print) a map of a building easily.
If a complex map is viewed by women, she can not understand it. She can not understand the details of the map easily.
For her it is dump of lines in a paper.


CAR DRIVING.
While driving a car, men's analytical spaces are used in his brain. He can drive a car fastly. If he see an object at long distance, immediately his brain classifies the object (bus or van or car) direction and speed of the object and driving accordingly. Where as women take a long time to recognize the object direction/ speed. His single process mind stops the audio in the car (if any), then concentrating only on the driving.

You can often watch, while men driving the car fastly, the women sit next to him will shout, "GO SLOW" , "CARE FULL", "AAHHH", "OHH GOD.."
..etc..


LIE
Many times, when men lie to women face to face, they got caught easily.
Her super natural brain observe the facial expression 70%, and the body language 20% and the words comes from mouth 10%. So he is easily caught while lieing.

Men's brain does not have this.
Women easily lie to men face to face.
So guys, While lieing to your girls, use phone, or letter or close all the lights or cover your/her face with blanket.
Don't lie face to face.

PROBLEM.
End of day, if men have lot of problems, his brain clearly classifies the problems and put into individual rooms of brain, the problems in individual room of brain and finding the solution one by one. You can see many guys looking on the sky's for a long times. If you disturb him, he gets irritated.

End of Day, if women have lot of problems, her brain can not classify the problems. she wants some one to hear that. After telling everything to a person she goes happily to bed. She does not worry abt the problem solved or not.

WANTS
Men want status, success, solutions, big process... etc Women want relationship, friends, family...etc...

UNHAPPY
If women unhappy with their relations, she can not concentrate on work.
If men unhappy with their work, he can not concentrate on the relations.

MAP
Men can easily locate the place in a complex map. His analytical brain does this. While watching a cricket match in a stadium with full of crowd, men can leave his seat to T shop and keeps everything in his mind and comes back to his seat with out problems. He uses his analytical skills space of brain.

Women can't do this. They often lost their way to their seat.

LIFE
Life is very easy to Men. One good job, one alcohol bottle is enough for him.
Women want everything in life.

SPEECH
Women use indirect languages in speech.
Geetha asked Vijay, "vijay do you like to have a cup of coffee?"
This means, Geetha really want a cup of coffee.
In the morning......."Darling, do you think, will it be good to have an Omlette for breakfast"
Men use direct language. "Geetha, I want to have a cup of coffee, Pls stop the car when you see a coffee shop".
In the morning...."Darling, Can you please prepare an omelet for breakfast".

HANDLING EMOTIONWomen talk a lot without thinking, if they are in emotion.
Men act a lot with out thinking. That's why many of prisoners are men all over the world.

Exchange Server 2003 based Interview Questions

1. Tell me a bit about the capabilities of Exchange Server.
2. What are the different Exchange 2003 versions?
3. What's the main differences between Exchange 5.5 and Exchange 2000/2003?
4. What are the major network infrastructure for installing Exchange 2003?
5. What is the latest Exchange 2003 Service Pack? Name a few changes in functionality in that SP.
6. What are the disk considerations when installing Exchange (RAID types, locations and so on).
7. You got a new HP DL380 (2U) server, dual Xeon, 4GB of RAM, 7 SAS disks, 64-bit. What do you do next to install Exchange 2003? (you have AD in place)
8. Why not install Exchange on the same machine as a DC?
9. Are there any other installation considerations?
10. How would you prepare the AD Schema in advance before installing Exchange?
11. What type or permissions do you need in order to install the first Exchange server in a forest? In a domain?
12. How would you verify that the schema was in fact updated?
13. What type of memory optimization changes could you do for Exchange 2003?
14. How would you check your Exchange configuration settings to see if they're right?
15. What are the Exchange management tools? How and where can you install them?
16. What types of permissions are configurable for Exchange?
17. How can you grant access for an administrator to access all mailboxes on a specific server
18. What is the Send As permission?
19. What other management tools are used to manage and control Exchange 2003? Name the tools you'd use.
20. What are Exchange Recipient types? Name 5.
21. You created a mailbox for a user, yet the mailbox does not appear in ESM. Why?
22. You wanted to change mailbox access permissions for a mailbox, yet you see the SELF permission alone on the permissions list. Why?
23. What are Query Based Distribution groups?
24. What type of groups would you use when configuring distribution groups in a multiple domain forest?
25. Name a few configuration options for Exchange recipients.
26. What's the difference between Exchange 2003 Std. and Ent. editions when related to storage options and size?
27. Name a few configuration options related to mailbox stores.
28. What are System Public Folders? Where would you find them?
29. How would you plan and configure Public Folder redundancy?
30. How can you immediately stop PF replication?
31. How can you prevent PF referral across slow WAN links?
32. What types of PF management tools might you use?
33. What are the differences between administrative permissions and client permissions in PF?
34. How can you configure PF replication from the command prompt in Exchange 2003?
35. What are the message hygiene options you can use natively in Exchange 2003?
36. What are the configuration options in IMF?
37. What are virtual servers? When would you use more than one?
38. Name some of the SMTP Virtual Server configuration options.
39. What is a Mail Relay? Name a few known mail relay software or hardware options.
40. What is a Smart Host? Where would you configure it?
41. What are Routing Groups? When would you use them?
42. What are the types of Connectors you can use in Exchange?
43. What is the cost option in Exchange connectors?
44. What is the Link State Table? How would you view it?
45. How would you configure mail transfer security between 2 routing groups?
46. What is the Routing Group Master? Who holds that role?
47. Explain the configuration steps required to allow Exchange 2003 to send and receive email from the Internet (consider a one-site multiple server scenario).
48. What is DS2MB?
49. What is Forms Based Authentication?
50. How would you configure OWA's settings on an Exchange server?
51. What is DSACCESS?
52. What are Recipient Policies?
53. How would you work with multiple recipient policies?
54. What is the "issue" with trying to remove email addresses added by recipient policies? How would you fix that?
55. What is the RUS?
56. When would you need to manually create additional RUS?
57. What are Address Lists?
58. How would you modify the filter properties of one of the default address lists?
59. How can you create multiple GALs and allow the users to only see the one related to them
60. What is a Front End server? In what scenarios would you use one?
61. What type of authentication is used on the front end servers?
62. When would you use NLB?
63. How would you achieve incoming mail redundancy?
64. What are the 4 types of Exchange backups?
65. What is the Dial-Tone server scenario?
66. When would you use offline backup?
67. How do you re-install Exchange on a server that has crashed but with AD intact?
68. What is the dumpster?
69. What are the e00xxxxx.log files?
70. What is the e00.chk file?
71. What is circular logging? When would you use it?
72. What's the difference between online and offline defrag?
73. How would you know if it is time to perform an offline defrag of your Exchange stores?
74. How would you plan for, and perform the offline defrag?
75. What is the eseutil command?
76. What is the isinteg command?
77. How would you monitor Exchange's services and performance? Name 2 or 3 options.
78. Name all the client connection options in Exchange 2003.
79. What is Direct Push? What are the requirements to run it?
80. How would you remote wipe a PPC?
81. What are the issues with connecting Outlook from a remote computer to your mailbox?
82. How would you solve those issues? Name 2 or 3 methods
83. What is RPC over HTTP? What are the requirements to run it?
84. What is Cached Mode in OL2003/2007?
85. What are the benefits and "issues" when using cached mode? How would you tackle those issues?
86. What is S/MIME? What are the usage scenarios for S/MIME?
87. What are the IPSec usage scenarios for Exchange 2003?
88. How do you enable SSL on OWA?
89. What are the considerations for obtaining a digital certificate for SSL on Exchange?
90. Name a few 3rd-party CAs.
91. What do you need to consider when using a client-type AV software on an Exchange server?
92. What are the different clustering options in Exchange 2003? Which one would you choose and why.