On Being a Database Facilitator Chris Shaw wrote in with thoughts on the posting Monday about being a Database Facilitator – "30 years ago we were just afforded the technology to watch a movie at home. If I wanted to see Star Wars more than once, my only option was to return to the theaters. 15 years ago if I […]
Other News
Improve your taxonomy management using the W3C SKOS standard
Until recently, tools for managing controlled vocabularies, taxonomies, and thesauri all stored their data using proprietary formats that made the data difficult to integrate with external systems. The W3C SKOS standard defines a portable, flexible controlled vocabulary format that is increasingly p
Incorporating XML into your Database Objects
(Robert Sheldon) XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check constraints, computed columns and defaults. Views and table-valued functions can be used to provide a tabular view of XML data that can be used in SQL Expressions.
XPath expression for XQuery may cause high subtree cost
(Jan Novak) There are a few ways how to write Xpath expression. Not every expression may return expected data. Here is a review and Subtree cost in execution plan (SQL Server 2008 R2, 64bit) for each tested method. Xml contains 100 nodes, some of them are empty:
Building A Razor Web Pages Site With Database First And Entity Framework
(Mike Brind) Since I published an item covering Code First development with Entity Framework and WebMatrix, I have had a few requests to provide a guide to working with the Entity Framework from a database first point of view. This post answers those requests and provides a step by step guide to get
Book Review: Dependency Injection in .NET
(Tad Anderson) Ugh. Sometimes my ability to be a complete ignoramus really annoys me. When I first saw this book on the upcoming list of books to be published I thought, “That sucks, I just got done reading Dependency Injection by Dhanji R. Prasanna last year. I don’t need to read the .NET version”,
The Format() Function in SQL Server 2012
(Ananthakumar Muthusamy) Folks with a programming background use some kind of function or module to format the output of dates, numbers or text. The only formatting capabilities that SQL Server has had until now was the CAST and CONVERT function. Some programmers write user defined functions for da
Business Validation in Oracle SOA Suite 11g using Schematron
(Emiel Paasschens) In a previous post I’ve explained the Schematron standard, how it works and how to use it. In the Oracle SOA Suite you can ‘Validate Semantic’ on the input (request) of a routing rule in a Mediator component by selecting a Schematron file. This is the Schemtron xml file in which y
Building Executable Scripts For The Mac OSX Command Line
(Ben Nadel) I’m relatively new to the Mac OSX operating system. And, as far as getting around on the command-line, I’m even more of a novice. I can’t remember where I saw this, but recently, I saw a fellow programmer execute a set of command-line scripts from a file.
Microsoft SQL Server 2012: Choosing the Correct Edition
(Mike Chapple) Microsoft’s 2012 release of the SQL Server 2012 enterprise database management platform marks a major evolution in this popular product. The new release includes major feature enhancements to SQL Server’s business intelligence, auditing and disaster recovery functionality, among other