(Juan Carlos Recio Abad) Often I see big projects in which XML is used to convey information among different modules, (instead of JSON with a very good current speed to do it more efficiently) where there are several applications responsible to handle such information.
Author: SSWUG Research
Building a CRUD using MVC 4 using Repository pattern as the model – Step by step
(Niladri Biswas) In this article we will build a CRUD operation using MVC 4 using Repository pattern as the model.
SQL Server Operations from Set Theory
(Tim Wiseman) SQL Server provides the UNION, EXCEPT, and INTERSECT set operations. How do they work and how can they be used in SQL Server? Can you provide any examples?
PostgreSQL guts: What is ‘resjunk’?
(Craig Ringer) I’m delving into the PostgreSQL parser, query rewriter and query planner at the moment, as part of work on row-level security for the AXLE project. As I’ve noticed that there’s some great documentation on the overall structure and flow but not much on some of the details I thought I’d
Oracle SQL Developer 4: Windows and the JDK
(Jeff Smith) A few things have changed when it comes to running SQL Developer on a Windows machine. In previous versions, the first thing you’d see when running SQL Developer would be a prompt asking for the location of Java.
Using a Statistical View to Improve Query Performance
(Ember Crooks) Sometimes just using the index advisor and a bit of common sense, you can address SQL performance issues. But other times, you have to dig a bit deeper.
Web API With AJAX: Understand Method Name and Attribute in Web API
(Sourav Kayal) This article explains action names and various attributes of them as well as the behavior actions corresonding to various attributes.
How to Work with Lists and Collections of Knockout ?
(Sampath Lokuge) Very often, you’ll want to generate repeating blocks of UI elements, especially when displaying lists where the user can add and remove elements.
Transactions: Rolling back part of a transaction.
(Kenneth Fisher) In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way to the top level. If that is the case then can we roll back an inner transaction and still maintain and commit the rest of the transaction?
MySQL encryption performance, revisited
(Ernie Souhrada) This is part two on a two-part series on the performance implications of in-flight data encryption with MySQL. In the first part, I focused specifically on the impact of using MySQL’s built-in SSL support with some rather surprising results. Certainly it was expected that query thro