Windows Update KB980182 in Windows 7 X64 Video stops playing

Well it looks like microsoft screwed this update up, least on my machine.

Last night I was informed that a security update had been applied. I rebooted and went to sleep. Windows 7
 Cumulative Security Update for Internet Explorer (980182) had been applied and caused my machine to no longer play any video.
This includes Flash,Silverlight, AVI, WMV, and any other video format to load, show first frame and then lock up.

The only way I fixed this and figured out it was the update was to do a system restore to last nights state.

I hope microsoft fixes this issue, as of now, I have to ignore this security update.

http://www.microsoft.com/technet/security/bulletin/MS10-018.mspx

WPF and Silverlight Programming

I have been programming Silverlight for some time now. I have had some hard times trying to grasp the design end and have found some great resources that I would love to share. Hopefully it helps you like it has helped me with Silverlight and WPF:

Windows Presentation Foundation
WPF Architecture
http://msdn.microsoft.com/en-us/library/ms750441.aspx#

XAML
http://msdn.microsoft.com/en-us/library/ms747122.aspx

Base Elements
http://msdn.microsoft.com/en-us/library/ms746683.aspx

Element Tree and Serialization
http://msdn.microsoft.com/en-us/library/ms750605.aspx

Properties
http://msdn.microsoft.com/en-us/library/ms753192.aspx

Guidance on Differences Between WPF and Silverlight
http://wpfslguidance.codeplex.com/

SQL Server - Get Row Count in Table TSQL

I was working on a shared site machine over at Ektron Hosting and hating this MyLittleSQLAdmin utility they have, doesn't even give row counts like SQL management studio.

So I needed a quick way to get total row counts on my table, this worked just fine:

USE [OURTABLEHERE]
GO
SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count
FROM sys.dm_db_partition_stats st
WHERE index_id < 2
ORDER BY st.row_count DESC
GO

How to clear Visual Studio 2008 Recent Project List

Well I was getting so frustrated at my Visual studio List being full of old unused projects when I opened it up, that I needed a way to clear the Visual Studio 2008 Recent Project List. All you need to do is create a reg file with the following code:


Windows Registry Editor Version 5.00

[-HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\ProjectMRUList]
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\ProjectMRUList]


Save it as a .reg file and run it, restart Visual Studio 2008.

How to parse Meta Tags

The other day I needed to parse a custom ASP.NET meta tag. Here is what I came up with:

List metas = new List();
foreach (Control c in this.Page.Header.Controls)
if (c.GetType() == typeof(HtmlMeta))
{
HtmlMeta meta = (HtmlMeta)c;
if (meta.Name == "CategoryID")
strMeta = meta.Content;
}