Monthly Archives: December 2004

SQLDependency and Notification Services – I give UP! (not really)

UNCLE!

I have the right code from the documentation, from Bob B’s awesome article, from the whidbey.adodtnet newsgroup, these posts from Wally McClure (rules, enabling CLR in SQL) and he was kind enough to spend a good chunk of time with me on i.m., too. But I cannot freaking get a notification from my SQL Server (Oct CTP bits). I have set up everything I know of in SQL, even tried this with my firewall temporarily turned off. Apparently besides the code, besides doing all of these things:

  •  grant send on service::SqlQueryNotificationService to guest  in msdb
  • GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [the user] in the database
  • ensuring that Enable_Broker is true in the database
  • getting your calls in your code in the correct order
  • making a proper query statement

there seem to be some 400+ other rules to follow. I have been changing the order of events in my code, reading through the online books, investingating the sql logs, learning more about SQL Server 2005 than I really care to/want to/have time for right now, and on it goes…

Okay it’s a beta. But really. Eight hours. I freakin’ give up. But of course, that’s a lie. I will post this and then think of 24 other things to try and just keep at it until …..who knows…?



Posted from BLInk!

Burlington based MS Gold Partner says business is really looking up

As mentioned by Dave Burke, the local paper, Burlington Free Press has this story in their Business Monday section about Competitive Computing. This is where SQL guru Roman Rehak works. The Free Press does not persist its articles for over a week so I am copying and pasting it into my blog. All copyrights etc  Burlington Free Press. Interestingly, what C2 says kept it afloat after the dot com bubble burst was to focus on local (i.e. vermont state area) businesses.

Boom to bust and back again

 By Shawn Turner
Free Press Staff Writer

COLCHESTER — Competitive Computing Inc. is hoping the days of scrimping and saving are over.

The Web-site builder was forced back into its shell following the tech collapse in 2001. Forty percent of the 75-person staff was laid off. Salaries had to be cut. A paid internship program with the University of Vermont was halted. The company refrained from buying new equipment.

Now business appears to be picking up. This fall, the company — known as C2 — completed Web-site redesigns for Green Mountain Coffee Roasters Inc. and glassware and pottery seller Simon Pearce Inc.

C2 had not worked with either company before, said Steve Thurlow, C2’s vice president of business development. Green Mountain Coffee in Waterbury and Simon Pearce in Windsor wanted to work with a Vermont company, and each initiated contacted with C2. The companies also liked the technical knowledge of C2’s workers.

Half of the 54-person staff at C2 is Microsoft-certified, Thurlow said, “which puts them at the top of the Microsoft skill set.”

C2 President Carolyn Edwards said she has noticed a change in how companies are implementing technology. During the tech-boom years, companies knew they needed to be up to date tech-wise, but didn’t always know how to integrate technology into the business, she said. Today, companies take more time in planning how to integrate business plans with technology.

“There is pent-up demand for technology,” Edwards said.

She might be right. Former U.S. Secretary of Labor Robert Reich said in October that Vermont’s technology sector is likely to see a reawakening during the next 10 years.

“Tech is here to stay,” Edwards said.

The work C2 did in cementing its reputation in the local business community helped the company outlast the slowdown, Thurlow said.

“It’s a way of fueling growth,” Thurlow said. “There are a lot of opportunities in Vermont.
Surviving


C2 had its start in 1993 and began doing Web development in 1996. Since 2000, C2 has occupied 15,000 square feet of office space on Mountain View Drive, which provides stunning views of Burlington and Lake Champlain. It’s a far cry from Edwards’ South Burlington condo that the four founders — Melissa Dever, Todd Kelley and Martin Thieret and Edwards, executives at Digital Equipment Corp., which closed its Vermont manufacturing plant in 1993 — used in the first months following C2’s launch.

The company comprises four parts: Web-hosting; building infrastructure services for clients, including e-mail systems; building Web sites; and consulting with clients on how to use technology to support a business strategy.

 

The company survived the lean years, in part, by relying on its Vermont customers, Edwards said.

“Stay focused on the future and manage your expenses very carefully,” she said, when asked how best to get through rough economic times. “Focus on good quality.”

Community connections, like Edwards’ membership on the boards of the Greater Burlington Industrial Corp. and Vermont Business Roundtable, also helped.

Involvement with the local business community has helped the company’s visibility, Thurlow said. Most of C2’s 30 to 40 clients are in Vermont. The close-to-home clients aided in sustaining C2 during the slow economic years. C2’s reputation in Vermont helped it compete with out-of-state businesses that were looking at adding Vermont customers.

“You need to own your local market,” Thurlow said.

One of the local clients C2 has worked with is the University of Vermont’s College of Medicine. The company helped UVM develop a template that allowed groups within the university to build Web pages that would have a consistent look with UVM’s homepage, said Ted Winfield, who was senior associate dean for finance with the College of Medicine when the template was built.

C2 also helped develop the college’s COMET program that was put in place in 2003. COMET — which stands for College of Medicine Educational Tools — is an online system that provides medical students access to educational resources, said Michael Caputo, director of information systems at the College of Medicine.

“It’s been an effective partnership and Competitive Computing has been very helpful,” said Winfield, associate vice president for budget and resource management at UVM.
The future


Edwards, who declined to reveal company revenues, is “absolutely” optimistic about the company’s future.

