Windows

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

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 »

SQL Error 80004005 – “Specified SQL server not found” – Solved

2017/10/08
By
Modified: 2017/09/16
SQL CFG Manager - Enable TCPIP

  Environment ASP or ASP.NET site is running on IIS 7.5. SQL Server 2008 R2 Express (10.50.1600.1) running on Windows 2008 Server R2 (W2K8 R2) x64.     Problem You will see one of two errors depending on whether you dealing with ASP or ASP.NET sites. On ASP.NET sites you will see  “Server Error – Error: 26 – Error Locating Server/Instance Specified” Server Error in '/YourApps' Application. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26…

Read more »

You can sign PowerShell certificates with New-SelfSignedCertificate and without MakeCert

2017/10/06
By
Modified: 2017/09/16
_20 Code Signing Certificate

  For those who can’t wait, here is the solution right away. Next two lines actually work – without using MakeCert.exe: New-SelfSignedCertificate -DnsName STA07 -Type CodeSigning Set-AuthenticodeSignature C:\T\add-signature.ps1 @(gci Cert:\LocalMachine\My -DnsName STA07 -codesigning)[0] First command creates a certificate in your Intermediate Certification Authorities.  Second command signs the script.  Wow!  Innocent error in documentation from our Seattle friends (https://technet.microsoft.com/en-us/library/hh847874.aspx) probably due to luck of testing.  But a very satisfying result in the end. Now the whole story. On Monday, 2016-02-22 I converted last PC to Windows 10.  A got a nice clean and crispy install.  Everything is working well.  Everything is in place.  I do not want to install any ad hoc software…

Read more »

Automate Database Backup with SQL Express

2017/10/02
By
Modified: 2017/09/16
Automate Database Backup with SQL Express

This article describes, how to automate database backup in SQL Express with mixed Windows and SQL Authentication running on Windows 2008 Server.   This material was tested with Microsoft SQL Server 2008 R2 Express. SQL Server 2008 Enterprise comes with Maintenance Plan feature.  That feature allows amazing flexibility and auditing.  SQL Express edition lacks this feature.  But you still need a backup. Backup automation with SQL Express consist of 3 steps: (1) Write the script to backup all your databases. (2) Test the script by initiating it from a command prompt. (3) Schedule the script using Task Scheduler. Here is each step in detail. ` (1) Write the Script This script overwrites…

Read more »

Office 2010 – Setup – Configure – Reinstall

2017/09/30
By
Modified: 2017/09/16
Office Pro Plus 2010 Activation

First to Note Office 2010 is a true heavy weight. It more than doubles the size of your registry on a fresh Win7 or Win XP instances. Full Office version requires an activation right away, if you install it on top of your Evaluation copy. You still can open applications without activation, but you can’t  Save, Print or set options.  Trial version allows to work without activation for 29 days.  You can see the day remaining counter in File – Help window. Template Normal.dotm from previous Office 2007 are still working.  They can be shared on the network among Word 2007 and Word 2010.  The same is true for an XLSTART file.…

Read more »