Avance Zone

Technical Experts Zone Blogs

EXPORT EXCEL SHEET TO SQL SERVER DATABASE

EXPORT EXCEL SHEET TO SQL SERVER DATABASE

SET @server = ‘XLTEST_SP’
SET @srvproduct = ‘Excel’
SET @provider = ‘Microsoft.Jet.OLEDB.4.0′
SET @datasrc = ‘D:\my_excel_file.xls’
SET @provstr = ‘Excel 8.0′
EXEC @RC = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct, @provider, @datasrc, @location, @provstr, @catalog
GO
SELECT * FROM XLTEST_SP…Sheet1$
GO

EXCEL SHEET TO SQL SERVER DATABASE

 

SELECT *

FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′,

                ‘Excel 8.0;Database=E:\example_arb.xls’,

                ‘SELECT * FROM [Sheet1$]‘)

 

 


OPENROWSET ( ‘provider_name‘,

              { ‘datasource‘; ‘user_id‘; ‘password‘ | ‘provider_string‘ },

              { [ catalog.][schema.]object | ‘query‘ }

           )

OR SIMPLY

OPENROWSET ( ‘provider_name‘, ‘provider_string‘, ‘query‘ )

 

 

 

SELECT *

 

FROM OPENDATASOURCE

 

(‘Microsoft.Jet.OLEDB.4.0′

 

,‘Data Source=”E:\example_arb.xls”;Extended Properties=Excel 8.0′)…[Sheet1$]

 

 

 

SELECT *
INTO db1.dbo.table1
FROM OPENROWSET(’MSDASQL’,
 ‘Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\book1.xls’,
 ‘SELECT * FROM [sheet1$]‘)

 

table1 will be created in the db1 database. The content of this table will be imported from the sheet1 worksheet in your c:\book1.xls Excel file.

locked your keys in the car

locked your keys in the car

Does your car have remote keyless entry? This may come
in handy someday. Good reason to own a cell phone: If
you lock your keys in the car and the spare keys are at
home, call someone at home on their cell phone from your
cell phone. Hold your cell phone about a foot from your
car door and have the person at your home press the unlock button,
holding it near the mobile phone on their end.
Your car will unlock. Saves someone from having to drive
your keys to you.
Distance is no object. You could be hundreds of miles away, and if you
can reach someone who has the other “remote”
for your car, you can unlock the doors (or the trunk).
Editor’s Note: It works fine! We tried it out and it
unlocked our car over a cell phone!”
us ringtones

Status bar scroll message

Status bar scroll bar message java script

<SCRIPT LANGUAGE=”JavaScript”>
<!– Start of scroller script
var scrollCounter = 0;
var scrollText = ” CALL +919894160363… HI THIS IS ARVIND’S HOMEPAGE.. CALL +919894160363… SUPPORT FOR THE WEBSITE DEVELOPMENT.. CALL +919894160363… HAVE A GREAT DAY.. THANK YOU”;
var scrollDelay = 70;
var i = 0;

while (i ++ < 140)
scrollText = ” ” + scrollText;

function Scroller()
{
window.status = scrollText.substring(scrollCounter++,
scrollText.length);
if (scrollCounter == scrollText.length)
scrollCounter = 0;
setTimeout(”Scroller()”, scrollDelay);
}

Scroller();
// End of scroller script –>
</SCRIPT>

No Girl Friends ???

HOW HAPPY IS LIFE WITHOUT A GIRLFRIEND

Reasons why LIFE without a Girl Friend is cool

1. You can stare at any Girl…….

2. You don’t have to spend money on her.

3. You won’t get boring result in ur board papers.

4. No girlfriend, no emotional blackmailing.

5. If u don’t have a girlfriend, she can’t dump u.

6. Having a girlfriend is hot, not having a girlfriend is automatically cool, and every one loves to be a cool guy.

7. This can be more to life than just waiting for the bloody phone to ring.

8. You won’t have to tolerate someone else defining, “right” and “wrong” for u.

9. Girlfriend can get so possessive that you can’t do anything according ur wishes anymore.

10. You can buy gifts for mom, dad, sis or grandpa instead of a girlfriend and have a happier family  life.

11. You won’t have to waste paper writing love letters.  No more endless waiting for ur date to arrive at some weird shop place.

12. You can have more friends, as u will have more time for them.

13. You wont have to see boring love stories instead of sports.

14. You wont have to tell lie to anybody and,  therefore, u’ll sin less.

15. You can have good night’s sleep-no need to dream about her.

