Monthly Archives: May 2005

Vermont IT Jobs: Network Administrator and PC Specialist at Chittenden County Schools

Jobs

The links on their site are currently a wreck, but you can go here http://www.ejhs.k12.vt.us/ to get more info. I have copied and pasted from their site, but again, thee links in the descriptions won’t work very well. I have emailed them so hopefully they will be fixed soon.

Position:

Network Administrator

Deadline:

May 23, 2005

Description:

Full-time, 12 month position available to direct, coordinate and maintain local area computer network activities of the Chittenden Central Supervisory Union, Union #46 School District and Essex Junction School District.  BA in Computer Science or related field, plus 3 to 5 years as a network administrator preferred.  Certifications in or ability to obtain certifications in Microsoft, Novell and/or Cisco required.  For additional details please refer to the job description.  Excellent benefits package including family medical and dental insurance; life insurance; a retirement plan with up to a 200% employer match; tuition reimbursement; 11 paid holidays, paid vacation and other paid leaves.  For consideration, please send letter, resume/application and three letters of reference and salary requirements to the address above.

and these two which you won’t retire early on but…

Position:

Microcomputer Specialist – Westford School District

Deadline:

May 25, 2005

Description:

Part-time position available, starting July 1, 2005 to serve our Westford School by performing a variety of specialized computer installation and support functions. Position pays $13.78/hour for 20 hours (2½ days) per week. For additional information please refer to the job description.  For consideration, please send letter, resume/application, and at least three references to the address above.

Position:

Microcomputer Specialist – Essex High School

Deadline:

Open Until Filled

Description:

Full-time position available immediately at our Essex High School to perform a variety of specialized computer installation and support functions. Position pays $13.43/hour, with an excellent benefits package including family medical and dental insurance; life insurance; a retirement plan with up to a 200% employer match; tuition reimbursement; 11 paid holidays, paid vacation and other paid leaves. For additional information please refer to the job description.  For consideration, please send letter, resume/application, and at least three references to the address above.



http://www.AcehAid.org

Vermont IT Jobs: Sys Admin at Country Home Products in Vergennes

Jobs

SENIOR SYSTEM ADMINISTRATOR
(full-time – Vergennes)
DR® Power Equipment, an information-intensive direct marketer, is looking for a Senior System Administrator to join our Information Systems Team. The ideal candidate will have 5 or more years of experience in the following areas: day-to-day systems deployment and administration, designing and managing infrastructure architecture, project management, systems security planning, procurement and supplier management, and budgeting and cost management. Our technical environment includes a multi-point wide area network, multiple Windows/ UNIX/MPE servers, an internally hosted eCommerce presence, stateful firewalling, 200+ desktops and Call Center ACD equipment. Key technologies include: Windows 2000/3, Exchange 2000, Oracle and SQL server, Cisco routers, and a host of supporting technologies.
We have several exciting initiatives in our plans and are looking for a self-starting team player to join us.

http://www.AcehAid.org

Needle Nose

Purely Personal

Late last night my poor doggie went out to pee before we went to bed. Normally I stand outside and keep and eye on her becuase we are surrounded by woods and a black dog can disappear in the black night pretty easily if they see something interesting to chase. But instead, I had a similar urge (to pee, not to chase deer) and went back inside for a few minutes. When I went back out she was not back up on the porch as I would have expected, waiting to come in. I called her (not too loudly, since it was past midnight) and still didn’t hear her panting and trotting back towards me. I went and turned on some more flood lights. Still no Tasha. Finally I put on my coat and shoes and went out. Then I heard her tromping through some dry leaves and a funny snorty noise. Tasha appeared in the light and was bobbing her head up and down in a strange way. When I got up closer to her I saw that her nose had a great display of porcupine quills sticking out of it. Nose, lips and the roof of her mouth. Not a ton – maybe 20 or so total. She wasn’t even whining.

After calling our vet who was on call that night twice and my mother (a breeder who has been through this with her dogs), the vet assured me that if Tasha had no complaints at all about this she would be okay through the night. Since she is old and the ones in her mouth might require sedation to remove, he did not want to do that in the middle of the night.

Tasha slept without complaint thanks to some Rescue Remedy – which I probably should have taken myself. I didn’t sleep much because I’m a big worry wart and I was concerned because she is an old dog and who knows what could happen? Were there any in her chest, in her throat? I kept waking up and checking on her – sleeping soundly and breathing!

This morning we brought her to the vet first thing and he was again amazed that she still had no complaints at all – except that we hadn’t fed her breakfast yet. He was able to remove all of the quills without sedation. The larger quills from the older porcupines are easier to remove for some reason so we were lucky. There is not even a bump or anything on her nose as proof that she went through this.

The stoicism of Newfoundland dogs never ceases to amaze me.

http://www.AcehAid.org

Another Vermont MVP

Community Cheerleading

I just discovered another MVP in Vermont. Anne Stanton, a CRM MVP. Anne also runs a user group, NH/VT Upper Valley IT Consultants, which seems to focus on Small Business Server. In fact, the user group is how I found her. Someone emailed me looking for an IT Pro group in Vermont and I went to Culminis and searched on Vermont.

That makes three including me, that I know of. In addition to Anne, the 3rd is Zoe Hart (Zoe rhymes with GO 🙂 ) who works at C2, a Burlington Gold Partner. Zoe is a Commerce Server MVP.



http://www.AcehAid.org

Vermont Flash User Group

dotNET

