(Alexander Falk) While Open XML may not yet be an ISO standard, it is already standardized by ECMA and – even more important – all documents created by Office 2007 are already stored in Open XML by default, so there is an abundance of documents whose content you can now reuse much more easily and pr
Other News
Building a Simple Blog Engine with ASP.NET MVC and LINQ – Part 2
(Keyvan Nayyeri) In the first part of this article series about ASP.NET MVC Framework, I gave a short introduction to Model View Controller (MVC) pattern, ASP.NET MVC and the basic structure of the sample blogging engine that I am going to build in this article series and have named it KBlog.
Microsoft’s Lineup of SQL Server Related Webcasts for February 2008
Ten new webcasts are scheduled for February, covering such topics as “Security Enhancements in SQL Server 2008”, “SQL Server 2008 and Your Microsoft Certifications” and more.
Find All Tables With No Primary Key
(Sheeri Cabral) A friend asked for this, so I thought it’d be helpful:
Improvement of AUTO sampling statistics gathering feature in Oracle 11g
Optimizer statistics in Oracle are managed via a pl/sql package, dbms_stats. It provides several pl/sql procedures to gather statistics for a table, schema, or a database. For example, gather_table_statistics is used to gather statistics on a table. This procedure has an estimate_percent parameter,
Run The Same SQL Command Against All Databases
(Tim Ford) There are times when I find myself needing to run a SQL command against each database on one of my SQL Server instances. There is a handy undocumented stored procedure that allows you to do this without needing to set up a cursor against your sysdatabases table in the master database: sp_
SQL Server 2008 Delays and Reality of the Cycles
Featured Article(s) What To Do When you need to compare databases. Databases commonly, have their own tools with pre-made queries that make a comparison by making table crossing. However, sometimes the interfaces are not as comfortable as a spreadsheet software like MSExcel TM. With a couple of formulas and graphic help you could do a better job and your life […]
A Decade in the Making, XBRL Is Poised for Adoption
(Chris Smith) With the public’s attention focused so intently on the results of financial statements, particularly with what’s happening in the mortgage industry, few outside the accounting and IT industries are talking about the technology revolution occurring in the back office affecting how those
Converting XML Schemas to Schematron (#9): Friendlier schemas
(Rick Jelliffe) We can improve on the diagnostics given by the rules in the previous article in this series, Progressive validation for complex content models.
Receive events from XMLBeans
(Jacob D. Eisinger and Vince C. Brunssen) XMLBeans is a great XML-to-Java data-binding technology, but it lacks the ability to register observers for model changes. However, you can customize generated plain old Java objects (POJOs) to include the necessary interfaces and the notification of changes