(Kurt Cagle) Although XML Schema was intended to be used to provide a better validation and definition layer for XML than Document Type Definitions (DTDs), certain underlying concepts were translated unintentionally. One concept was the notion that attributes could be set to enumerations (lists), bu
Other News
Subtemplates in BI-publisher
(Bastiaan Vellinger) A very often heard question of customers is; “can we change the header/footer of our reports with this or that…?”. Of course we can change this, but it can be a timespending operation. If you have a couple of reports than it is not a problem to change each report manually, but m
ASP.NET Dynamic Data Websites – Creating Custom Dynamic Data Fields
(David Hayden) This is my 4th tutorial on the new ASP.NET Dynamic Data that ships with the ASP.NET 3.5 Extensions CTP. ASP.NET Dynamic Data is all about building database-driven web applications in a more productive and less monotonous manner, and that sounds good to me 🙂
Working with Dynamic Populate Extender
(Nidal Arabi) I always wanted to be able to fill a panel with information gathered from all around the page directly after my end user selected his options and present them into a summary. Dynamic populate extender is a nice controller of a panel that is expected to be filled dynamically at the choi
Using ASP.NET 3.5’s ListView and DataPager Controls: Grouping Data with the ListView Control
(Scott Mitchell) ASP.NET version 3.5 added two new data Web controls to the Toolbox: the ListView and DataPager. As discussed in the first installment of this article series, Displaying Data with the ListView, the ListView control offers the same built-in features found in the GridView, but much fin
Database and Sql Server FAQ part 1
(Shivprasad Koir Koirala) In this article we will go through the most basic and frequently asked questions on SQL Server. It is written as a series of potential questions that you may encounter during a job interview. A great candidate can be confused by simple variations in SQL Server questions, so
Demystifying AJAX for the PL/SQL Developer
(John Russell) Raise your hand if you haven’t heard that AJAX is the web development buzzword du jour. Despite the word “Javascript” in the acronym — Asynchronous Javascript and XML — PL/SQL can play a role in the front and particularly the back end. PL/SQL developers have the kind of background t
Used unused indexes
(Pete Scott) One of my old customers had a data warehouse with a three-area design model: a staging area for data load/cleanse, a third normal form (or more 3-NF-like than dimensional) raw data layer and a denormalised dimensional layer containing aggregated data for reporting. They ran a retail bus
SQL Server Management Studio Standard Reports – Backup and Restore Events: [DatabaseName]
(Buck Woody) I’m continuing my series on the Standard Reports in SQL Server Management Studio, and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, click the “Standard Reports”, an
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Ser