SQL + Exchange Services Stop After Windows Server 2008 Updates

Rookie Mistake, even though I am an IT ‘veteran’.

As a Systems Administrator, I am always trying to time Windows Automatic Updates perfectly. It’s one thing to install updates on a solo PC, laptop, or tablet. You manually click the Automatic Updates, sit there and watch them install, and hopefully they go smoothly. These days, Windows updates usually do go smoothly. But for a mid sized or large company or organization, these need to be automated. It is the same in a UNIX, Linux or other environment.

Without going into detail, Windows Updates can be automated via a tool called WSUS. The updates are downloaded to a central server and from there, via group policies, they are pushed out to the local domain servers and workstations. Usually  a reboot is involved, which can be scary on critical servers. It also can be a sweaty experience!

Of course, in a perfect world a networked and domain environment would be duplicated in a test environment. Like I typed, ‘a perfect world’. It is easier said than done, and some companies do not allocate resources for a test environment. These companies, oddly enough, rely entirely on MICROSOFT ENGINEERS to test Windows updates properly before pushing them out to the world! But I digress …

The Rookie Mistake was entirely on me. I properly had spread out the Updates via my WSUS server. Workstations on 1 day, then Member Servers over the Weekend, spread apart from the DC’s time frame. I would check alerts to verify all servers came back online and services were up etc. Any Sys Admin knows ugly Netlogon and other errors can be generated as a DC reboots. Member servers start to panic when they cannot contact Active Directory and security related services. Because the Windows Domain Controller holds the keys to the Kingdom, it is imperative that a DC be active during restarts.

So, the point: One key item possibly overlooked by some administrators: separate Domain Controller and Member Server Group Policies, especially regarding update schedules.

I had done this initially but one day, carelessly, I was trying to get the DC updates done at a different time for scheduling purposes. The reason was that I wanted them done closer to the morning so I could fix quicker if there was indeed an issue. In my infinite (non) wisdom, I erroneously scheduled the new day + time for automated updates to be exactly the same as the schedule for the member servers. Again, this may seem fine on the surface, but again, certain services from member servers NEED to contact a domain controller continuously in order to start successfully. Exchange 2010 and SQL 2008 come to mind! Services like SQL Server and Exchange’s Information Store will literally STOP if there is no contact with a Domain Controller, but mainly when there are simultaneous reboots amongst all DC s and Member servers.

So, do not forget to schedule Domain Controller Windows Updates at least 1 hour apart from Member server updates. Brief reboots of the DC (s) while Member Servers are running are OK, but simultaneous reboots can be problematic. And always have services alerts running, in case there is a problem. I use Netikus Event Sentry for this (it is a solid product), and you can weed out the non critical services from the critical.

I readjusted the schedule to separate the Updates again, and … lesson (re) learned!

AT&T U-Verse Gives Away Free Kindle Fire

Normally when a large company promises gadgets or other enticements IF, and only if, you order THEIR service/product,  you become skeptical. So, when AT&T U-Verse came up with a free Kindle after ordering their cable, internet, and phone bundle I was pleasantly surprised not only with their 2 year pricing contract ($125 monthly for all 3), but with the free gadget offering a swell. It was almost mentioned in passing, and to be honest with you, I almost forgot about it.

This is where I thank AT&T. And no, I do not work at nor for AT&T. In fact, like many (some?)others, I have had issues with AT&T from time to time. But it’s important to pay compliments to large companies and providers as well! I love their U-Verse service. It is very reliable and enjoyable all around. Awesome!

Tangentially, getting back to the ‘free gadget’: I was offered a free item out of several offerings. From AT&T, the choices:

“New U-verse Internet Customers Can Take Their Pick: A Free Xbox 360, SONOS PLAY:3, Kindle Fire or Nexus 7 Tablet”

This was from a few months ago. I have no idea if the offer is still valid, but I am sure they have similar offers. I must tell you the item I chose rocks! I chose the Amazon Kindle Fire 7 HD. It is an awesome little guy. It packs a punch. It is a little too tied into the Amazon ecosystem, but hey, the little tablet was free, thanks to AT&T. I let my 8 year old son use it. We have already logged into our local public library and downloaded a few books to read for free. The WiFi on the Kindle Fire is speedy. It joined the AT&T Wireless network within seconds. It has all the social networking Apps and much more. Of course, an Amazon account is required, and they make purchases EASY (that’s their objective after all ;>). So far, I have not purchased anything, but I have surfed the web via its Silk browser, read a few free Kindle eBooks, and

http://www.amazon.com/dp/B0083PWAPW

U-Verse Blog Entry

Delete Windows Server 2012 Virtual Hard Disk

I noticed on Windows Server 2012 Datacenter edition that deleting a virtual hard disk is a little tricky. This is by design, of course. Imagine deleting your Production server database or web site after a clean up or maintenance cycle. It is not easy to do. If there is a an actual hard drive associated with a Hyper-V virtual machine, it is impossible to delete without tearing things down first. This is good. But even with excellent clustering, replication or {insert fail over of your choosing}, it’s still not good to remove a virtual machine ‘by mistake’.

But let’s say you need to clean up the virtual machines and drives on a large server? The Volumes, Drives, and/or Disks can grow rapidly. Before you know it, you do not know what is what. You can really see this by the location of your Virtual Hard Disks and Hyper-V files (config files). This can get messy if you are storing the virtual machines in different places (don’t do this). So, let’s say a few test servers are set up quickly. Some testing is done and as you are about to remove all virtual disks and machines associated with these testers, you get called off on another project or emergency. You will get to these disk ‘another time’.

But it is forgotten. Before you know it you need some space over n your Exchange Servers. A clean up of unused machines is needed to reclaim space.

This is what I learned. The first step occurs before any of this, when planning out your infrastructure. Namely, pay attention to Virtual Machine NAMING SCHEME. Be sure there is a rhyme and reason to it. In the modern age, you likely do not want to call the virtual machines by the company name + number, i.e. CoolStartup1, CoolStartUp2, etc. What happens if the company gets bought, renamed? Also, it is helpful to use function in the names: ServIIS1 or SERVER_SSL1, etc. This is important as in time, you may need to remove servers from the virtual environment. In other words, be organized.

