(Jan Kneschke) I got a few comments about my last example not describing a wormhole, but a whitehole. Time to improve the picture a bit and getting data from another dimension on a shorter route than the long standard way.
Other News
Writing XML Data
(Jim Mischel) The XmlWriter output model is quite simple. For example, to write an element, you open the element by calling WriteStartElement, write any attributes or nested elements, and then close the element by calling WriteEndElement.
Performance Impact: Setting a Database to Read Only
(Linchi Shea) It is widely quoted that if a SQL Server database is set to Read Only (using ALTER DATABASE … SET READ_ONLY), your queries may run faster because no locking occurs in a read-only database. This all makes sense conceptually. But I have not seen any empirical data to get a feel for the
Simple parsing of space-separated attributes in XPath/XSLT
(Micah Dubinko) It’s a common need to parse space-separated attribute values from XPath/XSLT 1.0, usually @class or @rel. One common (but incorrect) technique is simple equality test, as in {@class=”vcard”}. This is wrong, since the value can still match and still have other literal values, like “fo
A reminder about Daylight Savings Time
(Willie Favero) This reminder, however, is about daylight savings time coming to an end. Remember all the noise last spring because daylight savings time was going to start a few weeks earlier this year. Well, hopefully you all also remembered that daylight savings time will end a week later starti
Implementing a Custom ConnectionString Installer for Setup
(Paul Kimmel) MSBuild is supposed to be powerful. However, its integration into Visual Studio does not seem intuitive. Sometimes, changing the simplest things—like the text that shows up on the opening screen of the install—seems to be challenging.
Hiding SQL in a Stored Procedure
(Lewis Cunningham) I recently wrote a blog entry (on my Postgres blog) about hiding SQL in a stored procedure, Hiding SQL in a Stored Procedure. I decided to see if I could convert that same concept to a MySQL stored procedure.
Using Oracle 11g Virtual Columns for implementation of Dynamic Business Rules
(Lucas Jellema) With the new 11g feature Virtual Columns, we can (almost) declaratively implement dynamic constraints, such as: –salaries can not be increased by more than 10% –employee records can only be updated during business hours (9-5, Mon trough Fri) –only a database user with the rol
Data compression techniques and trade offs
(Sunil Agarwal) Ok, now that we have sort of agreed that data compression is a good thing, you may wonder how SQL Server compresses the data, what does this compression mean to my data and to my workload?
A Really New Approach – But I Need Your Advice
I Need Your Help! Please – if you have a minute or two – we have a new concept we’d like to first explain to you, then get your feedback on. I need to know what you think of it, what you’d like to see, what type of experiences you’ve had, etc. I’ve created a short video explaining the idea, […]