Blog Aggregator - Amardeep Sidhu

Here are my liveblogging notes from MySQL Sandbox: Easily Using Multiple Database Servers in Isolation by Giuseppe Maxia
Giuseppe has been a community member since 2001, and in the past year or so, a MySQL Employee.
He likes to give things away for free — he gave away T-shirts to the early arrivers to the workshop, and […]

Here are my liveblogging notes from MySQL Sandbox: Easily Using Multiple Database Servers in Isolation by Giuseppe Maxia
Giuseppe has been a community member since 2001, and in the past year or so, a MySQL Employee.
He likes to give things away for free — he gave away T-shirts to the early arrivers to the workshop, and […]

I’m at Collaborate 08 in Denver these days. I arrived yesterday evening so I haven’t had a chance to see any sessions yet but I did have a nice dinner with a bunch of OakTable folks. The steak wasn’t great but the best part was that I could enjoy my time with people I don’t […]

I’m at Collaborate 08 in Denver these days. I arrived yesterday evening so I haven’t had a chance to see any sessions yet but I did have a nice dinner with a bunch of OakTable folks. The steak wasn’t great but the best part was that I could enjoy my time with people I don’t […]

Yesterday I presented “Best Practices for Database Administrators” at the MySQL User Conference and Expo. I was successful in streaming the live video on www.ustream.tv, and you can see it in totality at http://www.ustream.tv/recorded/352479.
The slides are available in pdf form. And here are some of the links I spoke about:
cacti
nagios
rt
MySQL 5.0 manual
explain
show variables
show […]

Jonathan Schwartz’s Keynote at the 2008 MySQL Conference can be played directly in your browser or you can download the 147MB .wmv file. (Please do not download the movie on the conference wireless system!)
I finally realized who Jonathan Schwartz reminds me of:

That’s right, comedian and magician Penn Jillette.
Schwartz started by saying, “enough of this […]

Here are two new YouTube videos featuring Anjo Kolk and me. These were filmed at the Miracle SQL Server Open World event held April 3, 4, and 5 at Lalandia in Rødby, Denmark.

Mogens Nørgaard introduced these videos with the statement, “May I present the new Miracle TV concept called SlowTV…. where people don’t have to stare into the lens while trying to remember what they were talking about, but can roam freely with their eyes, just like in real life.”

• Stop Guessing - Anjo Kolk, Miracle Benelux
• Cary Millsap stopped guessing

Although by no means as common as it once was, there’s still some who believe separating indexes in a different tablespace from their parent tables somehow improves performance.
The theory goes that by having indexes in their own tablespace, we can reduce overall contention issues and thereby improve the overall performance of the database.
Here are some […]

I am sitting in my hotel room, bathed in beautiful sunshine as the sun dips towards the snow-capped mountains. Better make the most of it for tomorrow is forecast to be a lot (like 19ºC) colder and maybe even a touch of snow. Not that we will see much of the outdoors from the convention […]

If you’ve read many of my blog posts, you know that I consider lack of procedure cache control to be a major SQL Server pain point. Badly written apps that use non-parameterized ad hoc queries can quickly flood SQL Server’s memory pools and bring the server to its knees.
SQL Server 2005 brought some relief in […]