All posts by Julie

SQL Permissions for SQLNotificationRequest in ADO.NET 2.0

ADO.NET 2

Though I have the necessary permissions for using SqlDependency almost memorized (as well as documented in my presentations and my new CoDe Mag article on Query Notification), I tend to forget that when using the lower level SqlNotificationRequest, that you need permissions to send and receive on your custom services and queues.

Here’s how to do that and here is the MSDN Documentation on the same.

In this example, the ASPNET account is the one for IIS5 that I have set up in my SQL Server. Use whichever account is going to be accessing the services and queues.

GRANT RECEIVE ON MyNotifQueue TO ASPNET

GRANT SEND ON SERVICE::[MyNotifService] TO [ASPNET]

 

Don’t Forget: www.acehaid.org

Highest Priced Computer Service in Town

Just Rambling

Having spoken a few times over the years at the one of the Poughkeepsie NY ACM groups, I am on their mailing list. I got a good laugh from the recent mailing announcing a talk about Image Storage ex-IBM engineer (that describes most of the members of the chapter) who has an I.T. support business. In his business description, he says:

To keep from being swamped with more and more business, Jerry has adopted a new slogan:  Highest Priced Computer Service in Town.

Don’t Forget: www.acehaid.org

A sea of orange at DevConnections

Connections

The TabletPC Hands on Labs were very popular at DevConnections. I think I heard that over 600 people did the labs. Upon completion of the HOLs, the attendees were given a bright orange Mobile PC baseball cap. Throughout the conference, 3 attendees wearing those hats won a new Toshiba M400 Mobile PC (you know, a tablet). Lora Heiny has a lot of great pictures of the thrilled recipients here.

You can imagine that every time attendees were in one big room, for example at breakfast or lunch, it was a sea of orange, as they were all wearing the hats in hopes of winning the M400.

But even after all of the M400’s had been given away, people were still wearing the hats. They were kind of cool. At the closing session, where perhaps 1,000 of the attendees were all seated, I took this short video to show the sea of orange hats.

It is only 12 seconds long. The AVI version from my camera is 25 MB and the choppier WMV file is only 2.9 megs.



Don’t Forget: www.acehaid.org

Code Access Security and the BeerBuying Permission

dotNET

As I was doing the last section of my “5 Supposedly Scary Things in .NET” talk last night at the Vermont.NET user group, I came to the slide with the Permission attributes examples to either Request, Demand or Assert permissions. I had decided to try to explain these (very high level) as they had always completely mystified me. Although I have given this talk before, I had a sudden epiphany for a new analogy for the demanding and asserting permissions – purchasing beer. [Read more …]

[A DevLife post]



Don’t Forget: www.acehaid.org

Vermont IT Jobs: SQL DBA

Jobs

Technical Connection has been contracted to recruit for a full time position with a Major Vermont company.
 
We are reviewing candidates for a SQL DBA.  The position is full time with full benefits. We would like to see MSDBA or the equivalent experience.  This is a lead position that will involve hands on development as well as extensive liaison between management and clients.  As part of a team you will have considerable resources and support on hand to insure success. 
 
This is an onsite position so telecommuting is not an option at this time.  The Company offers a high degree of security and stability with fully developed Software Products that dominate their market.
 
Salary target is $75 K
 
Please apply by resume to:
 
Kathie Taft
Technical Connection, Inc.
Vermontjobs@vttechjobs.com
802-658-TECH

Don’t Forget: www.acehaid.org

Scary Vermont.NET Meeting tonight and a VS2005 Pro license

dotNET

I’ll be doing a talk entitled “Five Supposedly Scary things about .NET” at Vermont.NET this evening.

The talk covers the following daunting topics on a high level

  1. Declarative Attributes
  2. Reflection
  3. Delegate
  4. Threading
  5. Code Access Security

I’ll be raffling off the last of the launch copies of Visual Studio 2005 PRO and SQL SErver 2005 Standard.

Free pizza courtesy of www.dottnetjobs.com.

After I did this talk at DevConnections last week, an attendee told me that he had been trying to solve some problems with an app and hadn’t looked at any of these technologies becuase they seemed over his head. He was very excited because he realized that he could solve these problems using some of the stuff covered in the talk and was looking forward to learning more and leveraging them. That is exactly why I did the talk. I hope to inspire others as well.

Don’t Forget: www.acehaid.org

Oh! My CoDe mag article AND opinion piece are out (in a GREAT issue)

Just Rambling

CoDe Magazine sends a pile of issues for the VTdotNET user group every month. I got the box before I left for DevConnections and set it aside, only opening it this morning in prep for tonight’s user group meeting. I didn’t realize that the Query Notification article and the opinion piece I wrote for them had already been printed, but there they were. It’s the May/June issue but is not online yet. In addition to my articles, there is the first of the WCF series articles in there (yay!!!) by Juval Lowy and one on Transactions in ADO.NET by Sahil Malik (yay!). And of course (as always) bunches of other great articles and columns.

Don’t Forget: www.acehaid.org

Eolas, ActiveX in I.E. and Ink on the Web

Tablet

Lori McKinney sent me an email in response to my Winforms hosted in i.e. post, pointing out the I.E. update that  caters to the EOLAS lawsuit.This hadn’t caught my eye before. The update forces users to “activate” ActiveX controls (such as Flash) hosted on a web page. Here is the official article on how that affects our websites. I also found a blog post by Steve Smith and another by Matt Watson with discusson on workarounds.

I installed the update this morning from Windows Update to see  how it affected my ink-enabled winforms controls that are hosted in a web page (eg the Doodling website). Without any of the scripting workarounds, the effect is not really bad at first. Just by placing the cursor over the control area, I get the popup that says “click to activate and use this control.” Click and I’m instantly inking. But it doesn’t remember! I have to do it every time I ope the page in a new i.e. session. This is with Disable Script Debugging checked. If I refresh the page, I get a different message, “press spacebar or enter to activate the control.” But just clicking still works. Odd.

Okay so that was testing on my non-tablet with a mouse. With the tablet and stylus, luckily I don’t really need to tap and THEN draw. Doing that gives me an inky dot where I tapped. But I can actually just ignore the message and start drawing and it works. But this means, I will have to explain this on my website. Hmmm. Maybe I’ll have to check into the scripting after all.

So the known issue is with this thing unchecked – as all good web developers have it set. I didn’t experience anything different. I’ll keep playing with it.

 



Don’t Forget: www.acehaid.org