(Michael McLaughlin) While preparing for next week’s classes, I ran across a new future feature of MySQL – the virtual column. It appears, according to the article, that MySQL will have virtual columns in MySQL 6.
Other News
Arrays in C#
(Mayur Gujrathi) Arrays are a set of similarly typed values stored sequentially either as a single dimension, two dimensions or jagged.
Different Options for Query Results in SQL Server Management Studio
(Ashish Kumar Mehta) While looking through the new features and improvements in SQL Server Management Studio (SSMS), we found several options for displaying query results. In this tip we cover what options are available in SSMS and how they can assist you when dealing with query results.
Data Normalization Again!
Data Normalization Again! I find it interesting that so many have written regarding the editorial yesterday. What I find most interesting is the respect shown by everyone to differing opinions. This is definitely an area that has a huge impact on many individuals, and I have seen discussion become personl to the point of a complete communication breakdown. My thanks […]
The Stealthy Ascendancy of JSON
(Lori MacVittie) It looks like the debate between XML and JSON may be coming to a close with JSON poised to take the title of preferred format for web applications.
How to Query an XSD
XML Schema Definition (XSD) is developed by the World Wide Web Consortium for creating XML Schemas, which are a set of rules to be followed by any valid Extensible Markup Language (XML) data.
New XPath functions to get a control’s current label, help, hint, or alert
(Erik Bruchez) In XForms 1.1, a control’s label, help, hint, or alert (or LHHA as we call them at Orbeon) can read its value from data, in particular using the ref attribute. But the converse is not possible: for example if a control has a given label, you cannot figure out the value of that label f
Semi-Advanced Logging Options for SQL Server Agent Jobs
(Michael K. Campbell) Many DBAs and organizations rely fairly heavily upon SQL Server Agent Jobs to cover a variety of tasks and needs – everything from routine maintenance and error-checking on up to regular processing of complex business logic or comprehensive import/export operations.
Securing SQL Server data in the cloud: a few pointers
(Denny Cherry) Moving data into the cloud is a big talking point these days, and it’s no wonder. You can spin up a new SQL Server instance within Microsoft’s SQL Azure cloud database in just a few minutes and quickly begin loading data for a new transactional application or for reporting or other da
The DB2Night Show #Z02: DB2 Now and into the future
(klaas) In episode #Z02, special guest Jeff Josten, IBM Distinguished Engineer, is telling us about DB2 version 10 AND… version XI. While Roger Miller gave us a complete overview of the past, Jeff brings us back to here and now. After explaining all about DB2 10 in detail he also tells us what to