(Dave Beulke) Channel surfing the other night I came upon the C-SPAN video replay of the congressional testimony regarding the Healthcare.gov website. Thinking about all the testimony and the political partisan points I was amazed at the project planning comments, lack of understanding of the techn
Author: SSWUG Research
MySQL Binary Log Parsing With Pt-query-digest
(Ike Walker) I frequently use pt-query-digest to parse the MySQL slow query log. This morning I wanted to parse the MySQL binary log to find out how frequently various tables in my database are updated. A quick check of the pt-query-digest documentation confirmed that pt-query-digest does support pa
SQL Server Analysis Service DAX Time Intelligence
(Scott Murray) What date related functions are available in DAX for the Tabular Model version of SQL Server Analysis Service (SSAS)?
Delivering Fast Analytics Query Responses
(Jeannie Cramer and Terrence O’Donnell) In addition to IBM DB2 Version 11 for z/OS data management, IBM announced the recent release of DB2 Analytics Accelerator for z/OS Version 4.1. When combined with related prerequisite hardware and prerequisite software, this solution offers high-performance te
When the Oracle wait interface isn’t enough
(Frits Hoogland) Oracle has done a great job with the wait interface. It has given us the opportunity to profile the time spend in Oracle processes, by keeping track of CPU time and waits (which is time spend not running on CPU). With every new version Oracle has enhanced the wait interface, by maki
12c Adaptive Optimization – Part 1
(Kerry Osborne) Last week I did a webinar on 12c Adaptive Optimization. The talk was recorded. The slides are here: 12c Adaptive Optimization V2 PDF. The recording can be found here: 12c Adaptive Optimization Recording. There were a number of follow up questions and emails so I thought I’d summarize
MySQL Synonym?
(Michael McLaughlin) Somebody asked how to create a SYNONYM in MySQL, which is interesting because MySQL doesn’t support synonyms. I thought the prior entry explained how to do it, but here’s a new post. However, you can create a view in one database that relies on a table in another database.
ORA-00026
(Andrew Reid) This was tested on Oracle 9. When you use the ALTER SYSTEM KILL SESSION command, you must supply the SID and SERIAL# from an entry in V$SESSION. You get an ORA-00026 if you do not provide one:
jQuery Image Slider in ASP.Net
(Rohatash Kumar) Here you will see a jQuery image sliders control that is very useful for displaying images and photos and making the viewing of images more pleasant and intuitive on our website. In this article we make an auto-playing image slider. Users can also manually select content to see or h
XML Example With RESTEasy+ JAXB
(Nikos Maravitsas) In this example we are going to see how you can integrate RESTEasy with JAXB (Java Architecture for XML Binding) to create RESTful services that consume and produce XML streams. As you probably know JAXB is used to marshal a Java Object to XML, and ummarshal an XML file (or stream