Jason N. Gaylord
Social Distancing since 3/14
Visit JasonGaylord.com

Hello, I'm  jasongaylord Jason

I live with my family in the rolling hills of Northeastern Pennsylvania. I'm a web developer by trade, but have broad experience in various business areas. Want to know more about me?

Learn More

Understanding Font Rules in CSS

Quite often, developers or designers include a list of fonts within their CSS. As an example, one might define a CSS rule such as:

Read More

Detecting Caps Lock with JavaScript

Earlier today, I saw a user attempt to type his password in both Internet Explorer 9 and Chrome. In both browsers, he failed to successfully type it in. After 3 failed attempts, he realized it was due to his caps lock key being pressed. In some cases, a keyboard driver will inform you on screen when you press the caps lock button. If you are lucky enough to use Internet Explorer 10, you’ll notice that it is built into the browser as shown below:

Read More

Moving On… To Guard Insurance Group

After over 10 years of dedication to United One Resources, I’ve decided that it’s time for my next life challenge. Later today, I’ll walk out the doors of the office on Sherman St in Wilkes-Barre for the last time as a United One team member. I will never forget the past 10 years of my life and what this company has meant to me both personally and professionally. I have some fond memories and new found friends. Below are a few specific people that I felt I needed to mention:

Read More

T-SQL Count of Tables, Views, Stored Procedures and Functions

Have you ever needed to obtain a list or count of all tables, views, stored procedures, and functions in a database? It’s quite easy. Simply copy the T-SQL from below to a query window, set the desired database and execute.

Read More

Converting Unix Epoch to Date in Excel

I ran into an interesting problem earlier today. I was using a CDR dump from our Cisco system. However, all of the datetime fields were represented as seconds. I knew right away that it used an epoch value. What I didn’t know is what the originating date was. Apparently, I was correct at my first guess. I guessed that it was using the standard Unix epoch value of 1/1/1970. Many applications, such as Microsoft Excel, use 1/1/1900.

Read More

Updating Common Controls for Older Applications to Support Windows 8

There are times that you may need to install an older Windows application especially something developed using Visual Basic 6 or earlier. In these cases, you should always ensure that the installed application is using the most current common control library available from Microsoft. If not, you may receive strange error message that logs the following in the Event Viewer (abbreviated exception):

Read More

Detecting Browser Features and Internet Explorer Compatibility Mode

First of all, before I begin, please know that in every case, you should detect browser features and not browser versions. However, there are still times that you may need to know the browser version (such as providing screenshots of various browser alerts – ie: ActiveX installation).

Read More

Using PowerShell to Obtain CD/DVD Disk Information

As the years go by, more and more research, information, and documents can be found online. However, several business verticals still use CDs and DVDs to access research content, backup documents, and share files. In every position that I’ve ever held, I have been asked by someone to locate a disk. I had an old WMI script that would grab the information, place it in a text file on a machine, and notify me via a net message that the file was ready. This was great and did the job, but I wanted to see how I can do the same using PowerShell (and WMI).

Read More

Professional ASP.NET 4.5 in C# and VB

On May 3rd, Wrox Press released Professional ASP.NET 4.5 in C# and VB. I co-authored this book with two Microsoft employees Pranav Rastogi and Scott Hanselman as well as two Microsoft MVPs Christian Wenz and Todd Miranda. The book is packed with the most current information about ASP.NET 4.5. It is also the only book I am aware of that explains One ASP.NET. The foreword for this book is written by Scott Hunter of the ASP.NET team.

Read More

Get the Nth Past Date After Removing a List of Dates from MSSQL

This stemmed from a strange request that came across my desk. I had the need to pull a date 7 business days ago by using T-SQL in Microsoft SQL Server. Sounds simple right? Here’s the catch: the date had to be the 7th business day in the past after removing the days the individual was off.

Read More