(William Pearson) In this article, we will examine IsAncestor(), once again as a conditional logic modifier, but within the context of a filter. Combining IsAncestor() with the MDX Filter() function is another way we commonly see it in action in the business environment, and our exposure to the prac
Author: SSWUG Research
OUTPUT Clause in SQL Server 2005
(Keyvan Nayyeri) In previous versions of T-SQL you had to use a trigger to retrieve data from inserted, updated or deleted rows in tables which wasn’t very straightforward. SQL Server 2005 adds a new clause to T-SQL to simplify this task. OUTPUT is this clause.
A Primer to Windows Communication Foundation
(Jeffrey Juday) Windows Communication Foundation (WCF) is poised to revolutionize how developers build distributed services on the Microsoft Windows platform. More than a new SOA foundation, the Microsoft Connected Systems Division (CSD) has targeted WCF to do what was once done by a disparate colle
Building an AJAX Based Web Chatting Application using ASP.NET 2.0
(Xianzhong Zhu) This article will present you with a Web chatting application, which is based on the famous open source AjaxPro.NET library. Here, we will establish ourselves a nice little multi-user chat application, much like the famous MSN Messenger. We will build the application heavily on JavaS
Using Multiple Active Result Sets (MARS)
(Mladen Prajdic) SQL Server 2005 has so many new features that in my opinion if you read only BOL for a year you’d find something new every day. One of those is Multiple Active Result Sets or MARS. Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user
IBM DB2 9 Database Administration for z/OS Exam (732)
(Susan Visser) Now is the PEFECT time to validate your skills and demonstrate your IBM DB2 9 proficiency with Information Management Professional Certification. Ensure your success on exam day by taking advantage of our preparation resources.
The Answers (and the Questions) in the Hunt for Data Quality
(Robert Heidenreich) Data quality is a huge problem for B2B marketers, and one which too many fail to address. This article explains what to look for when searching for a data quality solution.
Using Oracle Forms
(Bogdan V) Oracle forms, is a component of the Oracle SQL database. The Oracle technology is to design and build enterprise application in a quick way and efficiently. This article is designed to give a short introduction to the Oracle Forms 10g toolset and the basic components of a forms applicati
Implementing Oracle Applications i Modules
(Sam) The latest release of Oracle Applications 11i and the current Release 12 include a number of i modules which have been included. These of course may require separate licenses before you can implement them.In my current post today I will talk about implementing these imodules from an APPS DBA v
ASP.Net 2.0: Export GridView to Excel – Part II
(Dipal Choksi) The article “ASP.Net 2.0: Export GridView to Excel” received a very good response from our user community. Some of the excellent tips collected from the user feedback have been included in the first version of the article.