(Ronald Bradford) To expand on Jervin’s Default RDS Account Privileges, RDS for MySQL provides a number of routines and triggers defined the the ‘mysql’ meta schema. These help in various tasks because the SUPER privilege is not provided.
Author: SSWUG Research
DB2 for z/OS: GETPAGEs are not ALWAYS the Key Determinant of SQL Statement CPU Time
(Robert Catterall) In my DB2 for z/OS-related work over the past 25 years, I’ve done a lot in the way of performance analysis, looking at individual queries and at DB2-accessing application programs (both transactional and batch in nature).
Outline hint for query tuning
(Bobby Durrett) I had a situation today where I had two slightly different queries that I thought should have the same plan but they didn’t. So, I needed a way to force the slower query to run with the same plan as the faster one.
ADF Task Flow Template Improvements in 12c
(Andrejus Baranovskis) There are great improvements in ADF task flow templates in 12c release. We can great ADF task flow template based on other template and what is even more amazing – JDeveloper 12c ADF task flow diagram window displays template contents when editing actual consuming task flow.
ASP.NET MVC 5 Authentication Filters
(Eric Vogel) ASP .NET MVC 5 is currently under developer preview, and is included in the recently-released Visual Studio 2013 Developer Preview. Today I’ll be covering how to use the new Authentication Filters included in the ASP.NET MVC 5 preview.
XML Marks the Spot Part 1: Conversion
(Jeffery Hicks) For many IT Pros, XML is the de facto storage standard. XML itself is a complex topic so I’m not going to attempt to teach you XML. What I will do is try to demonstrate some ways you can work with XML in PowerShell. I’m going to be using PowerShell 3 but I believe most everything wil
Debug ScriptBundle results in 404 if virtualPath parameter contains a dot
(Xinyang Qiu) I spent some time debuging a ScriptBundle problem last Friday and want to share my experience.
Using Base Controllers In AngularJS – An Experiment
(Ben Nadel) Yesterday, in a conversation that I was having with Chris Schetter, I was rehashing how my JavaScript style has changed somewhat since I’ve started using AngularJS. Specifically, I’ve started using the Revealing Module Pattern a lot more than I ever have before. While many things have co
What to Expect in Visual Studio 2013 and .NET Framework 4.5.1
(Hannes Du Preez) It seems like only yesterday that Visual Studio 2012 was released, well, in fact it was not so long ago. Visual Studio 2013 Preview and .NET Framework 4.5.1 are now available for download. I believe many a modern developers will be excited to hear this, but many an older developer
Transactional Replication – Violation of Primary Key Constraint
(satnam singh) Recently, I encountered a case where the Transactional Replication between our Production OLTP server named XYZ and Reporting database server named PQR went out of sync. Both the servers were located in the same Data Centre in the USA.