(Bruce Szabo) In my last article, A DTS Data Store I discussed a method for collecting DTS packages from a variety of servers and storing them in a single database. This technique allows one to capture all of the packages from a variety of servers and then store and use them from a single source. Us
Other News
Handling CLOBs – Made easy with Oracle JDBC 10g
Basically, LOBs (Large Objects) are designed to support large unstructured data such as text, graphic images, still video clips, full motion video, and sound waveforms. A typical employee record may be a few hundred bytes, but even small amounts of multimedia data can be thousands of times larger. O
Breaking the DB2 Platform Barrier
(Jim Wankowski) The popularity of DB2 UDB running on distributed platforms continues to grow. The sudden growth and popularity of DB2 on distributed platforms has resulted in a shortage of experienced non-mainframe DB2 DBAs. IT departments today have to deal with tightening budgets and shrinkin
Smarten Up Your DataSets with XML Schema
(Eric McMullen) You might as well face it; your data model is going to change. You can whine about it. You can fight with the DBA and the requirements team. Or you can get ready for the change before it happens. This article focuses on the last option, giving you some techniques to build a more flex
SQL Server 2000 Security – Part 3 (Service Accounts)
(Marcin Policht) In the previous article of this series, we looked into authentication mechanisms used to determine validity of credentials specified by a user connecting to a SQL Server 2000. Now, we are going to explore another topic related to authentication, but on a different level – SQL Se
Reading XML file with ASP
(Faisal Khan) XML stands for Extensible Markup Language. XML can be used in many ways and one of which is ‘data storage’. This is the one we will be exploring in this article. XML along with XSL ( Extensible Stylesheet Language ) can by used to present data on the web pages. XML provides the dat
Strongly-Typed Binding for List Controls
(J. Ambrose Little) This article briefly covers the implementation of two types that can be used to bind list controls, such as the DropDownList, in a strongly-typed manner to a SQL Server data source using stored procedures. I think the main application of this concept, as demonstrated by the
Management Tools: No Secrets
In enhancing existing management tools and designing new ones for SQL Server 2005—formerly code-named Yukon—Microsoft’s SQL Server Tools team followed two guiding principles: “no secrets” and integration. Euan Garden, product unit manager for SQL Server Tools for SQL Server 2005, tells SQL Server Ma
Access heterogeneous data with DB2 Information Integrator: Part 1, Create EJBs that manipulate federated data methods
(Julien Muller and Martin Klumpp) Many developers are faced with the problem of managing heterogeneous data — that is, data kept in various kinds of stores that needs to be managed in a unified way. One way to access such data is through IBM DB2 Information Integrator, working in tandem with a J2EE
XML Europe 2004: Refactoring XML
(Eric van der Vlist) The European XML conference (XML Europe) took place last month in Amsterdam. One of the presentations was titled “refactoring XML” and, without going that far, one of the main recurring themes was certainly refactoring the uses of XML.