(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
Author: SSWUG Research
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 […]
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.
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
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.
ASP.NET Tip: ASP.NET 2.0 Introduces FileUpload Control
(Eric Smith) One of the things that always baffles me about ASP.NET is why some HTML controls (such as text boxes and images) have ASP.NET equivalents and others (such as the file upload control) don’t. ASP.NET 2.0 rectifies this situation with the new FileUpload control, which is designed to replac
32 bit tools on a x64 server
(Louis Davidson) Ok, I readily admit I don’t know everything about SQL Server. But today I learned something that I would have thought I would have seen somewhere. I was having issues getting an SSIS package to build some offline cubes (on my 32 bit workstation, and tested initially on a 32 bit se
Rule-based vs. cost-based optimization
(Brian Peasland) Please tell me the difference between rule-based and cost-based optimization of SQL queries, in detail. Thank you. (R)
TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
(Peter Zaitsev) We all know disk based temporary tables are bad and you should try to have implicit temporary tables created in memory where possible, do to it you should increase tmp_table_size to appropriate value and avoid using blob/text columns which force table creation on the disk because MEM
Using the developerWorks XML validation tools
(Ian Shields) If you can’t find a validating XML editor you like, or prefer not to take the time now to learn how to use one, you can edit the XML for your developerWorks articles and tutorials using your preferred text editor. The author has created some great tools to help you validate, transform,