(Christian Bilien) I recently had to sit down and think about how I would spread workloads across nodes in a data warehouse configuration. The challenge was quite interesting, here were the specifications:
Other News
Debugging Script: Dumping out current and recent ASP.NET Requests
(Tess Fernandez) When you debug asp.net applications it is often useful to find out which requests are currently executing, how long they have been executing, what the querystring was etc. Since getting this information from a dump can be a long and tedious process even if you know what you are doin
Making Database Administration Easier with Freeware
(Steve Callan) Depending on your environment, working with and between Windows and UNIX can be somewhat problematic. It seems that no two workplaces are the same when it comes to the network file system. Two of the more commonly seen problems include not being able to get a GUI tool (e.g., Oracle Un
InnoDB Deadlock – Next Key Locking
(Parvesh Garg) So you use InnoDB, have indexes on your table, think of row level locking and concurrent queries, feel good and go to sleep. All this while forgetting that even UPDATE and SELECT …. FOR UPDATE statements will (or may) also use the same index for scanning or updating. Then what? You
Manipulate XML service definitions with Java programming
(Stephen B Morris) A Service-Oriented Architecture (SOA) typically exports a range of services. For XML service modelling and subsequent consumption of those services by users (people, machines, or other services), Java technology provides powerful mechanisms to handle XML data, which in turn provid
Bluetooth Programming using Python
(A.P.Rajshekhar) Bluetooth is a way to connect devices wirelessly. This technology has a variety of uses. Python is an easy to learn scripting language that has been growing in popularity. The two can work well together, as will be explained in this article.
Beef up SOA with real-time data integration
(Deng Peng Zhou) Service-Oriented Architecture (SOA) is a popular method for designing enterprise applications, because it provides benefits like reusable components and platform-independent communication. When considering an SOA, it’s essential to factor in data integration. A great deal of legacy
It All Adds Up
(Tom Moreau) A while ago I responded to a newsgroup post in which the poster had a table of inventory changes containing start and end dates, as well as the amount that was added. The poster wanted to be able to determine the inventory in stock at any given date. I gave him a solution but I got to t
The Problem: How to load SQL Profiler trace (.trc) files into a table?
(Andrew Novick) Server traces can produce a large amount of trace data that is stored in multiple trace (.trc) files. They can be loaded into a table by going through SQL Profiler (2005 or 2000) but that’s a cumbersome manual process. It would be great if all the trace files from a profiler run co
4 Tips for Stopping SQL Injection Attacks
(Frank J. Ohlhorst) One of the best ways to provide security is to understand the weaknesses prevalent in today’s Web-connected systems. Regrettably, ignorance has become the rule when it comes to securing these systems, whether it’s ignorance on the part of the security professional who just deploy