Blog Aggregator - Amardeep Sidhu

Welcome to the 93th edition of Log Buffer, the weekly review of database blogs.
Conference season is upon us, so it’s been a busy week. There was the MySQL Conference & Expo, so let’s look at that.
Arjen Lentz posts about Sunday’s community dinner, including the arrival of an unexpected guest. Two […]

There are deployments and there are deprayments. What’s the difference?

A deployment is when you deploy a change and verify that it was successfully deployed and functioning properly.

A deprayment is when you “deploy and pray.” It’s kind of like Dr. Evil in the Austin Powers movie: you don’t actually witness that the deployment succeeded, you just walk away and assume everything went

Today I was searching for an error message in metalink and it was giving strange messages. Then i came to know that the error message contained “%” character and metalink was not really happy searching for it. Rather it showed a confusing message:

Pretty strange…

In Part I, I discussed how separating indexes from tables won’t likely improve performance as:

Oracle moves from reading index blocks to table blocks in a sequential manner
Most of the associated I/Os are likely to be random anyways
Multi-User environments would result in disk contention regardless

That being said, why is it then some sites claim performance improvements after separating indexes […]

After the various sessions in the afternoon, I finished off yesterday with a meal with ODTUG, the Oracle Developer Tools User Group (I’m one of their SIG leaders). Apart from Mike Riley, John Jeunette, Jerry Ireland, Jeff Jacobs and John King, Kathleen and Karen (who do a lot of the organizing), we also had Dan […]

Did you know that in addition to SYSDATE, there is also a SQL function called CURRENT_DATE? Basically, they are the same except one important difference.

SYSDATE returns the current date and time set for the operating system on which the database resides whereas CURRENT_DATE returns the current date in the session time zone.

Here is a quick […]

10,000 Tables Can’t Be Wrong: Designing a Highly Scalable MySQL Architecture for Write-intensive Applications by Richard Chart
Chose MySQL for performance and stability, and less important but still there, experience and support. Support is becoming increasingly more and more important.
Starting point: 1 appliance supporting 200 devices
Problem/Goal: Extensible architecture with deep host and […]

Here are the slides and links I am using for the “Database Security Using White-Hat Google Hacking” at the 2008 MySQL Users Conference and Expo.
pdf slides
Where to Start:
http://johnny.ihackstuff.com/ghdb.php
i-hacked.com/content/view/23/42
for the impatient
Google’s Terms of Service
Google Operators
More Googlehacks to run:
Page 35 of http://www.sdissa.org/downloads/San%20Diego%20ISSA%20Google%20Hacking%20and%20Beyond%20May%202006-rhd.pdf
http://pauldotcom.com/wiki/index.php/Episode81#Tech_Segment:_Google_Queries_To_Run_Against_Your_Own_Domain
http://ferruh.mavituna.com/makale/sql-injection-cheatsheet/
Goolag
Google Hacks sofware
Google Hacks Honey Pot
www.robotstxt.org
Wikto
Nikto

Here are the slides and links I am using for the “Database Security Using White-Hat Google Hacking” at the 2008 MySQL Users Conference and Expo.
pdf slides
Where to Start:
http://johnny.ihackstuff.com/ghdb.php
i-hacked.com/content/view/23/42
for the impatient
Google’s Terms of Service
Google Operators
More Googlehacks to run:
Page 35 of http://www.sdissa.org/downloads/San%20Diego%20ISSA%20Google%20Hacking%20and%20Beyond%20May%202006-rhd.pdf
http://pauldotcom.com/wiki/index.php/Episode81#Tech_Segment:_Google_Queries_To_Run_Against_Your_Own_Domain
http://ferruh.mavituna.com/makale/sql-injection-cheatsheet/
Goolag
Google Hacks sofware
Google Hacks Honey Pot
www.robotstxt.org
Wikto
Nikto