16. You wont have to fight over having a ’special’ friend with ur folks.

17. No nonstop nonsense.

18. You wont have drown in the pool of her tears.

19. No tension.

20. You can be “urself”

21. You won’t have to hide your telephone bills……

So Try to AVOID Girl Friends in your Life…!.

Checklist to be a Perfect SEO

Perfect Search Engine Optimization Engineer Should Check

Which websites link to you
The number of websites linking to you
The Google page rank of the website linking to you
The page title of the website linking to you
The anchor text used in the link linking to you
The number and type of links linking to the website that’s linking to you.
The number of outbound links on the website that is linking to you
The total number of links on the website that is linking to you
Whether or not the websites linking to you are deemed by Google as an authority website.

Meta Tags

Important Meta Tags


<meta name=”resource-type” content=”document”>
<meta http-equiv=”pragma” content=”no-cache”>
<meta name=”revisit-after” content=”5 days”>
<meta name=”classification” content=”Family – Services”>
<meta name=”description” content=”Little discription”>
<meta name=”MSSmartTagsPreventParsing” content=”TRUE”>
<meta name=”keywords” content=”Keywords”>
<meta name=”robots” content=”ALL”>
<meta name=”distribution” content=”Global”>
<meta name=”rating” content=”Safe For Kids”>
<meta name=”copyright” content=”ARVIND”>
<meta name=”author” content=”ARVIND”>
<meta http-equiv=”reply-to” content=”callarvind_2000@yahoo.com”>
<meta name=”language” content=”English”>
<meta name=”doc-type” content=”Web Page”>
<meta name=”doc-class” content=”Completed”>
<meta name=”doc-rights” content=”Copyrighted Work”>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />

Job interview important questions

1. Tell me about yourself.

Keep your answer short and focused on your professional life. This is not the time to bring up relationships, childhood experiences, family etc. A brief history of education, career and special interests is what is called for here. End it with why you are interested in this particular job.

2. Why are you applying for this particular job?

Show interest and demonstrate that you have researched the job and know what you are getting into. Bring up evidence from past work/ studies that supports your interest in this role and any skills you have acquired in preparation for the role. You can say something like ‘I would like to work for a leader in innovative network and telecommunications solutions and my college degree in computational mathematics has given me a solid background for this role. Mention the value-added you can bring to the job.

3. What do you know about our company?

Indicate what you have learnt from your research activities – from their annual reports,

newspapers, word of mouth, other employees etc. Use this to flatter them and show that you have done your homework.

4. What makes you qualified for this particular job?

Again, explain that you are very interested in the job and demonstrate what it is about your past experiences, education and qualifications that makes you ideal for the job. Show enthusiasm and support your answers with evidence wherever you can (e.g. my summer internship at Citibank gave me broad exposure to the area of equity analysis and I think I can apply many of the tools I learnt there in this job). Elaborate on all the past experiences and skill sets that make you suitable for the job. In cases where your past experience is not directly relevant, you can still find elements of it that can be useful. Play up team skills, computer skills, leadership roles, specific courses and independent research activities that can be useful to the job at hand to show your initiative even where you don’t have directly relevant job experience.

5. What can you do for us that someone else can’t?

Demonstrate key strengths, skills and personal characteristics.

6. Why should we hire you?

See 3. Because you have all the experience/ traits/ credentials demonstrated in 3 and in addition to being qualified, you are enthusiastic, intelligent, hardworking, flexible and willing to learn. Also mention any key relationships you may have that may assist you in the job.

7. What do you look for in a job?

Be honest. Also mention keywords such as challenging, steep learning curve, good work culture, demanding, rewarding, opportunities for advancement and growth, team environment, opportunity to build and maintain client relationships etc.

8. Why are you looking to make a career change?

Mention your interests and make sure you bring up all skills/ experience however insignificant that can support your move in this new direction. It is quite common in this day and age to make a career switch. You need however to show that you have very carefully thought about the change, have a strong interest in the new career and can use some of your previous skills/ education/ relationships to make that move.

9. Why did you leave your last job?

Do NOT use this as an opportunity to badmouth past employers or peers or talk about a failure of any sort. Any of these answers are acceptable: you were looking for a new challenge, your learning curve had flattened out in the previous job and you were looking for a new learning opportunity, the company or department were restructuring, you were ready to start something new after achieving your career goals at the previous company etc.

10. Why do you want to work for us (as opposed to the competitor companies)?

