(Marcin Policht) Throughout our series of articles dedicated to SQL Server 2005 Integration Services, we have been working mainly with packages using the Business Intelligence Development Studio interface (although more recently, we also discussed SSIS-related functionality available in SQL Server M
Other News
Microsoft SQL Server I/O subsystem requirements for the tempdb database
Microsoft SQL Server requires that the I/O subsystem used to store system and user databases fully honor Write-Ahead Logging (WAL) requirements through specific I/O principals. These requirements are necessary in order to honor the ACID properties of transactions: Atomic, Consistent, Isolated, and D
Subclassing Pages and Master Pages in ASP.NET 2.0
(Wayne Berry) Sometimes the simplest things in ASP.NET 2.0 turn out to be the hardest things to implement. One example is trying to have a shared property across all your web pages. For example, let’s say that you want to have a User object that is on all of your pages and that object be initialized
IBM DB2 Content Manager for iSeries, Part 9: Troubleshooting
(Jack Boswell) This article is a simplified user’s guide for troubleshooting problems that you encounter with Content Manager Standard Edition for iSeries. Much of the information for this document was assembled from the Information Center. Use this information in conjunction with the Information Ce
Mastering Ajax, Part 5: Manipulate the DOM
(Brett McLaughlin) If you followed my discussion in this series last month, then you got a first-hand look at what goes on when a Web browser displays one of your Web pages. As I explained then, when the HTML and CSS you’ve defined for your page is sent to a Web browser, it’s translated from text to
Coming soon – data quality firewall week
(Vincent McBurney) I am running another theme week next week, it is going to be data quality firewall week! Watch accurate data pass through the wall of fire. Be amazed at the jaw dropping tricks on display.
Metadata-morphosis
(Michael Curry) IBM recently announced a unified metadata services infrastructure that’s designed to ease metadata management, access, and sharing within a service-oriented architecture (SOA). The IBM WebSphere Metadata Server will be generally available later this year as part of the Hawk release o
Oracle/PLSQL: Foreign Keys
A foreign key means that values in one table must also appear in another table.
SQL Server 2005 XML Support, Exception Handling, and More
(John Papa) SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run. DDL triggers are useful when tracking or securing the creation and modification of data
Securing services: Locking down your SOA
(Daniel Rubio) For the many benefits an SOA brings to an organization, like having the capability to mix and match services with many different providers and suppliers or granting access to data in a platform-independent manner, there are many implementation details that are often overlooked when de