(Svetlana Golovko) We need to get notifications every time a database is created or deleted. Also, we would like to receive emails when there are any database level configuration changes. This will help us react to these changes immediately (for example, configure database backup for a new database,
Author: SSWUG Research
effective_cache_size: Better set it right
(Hans-Juergen Schoenig) PostgreSQL knows a parameter called effective_cache_size. To many this is one of the most mysterious settings in the entire PostgreSQL config. Maybe this is the core reason why many people just completely ignore this setting – in many cases this is not the best idea of all. e
Fusion Concepts: Lookups
(Vik Kumar) Lookups in applications are used to represent a set of codes and their translated meanings. For example, a product team might store the values ‘Y’ and ‘N’ in a column in a table, but when displaying those values they would want to display “Yes” or “No” (or their translated equivalents) i
In-memory? That’s so yesterday!
(Philip Howard) Not for the first time, IBM has been underselling itself. I refer specifically to DB2 with BLU Acceleration. Given this second sentence you might be surprise at the first: IBM has been heavily marketing BLU. However, it’s true.
Web API With AJAX: Understand FormBody and FormUri Attribute In Web API
(Sourav Kayal) This article exlains the “FormBody” and “FormUri” attributes and how to use them with an action parameter to consume data at the client end.
Building a basic Web Forms application using Visual Studio 2013
(BalaChirtsabesan) In a previous blog post, we have described the different options you have when creating a new web application with Visual Studio 2013 (VS 2013) and provided an overview of the various ASP.NET features and NuGet packages present in the templates.
Assign SQL Service Account with Group Policy
(Ryan Adams) How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
WITH RECURSIVE and MySQL
(Guilhem Bichot) If you have been using certain DBMSs, or reading recent versions of the SQL standard, you are probably aware of the so-called “WITH clause” of SQL.
Testing removing subpartitions from a table with query testing package
(Bobby Durrett) I thought I would start this blog post before I finished this testing so I wouldn’t forget what I’m doing along the way. Usually I just write something up after I’m done and then I may forget all I’ve done along the way.
APAR Friday: An improvement in REORG messaging and JSON support
(Willie Favero) I’m doing something a little different today… I’m actually publishing an APAR Friday post on Friday.