Change your Yahoo Password Now!

You may have seen reports the last two days that over 500 million Yahoo accounts were stolen from the company. The theft actually took place nearly two years ago, but it is only now being reported. You can read details of the situation here:

What does this mean to you?


If you have a Yahoo email account, you should change your password immediately. Here are the instructions for doing this: (please note, I’ve included some screen shots at the end of this post)

  1. Click on the following link, which will take you to the Yahoo signon page:
  2. Enter your Yahoo email address, and press Enter
  3. Enter your current password, and press Enter
  4. Enter the Verification code (case sensitive) and press Enter
  5. You will then be prompted to enter a new password for your email account
  6. Finally you will be shown a list of alternate ways of contacting you (other email addresses or cell phone numbers). These would  be things you entered when you created your Yahoo account originally. Make sure they are all up to date.


Yes. The Yahoo web site is still available for use. My daughter uses it for her “home” page!


Step 1: Enter your Yahoo email address


Step 2: Enter your password


Step 3: Enter your NEW password twice


Step 4: Enter the verification code

Step 5: Confirm alternate contact information


How to Fix Windows 7 Update

Lots of complaints about Windows 7 Update being broken or not working right. What happens is that when you select to run Windows update, it will just sit their spinning for hours on end. Some people have left it running for 24 hours.

So frustrating. I know. BTDT.

So, here are the steps that I follow to fix the Windows 7 Update issue:

  1. Set Windows Update to not update
    Open up Windows Update, click on Change Settings, then click to NOT update
  2. Stop the Windows Update service
    You can do this by running services.msc
    Then locate and right click on the Windows Update service, then click to STOP  the service.
  3. Delete certain files from the Software Distribution folder
    Open up File Explorer and drill down C:/Windows/SoftwareDistribution
    Open up the Download subfolder and delete all files within the folder
    Go back a level, open up the DataStore folder and delete all the files within the folder
  4. Download the July 2016 Windows 7 Update Rollup (KB 3172605)
    Open Internet Explorer and go to 
    Scroll down to Method 3 (Microsoft Update Catalog)
    Click on the link and install the Microsoft Update Catalog utility
    Click to select the appropriate download for Windows 7
    Click to View Basket in the top right
    Verify the selected file then click Download
    Select the location to download the file
  5. Install the July 2016 Windows 7 Update Rollup, then Reboot
    Use File Explorer, locate the download file, then double click to run/install it
    Follow the prompts to install it
  6. Reboot your computer
    Rebooting your computer will make sure that the Windows Service is restarted properly
  7. Rerun Windows Update
    Hopefully it will now work for you

Windows 10 Memory Compression

I came across a very interesting 30 minute video from Microsoft Channel 9 that discusses the evolution of how Windows handles memory – paging, cache, and now memory compression – from Windows 7 to Windows 10.

You can see if your memory is being compressed by going to Task Manager –> Performance –> Memory.


Here is the video from Microsoft’s Channel 9:

Shrink ShareWebDB Log File on SBS 2008

There’s a well known issue on SBS 2008 servers where the SharePoint Config Log file continues to expand. This SQL log file can rapidly grow in size, eating up valuable disk space on your system C: drive.

I first blogged about this back in December 2008 (view blog).

I posted a second blog post 4 years late in December 2012 (view blog) which provided the recommended Microsoft fix (KB 2000544) to truncate the log file, creating a batch command file and an associated SQL command file to truncate this log file.

I only have a few SBS 2008 servers still installed out in the field. But recently I discovered that there is another similar SQL log file that can grow in size: ShareWebDB_log.ldf file.

On this particular server, the ShareWebDB log file had grown to over 200GB in size. Ouch! Ouch! Ouch!


The solution is to mimic the two files created for the SharePoint log file solution, but have it truncate the ShareWebDB log file instead.

STEP 1: Create the SQL command file

Download the SQL file from my web site (logshrink2.sql.txt), save it to the root of your C: drive, and then rename it to logshrink2.sql

declare @ConfigDB varchar(255);
declare @ConfigDBLog varchar(255);
declare @ConfigDBCmd varchar(255);
select @ConfigDB =  name from sys.databases where name like ‘ShareWebDb%’;
set @ConfigDBCmd = ‘BACKUP database [‘ + RTRIM(@ConfigDB) + ‘] to disk=”C:\windows\temp\before2.bkf”’;
set @ConfigDBCmd = ‘use [‘ + RTRIM(@COnfigDB) + ‘]’;
set @ConfigDBCmd = ‘BACKUP LOG [‘ + RTRIM(@ConfigDB) + ‘] WITH TRUNCATE_ONLY’;
set @ConfigDBCmd = ‘use [‘ + RTRIM(@COnfigDB) + ‘]’;
select @ConfigDBLog =  name from sys.database_files where name like ‘ShareWebDb_log’;
set @ConfigDBCmd = ‘use [‘ +  RTRIM(@ConfigDB) + ‘] DBCC SHRINKFILE([‘ + RTRIM(@ConfigDB) + ‘_log],1)’;
set @ConfigDBCmd = ‘BACKUP database [‘ + RTRIM(@ConfigDB) + ‘] to disk=”C:\windows\temp\after2.bkf”’;

