(Shailendra Chauhan) There are different ways for returning/rendering a view in MVC Razor. Many developers got confused when to use return View(), return RedirectToAction(), return Redirect() and return RedirectToRoute().
Author: SSWUG Research
TechTip: Simplify and Centralize Your SQL Triggers
(Kent Milligan) As the utilization of SQL triggers continues to rise, some developers are being challenged by the fact that they must define a separate SQL trigger for each database event they want to associate with a trigger.
List DB2 table columns and unique constraints
(Jack Vamvas) How can I list the DB2 table columns and unique constraints?
The DBA Detective: The Case of the Missing Index
(Grant Fritchey) When problems arise in SQL Server, we’re faced with a server full of suspects, including disk I/O, memory, CPU, incorrect or missing indexes, badly written T-SQL code, out of date statistics, and full disk drives. All of these have motive and opportunity to murder the performance of
BACKUP CURRENT CONTROLFILE creates a Snapshot Controlfile
(Hemant K Chitale) Recently, there was a discussion on forums about when a Snapshot controlfile is created. It is known that the snapshot controlfile is created to re-synchronise with the Catalog.
The many uses of CROSS APPLY
(Kenneth Fisher) Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
Migrating SQL Server Databases – The DBA’s Checklist (Part 2)
(Sadequl Hussain) It is always a good idea to update the statistics of the database that you have just installed or migrated. To do this, run the following command against the target database:
RAC KISS on VirtualBox
(mdinh) Practice makes perfect, but it does not have to be difficult. Please don’t short yourself by not trying to understand what is going on.
Custom Transaction Factory in ADF BC for After Commit
(Andrejus Baranovskis) We were facing issues overriding Custom Transaction Factory in ADF 11g R1, it was initialized only for the first loaded AM, this seems is not the case anymore in ADF 11g R2 (11.1.2.x). I would like to present today a use case of implementing global after commit.
XML Web Service using PHP and SOAP
(Ashokkumar) The basic Web services platform is XML and HTTP. XML provides a language which can be used between different platforms and programming languages. The HTTP protocol is the most used Internet protocol. Web services platform elements are SOAP (Simple Object Access Protocol), UDDI (Universa