(Tal Olier) In the following article we are going to cover the use of key-value tables in a database design. They can help you with flexibility in design, but will trip you up in other areas (such as data filtering) if you are not careful. I assume that the audience for the following article is fami
Author: SSWUG Research
Process Analysis Services Objects with Integration Services
(William Pearson) In this lesson we revisit an approach to automated / scheduled processing of an Analysis Services database (and related objects), a subject that we undertook in my article Process Analysis Services Cubes with DTS (Database Journal Introduction to MSSQL Server Analysis Services seri
Accessing Directory Services in .NET Framework 2.0
(Mark Strawmyer) The configuration of the development environment used for this article is a Microsoft Virtual PC running Windows Server 2003. I promoted it to a domain controller for a fictitious dev.codeguru.com domain. All of the examples in this article run against that server instance. For thos
Integrating .NET Web services with Java and classic ASP Clients for Interoperability
(Anand Thakur) Web Services means structuring operations and data according to SOAP specification in an XML document. SOAP (Simple Object Access Protocol) is a way for a program running in one kind of operating system or language (e.g. Windows or .Net) to communicate with a program in the same or an
Looking for Meaning in the Semantic Web
(Neil Raden) What is the Semantic Web and how can it help you? The concept may help solve tough corporate information-management problems.
Oracle looks to take on Eclipse
(Paul Krill) Oracle has just released a free JDeveloper Java development tool, in an attempt to compete with the open source community Eclipse.
Steps for recovering database with RMAN hot backup
(Brian Peasland) I took the RMAN hot backup on database open stage. What steps should I follow to recover the database using the RMAN hot backup? Can I do it in database mount stage or open stage? (R)
Understanding ASP.NET Provider Model – Part 1
(Bipin Joshi) ASP.NET 2.0 includes host of new features such as Membership, Roles and Profiles. These features are based on the Provider Model. This series of article will demystify the internals of provider model and will illustrate how to create your own custom providers.
FIX: Real-time updates that are made on Relational Online Analytical Process partitions may not be reflected in the query results when you use SQL Server 2000 Analysis Services
When you run Multidimensional Expressions (MDX) queries in Microsoft SQL Server 2000 Analysis Services, real-time updates that are made on Relational Online Analytical Process (ROLAP) partitions may not be reflected in the query results. This problem may occur when the following conditions are true:
Convert Descriptive Flex Fields to Numbers
(Kamlesh Jethwa) Often, data in Oracle applications is stored in extended columns known as Descriptive Flex Field (DFF) columns. These are character columns which you can map to store any kind of information. On the front end, it is possible to apply validations like numeric, date, or character but