In the course of working on some deadlock issues, I found that MS SQL Server exhibits some unexpected (to me, at least) locking behaviors that can affect performance and cause deadlocks. In the end, I found that SQL Server provides an isolation level called Snapshot isolation which removes the need for locks on rows and removes lock contention. To use this isolation level, you need to execute the following SQL on the database that you want to use the isolation level with (replacing MyDatabase with your database name, of course): ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON Next, you need to modify your hibernate.cfg.xml file to add a property to tell Hibernate to use the Snapshot Isolation level: <!-- The 4096 isolation level is the setting to use with the jTDS or Microsoft JDBC drivers --> < property name =”hibernate.connection.isolation”>4096</property> Snapshot isolation is not a panacea...
I noted an issue with my original Pandora Desktop Hotkey script in that the embedded Flash control in the Pandora Desktop app sometimes has a different "control" name. This change in name would _sometimes_ make the script unable to send keys to the control. Here's an updated script that tries to work around this issue by simply sending keys to either of the possible names for that embedded control. Enjoy! DetectHiddenWindows, On ; Pandora Controls ;Ctrl-Win-Alt-Right Arrow ^#!Right:: IfWinExist, ahk_class ApolloRuntimeContentWindow ControlSend, WebPluginView1, {RIGHT} ; Next ControlSend, WebPluginView2, {RIGHT} ; Next return ;Ctrl-Win-Alt-Up Arrow ^#!Up:: IfWinExist, ahk_class ApolloRuntimeContentWindow ControlSend, WebPluginView1, {UP} ; Volume Up ControlSend, WebPluginView2, {UP} ; Volume Up return ;Ctrl-Win-Alt-Shift-Up Arrow ^#!+Up:: IfWinExist, ahk_class ApolloRuntimeContentWindow ControlSend, WebPluginView1, {SHIFT}{UP} ; Volume Max ControlSend, WebPluginView2, ...
EDIT: There is a slight problem occasionally with this script not being able to send keys to the Pandora Desktop Air app. I've got an updated version of the script that you can use instead of this one. Pandora is a different sort of online music service that uses the work of the Music Genome Project to automatically selects music similar to an artist or particular song, and then streams it over the Internet for your listening pleasure. You can't select individual songs, but you can skip ones you don't like and make as many music channels as you like to suit your particular tastes. Pandora provides a free version of the product that is supported by visual advertising, and a very inexpensive ($36 USD per year as of the creation of this entry) subscription supported version of the product that provides higher quality streams and no advertising. Traditionally, Pandora has been a Flash-based application that required you to have your bulky browser open to listen on the deskto...
Comments