Demonstrate that you know something about the company, that you believe they are leaders/ innovators in what they do, or you think their work culture is exactly what you are looking for, or you like their product(s) or you have friends who work there and have always been attracted to the company etc. Flatter the company and show you know something about it.

11. How long will it take you to start making a meaningful contribution?

Show that you are enthusiastic and willing to learn and will put in all the hours and effort necessary to learn the ropes and start making an immediate contribution. Indicate that your past experiences/ skills/ credentials will enable you to make an immediate contribution at some level while you quickly learn all new aspects of the job. An Interviewer wants someone who is willing and able to learn and will make a return on his investment sooner rather than later.

12. What are your strengths?

See 14 below. In addition, keywords such as good teamplayer, work very well under pressure, very creative, very strong quantitative or computer skills, and very strong client relationship skills may be appropriate depending on your chosen field.

13. What are your weaknesses?

Do NOT mention key weaknesses here. This is not the place to say you are bad at meeting deadlines or you never mastered highschool mathematics etc. Turn this question around to your benefit. For example, you are ‘overambitious’ or ‘extremely attentive to detail’ or ‘like to take on too many projects’. Make it sound positive.

14. What are your career goals?

Show you have thought forward and are committed to your career.

15. How would you describe yourself?

Any of these are good examples of attributes employers are looking for: intelligent, hardworking, quick to learn, enthusiastic, honest, efficient, productive, ambitious, successful, compassionate (in the medical fields).

16. How would your colleagues describe you?

Do not bring up anything negative here.

17. How would your boss describe you?

They will check references anyways so bring up the most positive attribute you can think of about yourself e.g. hardworking, honest etc. and leave it to your Boss to say anything to the contrary.

18. What did you most like/ dislike about your past job?

Do not use this to badmouth past jobs/ employers. Keep it light and in your favour eg I outgrew the job, there wasn’t a clear career progression, I wasn’t learning anything new etc. Ideally, you will have loved your last job and would like to achieve the same kind of success and job satisfaction in a more challenging area as you have now ‘outgrown’ that job and are ready for ‘new challenges’.

19. Describe a situation in your past where you showed initiative?

You could describe any new methods you came up with to do your job or to save money for the company or to turn around a bad situation. It can be something as simple as changing a filing system, or establishing a relationship with a vendor that saved your department a lot of money. If you are in sales, you may want to talk about how you brought in that big account. Creatives may talk about how they came up with that cutthroat image or design that brought in the business.

20. What were your main responsibilities in your last job?

Have these ready and list them all. Dwell on the ones that are most relevant to the new job. This answer should be smooth and practiced.

21. What do you consider your greatest accomplishments?

Many of us have one or two milestones in our career that we are very proud of e.g. that early promotion, that ‘huge’ deal we brought in, the design we came up with, the costs we saved, the revenues we increased, the people we trained, a new invention or process we came up with etc.

Examples of accomplishments may be: ‘Reduced costs by X%; or renamed and repositioned a product at the end of its lifecycle, or organized and led a team to do do XYZ, or achieved sales increase of

X% etc. If you are a fresh college graduate, talk about extracurricular activities, leadership roles and grades.

22. Describe your management style (if relevant)

No answer

23. Do you work better in teams or independently?

Show that you are a proactive team player and like to bounce ideas off others and get input; however you are very capable of working independently (give examples).

24. How do you work under pressure?

Well. Give evidence.

25. What other jobs have you applied for?

Don’t mention jobs in different career directions (e.g. advertising and investment banking). Do however bring up any other offers or Interviews from competing firms.

26. How did you do in college?

Keep it positive. It’s okay to say you were very busy making the most of college and were very involved in sports, activities, social life etc. Employers want human beings not robots. Mention the areas you did very well in even if it was just one or two courses you excelled in. They will check for themselves.

27. What kind of hours would you like to work?

Employers want to see flexibility. Indicate you are willing to put in whatever hours are necessary to finish the job. Do however mention any constraints you have e.g. you would like to be home to pick your kids up from school at 3:30. Most employers are willing to work around your constraints if you show flexibility on your side as well.

28. Do you have any questions for me?

YES you do. Questions engage the Interviewer and show your interest. Ask questions that show you know something about the company or the job, that you are planning ahead, that you are anxious and willing to learn the ropes and that you are committed to the position.

FAQ’s

Methods are fired during the page load ?
Init() – when the page is instantiated
Load() – when the page is loaded into server memory
PreRender() – the brief moment before the page is displayed to the user as HTML
Unload() – when page finishes loading.

