Blog Aggregator - Amardeep Sidhu

Welcome to the 90th edition of Log Buffer, the weekly review of database blogs.
First, SSQA.net’s SQL Master offers his walk-through of best practices for installing SQL Server 2005, with clustering as the destination.
If you read SQL Server blogs, you already know Adam Machanic. I’m very pleased to mention his first post for the […]

I visit Oracle Forums  pretty often. At least when I am at home or I am able to have internet access for some time when I am traveling,I like to have a visit there for sure. Its a good place to learn, share and some time have a little fun also. Well for the fun […]

I like to go to Cafe Coffee Day very much. There are two reasons for it. One that I like the different flavors of coffee which are there. Second and I guess the most important one is that I like to sit there with myself. The location where I go is having a special corner […]

I never thought that starting up Oracle is difficult. Usually it looks something like this:

sqlplus / as sysdba
startup

Except when Oracle is used on Windows. We have one or two dev servers installed on Windows, but in the three years I’ve been working as a DBA, I never had to restart one. Today, I connected to […]

Whilst I remember it, Venkat has written up another excellent OBIEE article, this time on performing multi-user development against an OBIEE repository.
This uses the new “Projects” feature introduced in a recent release of OBIEE, and allows individual developers to “check out” logical fact tables and their corresponding dimensions, make some changes and check them back […]

I ran the first day of the Enterprise Business Intelligence Masterclass in Bucharest today, we had around twenty delegates who were a mix of Oracle staff, partners and customers.

After the seminar finished, I took a walk down from the venue to the historic part of Bucharest. I can see why Bucharest is called the “Paris […]

mysql-proxy defaults to round-robin load balancing. There are fancy tricks around to get mysql-proxy to balance connections based on how many idle connections there are in a proxy-based connection pool.
But there is no code that I found that would simply load balance based on “always go to one server, go to another […]