Div over a Youtube Video?

If you've ever had trouble with a lightbox or any other floating div being overshadowed by an embedded youtube video on your site, here's a very easy way to fix:

How to Fix the Embedded YouTube iFrame z-index Problem
Here’s the parameter you should add to the YouTube URL in the iFrame embed code:

?wmode=transparent

Example iFrame code:
<iframe title=”YouTube video player” width=”525″ height=”325″ src=”http://www.youtube.com/embed/ucowE8dtNqM” frameborder=”0″ allowfullscreen> </iframe>

Code With Fix Applied:
<iframe title=”YouTube video player” width=”525″ height=”325″ src=”http://www.youtube.com/embed/ucowE8dtNqM?wmode=transparent” frameborder=”0″ allowfullscreen></iframe>

I got the answer from:
http://www.jenkaufman.com/youtube-iframe-embed-video-problem-hides-menus-other-layers-546/

Hopefully this will save someone from having to rip through their CSS to find a solution!

A Cool .NET Class for formatting Time

Here's a quick little class I discovered in the framework that helps you format time.

It's called the timespan class, and here's an example:

VB
Dim t As New TimeSpan(0, 538, 0)

'Then you have the 2 properties
t.Hours
t.Minutes

C#
var t = new TimeSpan(0, 538, 0);

//Then you have the 2 properties
t.Hours
t.Minutes

Pretty cool little class! For more info click here:
http://msdn.microsoft.com/en-us/library/system.timespan.aspx

How to Kick People off SQL Server

Sometimes when you try to do something in SQL, like a db restore, it won't let you because of an active connection. If you want to see who it is that's locking up your DB and you want to kick them off, take the following steps:

sp_who - This returns a set of data with all activity on the database. Each connection will have a spid.

kill <spid> - This kills the spid.

Happy killing!