Windows Server Uptime

There are times I need to know if a scheduled server reboot has occurred.  Below works on both Windows Server 2012 & Windows Server 2016. 1. On the server, right … Continue Reading →

Cannot Generate SSPI Context – Connection Problem

Problem: When I attempted to logon to one of individual node for my AlwaysOn Availability Group, I received the connection error shown below. TITLE: Connect to Server Cannot connect to … Continue Reading →

Problem Patching a SQL Server Cluster

Problem: I was working with a SQL Server 2014 two node cluster in our test environment.  After the cluster had been setup, I was asked to change the drive letters … Continue Reading →

Creating an ODBC Connection to Teradata for Excel

Setting up a connection for Excel to the Teradata database was a little bit of a challenge.  In this example, the Operating System was Windows 7 and version Excel 2013 … Continue Reading →

Opening a Remote Desktop Connection in Full-Screen Mode on a 2nd Monitor

Problem:  I was give a second monitor at work.  My problem was that when I would drag an open Remote Desktop Connection to the second monitor, the window would have … Continue Reading →

BCP with No Output & No xp_cmdshell

My problem was that I needed to create a cvs file with an older version of a SQL Server database. My plan was to use the BCP utility to create … Continue Reading →

How to Install SQL Server 2012 Shared Management Objects

Recently was asked to install the SQL Server 2012 Shared Management Object on an application server.  There was a new application need some of the library file that are installed … Continue Reading →

Microsoft Lync Starts Automatically When I Log-On

At work, a vendor asked if I would join a Lync Meeting.  Since then Microsoft Lync now opens every time I log on my laptop.  This was annoying. Below is … Continue Reading →

Moving a Certificate from Windows to the Java Cacerts File

Recently I had a server with a java application that one day stopped authenticating users.  I was able to trace it back to the JDK  (java developer kit) that the … Continue Reading →

Grep like command in Windows?

In Linux & Unix, I find that I use the grep command to filter the information by different utilities that returns more then a screen full of information.  For example … Continue Reading →