Tuesday, September 06, 2005

In my What's new in ADO.NET 2.0 talk, I have one slide and three quick demos on Query Notifications. For DevConnections, I am doing a whole talk on the topic. I was a little worried about filling up an entire session on the topic, but I have learned so much about Query Notifications, caching and SQL Server Service Broker, that I could go on and on about it.

For anyone who has started working with this fantastic new result of collaboration between ADO.NET and SQL Server developers at Microsoft, there are some post-Beta2 changes you should be aware of.

Most importantly, it will, indeed, be possible to use query notifications (easily) when running as a non-admin. Phew!

Also, the plumbing has changed. Through Beta2, notifications come back through either TCPIP or HTTP. This was creating the permission issues above. Now It will be necessary when using SqlDependency or SQLCacheDependency, to do an application wide SqlDependency.Start, which will open up a SQL Connection for the notifications to come through.

Currently there are some settings that need to be tweaked which we haven't figured out yet so I wouldn't bother trying to use this post Beta2 anyway. After many many (many) hours of experimenting, I am determined that there is some setting in SQL Server that we are missing. (And I don't mean enabling service broker on the database). The experimenting pays off with a deeper understanding of how things work.

As soon as I find out the magic combo of settings, I will be sure as ___ ;-) to post them here!

Update: My old friend CompatibilityLevel had come back to bite me in the rear end - and hard. I was using the pubs database. Steve Smith was having the same problem and using the Northwind database. I was using a new install and therefore not inheriting my pubs db where I had changed the setting for pubs to 90. I thought the issue was gone, but it wasn't.

So, though this deserves it's own blog post - remember you can check and set the compatibility level. You need 90 for working with Notification Query. I wonder if Service Broker has the same requirement.

sp_dbcmptlevel yourdatabasename

will tell you what the level is.

sp_dbcmptlevel yourdatabasename,90

will set it to 90.

Thanks to Sushil Chordia and Leonid Tsybert at Microsoft for their help with this!!

 

Don't Forget: www.acehaid.org

Tuesday, September 06, 2005 4:34:34 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

Someone in D.C. is using their noggin!!!

They are sending seized items, such as counterfeit clothing (you know, like fake Ralph Lauren jeans), toys and more to victims of the hurricane.



Don't Forget: www.acehaid.org
Tuesday, September 06, 2005 4:17:27 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

Software Engineer – Telecommute/Virtual Team

CONIX Systems Inc. designs, develops and maintains software that creates new workflow options and improves operational efficiency and customer service for major banks and service providers.

Description

This position as a Software Engineer is a virtual team (home-based) telecommute position responsible for building and deploying large scale .NET infrastructures and systems.  CONIX supports its’ Software Engineers with a complete home office/development environment including furniture, computers, printers, phones and internet connectivity.  All engineers within CONIX telecommute from home-based offices with VPN access to corporate servers and mainframes.

Responsibilities

