Tag: DBA Lounge

Building a Windows Server 2008 Cluster, Part 3

In Part 1 of this series, we prepared our Windows Server 2008 servers to be a part of a cluster. Part 2 showed us how we can add the shared disks, install the Failover Cluster Feature, and run the Validate Cluster Configuration Wizard. In this post, we will complete the process by creating a Windows Server 2008 cluster.

Read More >

Twitter — Tracking Production Actions?

don’t want to post the link to this (perhaps, it was left public unintentional?) but here is what I stumbled upon recently. This is a log of production maintenance of IT systems in Perth, Western Australia (as far as I could say): Good idea but shouldn’t companies keep this sort of information private?

Read More >

Google Charts for DBA: Tablespaces Allocation

Pythian DBA’s have daily reports for each monitored database and some of the components are using charts to visualize the data. I’m a big fan of charts myself (when applied appropriately) and want to show how you can generate simple charts directly from the database. You’d be very surprised how easy it can be done from *any* database without installing any additional software or configuring something special.

Read More >

Australia — Helping Victims of Victorian Bushfire

I apologize for off-topic on this blog but I think it’s important…Victoria experienced unprecedented bushfire this month taking lives of almost 180 (the list is growing) people and leaving thousands without homes. This disaster left tears on everyone’s faces even outside of Australia. If you would like to show the compassion and provide some help there are few ways. One of them is to contribute to the Red Cross Bushfire Appeal 2009. You don’t have to be in Australia to do that — you just need to have a big heart and few bucks to share.

Read More >

Building a Windows Server 2008 Cluster, Part 2

In Part 1 of this series, we prepared our Windows Server 2008 servers to be a part of a cluster. In this part, we will look at adding the iSCSI disks to the servers. The series of steps outlined below should be done on both nodes.

Read More >

MySQL Query Analyzer Review

I had the chance to review the new Query Analyzer program from Sun over the last few days. I am very interested in how it performs as I have previously not had a chance to see the program in action (or the Enterprise Monitor program either for that matter). So, before getting into what the Query Analyzer can (and cannot) do let’s look at what Sun says it does.

Read More >

Building a Windows Server 2008 Cluster, Part 1

This happens to be my very first blog post with Pythian, and to kick this thing off, I would like to talk about building a Windows Server 2008 cluster. The goal of this series of posts is to be able to help DBAs who may be charged with installing SQL Server on a Windows Server 2008 cluster. The best approach is to always have an environment on which to run these tests. In my case, I run VMware Workstation 6.5 on my Windows XP laptop. Here are the steps that you need to take.

Read More >

Apparent vs. actual data integrity

I realized tonight exactly why MySQL’s default behavior of silent truncation bothers me. It reminds me of people who use a ticketing system and close every ticket as soon as they are done working on the issue instead of actually asking the other party if they are satisfied, because closing more tickets make it look like they’re doing more work.

Read More >

Remote connections without leaving the mysql shell

You probably know that mysql -h host_or_ip can connect you to a remote host. But did you know that you can change the host you are connected to from within mysql? The undocumented (as far as I can tell, in the MySQL manual and in the “help” on the mysql command line) CONNECT statement can help.

Read More >

Pop Quiz – Index length

A quiz, in 4 parts: Given the following table definition in the sakila database…Please prove your answers with examples. I’ll start off in the first comment with getting you part of the way there, so you can see what a “answer” with an example looks like.

Read More >
Page 42 of 68« First Page...10...4041424344...50...Last Page »