How do you copy from Notepad and paste to command line(DOS)?

Sometimes you may want to run a huge script from the command line but you hesitate to type it into the DOS window. In such cases you may want to type the script into NOTEPAD where you can more easily edit and then paste it into command line. Is this possible?

Yes, you can do it. First you have to run the DOS program with elevated permission, that is as an administrator. Once you do that you can paste it into the command line.
Step 1:
Run CMD with Administrators permission.

The DOS program starts

Step 2:
Prepare your script in NOTEPAD such as the one shown here.

Highlight the script you want to run and copy it to clipboard

Step 3:
Right click in the open DOS screen to pop open drop-down menu.

Click Paste (Control-V does not work). Your text is now copied to command line.

You are done!!

 

Do you want to upload 2GB files to sky?

Aloha from Bengaluru

Microsoft SkyDrive has just released the stuff that helps you to upload 2GB files. That's hefty!!

You can also pick and choose files that you need (Selective Sync) from SkyDrive as well as better organize your uploads. SkyDrive also has a SkyBin. You don't need it, send it to SkyBin and, you want it, get it restored.

Web, Mobile and Desktop (WMD, not that WMD) boundaries are disappearing. They are all one and the same, your stuff, but just 3 avataras.

Note: SkyBin is the blogger's construct.

Organize

Share / Sync

Skybin (Recycle bin on SkyDrive)

Breaking News: Packt finished publishing its 1000th Book

Aloha,

Packt is celebrating and I have been a part of this success story. Particpate in the celebration and get a free eBook to mark this occasion.

Just go to Packt's web site and register yourself if you are not already registered. The rest is simple.

If you are looking for jump starting your SQL Server / Applications you search for eBook versions of my books shown here:

Good luck

Mahalo

How to get rid of the FBI Green Dot MoneyPak Virus

This was quite bothersome virus which froze the screen with its own screen purporting to be from FBI warning you of some dire consequences, unless you send $100 to them on recieving which they will unclock your computer.

I got this on my Laptop which was dual boot Win7/Win8. I could access Win8 but not WIn7. Win7 got infected.

The first thing I tried was to restore it to an earlier point. I chose a point some 3 days earlier to the day I encountered this frozen screen. It did not do any good. It came right back.
I searched the web here and there. At least I knew it was a scam. I did read someone got so scared he was contemplating committing suicide, may be he was doing something illegal and felt that he may be caught.

Then I got hold of Norton 360 6.0 and scanned the whole system on the Win7 side. It had no clue. It found some 7 non-consequential cookies which it removed. I called up Norton and chatted for a while. Well, they told me that Norton 360 6.0 should do the job but they would provide a technicain with whose help I could remove the bug. The cost was $99.99 for this service. I was not prepared to part with the money and I wanted to try other options. I also downloaded few others, but I was not quite sure they would do the job.

These are some related sites where you may find some help:
http://www.spywareremove.com/removefbigreendotmoneypakvirus.html
http://www.zimbio.com/Remove+Malware/articles/9kb7G7Lpj5K/Uninstall+FBI+Green+Dot+Moneypak+Virus+Effective
http://community.norton.com/t5/Norton-360/MoneyPak-FBI-virus-Green-Dot/td-p/808830

My advice, forget about Norton, don't pay them $99.99 not even $9.99, send me a $1 for my advice.

If anyone is interested I can provide the transcript of the chat.
Here is my fix:
I went back and restored the computer to a date in August 2012. It's gone and I am rid of that ransomeware. MSFT has a good thing in its SYSTEM Restore.

BTW, when you choose to restore choose the OS that is infected, in case you have multi-os on your computer.

How to create a drive partition on Windows 7 Home Premium?

Want to try some programs on a partitioned drive? Dual boot Windows 7, Windows 8, Linux etc.

If you need measured steps to do it with screen shots, here it is:

Here I am trying to release some space from my C:\drive

To get to see this you need to go Start | Computer and make a right click and choose Manage from the drop-down list. In the Computer Management Screen choose Disk Management.

Right click the highlighted drive (C:) and pick up shrink Volume..

You get to the Shrink C: screen 

Enter the amount you want to shrink. This was my choice.

Hit Shrink button.

Now you are sizzling. You have 292.97 GB free.

Right click this new released space and click New Simple Volume...

New Simple Volume Wizard shows up.

Read the stuff on it. Hit Next. You need to specify the size of this volume (how many gigabits).

