Author Archives: Clint

Install Windows 7 from USB Key

I finally figured out a way to get Win 7 installed from a USB key. Here’s how. What You Will Need Windows 7 ISO 4GB or greater USB Key (thumbdrive, whatever you call it) Working Windows Installation (I did this … Continue reading

Posted in Tips | Tagged , , , | Leave a comment

How to copy a table in SQL Server

For some reason I keep forgetting the syntax SELECT * INTO MyNewTable FROM MyTable

Posted in Programming, SQL | Tagged , | Leave a comment

LINQ: Filtering against a list

I was trying to filter a LINQ query against a hard coded list and Visual Studio kept complaining that it was wrong. I was trying to do something like this: Dim orgnums As New List(Of String) orgnums.Add("210") orgnums.Add("750")   Dim … Continue reading

Posted in Programming, VB.NET, Visual Basic | Tagged , , | Leave a comment

HDCP Master Key

Originally copied from PasteBin (http://pastebin.com/kqD56TmU). I want to keep my own copy just incase it goes down. —– HDCP MASTER KEY (MIRROR THIS TEXT!)   This is a forty times forty element matrix of fifty-six bit hexadecimal numbers.   To … Continue reading

Posted in Programming | Tagged , , , | Leave a comment

Group in LINQ

I keep forgeting how to group by in LINQ and it’s something I do regularly. So here is my cheat sheet. Here is the original T-SQL. SELECT orgno, psno, sche, projid, RecType, Sum(OBBudExpAmt) AS OBBudExpAmt, Sum(ABBudEncAmt) AS ABBudEncAmt From tbl908_BudSPDGrps … Continue reading

Posted in Programming, Visual Basic | Tagged , , , , | Leave a comment