Avoiding the Red Gate Sql compare “Non-Schema statement was ignored” warning

Gotcha I recently had to create some non-schema related objects for a database project I am working on. It caused an annoying problem with Red Gate SQL Compare where I was prompted each time I did the...

ASUS P8Z68-V GEN3 – Rear bezel USB drivers are knocked out after Windows 10 update

Microsoft made a whoopsie Last night (10/17/2015-10/18/2015) I get a notification that there will be updates, “Okay, good to know – my computer will restart.” I thought to myself. I ...

Nexus 4 Default Notification Sound Won’t Stop Chiming/Playing after it Starts

The Stupid Problem (short answer below) In my situation this turned out to be a very stupid problem that I caused myself without knowing it. I changed my default notification sound on my Android Nexus...

ASUS Com Service (atkexComSvc.exe) Memory Leak Work Around

The Problem So I have noticed after leaving my fairly new PC on (only about 6-9 months old now) for about a week, I was losing a tremendous amount of memory and I couldn’t account for where it w...

Easy Way to Start/Stop SQL Server on a Multipurpose Machine

I have been doing a lot of development on my gaming machine and as all gamers know, you want to have as much free RAM as humanly possible while playing games. I close all open applications, but what d...

SQL Server: String or binary data would be truncated.

Msg 8152, Level x, State x, Line x String or binary data would be truncated. What does this mean? This is the equivalent of SQL Server telling you that you are trying to fit too much into a container ...