Technical Analysis,Dev Center,App - Port 25: The Open Source Community at Microsoft

Browse by Tags

All Tags » Technical Analysis » Dev Center » App (RSS)
    Connecting Office Applications to MySQL and PostgreSQL via ODBC
    by MichaelF on April 10, 2007

    In cases where business applications have been built on open source databases, it may be necessary to connect other Windows applications, such as Microsoft Access or Excel, to these databases for reporting or business intelligence purposes. One potential application of this process is to use Excel as a front-end for data analysis. Data can be pulled from views or tables and then further analyzed... more

    MySQL on Windows: Configuration & Install
    by jcannon on March 16, 2007

    MySQL is an open source relational database management system which is typically used for light-weight web applications. This paper will provide an overview of configuring & intalling this software on Windows. MySQL does not have as many features as PostgreSQL, however, and one would expect it to perform substantially better than PostgreSQL on Windows because of its thread-based architecture (PostgreSQL... more

    PostgreSQL on Windows: A Primer
    by MichaelF on February 22, 2007

    This paper will cover the installation and initial configuration of PostgreSQL 8.2 on Windows up to a point where a database is created and plpgsql is installed in it. We assume an ability to walk through the install wizard in general, though screens... more

    • Thursday, February 22, 2007
    • in: Dev Center
    • MichaelF
    Memtest
    by jcannon on July 11, 2006

    So, this weeks tech tip is about memtest, and yes, I am sure there are some that might scoff at this....But I think we have a tendency to loose sight of the basics. For instance, last week we had quite an interesting time debugging a problem that occurred intermittently and we where not able to find a way to consistently reproduce the problem. We ran through all kinds of things until we decided for... more

    HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS
    by admin on June 14, 2006

    We have been working in the labs on doing some testing and integration of jBoss talking to a SQL server 2005 backend. We have seen some questions on how to connect a SQL Server in the Windows environment to jBoss. So I wrote a little how-to that describes just that...... more

Top Contributors
Popular Tags