(Antony Reynolds) Last week I had a question from a consultant about how to efficiently process a large number of records in a file within BPEL. He needed to take a large file and insert all the records in it into a database. Lets look at the challenges and gotchas along the way.
Author: SSWUG Research
Rows to single string or aggregating strings
(Pawe³ Barut) In oracle there is no build-in group function that will concatenate strings, just like max summarizes all numbers. But there is quite easy way to do that in pure SQL. Assume we want to have get as an query result list of tables and column. But we want all columns to be concatenated and
‘GET’ing a BLOB from the database with the BLOB Streaming Engine
(Paul McCullagh) Current plans call for the use of the HTTP protocol to upload and retrieve BLOBs to and from the database. The BLOB Streaming Engine makes this possible by integrating a lightweight HTTP server directly into the MySQL server.
ObjectDataSource in ASP.NET 2.0
(Kuldeep Deokule) A new data bound control integrated in ASP.NET version 2.0 allows for a 3-layer architecture. Using ObjectDataSource control, you can separate the presentation layer, business layer and database layer. Presentation layer contains the web page (UI) while the business layer incorpora
Project Management Requirements Unique to Data Warehousing
(Alan Schlukbier) Recently, several project managers approached me about some common misconceptions about data warehousing. Knowing that I had worked for over 15 years as a consultant and completed over 100 data warehouse contracts, they urged me to publicize what is unique to data warehouse project
Convert XML to JSON in PHP
(Senthil Nathan, Edward J Pring and John Morar) With the growing popularity of Web 2.0, a new data interchange format called JavaScript Object Notation (JSON) is emerging as a useful way to represent data in the business logic running on browsers. Learn how PHP-based server programs can convert XML-
ASP.NET Complete Life Cycle
(Srinivas Jadhav) Since too many resources are shared on the process level (i.e. IIS, inetinfo.exe) and it is too easy for an error to bring down the entire server process, ASP.NET provides an out-of-process execution model, which protects the server process from user code.
Security and Compliance: Bringing Order to Information Chaos
(Mark Leon) Governing data is a little like governing people. Left to themselves, people will devolve into a “state of nature” in which civilization as we know it cannot exist.
Personalizing RSS Feeds with ASP.NET 2.0
(Erich Peterson) Really Simple Syndication (RSS) is a common XML standard for syndaicating web content. It is typically used by content-producing sites to offer a machine-readable version of the latest headlines. For example, news sites like CNN.com and MSNBC.com offer RSS feeds for breaking news; m
How To Protect Yourself From Fat-Finger Sally, Crazy Bosses and Other SQL Villains
(Denis Gobo) You all have been through this at least once in your life. In your shop there is this one person who likes to use Enterprise Manager as their Rapid Data Entry Application. We all know how these people operate; they delete rows, drop tables and all kinds of other funky stuff. SQL Server