I chose about 40 GB (twice the minimum requirement).

Hit Next. Now in this screen you can choose to create the partitioned drive.

I assumed F: drive. Hit Next to get to the Format drive screen.

I gave Windows 8 as Volume label. Hit Next.

Now you have a F:\ drive with about 40GB. Disk Manager screen gets updated as shown.

You are cooking now. The drive appears in the Windows Explorer as shown.

How do you import a text file to MS EXCEL 2010?

Text file should have some delimiting characters such as comma, tab, etc. Here we assume comma as the delimiting character.

Step 1:

Download the file to a location of your choice, say C:\

Or

Click to VIEW the attachment. Select all in the view. Open Notepad and paste the selected items to Notepad.

Save the Notepad with the selection pasted to a location of your choice, say C:\. Use the file name PrincetonTemp. It will be saved with the extension .txt.

If you cannot complete Step 1 go to the end of this post.

Step 2:

Open a new EXCEL workbook.

Step 3:

Click the menu item DATA at the top.

Step 4:

Now Click the item From Text.

This opens the Import Text File window. Now you go to the location where you saved the file.

In my case it is on the Desktop in a folderr called Basic Excel Training as shown above.

Step 5:

Click PrincetonTemp in the window above and click the button Import at the bottom.

Step 1 of 3 of the Text Import Wizard is displayed as shown.

Note 1: You can see the location of your file here

Note 2: You can see part of your data.

Step 6:

Click the Next button at the bottom.

The Step 2 of 3 of the Text Import Wizard is displayed as shown above.

Since your file has (,) comma delimited. Place a check mark in the check box named  ‘Comma’ as shown below.

Notice that when you click in the box ‘Comma’, you will see the preview of your data as shown above. You are almost there!

Step 7:

Click the button ‘Next’.

Step 3 of 3 of Text Import Wizard is displayed. Here you can make changes to the data and format it. For now Just click Finish at the bottom of the screen.

The Import Data screen is displayed as shown:

If you now click OK, the Excel program will paste the imported data beginning in cell A1.

 You can post it to another location or to a new worksheet. For this exmaple let us just click OK.

The data is imported to the worksheet as shown here.

That completes the Import Process.

---------------------------------------------------

If you could not download the file from my email to you, here it is, just copy and paste it to Notepad

January, 40, 60

February, 32, 50

March, 43, 65
April, 50, 70
May, 53, 74
June, 60, 78
July, 68, 70
August, 71, 70
September, 60, 82
October, 55, 67
November, 45, 55

December, 40, 62

How to get a Windows Live account?

Even if you have Google, Yahoo and other accounts, you should try Windows Live account. It opens the door for many things including all your social networking stuff. You also get to store your stuff on 'skydrive', which is password protected and you can access it from anywhere assumign you can get to internet.

While choosing usernames try to choose a slightly longer name than your own first name or nickname. if you are john do not choose john, try john$$ for example. The same goes to password, choose one hwich has atleast 8 characters, not something like '1234'. '1234' is easy to remember but a lot easierr to hack.

Now for the step-by-step tutorial:

1.  Hold down Control key (CTRL) and click on the blue line below.

https://www.google.com/search?rlz=1C1TSNP_enUS473US473&ix=acb&sourceid=chrome&ie=UTF-8&q=windows+live.com

The following page is displayed:

2.  Now click on SIGN UP in blue (the above should be in the web page).

The following page is displayed.

3.  After you finish the ‘Who are you?’ section do the following:

4.  Click on ‘Or get a new email address”.

The following is displayed:

You have already entered your personal information.  In the Microsoft account name box type in the first part of your email address. This form will add @ Hotmail.com to it. If you already have a ‘hotmail’ account you can use it. You can get a ‘Live.com’ account as well.

The other option to Hotmail.com is the following:

Make sure the name is little more than a few letters. TOM or CLARA will not do because there may be many more with the above name. Perhaps TOM_JULY30 or CLARA$ may be more easily available. Try to type in a slightly complicated account name. WRITE IT DOWN IN YOUR NOTE BOOK.

5.  In the create a password box type in a password which contains atleast 8 letters and atleast a number. WRITE IT DOWN IN YOUR NOTE BOOK.

6.  Reenter the password you just entred.

7.  Enter your telephone number (the one you access daily)