Design, document and code solutions for Windows and web-based environments using Microsoft Visual C++ and the Microsoft .NET Framework (C#).
Interface with QA to facilitate performance of unit, integration, system and regression testing.
Develop Visual Studio .NET, InstallShield and database installation packages and scripts.
Perform and support customer installations. 
 
Required

5+ years of full-time hands-on experience across multiple technical disciplines (e.g., client/server or web-based application development, network management, database administration, deployment, operations), in the design and implementation of large scale, complex, distributed applications.
Expert in C++, MFC, C# and ASP.NET with a strong background in Windows Systems and IT.
Clear understanding of Object Oriented Design and Programming.
Experience with Visual SourceSafe.
Thorough, hands-on understanding of the Windows server platforms including Server 2003, SQL Server, .NET Framework, XML, Exchange and IIS.
Experience packaging complex multi-server/service-based application and database installations using MSI and InstallShield.
Customer-facing deployment and support experience.
Bachelor’s degree in Computer Science or related field.
High speed internet access (cable or DSL, no satellite).
Travel up to 20%.
Reside in the Burlington, VT area. 
 

Preferred

Digital image movement, analysis and/or processing
Project management experience/certification
High performance multithreaded, Windows service-based architecture experience with .NET
MCSA, MCSE, MCAD or MCSD. 

Contact Human Resources at jobs@conix.com



Don't Forget: www.acehaid.org
Tuesday, September 06, 2005 4:13:45 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

I just got an awesome email from a member of Vermont.NET saying that he has been given permission by his boss to devote his company time to working on volunteer efforts for Katrina. This in addition to his personal time towards the same.

He is hoping to help out on the KatrinaDataProject - which is attempting to aggregate what is quickly becoming too many places to post and search for information on Katrina survivors.

If you have emailed the KatrinaDataProject folks for volunteering (that's john at katrinadataproject dot com), John says he has had 50 reponses so far (hooray) and is putting together an email list to respond to everyone more efficiently.



Don't Forget: www.acehaid.org
Tuesday, September 06, 2005 2:16:40 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

In WSE 2.0 we had the ability to run web services over TCPIP and other transports. Did you use it? I didn't. Too confusing. Loved the demos at TechEd & PDC, though. The Messaging API has in it SoapSender and SoapReceiver, but it is disconnected from all of the security I was doing with WSE - or maybe I just couldn't ever figure it out. I think it even required a lot more angle bracket programming, too,  though I don't recall now.

With WSE 3.0, Microsoft has made transport independent Web Services much more accessible. You can now write web services the way most of us luddites are used to, with the VS IDE (or even graduate to contract first web services) - - add in all of your WSE goodness - i.e. policies for security, etc.

With a HTTP hosted web service, you write the web service and build it in VS2005, deploy it if necessary (I'm still working in a development environment), then write your client, and ( in the simple world), add a web reference which creates a proxy, then make calls to the proxy.

With the example of a console application hosted web service, you write the web service and write a console app that fires up the web service in a URI with a tcp scheme.

The key code for the console app is

1) Create a URI that will be the endpoint
dim myTCPServiceURI as URI= new URI("soap.tcp://mytcphost/mynicewebservice")

2) Add the endpoint and the class for your web service to the Microsoft.Web.Services3.Messaging SoapReceivers
SoapReceivers.Add(new EndPointReference(myTCPServiceURI), GetType(myService))

Then you can fire up this console app and it will sit and wait for messages on that URI, just the way IIS does, but in the case it's coming through TCP. You can also specifiy a port eg: soap.tcp:90. The web service processing just happens right there.

On the client side, the code is not too much different than calling an HTTP Web Service.

For those who only know how to get at web services through web references, remember that this is an existing HTTP Web Service, right? So you can get a proxy to that the way you know, by pointing to the original HTTP Web Service. Otherwise, you can use the wsewsdl3 tool (included with the SDK) that will create a  proxy class directly from WSDL. The proxy is just to make it easier to code against the web service and has nothing to do with where the endpoint is. We will still access it through TCP when we run our client app.

1) Create a proxy  web reference (let's say that becomes localhost)
2) Instantiate the proxy
Dim myWS as localhost.MyServiceWSE=new localhost.MyServiceWSE()

3) Change the URL to point to the uri that is waiting on the TCP Wire (above)
myWS.URL="soap.tcp://mytcphost/mynicewebservice"

4) Define the operation that will be called (eg Web Method)
myWS.RequestSoapContext.Addressing.Action=new Action("GetSomeData")

5) Create a ReplyTo endpoint (as per the WS-Addressing specs)
myWS.RequestSoapContext.Addressing.ReplyTo=new ReplyTo(new URI "soap.tcp://receiver")

6) SetPolicy if that is required
myWS.SetPolicy("mypolicy")

7) Make your call!

Like I always say, if I can do it, so can you! More importantly, it's taken a while for me to finally comprehend it. Which says to me, that Microsoft has gotten it to the proper place for non-plumbers.



Don't Forget: www.acehaid.org
WSE
Tuesday, September 06, 2005 12:27:24 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

This is a really tough tough issue. I would not be the person I am today if it hadn't been for going to an all woman's college where I truly had the freedom to just be myself and over the course of those four years, discover my adult self. Wells College insisted that it was either go co-ed to attract more students, or eventually shut down.

School is in session. Here is an article from the NY Times on the first weeks.



Don't Forget: www.acehaid.org
Tuesday, September 06, 2005 12:16:47 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

Why is it that with thousands of people dead and immeasurable suffering, it's the dog stories that I can't stomach, I won't watch, I can't read. Damn you CNN for putting it front and center on the home page.