When during the page processing cycle is ViewState available?
After the Init() and before the Page_Load(), or OnLoad() for a control.

Where do you store the information about the user’s locale?
System.Web.UI.Page.Culture

What’s a bubbled event?
When you have a complex control, like DataGrid, writing an event processing routine for each object (cell, button, row, etc.) is quite tedious. The controls can bubble up their eventhandlers, allowing the main DataGrid event handler to take care of its constituents.

Suppose you want a certain ASP.NET function executed on MouseOver for a certain button.  Where do you add an event handler?
Add an OnMouseOver attribute to the button.  Example: btnSubmit.Attributes.Add(”onmouseover”,”someClientCodeHere();”);

What data types do the RangeValidator control support?
Integer, String, and Date.

Explain the differences between Server-side and Client-side code?
Server-side code executes on the server.  Client-side code executes in the client’s browser.

What is the Global.asax used for?
The Global.asax (including the Global.asax.cs file) is used to implement application and session level events.
How many classes can a single .NET DLL contain?
It can contain many classes

All Dos Commands – Disk operating system

ADDUSERS Add or list users to/from a CSV file
ARP Address Resolution Protocol
ASSOC Change file extension associations
ASSOCIAT One step file association
AT Schedule a command to run at a later time
ATTRIB Change file attributes

BOOTCFG Edit Windows boot settings
BROWSTAT Get domain, browser and PDC info

CACLS Change file permissions
CALL Call one batch program from another
CD Change Directory – move to a specific Folder
CHANGE Change Terminal Server Session properties
CHKDSK Check Disk – check and repair disk problems
CHKNTFS Check the NTFS file system
CHOICE Accept keyboard input to a batch file
CIPHER Encrypt or Decrypt files/folders
CleanMgr Automated cleanup of Temp files, recycle bin
CLEARMEM Clear memory leaks
CLIP Copy STDIN to the Windows clipboard.
CLS Clear the screen
CLUSTER Windows Clustering
CMD Start a new CMD shell
COLOR Change colors of the CMD window
COMP Compare the contents of two files or sets of files
COMPACT Compress files or folders on an NTFS partition
COMPRESS Compress individual files on an NTFS partition
CON2PRT Connect or disconnect a Printer
CONVERT Convert a FAT drive to NTFS.
COPY Copy one or more files to another location
CSVDE Import or Export Active Directory data

DATE Display or set the date
Dcomcnfg DCOM Configuration Utility
DEFRAG Defragment hard drive
DEL Delete one or more files
DELPROF Delete NT user profiles
DELTREE Delete a folder and all subfolders
DevCon Device Manager Command Line Utility
DIR Display a list of files and folders
DIRUSE Display disk usage
DISKCOMP Compare the contents of two floppy disks
DISKCOPY Copy the contents of one floppy disk to another
DNSSTAT DNS Statistics
DOSKEY Edit command line, recall commands, and create macros
DSADD Add user (computer, group..) to active directory
DSQUERY List items in active directory
DSMOD Modify user (computer, group..) in active directory

ECHO Display message on screen
ENDLOCAL End localisation of environment changes in a batch file
ERASE Delete one or more files
EXIT Quit the CMD shell
EXPAND Uncompress files
EXTRACT Uncompress CAB files

FC Compare two files
FDISK Disk Format and partition
FIND Search for a text string in a file
FINDSTR Search for strings in files
FOR Conditionally perform a command several times
FORFILES Batch process multiple files
FORMAT Format a disk
FREEDISK Check free disk space (in bytes)
FSUTIL File and Volume utilities
FTP File Transfer Protocol
FTYPE Display or modify file types used in file extension associations

GLOBAL Display membership of global groups
GOTO Direct a batch program to jump to a labelled line

HELP Online Help
HFNETCHK Network Security Hotfix Checker

IF Conditionally perform a command
IFMEMBER Is the current user in an NT Workgroup
IPCONFIG Configure IP

KILL Remove a program from memory

LABEL Edit a disk label
LOCAL Display membership of local groups
LOGEVENT Write text to the NT event viewer.
LOGOFF Log a user off
LOGTIME Log the date and time in a file

MAPISEND Send email from the command line
MEM Display memory usage
MD Create new folders
MODE Configure a system device
MORE Display output, one screen at a time
MOUNTVOL Manage a volume mount point
MOVE Move files from one folder to another
MOVEUSER Move a user from one domain to another
MSG Send a message
MSIEXEC Microsoft Windows Installer
MSINFO Windows NT diagnostics
MSTSC Terminal Server Connection (Remote Desktop Protocol)
MUNGE Find and Replace text within file(s)
MV Copy in-use files

