Archives
-
Have a Merry ZBB day
If my memory serves correctly, the infamous ZBB date for ASP.NET 2.0 Whidbey is either close or here. I would like to wish the ASP.NET team a merry ZBB day. I am looking forward to the first post ZBB CTP bits from the ASP.NET team.
-
New version of MySql .NET Connector.....maybe
I just looked at the contents of the MySql .NET Connector this morning. There are a couple of files dates from October 28, 2004 @ 8:00 am. BTW, it is 10:10 am in my timezone). I think that this might be a new version of the connector, if you are interested.
-
Cursed no more - Red Sox win World Series
http://sports.espn.go.com/mlb/fallclassic/columns/story?id=1907279
-
ASP.NET MVPs on the MSDN Dev Center Site
-
MySql 4.1 - Generally Available
MySql Version 4.1 general availability was announced.
-
Visual Studio 2005 Intellisense Support
If you want the full Visual Studio 2005 Intellisense Support, don't forget to save your files to the project that you are working on. It seems at this time, if you don't save the files to the file system, the IDE does not pickup the changes and Intellisense doesn't pickup changes to files, such as a change to the web.config. I was doing some work last night and talking to J. Ambrose Little at the same time. During some complaining on my part, he reminded me of that fact. I saved my files and voila, the intellisense was working as expected. Thanks Ambrose.
-
Attribute member values in Visual Basic .NET
An important safety tip that I forgot last week. When you want to set the member values of an attribute using Visual Basic .NET, you need to use ":=". This forgotten item hounded me for a couple of hours last week as I would "forget" the syntax. In C#, the "=" sign is all that is needed.
-
SqlFunction attributes members DataAccess and SystemDataAccess
If you have looked into using the SqlFunction attribute, you may have seen that there are members DataAccess and SystemDataAccess. What's the difference in the two, afterall they sound so similar? The DataAccess member is for providing data access to user tables. The SystemDataAccess member is for providing data access to system tables. This info somes from a response to a question I posted in a sql clr newsgroup at Microsoft.
-
Spam
I have noticed this dramatic increase in the amount of spam that I have gotten over the last two weeks. It seemed really strange because I have very closely guarded my personal email address and my email address at my office. Yesterday, I went out and googled for my email address. Low and behold, my email address is posted on several pages online. How did my email get there and get this spam?
-
Google stock is really shooting up
http://www.usatoday.com/money/industries/technology/2004-10-25-google-usat_x.htm
-
Still hope for anti-spam initiative
-
Setting the Name of your CLR Function using the the Name member of the SqlFunction attribute
If you need to set the name of the function, you can do that by using the Name member of the SqlFunction attribute. I think this is very convenient for setting the name as oppossed to using the default name of the function name.
-
CLR Functions - SqlFunction attribute - DataAccess member
I have been reading through the documentation on the SqlFunction attribute. I came across an interesting item in the documenation that I wanted to pass on, being that I am a data access kind of guy.
-
Sql Server 2005 October CTP Upgrade
When I upgraded my installation of beta 2 of Sql Server 2005 to the October CTP bits, I repaved my system and started over. I had a copy of the database tables and was able to re-attach them. I have not seen any ill-effects of doing this.
-
Trying to find October Visual Studio and Sql Server CTP bits on MSDN?
If you logon to MSDN as a subscriber and look under neath the VS.NET section, they aren't there. Go to the Sql Server section. You will find them under Sql Server 2005. Both Sql Server and VS.NET bits are there.
-
Silicon Image driver for 3x12 SATA RAID
Need a driver for your motherboard based Silicon Image 3x12 SATA Raid driver? Need one for Win64 on x64? Here is where you will find it.
-
I promised I wouldn't say anything political, but I can't help myself
Did you see or hear about Jon Stewart on Crossfire. Finally someone that talks about the truth in politics. Check out Jon Stewart's followup at the end.
-
Do what I say, not what I do with CLR Triggers
Yesterday, I blogged and posted some code regarding CLR Triggers. One thing to be careful of is the use of the SqlPipe object. I am using it for debugging purposes. Don't put a bunch of SqlPipe outputs to your application in your CLR objects. You may break things inadvertently. I should have commented in my code that the SqlPipe statements were for debugging purposes only. Typically, for objects that don't have a user interface, I like to write to the event log, but I found the SqlPipe to be so easy and gave me immediate output that I used it. I don't think I would do this in a production application.
-
Copy a database with Sql Server 2005
With Sql Server 2005, you no longer use the DTS wizard to move objects from one Sql Server database to another. Go into the Sql Server Management Studio, select "Copy Database", and then follow the instructions.
-
DEMONS BE GONE
http://sports.espn.go.com/mlb/playoffs2004/columns/story?columnist=caple_jim&id=1906307
-
CLR Triggers and Objects
I spent today floundering through the the EventData and ColumnsUpdated properties in the SqlTriggerContext of Sql Server 2005 aka. Yukon. I asked a bunch of questions to a bunch of people. Thanks to some various response to my posts in some newsgroups, I was able to understand and figure some things out. Some of the things I learned today.
-
SqlTrigger attribute
<SqlTrigger(Name:="trtblSearchResults", Target:="tblSearchResults", Event:="FOR INSERT, UPDATE")>
-
Enabling the CLR in the Sql Server 2005
If you want to run a CLR object in Sql Server 2005 (or SqlExpress), note that CLR is disabled by default on Sql Server 2005. You will need to enable the CLR. Here are the commands that I used to enable the CLR.
-
Having problems getting the betas of Whidbey uninstalled? Use msiinv.exe.
I have installed and uninstalled several sets of bits with .NET. One thing that I have found INFINITELY valuable is the utility called msiinv.exe. This utility queries the registry for information about installed packages. It seems to be a little more accurate than the the windows control panel. Great, where do you find this utility? Googling doesn't help much. I posted it up in the newsgroup microsoft.private.sqlserver2005.setup (don't worry, its actually a publically available newsgroup). I put it under the post about "Error re-installing SqlServer Express" to assist in problems that this person was having.
-
DTS in the October Sql Server CTP bits
I had some problems with the beta 2 DTS wizard in Sql Server 2005. I continually got an error on starting it and it would merely exit without running. With the October CTP update, I have been unable to repeat the error. I have moved some small data around. I am looking forward to trying more with these bits.
-
Updated info on the ASP.NET Canonicalization bug as of 10-14-2004
Information on the ASP.NET ValidatePath Module Scanner is available in Microsoft Knowledge Base article 887290, which is available here:
-
October CTP release of Sql Server 2005 Installation issues and resolution
-
SqlClient chapter done - Sql Server chapter now
I emailed to my publisher earlier today the SqlClient V2 chapter. Now, I am going to be starting on the Sql Server 2005 specific chapter. I was up late last night and I worked on it for about an hour this morning before sending. My 30 goal pages ended at 37, which I figure is just fine. My goal for the Sql Server 2005 chapter is 50 pages. I have two months to get this one done.
-
Skype - get it!
I read about Skype a couple of weeks ago. I read about Skype again yesterday in the USAToday. I downloaded today. I have talked to Chris Frazier in Houston, Robert Johnson in London, and J. Ambrose Little in Tampa, Fl. It is almost crystal clear. The only problem I had was getting the drivers hooked up to my USB headphones. Get it and make person-2-person calls over your computers.
-
Introducing my author group
I wanted to take a moment to introduce my author group for our book. The tenetative title for the book is "Professional Programming with ADO.NET Version 2." My fellow co-authors are
-
Finishing up the System.Data.SqlClient chapter
As some of you know, I am working on a book on ADO.NET in Whidbey. I am just about finished with the System.Data.SqlClient chapter. I am pretty excited about this because getting me to write is......shall we say an adventure. As I like to say, "Just because I can read and speak English doesn't mean I can write it."
-
Canonicalization security bug in ASP.NET
As many people know, there has been a lot of talk about a security bug in ASP.NET running on Windows 2000. Microsoft has just announced information regarding this bug. Here are some urls that I suggest you look into.
-
See Mt. St. Helens erupt right before your very eyes
The Volcano Cam is online at http://www.fs.fed.us/gpnf/volcanocams/msh/
-
Non-Technical - Fantasy Sports Foulup
I'm new to this fantasy sports football thing. I have decided to let the sportsline system do some automatic player selection. I've been letting it select Daunte Culpepper as my quarterback so far this season. Only one problem, Culpepper doesn't play this week! DOOOHHHH! My number 2 quarterback is Rich Gannon, who has a fractured bone in his neck. DOOOOHHHHH! Jeff Garcia of Cleveland is my number 3. Great, except that the computer selected Culpepper to be my quarterback this week. AAACCCCKKKKKK The results aren't final, but I can just about guarantee that I'm a loser this weekend.............
-
Non Technical - One negative effect of physical fitness
Yesterday, I went to buy a new suit, the first in something like ten years. I was measured for a jacket first. The guy looked at me and basically said "I will be hard to find something for you in the off the rack area." The problem is that my waist is much smaller than a "standard" size person with my jacket size, even for the "athletic fit" sizes. Well after a lot of discussion, I ended up with a jacket size of 46-48 and a pant size in the waist of 34-35.
-
SqlCacheDependency in ASP.NET Whidbey
If you have been playing with the SqlCacheDependency in ASP.NET Whidbey, you know that the MSDN docs are not quite complete and still contain the PDC information from last year. Here is what the web.config should look like. I would like to thank Rob Howard and ScottW for setting me straight on this. The IDE suggests that there is a problem with the XML used, but the ASP.NET application does work. With the web.config entries from the MSDN docs, the application will not start and complains about an error in the web.config configuration. I hope that this helps if you have been struggling with trying to get SqlCacheDependency working. Note that this example is what is used for a Sql 7 or Sql 2000 database using a ASP.NET Whidbey front end.
-
Congratulations to my friend Kent Tegels
http://sqljunkies.com/WebLog/ktegels/archive/2004/10/01/4420.aspx