-
-
This is a rewrite of a post to microsoft.public.dotnet.framework.adonet.
I'm having a discussion with my team leader concerning the use of
SqlTransactions.
We work on an ASP.Net 1.1 website. Up until now we've been using
ADO.Net SqlTransactions in our business logic layer to combine several data access layer method calls into one coherent, atomic action.
I am in favor of this approach as it supports isolating the business logic from the database and provides for greater code readability.
My team leader diagrees - he thinks that we need to get rid of all ADO.Net SqlTransactions and instead guarantee atomicity by combining data operations inside stored procedures with transactions.
The reasons why he says SqlTransactions are bad are:
1. If one of the running threads in the IIS just dies all of a sudden, it would leave a transaction open and stuck, putting strain on the DB and risking deadlocks.
2. The DBA won't be able to properly debug the SQL Server whenever deadlocks and critical loads are encountered. Because transactions are opened from a place outside of the DBA's scope he will have no way of
knowing how or why certain statements and stored procedures might be executing together or locking each other.
Would you agree with my team lead? Do reason 1 and/or reason 2 justify moving some of our business logic into our DB? If not, does anyone have contradictory examples or links?
I'm calling on whoever is reading this to share their knowledge as I find that I do not know ADO.Net SqlTransaction well enough at this time.
-
-
I'm not 100% sure but it seems Microsoft has silently (?) launched IIS version 7.0. This is said to be a part of Windows Vista. Oddly enough I've not seen any launch announcement from MS. Maybe I just missed it?
The new version of IIS is said to implement a lesson from the Apache Web Server - modularity. Functionality previously embedded in older version of IIS has been relocated to modules that can optionally be installed alongside a core IIS server. This would allow for better security as administrators can minimize the surface of the server by including only necessary modules.
Another feature worth mentioning is that the metabase (IIS' registry like configuration settings store) has been dropped in favor of an XML based configuration. Compatability with the older IIS6.0 metabase is served by a Metabase Compatibility component that enables old scripts to work against older metabase APIs.
Via alikl's blog
-
-
I've just finished installing MediaWiki 1.8.2 (the same wiki engine that powers Wikipedia) on my machine at work. MediaWiki requires three things to be present on the machine prior to installing: A web server, A database server and the PHP engine.
In my case that meant that I had to install Apache Http Server 2.2.3, MySQL 5.0.27 Community Server and PHP 5.2.0 - all from scratch.
The point of this post is that I was surprised at how easy it was to obtain and install these 4 (counting MediaWiki) pieces of server software. With the exception of MediaWiki, I was able to download and install within minutes. The setup programs are robust, user-friendly and most importantly - almost intuitive.
The one exception was MediaWiki which required me to read through its online installation guide and tackle one undocumented issue during the process (It requires MySQL to run with Strict Mode set to off - I'll post about that in the near future).
It is almost amazing to me how open source software could come this far in providing a free, easy to use alternative to commercial software. The power to all the people developing these wonderful tools of our trade!
-
-
Finally (!) Microsoft strikes back against Apple's hilariously funny "I'm a Mac. I'm a PC." commercials.
It's not really a public commercial - more of an internal lampoon - and it's certainly not as sharp as some of the original Apple ads, but it goes to show that at least some people in MS are indeed in touch with reality and care to respond to the hammering they're getting on the web.
Sony also jumped into the arena with a small flash banner that you can see on their Sony Australia website. Considering the amount of evil that company is doing with its DRM rootkits, that hip cute girl you see there is one mean ***…! :P
Via Tim Hibbard's blog and engadget.
-
-
… doesn't mean they're not out to get you.
Did you know that the FBI can spy on you by remotely activating your cellphone's microphone to listen in on conversations around you? What's more, this has been affirmed by a U.S. District Judge!
How scary is that? Is it constitutional? And how can this even be technically possible? Yikes!
Via Monkey Bites' Morning Reboot for Dec 4, 2006