(Henrik Loeser) DB2 allows users to switch to different identities. One way is through the means of so-called trusted contexts (which I won’t discuss today), the other option is to call SET SESSION AUTHORIZATION (old: SET SESSION_USER).
Author: SSWUG Research
DB2 Locking, Part 1: An Overview
(Craig S. Mullins) DB2 automatically guarantees the integrity of data by enforcing several locking strategies. These strategies permit multiple users from multiple environments to access and modify data concurrently.
Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
(Stephane Combaudon) It’s not uncommon to promote a server from slave to master. One of the key things to protect your data integrity is to make sure that the promoted slave is permanently disconnected from its old master. If not, it may get writes from the old master, which can cause all kinds of d
ASP.NET MVC: Annotated for Input
(Dino Esposito) With an ASP.NET MVC application of any size, there comes a time when you are faced with creating utility forms where you don’t need a special form layout. One of the best ways of doing this is by using data annotations. Despite a quirk or two, it can save a lot of time.
Code Map and Debugger Integration in Visual Studio 2012 Ultimate
(Suprotim Agarwal) The Code Map and Debugger Integration in Visual Studio 2012 can add a lot of value in large sized projects with plenty of legacy code and sparse documentation. This article explore these new features.
Direct Path Reads Again
(Coskan Gundogar) Number of Oracle database in our estate is a high number and they are on shared storage arrays which means if one of them is naughty on I/O it has a potential impact on others.
Understanding SQLTXPLAIN Health-Checks
(Carlos Sierra) SQLTXPLAIN (SQLT) collects diagnostics details about a SQL statement that either performs poorly or it produces unexpected results (also known as wrong results). In addition to that, it also performs over a hundred health-checks around the SQL statement being analyzed.
Application Design is the only Reason for Deadlocks? Think Again
(Arup Nanda) Have you ever seen a message “ORA-00060: Deadlock detected” and automatically assumed that it was an application coding issue? Well, it may not be. There are DBA-related issues and you may be surprised to find out that INSERTs may cause deadlock.
Building a shopping cart with SignalR, ASP.NET Web API and Knockout.js
(Filip W) In this tutorial we will go through a process of building a sample shopping cart with real time capabilities. On top of that, we’ll also throw in a real time admin order overview.
How to Customize Telerik’s ASP.NET PivotGrid Cells Using the Built-in Templates
(Daniel Peichev) Another long-awaited PivotGrid core feature was introduced with the Q1 2013 release of RadControls for ASP.NET AJAX. If you have seen our new demos, there is a good chance that you might have already guessed that I’m talking about the templates support.