Author Archives: Clint

Install Windows 7 from USB Key

Posted on October 22, 2010 by Clint

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

Posted on October 8, 2010 by Clint

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

Posted on September 23, 2010 by Clint

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

Posted on September 17, 2010 by Clint

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

Posted on September 16, 2010 by Clint

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