Windows

Windows XP – Windows 2003 2008 Server R2 – SQL 2008 Server
MS Office Tips – Applications – Registry Secrets – Browsers

The very first Tech Forum here is Windows

Update Field Based on a Field in Another Table

2013/03/19
By
Modified: 2013/02/17

This article contains 3 examples: - T-SQL; -MS Access; - AS/400.   This example shows a standard T-SQL syntax tested on MS SQL 2005 server: update P set P.CertMemberLevelID = Z.CertLevelTo from   UPM_MemberPermissionMask P INNER JOIN zzzCertRegistryUpdate Z ON P.MemberID = Z. Cert2ID  Here we are updating one filed CertMemberLevelID in table UPM_MemberPermissionMask based on field Cert2ID in table zzzCertRegistryUpdate. This next example was generated using MS Access 2007 syntax: UPDATE CRPDTA_F1201 INNER JOIN CatCode7 ON CRPDTA_F1201.FANUMB = CatCode7.XXNUMB SET CRPDTA_F1201.FAFA7 = [CatCode7].[XXFA7] A field FAFA7 in CRPDTA_F1201 is being updated. Table  CatCode7 contains 2 fields: - ID Link field XXNUMB and - Update values field XXFA7 SQL statement JOINs two files…

Read more »


How to Re-Install SQL Server 2008 Evaluation

2013/03/17
By
Modified: 2013/02/17

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 »

How to Get SQL Table Fields Structure?

2013/03/15
By
Modified: 2013/02/17
SQL-2008-R2

Sometimes you need to display or print a SQL table structure. This article provides a SQL statement that allows you to do that. We are using MS SQL 2008 Studio interface.

Read more »

How to Compare SQL SmallDateTime Field for Equality

2013/03/13
By
Modified: 2013/02/17
MS SQL Server 2008 R2

It is meaningless to compare for equality (==) two fields of type SmallDateTime, because they contain time component and they are hardly ever the same. Here are some interesting ways around this problem to check, if two SmallDateTime fields have the same date component.

Read more »

WordPress: Image Editor is not Loading in IE under Tight Security

2013/03/11
By
Modified: 2013/02/17
WordPress - Image Editor is not Loading

Let’s say you have a very thigh zone security setup in IE.   All Internet sites are set to High security level, and  Trusted sites set a Medium-High. In that case you might experience a painful WordPress problem – Image Editor is not loading in IE.  It is getting stuck on a dark loading image. Symptoms: when you click on Add an Image or Edit Image buttons, all you see is your screen is darkening and running image in the middle imitating loading is staying on, forever. To solve this problem without killing your security settings add site about:blank to you trusted site list and here we go – problem is solved!

Read more »

Apply Color Scales Conditional Formatting to Multiple Rows in Excel

2013/03/09
By
Modified: 2013/02/17
Excel - Color Scale Conditional Formatting

When you might need to apply color sales Conditional Formatting to multiple rows in Excel using a Macro?  We found that is most useful, when you have a perfectly arrange row-by-row conditional formatting, and you are trying to insert a new row.  You can try to fix the resulting formatting rules mess manually, or use this macro to set all formats in the range. First you n first row need to select the range were your conditional formatting will apply and clear all formatting rules. Next, you need to setup proper color scale conditional formatting in the first row of the range. Now, you should create a name range to reference…

Read more »

Office 2010 Encountered an Error During Setup – Many Sulutions

2013/03/07
By
Modified: 2013/02/17
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 »

Horizontal Line in Excel Header and Footer

2013/03/05
By
Modified: 2013/02/17
Horizontal-Line-in-Excel

  We would like to add a horizontal line to the header of an Excel file to be repeated on every page. To add a horizontal-line we first need to create an image of a horizontal line in your favorite imaging software. Create a PNG image 660 by 3 pixels and color it in some shade of gray.  Save the image with an appropriate meaningful name.  You will be using this file each time you need to add a line to Excel header of footer. Now, insert this image into Excel header: Note that &[Picture] code should be bellow any other code that you have in the header. Now we have…

Read more »

How to Run Malicious Software Removal Tool?

2013/03/03
By
Modified: 2013/02/17
Malicious Software Removal Tool

MRT Just 3 letters you need to know – MRT That is right, just type MRT.exe in you Start – Run box.  Why they hide it so deep?  Why there is no easy answer anywhere on the Internet? The program is located in %WinDir%\System32\MRT.exe Once again, to run Malicious Software Removal Tool type MRT in your  Start – Run box. In this article I am going to: - Accumulate information about annoying files that push themselves in the registry; - Show how to write a small CMD script that will continuously clean your registry Run locations; - Describe how to secure your Internet Explorer to lower possibility of malware infection; -…

Read more »

Count Number of Cell with Errors in Excel

2013/03/01
By
Modified: 2013/02/17

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count, how many errors are in that column. Enter formula =SUM(IF(ISERROR(E2:E10),1)) and press Ctrl+Shift+Enter while still in editing mode. You should see two things.  First, your formula turns into {=SUM(IF(ISERROR(E2:E10),1))} with square brackets around it, and second, you got you a correct cells with errors count.  This is it. If you need to count cell without errors, you can use this formula: =SUM(IF( NOT( ISERROR(E2:E10)),1 ))…

Read more »

Automate Database Backup with SQL Express

2013/02/21
By
Modified: 2013/02/17
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 »