STEP 2: Create the DOS batch command file

Next, download the DOS batch command file from my web site (logshrink2.cmd.txt), save it to the root of your C: drive, and then rename it to logshrink2.cmd

dir c:\windows\sysmsi\ssee\mssql.2005\mssql\ShareWebDb* /s
sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E -i c:\logshrink2.sql
dir c:\windows\sysmsi\ssee\mssql.2005\mssql\ShareWebDb* /s

STEP 3: Run the command file with administrator rights

Finally, open up File Explorer, right click on the logshrink2.cmd file, and click to “Run as administrator”

RESULT: Here is a screen shot of running this on the server with a 200GB log file:


How to Stop Windows 10 from Installing an Update

Have you encountered a situation where Windows 10 will try to install an update that you don’t want installed? Perhaps for a non-existent printer? Or an update that you just aren’t ready to test, like a new video driver?

Windows 10 seems to love doing things automatically, without any real control over what it does. Fellow MVP’er, Susan Bradley, pointed me to a Microsoft driver tool that will allow you to resume control of some of these updates and troubleshoot such situations.

Check out Microsoft KB 3073930 titled: How to temporarily prevent Windows or driver update from reinstalling in Windows 10

  1. When you click on the link, you will be prompted to run or save “wushowhide.diagcab”. Go ahead and select run.
  2. Click Next to proceed:
  3. Now you can select to hide updates, or to show hidden updates:

Security Patch MS16-072 Breaks GPO on SBS 2008, SBS 2011, and Windows Server 2008/2008R2

Microsoft recently released security hotfix MS16-072 last week. This patch attempts to improve GPO security. But as my fellow MVP’s Susan Bradley and Wayne Small have discovered, this new security update can actually break certain GPO based processes, such as WSUS.

Note: Microsoft has not released a fix to this, nor are we expecting them to do so. But the blog posts below offer instructions for manually fixing this issue.

Here are the two blog posts that Wayne Small posted on his site, identifying the problem and suggested work arounds:

Susan Bradley forwarded the following post from Group Policy Central which includes a PowerShell script and further instructions from Microsoft to manually fix this problem.

Beware of Microsoft Tricking You Into Installing Windows 10

I’ll keep this short, sweet and to the point. Beware of the “Windows 10 Upgrade” notice!

First, I really like Windows 10, and I encourage people when buying a new computer to get Windows 10. I have also done a fair number of in-place upgrades to Windows 10. All of them were successful upgrades, although I had unique challenges with two of them that took time to resolve.

Microsoft released Windows 10 at the end of July 2015, and made it a free upgrade for most people. In the past six months, Microsoft has been pushing nag messages and prompts to remind you to upgrade to Windows 10.

But, with less than two months to go, Microsoft has upped the nagging to almost full scale trickery. The details can be read in this PCWorld article.

But here is the catch: you may think you are saying “No” to the Windows 10 upgrade by clicking on the X in the top right corner of the popup window. But it’s just the opposite. Clicking on the X is being treated the same as clicking on OK at the bottom of the window.


Please be careful!

QuickBooks Pro 2016 Fails to Open Company File in Multi User Mode

One of my customers has been running QuickBooks Pro 2016 with no issue in multi user mode since we upgraded to it in January. Server is SBS 2011 (Windows 2008 R2).

Yesterday we were putting in a new router and VOIP phone system. We had an issue with Exchange receiving email after the new router was in place. I ran the “Fix My Network” and then rebooted the server. Meanwhile the tech working on the phones found where he had to make a change to the firewall to open port 25.

Long story short, we did some minor things to the server. But an hour later the customer could not open QuickBooks in multi-user mode, although it did work in single user mode.

That pointed to an issue with the Database Manager Service for 2016 (QuickBooksDB26). Sure enough, the service was not running.


And when I attempted to restart it manually, it displayed the “started and then stopped” error message:


I checked to make sure that firewall rules on the server were correct. I even attempted to re-scan using the the QuickBooks Database Server Manager, but it also just told me that the service was not running.


Most solutions to fix this problem centered around uninstalling and reinstalling the QuickBooks Manager service, which I was not keen on doing.

I kept searching, and then found this solution in the Intuit forum that fixed the issue for my customer:


Hope this helps you!

Microsoft Phone Business Sold

Lumia 950The writing has been on the wall for this announcement, as far as I’m concerned, since the day Microsoft bought Nokia’s phone business back in 2013.  They spent $7.2 billion to purchase Nokia.

And today it’s announced that they’re selling it for $350 million to IH Mobile and HMB Global.

Aarrgghh …

You can read more of the details here and here.

BrightHouse Becomes Charter Today

In April, Frontier took over Verizon. And the fallout is still being addressed 6 weeks later. Today, Charter takes over BrightHouse Networks, and they promise a smoother transition, according to a Tampa Times article.

“When we acquire Bright House, we acquire the whole company,” Dudley said. “The plan ensures that the company that is running today is running tomorrow. There’s not a switch that gets flipped. We can leave them right in the Bright House infrastructure while we work behind the scenes.”

Let’s hope so!

Bright House

Charter Communications Logo.