Posts

Showing posts from July, 2006

Can you hear me NOW?!?!

My wife is very disgusted with our packet8 telephone. Part of the issues we're facing are that our Belkin router will block the outbound voice (thinking that it is a DOS attack). In the security log, there was this entry: 07/17/2006 18:35:57 **UDP Flood to Host** 192.168.1.10, 8006->> 209.247.23.73, 62602 (from WAN Outbound) So, thanks to a technical article I found, there is a support page that references this URL: http://192.168.1.1/firewall_spi_h.stm which allows you to turn off the "SPI and Anti-DoS firewall protection:" It should be easier to turn off a feature like this than an undocumented feature.

It's about time...

Time and space. Two of my favorite things. Time keeps everything from happening all at once. Space keeps everything from happening to you. Time AND Space keep everything from happening all at once to you! The problem to be solved today is this: Create a .net object that has it's XML serialization saved to an XML column in a database table. Now, have a trigger (add/update) that takes that XML field and denormalizes its content to some additional columns. In this way, you have the denormalized data that you might want to use for joins and filtering without having to parse the XML field over and over. You'd create a class something like this: public class Foo { Guid _id = Guid.NewGuid(); //This is our object's database identifier DateTime _updated= DateTime.Now; //This was the last time the object was changed string _description = string.empty; public Guid Id{ get{return _id;} set{_id = value;} } public string Description { get{return _description;} set{_description = va

U-Turn (Going the other way)

So, here's a way to get back a delimited list of items from a table. In other words, concatenate values into one column (that you can then take together to pass to my parse table function). --Setup a sample data to demonstrate the concept declare @Table1 as Table (id int, Item varchar(100)) insert into @Table1 values (1, 'a') insert into @Table1 values (1, 'b') insert into @Table1 values (2, 'c') -- show the table data select * from @Table1 --retrieve the data from @Table1 as a concatinated list Select distinct id, ( Select upper(Item)+' ' as [text()] from @Table1 S where id = T1.id for xml path('')) Items from @Table1 T1