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

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.

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!!