Series Index Build Automation Part 1: Overview and Pre-build Tasks Build Automation Part 2: Building and Packaging Build Automation Part 3: App Deployment Script Build Automation Part 4: Database and Report Deployments Unlike deploying the application itself in its entirety each time, database and report items have required incremental deployments due to their nature and…
Red Gate Schema Compare for Oracle Review
As part of my recent role in application release management, I have had to compare and sync various objects across Oracle databases. This was not fun work and I decided to evaluate some different tools to make this easier. The tool I have been working with recently is Red Gate’s Schema Compare for Oracle. In…
Slow OracleConnection Creation
This afternoon I executed a simple DDL statement with Oracle.DataAccess.dll and noticed it took upwards of 30 seconds when it should have come back in a second or so. In stepping through the code I noticed the large delay was in creating the Oracle Connection, not connecting to the database or executing the SQL: Oh…
Silverlight + WCF + IIS + Windows Auth + Oracle EF = PAIN
A couple days ago I started converting our Silverlight 4 app’s website and IIS-hosted WCF (v4) service to use Windows Authentication. The goal was to secure the service and data, get the user’s credentials down to the data tier and database, and provide some auditing and general security without asking for credentials already available for…
Read More Oracle Powershell Cmdlet
For more on this topic, check out my book Instant Oracle Database and PowerShell How-to. The What The past couple days in between tasks at work I decided to start a basic set of PowerShell cmdlets for Oracle. I wanted an easy way to work with our DB from the command line while leveraging the…
Read More