(Jeremy Kadlec) Being able to identify SQL Server performance issues at the drop of a hat is easier said than done. Without a means to collect and analyze the performance data it is difficult at best to understand and correct the items in a timely manner.
Author: SSWUG Research
3 handy tools to remove problematic MySQL processes
(Muhammad Irfan) DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors.
REST Service Access with A-Team Mobile Persistence Accelerator
(Andrejus Baranovskis) A-Team Mobile Persistence Accelerator (AMPA) works on top of Oracle Mobile Application Framework (MAF) and provides tools to simplify consumption of REST services. It enables transparent persistent layer usage on the device with the option of synchronising offline data with th
Sequences – where did the view go?
(Neil Chandler) I was pottering around with the sequence cache recently, investigating a few things like exactly when it refreshes (such as if it is flushed or aged from the shared pool – pin it!) and I was monitoring the next value using V$_SEQUENCE, like I have been since, erm, Oracle 8i in 1999 o
Showing Interval Partitons Code in DBMS_METADATA.GET_DDL
(Fahd Mirza) If you want to display the system generated partitions as part of the CREATE TABLE DDL, then set the EXPORT parameter of the dbms_metadata to true.
Using WebSphere Cast Iron with OAuth to access Google APIs and Amazon Redshift, Part 1: Extracting data from Google Analytics
(Giovanni Vigorelli and Jervis Lee) This two-part tutorial series demonstrates the flexibility of WebSphere Cast Iron by integrating with popular cloud services such as Google and Amazon Web Services. The tutorial series shows how to authenticate to Google Analytics via Google APIs and OAuth V2, and
Compress XML, String, Variables in Client Side and Export in HTML5 Using jQuery
(Sibeesh Venu) In this article you will learn how to compress a XML, String, Variables in the client side and export in HTML5 using JQuery.
How to Change an AppBar Button Icon at Run Time
(Ged Mead) This is one of those things that’s supposed to be easy, but I found myself going round in circles with it. Most of the suggestions I’ve found talk about swapping out the Segoe UI Symbol character that’s used for the Content property of the App Button.
SQL SERVER – Where is ERRORLOG? Various Ways to Find its Location
(Pinal Dave) Whenever someone reports some weird error on my blog comments or sends email to know about it, I always ask to share SQL Server ERRORLOG file. There have been many occasions where I need to guide them to find location of ERRORLOG file generated by SQL Server.
Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?
(Fernando Laudares and George O. Lorch III) If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later you’ll see the following lines on the server’s error log and chances are you’ll be worried about them: