Archives
-
Why you should do database stuff in the database.
Today, I had a need to programmatically update data in one database from another database. I wrote a quick .NET app to pull the data out of one table, process the data, and put it into another table in another database table. I just went to write a quick utility because I was running in two databases. I didn't check the amount of data, but I saw that this was really slow. As the data ran through the triggers, it was way to slow. it was taking about 2 seconds for each record. It would have resulted in approximately 2 days of processing. Well, that was not acceptable. I pulled up my SQL Server Books Online and grabbed a couple of TSql commands. The resulting TSql command took 16 seconds to run. Moral of the story, if you can do it in the database, you should probably do it in the database.
-
Plagarizing Jason Salas's podcast
Ok, you have got to go listen to Jason's podcast at http://weblogs.asp.net/jasonsalas. A new word was invented. Podderize - the using of audio from someone else's podcast without their permission.
-
ASP.NET Podcast Show #4 - Paul Glavich and Mitch Denny
Download at: http://aspnetpodcast.com/CS11/blogs/asp.net_podcast/archive/2005/11/09/asp-net-podcast-show-4.aspx
-
Need your help - Market analysis of Atlas and Ajax
Hi folks. I need your help. I need to do get some market information about Ajax and Atlas. I have found the MSDN product feedback code at http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=9c2b3819-4ab0-4435-8ece-f25118056278. What's happening with customers and developers trying to do ajax? Any information that you can provide about ajax in the marketplace is greatly appreciated.
-
AMD sues Intel
http://www.amd.com/us-en/Weblets/0,,7832_12670_12684,00.html?redir=CORBF02
-
Bob's in
Congratulations to Bob Beauchemin of Developmentor. Bob was last week's "Database Geek of the Week" at http://www.simple-talk.com/2005/06/21/database-geek-of-the-week-bob-beauchemin/
-
Microsoft talks AJAX
http://news.com.com/Microsoft+gets+hip+to+AJAX/2100-1007_3-5765197.html?tag=nefd.top
-
U Gotta Love Spam about Spam
----- ---- --- -- - - -
-
My Crystal Turns Darker Today
Yeah, its my birthday again. I'm 38.....................
-
MARS is off by default - I feel dumb
Ok, how dumb was this. I misread my own code. I was explicitly turning MARS on and off while doing the performance test. I thought I was only turning this off. I feel so stupid.
-
Ok, so maybe Dell isn't so bad
Ok, so you might remember my horrific rant about dell last year. I had had a REALLY BAD experience with their support. Well, maybe dell isn't so bad. I dropped my inspiron laptop on Monday off my desk. It fell on to very thin carpet which merely covered concrete. It landed on a corner. The screen got knocked around. The spring that holds an item in one of the bays was broken. My laptop ran out of its 3 year warranty about a month ago. We put the screen back straight. I had to have a new spring for the bays ordered. Thats it. The guys that helped were shocked that the laptop was still in one piece. Maybe dell isn't so bad after all............
-
The Inventor of the Integrated Circuit - Jack Kilby dies at age 81
-
Block Windows 2003 SP1 update
-
Ajax for .NET
Here is the url: http://ajax.schwarz-interactive.de/csharpsample/default.aspx
-
Stats and Referrers
Is there any way that I can get a list of the Stats and Referrers for my weblog? I get a Sql Timeout when I try and get a list of the Referrers? BTW, not complaining, just curious if there is some offline way that I might be able to use to get the list.
-
My Technical Editing is Complete
I just got done completing the Technical Editing portion of my chapters for our ADO.NET V2 book with the June CTP of Sql Server 2005 and the April CTP of Visual Studio 2005. I didn't find anything that was a big deal beyond the SQL CLR changes that were announced back in December, 2004. Besides making the necessary changes to my webforms pages, pretty much everything worked that I had already written. Too bad I can not say the same regarding my creative use of the English language.
-
Server Enumerator with Sql Server 2005
If you want to get the Server Enumeration working properly with Sql Server 2005, you will need to start the Sql Server Browser service on that machine. Otherwise, you don't get information back, such as the version number and other good pieces of information.
-
MARS should be turned off in your Connection String with Sql Server 2005
I've been doing a small amount of testing with the June CTP of Sql Server 2005 and ADO.NET V2. MARS is turned on by default in a SqlConnection. I would suggest turning MARS off, unless you need it. I am seeing a performance difference between having MARS turned on and off, just on regular ADO.NET commands.
-
Warning: June CTP of Visual Studio 2005 is not compatible with the June CTP of Sql Server 2005
From the MSDN Download Section:
-
40 million credit cards affected by Mastercard Security Breach
-
Documentation in the June CTP for Sql Server 2005
I just wanted to note that the documentation for the June CTP of Sql Server 2005 is greatly improved over the older books online for pre-April CTPs of Sql Server 2005. I am going through the technical editing process, and this documentation is a great improvement.
-
Blogs in the work place style article from the USAToday June 15, 2005
http://www.usatoday.com/money/workplace/2005-06-14-worker-blogs-usat_x.htm
-
ADO.NET talk in Hunstville, AL on 6/14
I'm doing my ADO.NET Whidbey/Yukon talk in Huntsville, AL tonight at the local user group there. Come out and listen to my talk.
-
How we got here - The ASP.NET Podcast from Wally McClure's standpoint.
I was listening to Jason's Digital Pontification last night, and it kinda got me thinking that it might be confusing for folks as what we are, so I thought I would throw out my personal timeline as to how we got here as far as I know it.
-
ASP.NET Podcast for June 11, 2005 - People of the .NET Community including the full interview with Scott Guthrie.
Original url: http://aspnetpodcast.com/CS11/blogs/asp.net_podcast/archive/2005/11/08/asp-net-podcast-show-3.aspx
-
Installing the June CTP of Sql Server 2005 with Beta 2 of Visual Studio .NET 2005
I have installed the June CTP of Sql Server 2005 onto my 32 bit laptop and to my x64 desktop system. To install the June CTP, I completed the following steps:
-
Oracle Tools for .Net Support forum - FYI
If you are a user of the Oracle Tools for .NET, check out the OTN Support forum at http://forums.oracle.com/forums/forum.jsp?forum=228
-
Windows Longhorn Site
-
Starting a new category - Business of Technology Consulting
I am starting a new category for my blog. It will be on the Business of Technology Consulting. It will basically contain a set of posts regarding my insight into the business of technology consulting and software development. It will contain funny stories and my whining on some things. I'll try and not include posts from this category in the main feed or page, so please put this category in your RSS reader.
-
Welcome to the club!
I would like to welcome Rebecca Riordan to the database geek of the week club. She joins DonXML Demsak, some dude named Wally, Hilary Cotter (wow, I'm a big fan of him), Euan Garden (Microsoft PM in the Sql Server area and a heck of a nice guy), Ken Henderson, Jim Kyle, and Terri Morton.
-
There are people problems everywhere
It seems that Gretchen is talking about some of the people problems at Microsoft. This got picked up by News.com. Its funny, but I think that this can be summed up in two thoughts:
-
Music Midtown in Atlanta
-
News.com story on IIS7 as Microsoft targets hosting market
http://news.com.com/Microsoft+targets+Apache+Web+server/2100-1010_3-5735805.html
-
News.com story on Apple's Rosetta software
http://news.com.com/The+brains+behind+Apples+Rosetta+Transitive/2100-1016_3-5736190.html?tag=st.prev
-
Sql Server 2005 June CTP Reports
-
Sql Server June CTP is publically available..........well sorta
According to the press release at http://www.microsoft.com/presspass/press/2005/jun05/TechEd2005Day2PR.mspx, the Sql Server 2005 June CTP is publically available at http://www.microsoft.com/sql/downloads/. Unfortunately, as of 10:40 am US - Eastern Time (GMT - 5, I think), the link generates a 404 error. I'm sure it will be fixed, but ack....................
Update: as of 12:10 pm, I can see the files on betaplace. Happy days are here again. :-)
-
Its pretty cold in you know where.....................Apple announces switch to Intel CPUs
-
XML feed for my Scalability with .NET Podcast
http://www.scalabledevelopment.com/ftp/scalabilitywithdotnet.xml
-
News.com reports that Apple will announce a CPU change on Monday
-
Installing Oracle DB and Tools
One of the interesting install problems that I have noted about installing Oracle's database and tools, such as OTN, is that the setup.exe program doesn't seem to do anything. I have found that you typically have to go into the install directory and run the setup program there for anything good to happen.
-
TechEd might not be worth it for me
I've got to say that I agree with Sahil Malik on this one, but I'm going to chime in with a few extra cents.
-
School Board makes land choice - Not Technical
Sorry, but I just can get away without mentioning the location choice of the new high school in West Knoxville. It will be adjacent/nearby to the existing elementary school in Hardin Valley.
-
Oracle Tools for .NET Ship!!!!!!!!!!!