I have seen images of floating bloated human bodies. But they become "bodies" - somehow there's a disconnect. We know there are still people undiscovered in their homes hoping and waiting - no food, no water, run out of their meds. But it's hearing about people euthanizing their dogs and that the larger dogs are fighting the gas (I have big dogs), seeing the dogs on the rooftops being left behind (not by choice, not by anybody's real choice), hearing them suddenly being referred to as stray dogs and something to fear, knowing that eventually the answer to "wild roaming packs of dogs" will be to shoot them. This I can't bear. Why? Why is that more powerful?



Don't Forget: www.acehaid.org
Tuesday, September 06, 2005 9:11:49 AM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

So what of the independents? Is it time to give it up and build teams? Time to pick something to become so expert on that you will be the go-to person for that technology? [read more ...]

[A DevLife post]



Don't Forget: www.acehaid.org
Tuesday, September 06, 2005 8:44:28 AM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 
Frank Arrigo highlights an article about a company in Australia deploying 400 Tablet PCs to their sales and marketing team.

Don't Forget: www.acehaid.org
Tuesday, September 06, 2005 7:23:41 AM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 
 Monday, September 05, 2005

Thea Burger reports on attending the launch of South African website: Women in IT, a Microsoft SA initiative.



Don't Forget: www.acehaid.org
Monday, September 05, 2005 4:09:46 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

There will be a code camp in New Brunswick Canada in mid-October.

Here's more info from Amanda Murphy's blog.



Don't Forget: www.acehaid.org
Monday, September 05, 2005 11:25:19 AM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

If you are curious where in Indonesia this was, it is Medan which is on the northeastern part of Sumatra - near Aceh Province

Here is a map where you can see  Medan.

The flight was departing Medan and headed for Jakarta, Indonesia's capital. It crashed in a residential neighborhood in Medan.



Don't Forget: www.acehaid.org
Monday, September 05, 2005 9:57:31 AM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 
 Sunday, September 04, 2005
by way of Rocky Lhotka's blog where he is also passing on the information:
 
We're a few local (ATL) ASP.NET programmers who have created a central datastore, collection web interfaces, and processing system for missing/safe person data on people affected by hurricane katrina.
The idea caught on quick... we've only got 2 guys working on this full time and a third helping out when he can. Since going online we've ben contacted by LOTS of groups who want to work with us. We're overwhelmed and need help... we've got plans for a mobile device interface to our data, and are working with a callcenter fielding calls from disaster victims (the callcenter needs some special enhancements to the interface we can't get to fast enough.). We're being listed as the central survivors database on the emergency web terminals being deployed in disaster zones ( http://www.publicwebstations.com/ )
We've got people on the ground at shelters trying to gather lists and transmit them to our datastore electronically. We're also contacting almost 50 other websites which have lists or data collection systems... they are starting to use our MSP file spec and transmit data to us.
If you could get the word out that we are looking for volunteer programmers who can hit the ground running and take ownership of some of the special projects we have WE WOULD APPRECIATE IT.. but there are people out there looking for loved ones who would appreciate it even more.
Current experience we need:
  • .net mobile framework using our data classes to collect and process data
  • string data parsing experience... there's a lot of data in forum posts we can't use but could triple our data if we could parse into useful fields
  • Mass emailing system... as our system processes incoming bulk data, it makes matches between searchers and safe persons, flagging them as needed contact via email. We need a system to read from a database table containing these contact requests and send them out
  • any general ASP.NET (we're using VB) experience to help build special lookups and interfaces
I hate to make such a request on a holiday weekend, but we are swamped.
Please spread the word if you can.
Thanks!
-John
Developer, The Katrina Data Project

email: john at katrinadataproject dot com



Don't Forget: www.acehaid.org

Sunday, September 04, 2005 7:38:55 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

I went to a wedding today, well, actually a Civil Union of two dear friends who have been together for 20 years already. I was talking with another guest who asked, "hey didn't I see you at Costco with a couple of pallets loaded with stuff?" I said that I was there with a cart and pallet but there were a lot of other people doing the same. But she told me "No, it was you. I recognize your hair. And I didn't even know about the drop off center. But when someone explained to me what you and so many others were doing, I was inspired and we collected a bunch of stuff and also went to the drop off center."

Exactly my point.... :-)



Don't Forget: www.acehaid.org
Sunday, September 04, 2005 7:10:13 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 
 Saturday, September 03, 2005

Here are some things from the .NET community that have caught my eye.

Within the .NET community, there are plenty of developers who live in New Orleans. There is even a small .NET user group, GNONUG, run by Manny Dennis, who was an INETA liaison during the time that I was the chair of the related INETA committee.I haven't heard from him, but I am confident that he, his wife and young child are far away from New Orleans.

Sara Ford at Microsoft is from Mississippi and has been blogging information on the status of family and her town, with a reminder that there are bulletin boards style blogs for relaying information about survivors.

Another Microsoft employee, Bill Steele who is one of the DCC's ( the folks who present at the MSDN events), is planning to fly his plane to the Gulf Coast to deliver 10,000 MREs. This is coming 3rd hand, but the sources are pretty good.



Don't Forget: www.acehaid.org
Saturday, September 03, 2005 12:39:38 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

update: In total, Vermonters filled up 34 tractor trailers, which arrived in Gulfport Mississippi over Labor Day weekend.

I witnessed the most amazing thing yesterday. In one day, thousands upon thousands of Vermonters donated amazing amounts of needed supplies for victims of Katrina. Here are two stories about it. One from the Burlington Free Press the other from Vermont Public Radio.

Here is my own account of what I saw at the local Costco and at one of the drop off centers.

After packing up a bunch of those geeky t-shirts and some other stuff that I have hardly ever or just never worn, I went to Costco. As I am not a member, they gave me a one day pass. The parking lot at Costco was completely packed, hundreds of cars at about 2 in the afternoon.

Inside, though there were plenty of people just doing their regular shopping, it was easy to spot the many folks who were shopping for the hurricane victims. And there were a LOT of them!! They had carts loaded with huge bags of dog food, cases and cases of canned goods, diapers and more. Armed with my credit card as well as promised contributions from Canadian Sharepoint geek, Michael Reinhart and VTdotNET user group member, Dan Smith, I went shopping. It was addictive. I loaded up a cart and then a "flat bed", stood in line with many others who were buying the similar requested items and then with help from James, a Costco employee who was reminiscing about packing up items for soldiers in Iraq, loaded everything into my SUV which I nearly filled. A good feeling. I obviously stopped shopping just on time.

I drove to Williston where one of the 10 drop off centers around the state was located. When I got off the highway, there were state troopers directing traffic, which was backed up and barely moving, with long periods of no movement at all. When I got closer to the drop off point, I saw another trooper signalling a long stream of cars into the parking lot. It had been like this all day. I finally got in there and was astonished, thrilled and elated at what I saw. Sprawled everywhere were various areas for each type of dontation - pet food, baby stuff, women's clothes, hygiene, food, water, etc. Hundreds of volunteers, many just people who had come to drop stuff off or were just driving by and saw the activity, were organizing, sorting through, boxing up items and then loading up pallets. The pallets were then wrapped and moved into tractor trailers. The local paper said that 20 tractor trailers were hired for this job. I wonder if that will even be enough?

These photos don't even come close to capturing what was going on.

The incoming cars were never-ending. I went and parked my car in a nearby parking lot and came back and jumped in. Another trooper and I brought about 20 grocery carts over from Dicks and we then used these to get cars emptied quickly so they could go and more could come. I then would run around dropping off items at the appropriate station and then go attack another car. "Ma'am, have you been emptied yet?" was the catch phrase of the day.

Thousands and thousands of people were bringing donations in.

Everyone kept thanking each other. We thanked people for donations, they thanked us for helping. Everyone was feeling pretty good (for the moment). We had found SOMETHING we could do to help. We knew that this food and water and other items would be in people's hands in one or two days. It was so tangible.

There were news cameras at Costco and at the drop off center. I can't find any video links, but there are links at the top of this post to some news stories and my few meager pictures - oh how I wish Shelley had been there to capture the beauty of this.

One source for more info on how Vermonters can help is the Northern Vermont Red Cross website.

Saturday, September 03, 2005 12:26:24 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

There are a number of spots where people can "check in" so others can find them.

The Red Cross added one yesterday afternoon called Family Links.

You can go to www.redcross.org and click on Family Links on the right.

The direct url is http://www.familylinks.icrc.org/katrina

There is also an 800# where you can call in and have someone at ACR register you in the database or do a search for you.  Call 1-877 LOVED-1S  (1-877-568-3317)



Don't Forget: www.acehaid.org
Saturday, September 03, 2005 9:36:38 AM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 
Saturday, September 03, 2005 9:24:15 AM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 

INETA has added 9 new members to the speaker bureau. Although it's "official", it is not yet posted anywhere so I thought I would. Unfortunately, their budget limited the number of new people that they could bring on board. I know that they had a lot of wonderful people to choose from and had a difficult task. Hopefully, there will be more opportunities at some point to bring some of these people on as well and share them with user groups around North America.



Don't Forget: www.acehaid.org
Saturday, September 03, 2005 7:48:29 AM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  | 
 Friday, September 02, 2005

I mean really psyched! As well he should be!

www.devconnections.com



Don't Forget: www.acehaid.org
Friday, September 02, 2005 12:01:56 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  |