(Stefan Prodan) If you made an application that is using an SQL database that needs to be located on the client server, VS.NET Setup Project doesn’t help too much, you could go for InstallShield or other product that will make things easy but the costs will get higher. So searching for a free soluti
Other News
Handling Data Integrity Issues in Analysis Services 2005
(T.K. Anand) Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.
Writing BLOB Values to a Database
You can write a binary large object (BLOB) to a database as either binary or character data, depending on the type of field at your data source. To write a BLOB value to your database, issue the appropriate INSERT or UPDATE statement and pass the BLOB value as an input parameter (see Using Stored Pr
Analytics for Non Analytics
(Jaromir D.B. Nemec) This paper gives overview of the most important analytical functions, that are often used in every day life in DSS or DW business.
FIX: A pooled connection is not disposed by Microsoft .NET Managed Provider for Oracle when an exception occurs
OracleConnection objects that experience errors because sessions or connections are dropped are returned to the connection pool when the Connection.Close method is called. Then, the OracleConnection objects are reused. This may cause unexpected behavior
Explore Model Driven Architecture and Aspect-oriented Programming, Birds of a Feather
(Anneke Kleppe and Jos Warmer) Although AOP and MDA were developed from very different viewpoints: programming vs. modeling; weaving many inputs into one output vs. creating many outputs from one input, there is a great deal of common ground between them and both techniques are used for identical pu
Use SQLyog Tunneling for Secure MySQL Server Management
(Karam Chand) Most Web hosting providers block port 3306 (the MySQL server port) at the firewall to prevent outside access. As a result, many MySQL developers and administrators can’t access and manage their own MySQL servers remotely; they must use the Web-based interfaces that their ISPs provide.
If you swap a table partition in/out, does that cause all the statistics to be recalculated?
(Larry Chesnut) The other day, I got an interesting email. The jest of the question was, “When you partition a table, and the associated index, where are the statistics stored? If you swap a partition in/out, does that cause all the statistics to be recalculated?”
Inheritance and Polymorphism in PHP: Building a Form Generator – Part I
(Alejandro Gervasio) Object Oriented Programming (OOP) is a powerful technology for designing Web applications. This article is the first in a three part series that will explain two of the bases of OOP, Inheritance and Polymorphism, and apply these principles to building an extensible form gene
Generating Surrogate Keys
(Jamie Thomson) Surrogate keys are generally considered fundamental building blocks of a data warehouse. They are used as identifiers for dimensional members and enable us to manage slowly changing dimensions.