To remove a Virtual Hard Disk, you first need to locate it, then detach it. First, I verified the ones CURRENTLY IN USE. Screen shots are nice for your own reference. These are not to be touched.
Next up: open Computer Management/Storage/Disk Management. This area is clear on a home laptop, but on a fully raided beast of a Windows Datacenter 2012 Server, this can be blinding. Depending on your scenario, you may have dozens and dozens of Data Partitions and Disk drives. Verify your Disk to be deleted is correct. Right-click the Disk (#), and select Detach VHD (Virtual Hard Disk). In the Detach Virtual Hard Disk window, verify all is good. You will see the name of the .VHDX file that is associated with your virtual machine to be deleted. Hopefully, the names of your machines are logical. Then you can confirm.

This clears it from this interface. But in order to delete the virtual machine’s folder, the one with the large .VHDX file, you may need to find the SYSTEM RESERVED drive within Disk Management. Right click the virtual hard disk and try to Mount. This should yield a System Reserve drive letter. That needs to be deleted, then you should be able to delete the .Vhdx.

Toshiba Windows 8 Laptop for $314

Toshiba Direct is offering a new Windows 8 laptop for $314. Yes, you read that right. If you are a student, for example, this is outstanding. Don’t forget, as cool as iPads are, they do not have a lot of storage (disk) space, and also, the screens are TINY. Small screens are fine for using Facebook and Twitter, not so good for doing real work or study.

Detail are below.

Toshiba Satellite C50-ABT2N11 Laptop

  • Intel® Celeron® processor 1005M
  • Windows 8 (Windows 7 Professional option available)
  • 4GB DDR3 memory
  • 320GB (5400RPM) hard drive
  • Touchscreen Option Available
  • Mobile Intel® graphics
  • DVD SuperMulti Drive
  • 1366×768 TruBrite display
  • Wi-Fi® 802.11 b/g/n
  • Dedicated numeric keypad
  • Integrated webcam
  • Starting at 5.3 lbs
  • http://www.toshibadirect.com/td/b2c/customlanding.to?page=Windows_8_Laptops&src=MAXG&cm_mmc=SEM_Direct_Google

    Windows 8.1 Update

    So … Windows 8.1 shall be released soon. What is this all about? In sum, Windows 8.1 is akin to a nicely done coat of fresh paint over the original version 8. It is an update. A couple of simple key points:

    1. IT IS FREE. Makes sense? It is simply an update to Windows 8.

    2. Searching is easier: when you mouse or touch down to the lower right of Windows 8, you see the Search function. It has been divided into 3 separate search areas: Apps, Settings, Files. With Windows 8.1 the searching is combined, and includes web results. It is done by Bing technology.
    [I am still not 100% sure whether or not Settings are also searched in this all-in-one update]

    3. SkyDrive is the default location for saving files. I think this is awesome. I do not think Microsoft does enough to tout its SkyDrive nor the integration with the former Hotmail and everyday PCs or tablets etc. If you have not saved anything to SkyDrive, give it a try. Save a few test files to it. If you have a Windows phone, you can see them from there. You can log into your Outlook.Com account from any PC in the world and retrieve that cool picture or important Word Document.

    After logging into Hotmail (Outlook.Com), a little secret that some do not know: there’s a little arrow pointing downward. If clicked, you get the secrets to your kingdom:
    Outlook.Com, People, Calendar, SkyDrive

    There are other new features, fixes, and updates included with the Windows 8.1 release.

    Anyway, here’s the official Microsoft Windows 8.1 site

    Windows 2012 Datacenter Virtual Machine Installation

    Imagine having a brand new mondo sized Dell PowerEdge R720 thrown in your lap. Then couple this with Windows 2012 Datacenter, which is essentially a VMWare killer (no way, really?). You spend enough time at the Microsoft Virtual Academy to familiarize yourself with the peculiarities of this Datacenter edition, and really, there aren’t enough hours in a day for this! So, it will stretch for months. But it will happen! The following can apply to Server 2012 Standard edition, but that edition maxes out at 2 virtual machines. This will likely not be enough for most people, but if so, great. Otherwise pay extra for Datacenter edition.

    After learning how to configure the basics of Datacenter, like virtual switching and networking, adding Hyper-V etc, then comes the fun part: adding a virtual machine itself to the Server. After opening the Hyper-V Manager, you can easily go to New /  Virtual Machine. Be sure disk space is straightened out beforehand, because the default is straight off the C: Drive. If you RAID the actual Terrabyte storage drives, then that’s where you need to place all the virtual machines and drives. You can change the defaults for these by going to the Hyper-V Settings of the Server: opposite click the Server (not a virtual machine). Then, under Server, edit the Virtual Hard Disks and Virtual Machines location. Although this can be done manually each time a virtual machine is set up, this defaults to the larger drive location. If you do it manually but forget once, you run the risk of filling traditionally smaller C: Drives (the default location).

    Once you are all set there, the install is a breeze, assuming the ISO install file is healthy. The installation is the same as that of Windows Server 2008 R2, with one major exception: it takes only a fraction of the time (5-10 minutes)! This is the nature of Microsoft virtual machine installation.

    Note: the virtual machine restarts in about 15 seconds after the installation, BUT you’ll still see the “Press any key to boot off DVD” (or similar). DON’T DO IT. This starts the install all over again. The message goes away in a few seconds, and your new machine pops up.

    Here’s my messy screen during an install.

    Charge The Windows Nokia Phone Wirelessly

    Charging a Windows (or any) phone wirelessly? Through a so called wireless “pillow”? What? You mean, no cable to the phone of any sort is involved? To be able to charge a smart phone wirelessly is so cool! Now, it looks like it is possible to do so for under $35. Very nice.

    “We’ve seen the Nokia wireless charging pad go for as little as $25 recently but so far, its fluffier cousin, the “Fatboy” has not had such a deal. Yesterday we reported an offer for $45 but today we can beat that. Truth be told, the Fatboy pillow is the very same wireless charging pad but with a wraparound bed for your precious Lumia.

    That wireless downy combo used to cost upwards of $100 but now you can pick up both for $35 using the Daily Steals website. Even if you don’t like the bed, you can pull away the Velcro and slide out the wireless charging pad to use it naked.”

    http://www.wpcentral.com/deal-alert-nokia-fatboy-dt-901-wireless-charging-pillow