C2, which began doing such work as helping bank branch offices network with a home office, will continue to adapt to whichever way the fast-changing world of technology goes next.

“We live in a world where our knowledge base turns over every nine to 12 months,” she said.

With the tech sector recovering, Thurlow said C2 is setting its sights beyond Vermont’s borders. The company has done business with out-of-state companies — including Hershey Foods Corp.’s Hershey Gifts — but would like to add to its list of non-Vermont clients.

Helping C2 expand nationally is Microsoft, of which C2 is a “Gold Partner.” This means the software giant helps C2 with marketing and filters referrals to C2. Hershey Gifts was referred to C2 through Microsoft.

The company doesn’t want to forget about its home state. Thurlow said C2 plans to host a series of business seminars that would advise businesses on how to intertwine technology with operations.

The company is beginning to hire again after employment dropped to 45 from a high-water employment mark of 75 in 2000.

“We could be hiring in the springtime,” Edwards said. “That could be a point for us. Our plan is to grow.”
Contact Shawn Turner at 660-1852 or
sturner@bfp.burlingtonfreepress.com 

Posted from BLInk!

Beth Massi blogging

She didn’t happen to mention it to me, but I found out anyway through a referrer that Beth Massi, a chick who’s brain moves faster than anyone I have ever met, has started blogging. Beth is not only an incredibly smart developer, but she can also rebuild a car engine and has even managed to convince me to get back *out* of bed at 10pm to go out for a drink (along with some additional arm twisting by Marcie…) I expect her blog to be entertaining and very enlightening.

Posted from BLInk!

What do I think of the Code Room pilot?

I have only watched about 1/2 of it so far. I am definitely a little jaded since I know Russ Fustino (the MSDN presenter) and Scott Bellware (making the obvious naughty joke about master pages) pretty well.

What I have seen so far strikes me that the video is a lot more about the MSDN event than the experience of the programmers. I’ve seen discussions of this where people are saying that it’s designed to be accessible to non-technical people. I just can’t see that at all. It’s all way too technical. Who, besides a programmer, could possibly care what ASP.NET 2.0 is? (I just want to drive the car. I don’t care how thermodynamics makes the engine work. And please, if thermodynamics has nothing to do with a car engine, don’t bother correcting me, it’s just an example!)

The one thing I think an average user could connect to (of what I’ve seen so far) is Scott sitting there trying to figure out how to log in to the computer. It’s actually a great moment because here’s this total braniac whiz-kid (yes he’s an extremely smart guy and he’s not really a kid…Scott always has to remind me that he’s not quite as young as he looks :-)) being daunted by Windows – because you know what, we *all* are! Security, even at the level of just being a user on your computer, is really hard for most of us to deal with. And also it is a completely laugh out loud moment to recognize in all of us that we typically don’t think *we* need to read directions. Like when you are setting up a new computer for your parents or friends. Those nice posters that Gateway and Dell et alia create – plug this here, plug this there. Ahh, better yet, I think I blogged a perfect example in my pre-blog blog over here…yup… gad this is embarrassing – but very true!!

Another hour went by before I figured out that I probably should install .Net Framework on to my IIS server. I have been using IIS server on my Win2K server for VS6/ASP development for the past year – but the server obviously needs something more to handle .Net. We’ll see.

Four hours later I see that this is still not working. Aaargh!

3/13: I have finally found explicit instructions about installing to a remote webserver, which include going through the motions of installing VS.NET on the my server. These were right in the initial setup instructions, which I should have seen at beginning but did not in my presumptuousness and impatience. Click here for the explicit instructions for setting up your webserver to host your .Net Web Applications.

Hooray. WebApplication3 is alive!

So, regarding this as something with possible mass-market appeal? I just don’t see that at all. Though, really I have never seen anything official that suggests this is MSDNs goal. Is it a tool to lure new developers? Hmmm, I have to see the rest of the episode to see if they are successful. If they aren’t, then the answer might be no because if Microsoft is promising that it’s SO easy and these guys can’t do it, then I’m not sold. Granted, you are taking serious developers and asking them to do something that is out of the norm for them. These guys are not drag & drop developers so it’s got to be way too hard for them to let go of their way of doing things to use the tools that were probably not really designed for them.

Posted from BLInk!

Don Box on giving presentations and conundrum of slides vs. whitepaper

If you are doing any conference speaking or hoping to, definitely watch this Channel9 video.

One of the things I have the hardest time with is the amount of content on the slides. Don and Mike talk about this. What is the purpose of the slides? A tool for the speaker? A visual aid for the speaker/audience? Or a whitepaper? I tend to go for the whitepaper because I want people to be able to go home with those slides and still have a great reference. Then I will skip whole slides or some points on certain slides during the talk. I would love to minimize the content on the slides during the presentation. I think that I am even comfortable doing this with talks I have done a few times. But I still want the audience to have more than a few bullet points to refer to when they go back to their computers.

I will be thinking about this as I prep for Connections, Windows Anywhere and EdgeEast over the next few months.

The A#1 most important thing according to Don (and I wholeheartedly agree from experience) is get enough rest. “Don’t stay up till 4am working on your demos”. Being rested and alert will carry you through a lot more then being, as Don suggests, an exhausted encyclopedia.



Posted from BLInk!