Watch the Latest Weekly SQL Server Show, Released Today Watch SelectViews – Facing the Real World Users, a Tool for Optimizing Queries. Query Plans, Your 15 Minutes of Fame, Current Release Versions, Upcoming Events, Tips and More. > Click Here to Watch The Show. Consolidation is More Than Moving Around Instances Frankly, when I first started learning about consolidation, I […]
Other News
TEMPLATE Switching [DB2 9 for z/OS]
(Craig Mullins) Next up in this on-going series covering the new features and functionality of DB2 9 for z/OS we will tackle the improvements that have been made to the IBM DB2 utilities.
XML DB HOW TO: Updating Simple XML Values on the Database
(Edmon Begoli) So far I provided tips on how to read the content of the XML stored on the Oracle database. In this entry I will review some basics of how to update the content of the XML stored on the database as XMLType. I will be starting with the following XML (reviewed in previous XML DB entries
Unique indexes on materialized views
(yas) One of the uses of materialized views is replication. Mviews can be used to replicate a table to another database to prevent users from accessing several databases through database links. This can improve the performance of queries which frequently access that table by removing the latency of
Data Warehousing update, part 1
(Philip Howard) A lot has been happening on the data warehousing front lately. Earlier this summer, Oracle announced its Information Appliance initiative and, in particular, a partnership with PANTA Systems. Then, more recently, ParAccel has announced a product re-positioning, Calpont is finally tal
Tip: Read News Industry Text Format (NITF) files with PHP
(Vikram Vaswani) The News Industry Text Format is an XML-based format used by the news industry to encode and share the content of news articles. PEAR’s XML_NITF package provides an extensible API to read and parse NITF-formatted files, making it easy to extract bibliographical information and artic
Managed Code Shines in Silverlight 1.1
(Steven Porter) In addition to the XAML and JavaScript combination supported in Silverlight 1.0, this Silverlight 1.1 Alpha client also supports managed code written in a language such as C# or VB.NET. That single addition brings many more development possibilities into play, and also pulls in a hos
Microsoft’s Lineup of SQL Server Related Webcasts for September 2007
Seven new webcasts are scheduled for September, covering such topics as “Programming SQL Server 2008”, “Entity Framework for Database Administrators (Level 200)” and more.
WebSphere Business Modeler Advanced Simulation
(Marc Fasbinder) One of the most powerful features in WebSphere Business Modeler is the ability to simulate business processes. Creating business models lets you capture business metrics, such as the times required to perform given tasks, the resources involved, and the costs. The simulation uses th
Creating an ASP.NET 2.0 Polling User Control: Design Decisions and the Data Model
(Scott Mitchell) Many websites include some sort of polling user interface through which visitors can cast their vote on the topic du jour. The typical polling user interface includes some question text, like “What is your favorite programming language?”, along with a series of radio buttons listing