Twitter Updates

    follow me on Twitter

    Tuesday, January 24, 2006

    Backup OLAP 2000 databases

    Een VBS Scriptje dat een archive neemt van elke OLAP database in een Analysis Services 2000 installatie.

    Set dsoServer = CreateObject("DSO.Server")
    Set dsoDatabase = CreateObject("DSO.MDStore")

    Set objShell = WScript.CreateObject("WScript.Shell")


    ServerName = "mySERVER"
    msmdarchPath = "c:\Program Files\Microsoft Analysis Services\Bin\msmdarch"
    OlapPath = "c:\Program Files\Microsoft Analysis Services\data\"
    BackupPath = "c:\temp\"

    dsoServer.Connect ServerName
    For each dsoDB in dsoServer.MDStores

    cmd = """" & msmdarchPath & """" & " /a " & ServerName & " """ _
    & OlapPath & """ """ & dsoDB.Name & """ """ & BackupPath & dsoDB.Name & ".CAB"""

    objShell.run cmd, 6, True
    'wscript.echo cmd
    Next

    Thursday, January 19, 2006

    Microsoft SQL Server 2005 JDBC Driver

    Microsoft heeft een nieuwe JDBC driver voor SQL Server 2005 uitgebracht.


    In its continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver with SQL Server 2005. The SQL Server 2005 JDBC Driver download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition).

    The SQL Server 2005 JDBC Driver is JDBC 3.0 compliant and runs on the Java Development Kit (JDK) version 1.4 and higher. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, JBoss, and Sun.

    Thursday, January 05, 2006

    kbAlertz.com

    Weer zo'n tooltje dat doet wat het moet doen, niets meer en uiteraard niets minder: kbAlertz.com

    kbAlertz.com is an e-mail notification system that scans the entire Microsoft Knowledge Base every night, and e-mails you when updates or additions are made to the technologies you subscribe to.

    Meer moet dat niet zijn: tooltje van de week dus!!