Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008

Click this article to see how CTEs and UNION ALL can be used to create a recursive query to flatten a hierarchy relationship into a bread crumb style path: Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008

passing generic list to stored procs

• SQL Server 2008, Table Valued Parameters, and LINQ 
• how to populate a user-defined table type and pass it to a stored procedure call
• Executing Stored Procedure with User Defined Table Type Parameter in Entity Framework Using EntityFrameworkExtras

git ignore

asp.NET Git Ignore

Creating a Disk Image in Windows 8

windows-8-1-full-backup

Juniper Backdoor Exploited

Network Cables: 4 Hacks!

Inner Vs. Outer Join

What is the difference between and inner and out join in SQL?  I hear this question a lot (at work, when I conduct interviews, and when I'm interviewed).  The answer isn't as straight forward as you may think.  Here is a diagram from the article  "Visual Representation of SQL Joins" by C.L. Moffat that show's a visual representation of what each time of join does:

There are other good discussion on the difference between inner and outer joins found in Stack Overflow.

Git Pull = Git Fetch + Git Merge

Even Mark understood this back in 2009.

Python IDEs

10 Python IDEs

Wingware

You can use a text editor, like sublime text, if you are learning or doing very simple things.

Hackathon 2015

Upcoming Hackathons

Find, compete, and earn points for your school at the largest, most diverse student hackathons in the world.