Windows Archives | Domain Web Center

Can’t convert Number into a string in Excel (not all space characters are the same)

2017/11/05 Udar Gromov 0

Problem started as a simple CAN’T CONVERT NUMBER INTO A STRING in Excel. But solving this problem revealed a deep difference between character Space and character No-Break Space. I was coping some text from Internet and pasting it into Excel to extract QTY, Amount and Total. The ultimate goal is […]

Allow to Pass Optional Parameters to a Stored Procedure

2017/11/03 Udar Gromov 0

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? […]

SQL – Count combinations of values in several columns

2017/11/01 Udar Gromov 0

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: […]

How to Re-Install SQL Server 2008 Evaluation

2017/10/28 Udar Gromov 1

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 […]

Office 2010 Encountered an Error During Setup – Many Sulutions

2017/10/26 Udar Gromov 1

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 […]

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

2017/10/20 Udar Gromov 6

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 […]

Share Digital Certificate for VBA Between Several PC(s)

2017/10/18 Udar Gromov 1

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 […]

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

2017/10/16 Udar Gromov 2

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 […]

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

2017/10/08 Udar Gromov 0

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 […]

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

2017/10/06 Udar Gromov 1

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 […]

Automate Database Backup with SQL Express

2017/10/02 Udar Gromov 8

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 […]

We won again!

Great victory for the People - Tax Cut!

Windows