Hello, I'm   Jason

One of my friends was recently in a job interview for a SQL Admin position. The HR representative in the interview asked him if he ever wrote complicated stored procedures. He told me this and I chuckled. What exactly dictates a complicated stored procedure? I’m interested to see what others would consider complicated, especially if you have an example. Post your “complicated procs” here.

I’m not a SQL expert by any means, but, I hope to improve my knowledge and provide valuable insight to readers. I will be posting some interesting news and facts about SQL. My information might not always be regarding SQL Server 2000 or the upcoming SQL server code-named Yukon, but it will all relate to SQL.

Enjoy reading!

Today I was building an assembly in C#. I received an error saying, CS1607: Assembly generation -- Referenced assembly 'Assembly Name' is a localized satellite assembly. After lots of fussing, I figured out that the reason I was receiving that error was because of incorrect data in the AssemblyCulture property. In the AssemblyInfo.cs (or whatever your file is called with the version information), I had to change the [assembly: AssemblyCulture("en")] to [assembly: AssemblyCulture("")]. That fixed the issue!

This past week, I began finishing up a survey application. It was a request from one of the departments that needed to send out multiple surveys with multiple types of questions. Then, they needed a way to build a dynamic query to get the results they needed. It is a fairly cool app with 6 tables and only 5 ASP.NET pages. Not too bad. I will see if I can post the polished code in the future. It’s still in beta mode.

One last thing: I noticed that at ASP.NET Connections in Palm Springs, Steve Smith will be speaking about caching. I think my User Group will find this interesting as he will be speaking about caching just 2 months before that conference when he visits our User Group. :-)

Finally our user group website is back up. You will notice that it loads much quicker now. I’ll be posting some items interesting items that I find on the blogs or in the lists there as well so even if you aren’t in the Northeastern Pennsylvania area, you can still get the info.

Thanks to Julie Lerman, I now know of some material I can pass onto my User Group and students about Whidbey. I’ll post this on the Discussion Board of my User Group site, however, the link is here:

In the Fall of this year, I will begin a part-time teaching gig at a local college called Luzerne County Community College (www.luzerne.edu). In the fall, I will be teaching CIS 263, an Introduction to ASP.NET. The class will be on Monday nights from 6pm-8:55pm EST. If anyone is interested in learning more, let me know. Otherwise, I’ll try to post frequent updates in the blogs regarding this.

I would like to take the time to thank Scott and everyone else who worked on the blog admin site and the blogs in general. You guys did a phenomenal job on cleaning this up and getting this to work. Unfortunately I have been tied up with stuff to blog much, but I hope to be back soon! Congrats on the improvements!!!

I recently had two great speakers at my User Group. The first one started with Charles Carroll. He spoke about Data Access Layers, Web Services and the Utility Belt. He also gave away swag to the attending members. Then later this week I had invited Julie Lerman (in which her parents probably thanked me the most - lol) to speak to the group about streaming. That speech was absolutely phenomenal. We had a very small group for her speech, however, she tailored the speech to fit each of the individuals. She too gave away some swag.

The firm that I work at inventories all of the computers that come in. However, the inventory becomes outdated at times. So, I built in a small component into the inventory system that uses the NT “ping” command to find out if the machine is online, offline, or still exists. This is fairly inefficient as for speed, but we needed a tool to be setup rather quickly to find machines. So, I modified my MAC address web service to use “ping”. Then using the varied responses from the different operating systems, I was able to determine the status. If anyone is interested in the code, let me know and I’ll post what I used.