(Pinal Dave) The questions I received in last two weeks:
Author: SSWUG Research
MySQL 5.6, InnoDB statistics, and testcases for optimizer
(Sergey Petrunia) One of the new features in MySQL 5.6 is persistent table statistics. The word “persistent” makes you think that table statistics will be very stable from now on.
Security Questions: Granting Access with Jobs
(Jason Strate) As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted to p
DB12c – PGA_AGGREGATE_LIMIT
(Surachart Opun) On Oracle Database 12c features, PGA_AGGREGATE_LIMIT initialization parameter is value, that limits PGA memory usage. If total PGA memory usage is over PGA_AGGREGATE_LIMIT value. The sessions or processes that are consuming the most untunable PGA memory will be terminated.
Cursor Invalidation
(Thomas Saviour) Got a question: What will happen a running curosr got invalidated? SQL execution will fail or invalidation is not at all possible?
A Generic Object Pool
(Richard Carr) The object pool design pattern can improve performance by reusing objects that are expensive to instantiate, rather than creating new instances. This article describes a generic implementation of the object pool pattern.
The MVC Pattern and ASP.NET MVC – Back to Basics
(Suprotim Agarwal) Today we’ll take a break from discussing cutting edge framework enhancements and the latest and greatest. We’ll step back to take a look at the big picture. We will revisit some old questions of what is MVC, where do we start and how do we go about understanding the working of ASP
Creating a Business Intelligence Dashboard with R and ASP.NET MVC: Part 2
(Sergei Dumnov) In my previous article, I began a demonstration of how to build a Business Intelligence (BI) application using R, Visual Studio 2012 and Twitter Bootstrap. The aim of this series is to leave you at the end of each article with a working system, adding functionality in each article as
Getting to grips with Regular Expressions: (1) Regex.IsMatch
(Ged Mead) I’m planning on writing a series of posts on regular expressions over the next few months. I’m going to start from absolute basics, hopefully building up a collection of useful techniques for you to use with this very powerful but often mightily difficult technology. It’s worth persever
How to convert XML to Java object and vice versa in runtime?
(Ananth Chellathurai) Well the obvious choice would be to use JaxB, due to its familiarity. Let us see it with a simple example. JAXB is governed by the same team as Glassfish. JAXB comes by default with JDK1.6+. JAXB stands for Java Architecture for XML Binding.