(Rion Williams) As mentioned in my previous article on “Implementing Simple Audit Trails using ActionFilters in ASP.NET MVC”, accountability is such an important factor when working with systems that involve any level of security and confidentiality.
Author: SSWUG Research
GO
(Kenneth Fisher) Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in case you were wondering that’s why you can’t put GO inside of stored procedures, functions etc.
Oracle Database 12c and APEX
(Dimitri Gielis) The below content is based on a David Peake’s presentation at OOW 2012 and APEX World 2013.
Uploading Data to Windows Azure SQL Database
(Feodor Georgiev) One way of getting the advantages of the Cloud without having to migrate the entire database is to just maintain a copy of the data that needs to be accessible to internet-based users in Windows Azure SQL Database.
A jQuery inspired server side view model for Java
(Johannes Brodwal) In HTML applications, jQuery has changed the way people thing about view rendering. Instead of an input or a text field in the view pulling data into it, the jQuery code pushes data into the view. How could this look in a server side situation like Java?
DB2 11 for z/OS: What’s ahead
(Troy Coleman) IBM announced the DB2 11 for z/OS Early Support Program last fall, and a select group of clients are now participating in the program. I want to revisit the announcement letter to show you how IBM is positioning DB2 11.
DB2 Locking, Part 5: Lock Suspensions, Timeouts, and Deadlocks
(Craig S. Mullins) The longer a lock is held, the greater the potential impact to other applications. When an application requests a lock that is already held by another process, and the lock cannot be shared, that application is suspended. A suspended process temporarily stops running until the loc
Oracle Data Guard 11g – Redo Transport User
(Mahir M. Quluzade) As you know when we create Data Guard Configuration, we must copy password file. Because SYS user is default redo transport user on Data Guard configurations.
Measure the impact of DB2 with BLU Acceleration using IBM InfoSphere Optim Workload Replay
(Patrick Titzler and Hassi Norlén) In this article, learn to use IBM InfoSphere Workload Replay to validate the performance improvement of InfoSphere Optim Query Workload Tuner (OQWT) driven implementation of DB2 with BLU Acceleration on your production databases. The validation is done by measuring
Deferred Query vs Immediate Query Execution in LINQ
(Jasminder Singh) To provide an overview, deferred query execution means execution of the SQL query only when it is needed, rather then executing it prior to any operation that may require any change (as you will learn later in this article).