Start by downloading .NET 4.6.1 from Microsoft. Launch the installer – I typically do this by running the command c:tempNDP461-KB3102436-x86-x64-AllOS-ENU.exe from an elevated PowerShell. Accept the licensing agreement and wait…. Check Version(s) of .NET InstalledFrom an elevated PowerShell run the following set of commands: Get-ChildItem ‘HKLM:SOFTWAREMicrosoftNET Framework SetupNDP’ -recurse |Get-ItemProperty -name Version,Release -EA 0 |Where { $_.PSChildName -match ‘^(?!S)p{L}’} […]
Use PowerShell to Save Excel Worksheet as CSV
I’m working on a PowerShell script to launch some virtual servers on VMWare based on input from a CSV file. To create the CSV file I’m using Excel, and I have more than one worksheet in the Excel workbook. Since it’s a bit of a hassle to use Excel’s GUI to save a given worksheet as a CSV, […]
History of Internet Addressing
Volumes have been written about the Internet and its protocols so what I have here is nothing new or ground-breaking. It is, however, a good overview of the history of IP addressing, related Request For Comments (RFC) and other links. I’ve been working with the Internet Protocols for a while, including data center builds, network operations and teaching […]
How Did One Guy Build A World Class Web Infrastructure Serving Over One Billion Calls Per Day?
On Monday, December 15, 2008 I went to work for an online video start-up. On my first day our video players loaded on 384 of our partner’s web pages. As you can see from the first chart that was actually a pretty good day for us (it was actually our biggest day to date) as we were averaging […]
AWS Certified Solutions Architect
Although I’ve been working with Amazon Web Services for a few years now I only recently learned about AWS certifications. So today I went to an authorized testing center (for the first time in several years) and took a certification exam. And didn’t do too bad. Back in the day I took dozens of exams for Novell’s CNE, […]
My EC2 Server That Ran For Over 5 Years
Today I observed a moment of silence as I shutdown our longest running Amazon Web Services EC2 instance. We started this instance on the evening of October 29, 2008 when we were first getting acquainted with AWS, and stopped it today, February 4, 2014. That’s 5 years, 3 months, 6 days.
Crunching Billions of Log Lines With LogParser
Yesterday three different people came to me asking what type and how many browsers are our “users” using to access our content. Since our products load on about 50 – 80 million pages a day we have a pretty good sample size. And a hell of a lot of log files to collect and analyze. Since I already […]
Improving Web Services (Part II)
Last year I wrote about how we improved web server performance with some fairly small changes, and about how I keep an eye on these metrics with reports I create analyzing my web server logs with Microsoft’s LogParser. This is a follow-up to those. Recently we did an upgrade to our platform. One of the “improvements” was our amazing DBA […]
Using Log Parser to Extract User Agents From Web Log Files
I’ve been meaning to write a follow-up (or two…) to my I LOVE LogParser post from a few months ago. The time has finally arrived. Every day I collect and analyze (at least at a high level) somewhere around 1/2 a billion (yes, billion) web server log lines. And about that many more from a couple CDNs. Needless […]
AWS VPC VPN with SonicWALL NSA and PRO Series Firewalls
Recently Amazon announced, (see also) “You can now create Hardware VPN connections to your VPC using static routing.” This is great news as it greatly expands the type of devices from which a point-to-point IPSec VPN can be created to your Virtual Private Cloud. Previously only dynamic routing was supported, which required BGP and a device (like Cisco […]