(David Catherman) The Dataset Editor in Visual Studio 2005/8 assists in the design of a data entity structure and generates a set of classes that meets the requirements of a good object relation mapper (ORM). This article shows the code that needs to be added to provide tier separation and how it ca
Other News
Convert HTML tables to a DataSet
(Mark Smith) I recently needed to do some “screen scraping” from a locally installed 3rd party web application and then do some data manipulation based on the results. The application in question wrote the results out to the page inside tags and there were several of these tables on the page
Fall In Love with Visual Basic All Over Again in Visual Studio 2008
(Michael S. Jones) You undoubtedly know by now that Visual Studio 2008 was released to manufacturing in November, just in time for Christmas. It comes wrapped up with a new version of Visual Basic, which includes (among others) these great new features:
An addendum to Monday’s History 101 post on DB2 V1.2
(Willie Favero) In our discussion of DB2 Version 1 Release 2 on Monday, I forgot to mention a significant change in V1R2 that most would have probably never noticed. It was one of those changes you got and had no control over but has improved your DB2 life ever since. It was a little thing called Pl
Converting XML Schemas to Schematron (#11): Partial order validation for following sibling elements
(Rick Jelliffe) This article is part of a series describing how to convert from W3C XML Schemas to ISO Schematron. They are very different schema languages! This time we look at some code with quite complex XPaths: we want to validate that the element that follows another element in a document is on
How MySQL Query Cache works with Transactions
(Peter Zaitsev) As MySQL Manual Says Query Cache works with transactions with Innodb tables but it does not tell you how and with which restrictions.
Mimicking Production Database
(Radhesh Kumar) If you are a DB2 DBA, most likely you have already used db2look to extract the DDL from a DB2 database. However, db2look can do more than just extracting the DDL. Sometimes you may want to create a test database similar to production database in order to test your applications and qu
SQL Server 2008: FILESTREAM
(Paul S. Randal) During this week I’ve been playing with FILESTREAM for some demos I’m writing for a Microsoft class I’ll be teaching when I get back to Redmond. The class is about SQL Server 2008 for DBAs and the attendees will be a bunch of Microsoft Field personnel and SQL Server MVPs. Anyway, as
Dimensional Model Components: Dimensions Part I
(William Pearson) The general consensus within current data warehousing and business intelligence communities is that the preferred structure for presenting quantitative and other organizational data to information consumers lies within the dimensional model. The dimensional model has consistently b
Oracle BI EE 10.1.3.3/2 – Dynamic Report Columns using Dashboard Prompts and Presentation Variables – Part 2
(Venkatakrishnan J) If you had gone through my previous blog entry here, you would be knowing how to go about dynamically varying the columns in a report. But one drawback that i mentioned there was, one had to manually enter the column names and any wrong entry would give out an error. Now lets loo