MOTHERS & CHILDRENS

Pencil: I'm sorry

Eraser: For what? You didn't do anything wrong.

Pencil: I'm sorry cause you get hurt because of me. Whenever I made a mistake, you're always there to erase it. But as you make my mistakes vanish, you lose a part of yourself. You get smaller and smaller each time.

Eraser: That's true. But I don't really mind. You see, I was made to do this. I was made to help you whenever you do something wrong. Even though one day, I know I'll be gone and you'll replace me with a new one, I'm actually happy with my job. So please, stop worrying. I hate seeing you sad. :)

I found this conversation between the pencil and the eraser very inspirational.

Mother is like the eraser whereas their children are the pencil.

She is always there for their children, cleaning up their mistakes.

Sometimes along the way...  She get hurt, and become smaller (older, and eventually pass on).

Though her children will eventually find someone new (spouse), but she is still happy with what she do for their children, and will always hate seeing her precious ones worrying, or sad.

This is to all the MOTHERS & CHILDRENS..............!!!!!!!!!!!!!!!!!

Ref: Dont know the origin but I get it from Ahsan

P.S. Thanks a lot (whomsoever compose it) for writing such a wonderful inspirational message..

How to pass variable to sql script from batch file?

How to pass variable to sql script from batch file?

1.       Create a Table called Employees

id int

fname varchar(50)

lname varchar(50)

dept varchar(10)

2.       Insert few records into it as

Id            fname                   lname                   dept

01           Mohd                    Irfan                      IT

02           Gaurav                  Thakur                  IT

03           Animesh              Mishra                  Security
04           Ashok                   Roy                        Admin

3.       Create the sql script as getEmployees.sql

use $(dbname)

select * from $(tablename)

4.       Create the runsqlscript.bat file for running the sql script as below.

sqlcmd -S %1 -i getEmployees.sql -v dbname = %2 tablename = %3 -o %4

5.       Run this command from cmd.

>runsqlscript.bat SQLServerName DBName Employees D:\EmployeesList.txt

Ref - http://blogs.msdn.com/b/ssehgal/archive/2009/04/03/passing-parameters-to-sql-script-using-batch-files.aspx

HCL Care Noida

Hcltouch Number for Noida - 18601800425

For Desktop - Monday to Saturday 9:00 AM to 5:00 PM

For Labtop - 24x7

 

Equivalent SQLWB Command in SLQ 2008

Run command for opening SQL2005 management studio is SQLWB, however the same is not availabl ein sql 2008.

So what is the run command for SQL 2008

 

 

Its SMSS

 

Go to Start -> RUN

Type SSMS

Click Enter

 

And here you are with SQL2008 Management Studio.

 

 

It is possible to have dynamic query in LINQ?

It is possible to have dynamic query in LINQ?

var data = items in ItemsList
where items='some condition'
select items;


The above query is static query as its already written and it will be executed good.

I wanna know if we can make the same query into some string and exec the same??

Can SQL Mirroring be implemented on .NET 1.1

The straight answer is NO, let me find some tweeks and update this topic.

And yes its true, for mirroring , failover implementation it need to provide the failover partner into the connection string which is not supported for .NET Framework 1.1 and 1.0.


http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx


Key: Failover Partner
Default Value : N/A
Description: The name of the failover partner server where database mirroring is configured.
The Failover Partner keyword is not supported by .NET Framework version 1.0 or 1.1.

Database Mirroring Vs Database Replication [SQL 2005 and Above]

Database Mirroring	Database Replication
Making the same database with transaction logs [ synchronous or asynchronous]	Making the same database replicated on other server.
Only snapshot can be used to fetch the data from mirroring server.	Can be fetched data directly from the replicated server.
Mirroring is preferred when we want database online most of the time.	Replication used when we need to run the reports without affecting the primary database performance.
In case of failover the mirroring database in as primary database.	In case of failover you have to specify the secondary database name, it's not failover automatically.