Windows

Everything Windows – Windows Server – SQL Server – Windows 10, 8, 7, even XP
MS Office tricks – Registry secrets – Applications – Browsers

Windows 7 – How to Copy and Delete Massive System Directories

2017/11/17
By
Modified: 2017/11/05
2007-07-07

Problem: You have an old discarded instances of failed Windows 7 installs.  You can rename the directories, but they still clutter your hard drive, and they are very hard to get rid of. I simply can’t take this painful and slow process of deleting huge system directories under Windows 7.  Remember this endless stream of errors, and warnings, and skips.  The same task in Win XP only takes a few seconds.  But under Windows 7, it  is a project of its own.  Pain! Finally, my patience ran out.  I decided to write a script.  And it it worked!   Delete Windows System Directories Here is a fantastic way to delete huge Windows 7…

Read more »


Moving Old ASP Sites to 2008 Server, IIS 7, and SQL 2008

2017/11/13
By
Modified: 2017/11/12
IIS75-ASP-is-not-Installed

It was time to move many sites from W2K3 Server (Windows 2003 Server) and SQL 2000 Server to a new W2K8 Server (Windows 2008 Server) and SQL 2008 Server.  And if I ever have to do it again, I will check with these notes. The greatest secret in technical life (and may be wider) is to change before you have to.  Anticipate and change before circumstances force you.  For a long time I was planning this migration, but I didn’t expect to go through so many hurdles and error messages.  Luckily, I found solutions that seem logical and clean.  So, let’s go into step-by-step details. COPY DATABASE AND SITES – Backup…

Read more »

Macros to “Paste as Text” for Word and Excel

2017/11/07
By
Modified: 2017/11/05
Macros to “Paste as Text” for Word and Excel

These two macros will save you a lot of time.  They used, when you need to copy something from Internet page into a Word or Excel document, but  you do not need all the colors and formatting.   You just need the text. Usually you would do this with Paste Special, but this is several awkward clicks and many seconds lost.  Over the course of the day this is a huge inefficiency. Let’s write a macro for Word first. As of 2012-01-11 WED, I adopted this little macro as final version: Sub PasteText() On Error GoTo Unicode Selection.PasteSpecial Link:=False, DataType:=wdPasteText, _ Placement:=wdInLine, DisplayAsIcon:=False GoTo Done Unicode: Selection.PasteAndFormat (wdFormatPlainText) Done: End Sub This macro…

Read more »

Allow to Pass Optional Parameters to a Stored Procedure

2017/11/03
By
Modified: 2017/09/16
Mount Carrigain NH 1427m

This article shows how to use string parameters to make selection on Boolean fields. What is it you need to select "true", "false" of "ALL" records. How WHERE statement will look like in that case?

Read more »

SQL – Count combinations of values in several columns

2017/11/01
By
Modified: 2017/09/16
Life is a Passage

You have a large table (in my case it has 8,697,647 records) with an Asset Number and a Business Unit, and you would like to know if any asset has record with multiple Business Units. You can count records of unique Asset/BU combinations, but this is not what you want: SELECT FLNUMB, FLMCU, COUNT(FLAID) AS COUNT FROM JDE_CRP.CRPDTA.F1202 GROUP BY FLNUMB, FLMCU ORDER BY FLNUMB, FLMCU This query will return results similar to these: FLNUMB FLMCU COUNT 84865 12000 66 84866 12000 66 84867 12000 75 84867 12704 18 84867 12705 28 84868 12000 75 84868 12715 22 84868 12717 32 84869 12000 66 84870 12000 75 84870 12535 40 84871…

Read more »

How to Re-Install SQL Server 2008 Evaluation

2017/10/28
By
Modified: 2017/11/04
Sandy-Beach-2017

You have 180 days to evaluate.  You can check number of days till expiration:   open your SQL Server Management Studio and widen first line in Help — About box. What if your trial is about to expire, and you need just a few more days to evaluate? You can switch to a free Express edition, or you can follow this cumbersome procedure.   =01= Un-Install SQL Server 2008 Drop all your custom databases Run your Maintenance Plan one last time Save all your maintenance plans (this step was not tested) Go to Control Panel – Programs and Features Uninstall Microsoft SQL Server 2008 – Remove Check Rules – Next Select Features –…

Read more »

Office 2010 Encountered an Error During Setup – Many Sulutions

2017/10/26
By
Modified: 2017/09/16
Office-2010-Error

You are an expert.  You are almost a god. You can manipulate complex installs and difficult projects.  This time you just want to test Office 2010, and be done with it. […This article is quickly growing.  There are surprisingly many nuances behind behind this simple facade  ——>] You quickly create a fresh Windows instance, by copying 3 or 4 directories from some backup storage, and you boot into it. Now, you are trying to install a fresh Office 2010 on a fresh install of Windows (any version including XP, Win7 and W2K8 R2). Everything great and dandy, but you are interrupted with this very informative error message: Microsoft Office Professional 2010…

Read more »

How to Install WordPress 4.X on Windows 10 and IIS 7.5

2017/10/20
By
Modified: 2017/09/16
Pick-IIS-FastCGI-Option

This article is written for those who need to test/evaluate features of new WordPress release on a local machine before rolling it out to all the serves. This article describes running PHP on IIS 7.5 through FastCGI. For best results, reader is required to be able to start and stop services, understand registry manipulations, be comfortable with copy and paste inside a command prompt (Alt+Space, E, P). To achieve better portability, try to match your test machine directory structure as close as possible with your server. Other IIS Features to Pick If you are planning to test old ASP sites on the same machine, you also need to pick: - ASP…

Read more »

Share Digital Certificate for VBA Between Several PC(s)

2017/10/18
By
Modified: 2017/09/16
Excel-Install-Certificate

This article is about time saving, when it comes to enable your macros in Excel every time you open the file. You do not want to allow all macro to run.  But if you don’t, you have to constantly enable your macros over and over again, when you open your Excel files.  To eliminate this, you can create a self-signed digital certificate and this work fine on one PC. But what, if you need to open the same files with macros from several PC(s) on your network.  I think I found a solution on how to create a certificate on one PC and then install that certificate on other PC(s). This…

Read more »

Moving a IIS WordPress Site to Amazon EC2 (New Prices!)

2017/10/16
By
Modified: 2017/11/12
RDP-Options

What is Wrong with Home Server? After a RAID drive hiccup on my local Windows 2008 Server, I was more inclined to consider an external hosting options.  And one of my friends already uses Amazon hosting for at least 4 years now.  So I decided to invest some time to explore this option.   What is Covered Here? – Terminology – Pricing – How to  extract your original ADMIN password – How to open a Custom Port on My Amazon Server – How to transfer files using RDP – How to launch an instance with Instance Store – What if I am Using SQL Express and need a regular D/B Backup…

Read more »

Keyboard Shortcuts for Next, Previous, Euro, Degree Symbols and Moving Around Inside a Worksheet

2017/10/15
By
Modified: 2017/11/05

I never can't remember the Notepad equivalent of "F3" (Find Next) in Word and Excel. Here are the keyboard shortcuts, that are most useful, but almost impossible to remember. Also I constantly need Euro currency symbol (€) and Temperature Degree symbol (°), when writing my travel notes about Europe.

Read more »