8.  If you have another email address (perhaps, someone@yahoo.com  or someone@gmail.com

9.  Next you write the ZIP code in its box.

10. In the bottom most box type exactly what you see in blue under(New|Auto).

11. Click I accept

12. If there are no issues you will see the final page which says your entry was successful. It probably opens on  your Windows Live Account page.

How do you sign up for Windows Live account?

Even if you have Google, Yahoo and other accounts, you should try Windows Live account. It opens the door for many things including all your social networking stuff. You also get to store your stuff on 'skydrive', which is password protected and you can access it from anywhere assumign you can get to internet.

While choosing usernames try to choose a slightly longer name than your own first name or nickname. if you are john do not choose john, try john$$ for example. The same goes to password, choose one hwich has atleast 8 characters, not something like '1234'. '1234' is easy to remember but a lot easierr to hack.

Now for the step-by-step tutorial:

1.  Hold down Control key (CTRL) and click on the blue line below.

https://www.google.com/search?rlz=1C1TSNP_enUS473US473&ix=acb&sourceid=chrome&ie=UTF-8&q=windows+live.com

The following page is displayed:

2.  Now click on SIGN UP in blue (the above should be in the web page).

The following page is displayed.

3.  After you finish the ‘Who are you?’ section do the following:

4.  Click on ‘Or get a new email address”.

The following is displayed:

You have already entered your personal information.  In the Microsoft account name box type in the first part of your email address. This form will add @ Hotmail.com to it. If you already have a ‘hotmail’ account you can use it. You can get a ‘Live.com’ account as well.

The other option to Hotmail.com is the following:

Make sure the name is little more than a few letters. TOM or CLARA will not do because there may be many more with the above name. Perhaps TOM_JULY30 or CLARA$ may be more easily available. Try to type in a slightly complicated account name. WRITE IT DOWN IN YOUR NOTE BOOK.

5.  In the create a password box type in a password which contains atleast 8 letters and atleast a number. WRITE IT DOWN IN YOUR NOTE BOOK.

6.  Reenter the password you just entred.

7.  Enter your telephone number (the one you access daily)

8.  If you have another email address (perhaps, someone@yahoo.com  or someone@gmail.com

9.  Next you write the ZIP code in its box.

10. In the bottom most box type exactly what you see in blue under(New|Auto). It is not case sensitive.

11. Click I accept

12. If there are no issues you will see the final page which says your entry was successful. It probably opens on  your Windows Live Account page.

What is DTS?

SQL-DMF: SQL Distributed Management Framework is a set of utilities that are not part of the database engine (like Query Analyzer and Enterprise Manager). There are three application programming interfaces, or utilities that allow us to access all the objects in the SQL Server. They are:
 SQL Namespace - SQL-NS
SQL Distributed Management Objects - SQL-DMO
SQL Data Transformation Services - SQL-DTS
DTS, which stands for Data Transformation Services, enable transfer of data and objects between different SQL 2000 Server systems. DTS was originally created to transfer data from OLTP data into OLAP data, which included the various steps of extracting the data, cleansing and transforming to remove inconsistencies, and then loading the data (popularly known as ETL). DTS can validate and summarize data while transferring -- making it extremely powerful.

DTS is available to all SQL Server editions from Enterprise to MSDE. DTS uses OLEDB, so it can be used for transferring data from one OLEDB to another OLEDB and therefore is not specific to SQL Server. It could be used to transfer data between any OLEDB supported databases, for example between Oracle to MS Access without an SQL 2000 middle man. Since Microsoft OLEDB for ODBC can connect to ODBC sources, the data transfer functionality is extended to ODBC sources, and DTS assumes an even more powerful role.

This article will be very useful if you are still using SQL Server 2000

SSIS replaced DTS in the recent SQL Servers after its 2000 Version. If you want a jump start on SSIS, I recommend my books which describes some 20 ETL Tasks. This book may be purchased from Amazon.com

How do you create an empty database in SQL Server Express 2008 R2?

Step 1: Connect to SQL Server Express 2008 R2 in the SQL Server Management as shown.
Right click the Databases node and from the drop-down list shown  click New database.

Step 2: In the New Database window that pops-up provide a name for the database you want to create, herein Htek. If you want you can choose a size different from default size of 2 MB.

Click OK.
This is all that is necessary for creating an empty database on the server. You may click the navigation on the left side for working with file groups and many other options.

After clicking OK you will see the Htek database added to your Databases node which earlier had only System databases. Note however you may need to refresh by right clicking the Databases node and choosing Refresh at the bottom of the list.