SQL Server: Kill All the SPIDs

Sometimes, we need to take a SQL Server database offline. After notifying the users and giving them plenty of warning, they leave connections to the database – some connections are SLEEPING or AWAITING COMMAND, others have select statements that have been running for over four hours. I use the following sql to kill off all of the remaining user sessions on a database. Just change the YOURDATABASE text to the name of your database and […]

BI Publisher Report Shows ‘No Data Found’

A report in Oracle BI Publisher Enterprise v11.1.1 returned “No data found.” for all elements in the report when viewed by guests and administrative users. The report used several data sources and only worked for the sysman user. The problem data source turned out to be the default data source, EMREPOS, which stores all of the Oracle Enterprise Manager data and for this installation is also the BI Publisher repository. EMREPOS is a hidden data […]

Intro: SSO for EBS R12

There are four essential components to enabling Active Directory (AD) logins to Oracle EBS R12 including: Identity Management (IDM), Unified Directory (OUD), Access Manager (OAM) and Access Manager WebGate. Only the WebGate is installed on the EBS application tier. IDM uses Directory Integration Platform (DIP) to integrate AD users into OUD. OAM handles requests from the WebGate on EBS to authenticate AD users in OUD. IDM, OUD and OAM each require a WebLogic server (WLS). If all […]

Node.js + Express + Redis = Web Service

The goal is to provide real-time information from Redis Cache via Node.js to web clients. The data include temperature, ozone levels and humidity, collected from devices in various regions. A sample record: key: be65-429a-8706a:region2 value: [{“id”:”be65-429a-8706a:region2″,”x”:175.1319,”y”:174.3768,”ts”:”Thu Oct 15 2015 14:03:33 GMT+0000 (UTC)”,”temp”:”32.7″,”humidity”:”87.2″,”o3ppm”:”0.420″}] For this demonstration, I used openSUSE 13.2 x86-64 on a single core VM with 1.75GB of RAM and installed Node.js v4.2 via zypper. I also installed redis version 3.0.4 for local testing, but the […]

UPDATE: Azure VMs and CouchDB

After experimenting with the limits of Azure VMs and CouchDB based on my articles, I determined that the best practice should be to create disks to attach to the VM. The CouchDB data files should be stored on the attached disks. A terabyte of storage costs just over $50/month. (http://azure.microsoft.com/en-us/pricing/details/storage/) Attaching a new storage disk can be done in the Azure portal by navigating to the All Settings link for a VM, clicking on the […]