(Charlie Killian) Using pt-query-digest is an excellent way to perform a SQL review. However, sometimes you don’t have access to the slow_query_log_file. For example, when MySQL runs on Amazon RDS, the slow_query_log_file is unavailable (see the RDS FAQ). To get around this, export the mysql.slow_lo
Other News
IBM Cognos Proven Practices: IBM Cognos 10 Audit Extension
A IBM Cognos 10 SDK application that provides additional auditing, including Role Auditing, for IBM Cognos 10 BI. The version of the application is 1.1.01 and it will work with IBM Cognos 10 BI versions 10.1 and up.
To find out the size occupied by indexes in a table
(SQLZealot) The below procedure will return the size occupied by the indexes in a table. This will be helpful to measure the size before and after the maintenance activities.
Readers Comments
Reader’s Comments Today I’ll share a number of comments from our readers covering Disk Partition Alignment and Visual COBOL. Disk Partition Alignment Leif Writes: This is true for Windows Server 2003 and earlier where the default alignment was 16K, 32K or 48K depending on the storage system behind, but for Windows Server 2008 and later (atm. Windows Server 2008 R2) […]
Disk Partition Alignment
SSWUG TV With Stephen Wynkoop Get the latest news on Oracle’s purchase of RightNow Technologies Watch the Show Disk Partition Alignment How much would it be worth to get significant improvement on you Windows Servers for Files, Exchange, or even SQL Server? What if your only investment was time? Well, if the concept of Disk Partition Alignment is new to […]
Scrape Site Content with Simple HTML DOM Parser in PHP
(Armando Roggio) Web scraping is a helpful technique for comparing prices; collecting unstructured site content and organizing it in a way that is easier to present; and even collecting data for a multi-site search feature.
Auto DOP And Direct-Path Inserts
(Randolf Geist) This is just a short note about one of the potential side-effects of the new Auto Degree Of Parallelism (DOP) feature introduced in 11.2.
Experimenting with ADF BC Application Module Pool Tuning
(Andrejus Baranovskis) This week we were performing advanced ADF BC Application Module pool tuning. There are few lessons learned, I would like to share with you. Tests were performed using latest JDeveloper/ADF release 11g R2 (11.1.2.1.0) (Build 6081). Test case is based on sample application fro
SharePoint 2010 HierarchicalConfig Caching Problem
(Damon Armstrong) We’ve started using the Application Foundations for SharePoint 2010 in some of our projects at work, and I came across a nasty issue with the hierarchical configuration settings. I have some settings that I am storing at the Farm level, and as I was testing my code it seemed like
How to convert an SQL statement into a XML file
(Hosk) Today I found some functionality which I thought was amazing and will save me loads of time creating some sample XML files to test my webservice with.