There’s a fairly new u.g. in town – it’s the VTFUG. They meet monthly in Burlington and have been doing so since November 2004. It’s nice to keep some friends with design skills around, y’know? They meet on the 2nd Tuesday of the month, which is one night after VTdotNET.

There is another Flash/Macromedia group in Brattleboro. They have been around for a while. That is the Northern New England Macromedia User Group, aka NNEMUG. They meet on the 1st Tuesday of the month.

http://www.AcehAid.org

Next Vermont SQL Meeting : May 16th

dotNET

 

Vermont SQL Server Special Interest Group

Next Meeting

When:   6-8pm, Monday, May 16th.
Where: Competitive Computing, Inc. Colchester, VT.
Topic: SQL Server 2000 Security in a Web scenario

Level 200

Audience: SQL developers and Database administrators

SQL 2000 security in the classic client/server scenario is mastered by most admins and developers. But put the same database in a Web scenario, and everything becomes a little bit blurry. User authentication and authorization suddenly becomes more complex. This conference will cover many topics:

  • Refresher of classic SQL 2000 security: Authentication, Authorization, networking
  • Best practices: SQL Login vs. Windows Login
  • Secure SQL 2000 on a developer workstation
  • Secure SQL 2000 in a web scenario
  • Interaction between a Web App and SQL Server
  • Best and worst practices of authenticating with :
    • IIS
    • ASP
    • ASP.NET
    • SQL
  • Windows Authentication Process :
    • Anatomy of a Token
    • The workings of a Ticket
    • Impersonation and delegation
Speaker:
 

Eric CotĂ©                        

Technical Trainer, 3-Soft (Montreal)  www.Conixio.com

Consultant on the Microsoft platform for the last ten years, Éric CĂ´tĂ© is now an expert on the .NET architecture. Eric holds many certifications (MCSD, MCDBA, MCT) and holds a degree from UniversitĂ© de Montreal (BSc). Eric’s certified trainer status allowed him to instruct developers from many large corporations (Desjardins, Motorola, Bombardier, SoftImage, TĂ©lĂ©-QuĂ©bec, UbiSoft, CAE…). For a third year in a row, Mr. CĂ´tĂ© will be speaking for Code Magazine’s conference, DevTeach, in Montreal next summer. Also, he is a co-chair and an occasional speaker to Montreal’s Visual Studio.NET user group, GUVSM. Finally, Eric is also a co-host to the French version of the Internet radio show .NET Rocks, which is called Blah Blah Dot NET . 

http://www.AcehAid.org

SqlDependency and the non-admin in ASP.NET

ADO.NET 2

SqlDependency is really easy to get working if you are an admin, but when using it in a web app (whether via the System.Data.SqlDependency or System.Web. Caching.SqlCacheDependency) it is not so easy when you are not running under an admin account, which is what you should be doing (although maybe Don Kiely and Andrew Duthie will make exceptions for Betas!) When  you deploy your apps to a web server, you will need the Network Services account to the SqlDependency work.

In addition to enabling the service broker, I had to do two additional steps when working as a non-admin.

Grant Notification Permissions to specific database
  GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [MyDomain\MyGroup]

Grant NotificationErrorsQueue Perms to user (this is for all of SQL Server, so do it from Master)
GRANT RECEIVE ON dbo.[QueryNotificationErrorsQueue] TO [MyDomain\MyGroup]

But this still didn’t do the trick. In Beta2 there is still a problem when SQL Server is trying to send notifications to the web server that requires opening up ports. There is a wide range of ports to open up. I tried a few but still was unable to get through. This is a known issue and will not persist through to the release mode. I will keep at it and blog the key to success when I find it.

During my presentation at the MAD Code Camp, when I got to this demo, I had to log in as admin to run it.



http://www.AcehAid.org

I am a SQL Server luddite

Tools

I use SQL Server nearly every day and I know nothing about it. Two months ago I saw Rod Paddock running stored procedures line by line in SQL Query. I never knew you could do that. (highlight the lines you want to execute and hit run.)Today I was trying to do a query that was case sensitive. I guess in all the years I have used SQL, I have never needed a case sensitive search. So I didn’t know that I had to have my field as a varchar so that I could cast it to varbinary in order to do the comparison. (See Michael Kaplan’s post on an even better way to deal with case sensitivity!)

It is really pathetic (and kinda scary) to know that there are thousands and thousands of people like me who end up being responsible for doing all of the SQL Server work, but we are too busy learning our development tools to *also* be a pro at the database tools, too. Oh, to have Roman Rehak spend just *one* day a week working with me. Heck, I’d take one day a *month*. Boo hoo. I know that looking at my database would probably give him a coronary anyway, so maybe it’s better this way. Actually it would be better not to have someone wiht a public blog look at my db anyway. That way they couldn’t humiliate me as readily. Of course, maybe I could bargain with him using my ADO.NET 2.0 deck and demos for his PASS talk!!



http://www.AcehAid.org

Code Camp D.C. Deck and Demos

ADO.NET 2

Thanks to everyone who attended my Web Services Security and ADO.NET 2.0 sessions. I have had so much awesome feedback on the security session which I really appreciate.  The ADO.NET 2 talk is also one of my favorites. I could go on for days with that one as well.

If you are looking for the slides for the sessions and the demos from the ADO.NET talk, they are all posted on the MAD Code Camp site (that Andrew created using the ASP.NET 2.0 Clubs starter kit!!) for download as well as on my own site, on the presentations page.

Keep spreading the word that security does not have to be a mystery!!!

http://www.AcehAid.org