(Rudy Limeback) How to find the cumulative sum without using an analytical function? (R)
Author: SSWUG Research
Improving Productivity and Code Quality Doesn’t Have to Break the Bank
(Shari L. Gould) While increasing productivity and efficiency in the editor is important, developers now have a choice to also add an extensive set of user interface controls and frameworks at a remarkable price point that seems to be striking a resonant chord with the Visual Studio .NET community.
XSD Tutorial: XML Schemas For Beginners
(Simon Sprott) First, look at what an XML schema is. A schema formally describes what a given XML document contains, in the same way a database schema describes the data that can be contained in a database (table structure, data types). An XML schema describes the coarse shape of the XML document, w
Code Access Security in .NET 2.0
(Uday Denduluri) Code access security is a concept of .NET Framework that restricts the execution privileges of the code on the resources and its operations. Usually administrators configure security policy of the code. This is done by sets of permissions with groups of code called as Code Groups. I
What’s new in IDS Cheetah (IDS 11)?
(Mohan Saraswatipura, Radhika Gadde and Priyambada Behera) IBM Informix Dynamic Server (IDS) is a fast and scalable database server that manages traditional relational, object-relational, and web-based databases. IDS supports alphanumeric and rich data, such as graphics, multimedia, geospatial, HTML
LOB Enhancements [DB2 9 for z/OS]
(Craig Mullins) IBM focused their attention on improving DB2’s ability to store and manage LOB data in Version 9. As anyone who has tried to use LOBs in a previous version of DB2 knows, the usability limitations were troublesome. But with Version 9, IBM chips away at some of the more annoying LOB li
IDUG… but you may want to as well
(Fred Sobotka) Yeah, I know…IDUG wrapped up its 2007 conference a while ago, but I took a bit of a vacation afterward, so I’m just starting to dig myself out of the pile of notes, business cards, and action items that I maneuvered my self into back in San Jose. I’m sharing my observations so those
ASP.NET Futures Release Showcases New Controls, Capabilities
(Chris Kanaracus) Microsoft announced ASP.NET Futures in May of 2007, a collection that includes early versions of new tools for ASP.NET and the Silverlight cross-platform browser plug-in.
RESTful Web Services
(Jon Udell) RESTful Web Services, by Leonard Richardson and Sam Ruby, was published this month. I interviewed the authors yesterday for an upcoming ITConversations show, but I also want to spell out here why I think it’s such an important book.
Debunking GROUP BY myths
(Roland Bouman) There is a popular myth about the SQL GROUP BY clause. The myth holds that ‘standard SQL’ requires columns referenced in the SELECT list of a query to also appear in the GROUP BY clause, unless these columns appear exclusively in an aggregated expression. MySQL is often accused of vi