(Danny Lesandrini) Years ago, I created an Add-In for Microsoft Access that was a toolbox of sorts, and I called it the DataFast Utility. It’s still available for download, but never was anything more than a crude collection of scripts that I found personally useful. According to my records, it’s be
Other News
PHP’s Building Blocks: Data Types, Literals, Variables, and Constants
(Ellie Quigley and Marko Gargenta) A program can do many things, including perform calculations, sort names, prepare phone lists, display images, play chess, ad infinitum. To do anything, however, the program works with the data that is given to it. Data types specify what kind of data, such as numb
How To Use Lazy Initialization with VB.NET and Visual Basic 2005
(Mike McIntyre) This is part one of a two part article and source code which explains the lazy initialization pattern and how to implement it in an order entry scenario with VB.NET and Visual Basic 2005. In object-oriented programming (OOP), lazy initialization is the strategy of improving applicati
Improving ASP.NET Application Performance and Scalability
(Joydip Kanjilal) Many factors influence application performance, but in essence, the most important is to be aware of how to optimize your applications so they consume the least amount of memory and require the least amount of processing to produce the desired output in a managed environment.
Sizing Up Performance
(Mike Hichwa) As Oracle Application Express becomes more popular, many users are asking for guidance on sizing and performance tuning. In this column, I’ll show you a quick and convenient way to estimate performance and sizing. I’ll also demonstrate how to identify and deal with performance issues.
Oracle quietly releases E-Business Suite 12
(Nancy Gohring) Oracle Corp. has quietly released E-Business Suite Release 12 to customers a few days in advance of a big launch event planned for next week in New York City.
DB2 Security—The Starting Point
(Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong and Yuk-Kuen Henry Chan) When thinking about organizational information security, your mind might jump to the technical details such as firewalls, access control lists, certificates, auditing, encryption, and all those well-known electronic tra
MySQL GROUP BY and DISTINCT Oddity
(Alex Gorbachev) At the end of my last MySQL post I mentioned strange behavior with GROUP BY and DISTINCT. In Oracle such constructions are not valid and produce an error.
Extracting Master-Detail data from an XMLType with a single SQL statement
(Alex Nuijten) Probably this is old news for all of you who have lots of experience with XMLDB, but for me this is something new. In order for me to remember this sort of stuff, I need to write it down (I am getting older, you know) hence this blog. What I needed was a way to extract the data […]
Part 2: Developing an object oriented database in less than 140 lines of C#
(Zach Smith) In Part 1 [link to part 1] of this series we explored how an object oriented database (OODB) could be implemented using built in .NET Framework functionality. The basic database is setup using XML as a storage format, XPath and Predicates as query languages, and the XmlDocument object a