(Scott Mitchell) The Membership API in the .NET Framework provides the concept of a user account and associates with it core properties: username, passsword, email, security question and answer, whether or not the account has been approved, whether or not the user is locked out of the system, and so
Author: SSWUG Research
What is an outer join?
(Brian Peasland) What is an outer join? How is it advantageous over an inner join? (R)
SQL Server 2005 Integration Services – Fuzzy Lookup – Part 34
(Marcin Policht) In the recent articles of our series dedicated to SQL Server 2005 Integration Services, we have been covering the most popular Data Flow components. The latest article focused on Lookup Transformation, which combines records from two sources based on exact match between their corres
SQL 2005 Web Synchronization for Merge Replication
(Hilary Cotter) Prior to SQL 2005, if you wanted to replicate over the Internet your network administrator had to configure a VPN or open the firewall ports 1433 (the ip port that SQL Server runs on by default) and 21 (the ip port that TP runs on) for inbound communication.
Simplify Dependent Lists with the Microsoft AJAX CascadingDropDown Control
(Wei-Meng Lee) One key problem that AJAX addresses is improving Web application user interfaces. By reducing the need to constantly refresh the entire Web page, Atlas helps ensure that your Web application is always responsive to user actions. For example, suppose you’re filling in a Web form to reg
Free Load Generator for Oracle
(James F. Koopmann) Have you ever needed to generate a real database load on Oracle for testing purposes? Or maybe another good question is: Have you ever tested your database procedures with a real load on Oracle?
In predicate performance problem
(Omer Brandis) In this post I’ll tell you about two limitations of the DB2 optimizer (DB2 for z/os v8) in regard to “in” predicate processing.
Creating an XML file based on XSD
(jebarson) This article will be successful in explaining you how to generate an XML file based on the schema you have.
SQL statement error
(Kent Milligan) I am running the following SQL statement but getting an error as “Position 1 Null values not allowed in column or variable VC_EST_PAYMENT UPDATE UARSLSDET AS A SET (VC_EST_PAYMENT, FEE) = (SELECT IFNULL(EST_PAYMENT*100,0), IFNULL(FEE*100,0)
Views
(Philip Greenspun) The relational database provides programmers with a high degree of abstraction from the physical world of the computer. You can’t tell where on the disk the RDBMS is putting each row of a table. For all you know, information in a single row might be split up and spread out across