NET Manage network resources
NETDOM Domain Manager
NETSH Configure network protocols
NETSVC Command-line Service Controller
NBTSTAT Display networking statistics (NetBIOS over TCP/IP)
NETSTAT Display networking statistics (TCP/IP)
NOW Display the current Date and Time
NSLOOKUP Name server lookup
NTBACKUP Backup folders to tape
NTRIGHTS Edit user account rights

PATH Display or set a search path for executable files
PATHPING Trace route plus network latency and packet loss
PAUSE Suspend processing of a batch file and display a message
PERMS Show permissions for a user
PERFMON Performance Monitor
PING Test a network connection
POPD Restore the previous value of the current directory saved by PUSHD
PORTQRY Display the status of ports and services
PRINT Print a text file
PRNCNFG Display, configure or rename a printer
PRNMNGR Add, delete, list printers set the default printer
PROMPT Change the command prompt
PsExec Execute process remotely
PsFile Show files opened remotely
PsGetSid Display the SID of a computer or a user
PsInfo List information about a system
PsKill Kill processes by name or process ID
PsList List detailed information about processes
PsLoggedOn Who’s logged on (locally or via resource sharing)
PsLogList Event log records
PsPasswd Change account password
PsService View and control services
PsShutdown Shutdown or reboot a computer
PsSuspend Suspend processes
PUSHD Save and then change the current directory

QGREP Search file(s) for lines that match a given pattern.

RASDIAL Manage RAS connections
RASPHONE Manage RAS connections
RECOVER Recover a damaged file from a defective disk.
REG Read, Set or Delete registry keys and values
REGEDIT Import or export registry settings
REGSVR32 Register or unregister a DLL
REGINI Change Registry Permissions
REM Record comments (remarks) in a batch file
REN Rename a file or files.
REPLACE Replace or update one file with another
RD Delete folder(s)
RDISK Create a Recovery Disk
RMTSHARE Share a folder or a printer
ROBOCOPY Robust File and Folder Copy
ROUTE Manipulate network routing tables
RUNAS Execute a program under a different user account
RUNDLL32 Run a DLL command (add/remove print connections)

SC Service Control
SCHTASKS Create or Edit Scheduled Tasks
SCLIST Display NT Services
ScriptIt Control GUI applications
SET Display, set, or remove environment variables
SETLOCAL Begin localisation of environment changes in a batch file
SETX Set environment variables permanently
SHARE List or edit a file share or print share
SHIFT Shift the position of replaceable parameters in a batch file
SHORTCUT Create a windows shortcut (.LNK file)
SHOWGRPS List the NT Workgroups a user has joined
SHOWMBRS List the Users who are members of a Workgroup
SHUTDOWN Shutdown the computer
SLEEP Wait for x seconds
SOON Schedule a command to run in the near future
SORT Sort input
START Start a separate window to run a specified program or command
SU Switch User
SUBINACL Edit file and folder Permissions, Ownership and Domain
SUBST Associate a path with a drive letter
SYSTEMINFO List system configuration

TASKLIST List running applications and services
TIME Display or set the system time
TIMEOUT Delay processing of a batch file
TITLE Set the window title for a CMD.EXE session
TOUCH Change file timestamps
TRACERT Trace route to a remote host
TREE Graphical display of folder structure
TYPE Display the contents of a text file

USRSTAT List domain usernames and last login

VER Display version information
VERIFY Verify that files have been saved
VOL Display a disk label

WHERE Locate and display files in a directory tree
WHOAMI Output the current UserName and domain
WINDIFF Compare the contents of two files or sets of files
WINMSD Windows system diagnostics
WINMSDP Windows system diagnostics II
WMIC WMI Commands

XCACLS Change file permissions
XCOPY Copy files and folders

content filter

Spam emails pose the risk of lost productivity when deleting them, infecting the network with viruses from incoming emails and infecting other networks from viruses in outbound emails with the accompanying embarrassment and potential legal liability.

  • Personal surfing poses the risk of lost productivity, legal liability and malware installed on the network with the associated risk of breach of confidentiality.

  • File sharing poses the risk of exposing confidential information to unknown parties.

  • Instant messaging allows users to transmit information undetected, and effectively punches a hole in the firewall, potentially exposing the client machine to unauthorized access through security vulnerabilities in the IM application itself.

  • Internet telephony uses your bandwidth for other people’s needs.