You’ve got a production database server, and you can’t enable query logging… so how do you see the queries being executed against the database?
Microsoft’s SQL Server has a tool called Profiler that you can use to monitor every SQL query that hits the database. This is extremely useful for programmers as well as database administrators to troubleshoot the exact queries generated by an application.
Many utilities need to be run as administrator in order to function properly, especially older utilities that haven’t been updated to support Windows 7 or Vista yet.
In the first part, I ran through the basics on how to connect and configure your Mac Mini as the heart of your entertainment center. In this next article in the series, I had been planning on going into detail on how to store your media files on a remote NFS share. However, one of the comments on the first article got my attention and it occurred to me that I didn’t really cover alternate video codecs at all. So, rather than launch into some fascinating list of iptables rules and Apple alias quirks, let’s look at third-party codecs.
Apple has been pushing the use of the Macintosh as the heart of one’s media center for a long time now, but more specifically since the release of the Mac Mini. With its compact size, low price and FrontRow, it’s the perfect computer to plug into your TV and watch some of those “archived” Lost episodes.
Ever wonder how big a table really is in your database? You know there are a million rows in the table, but how much space is that really taking?
VMWare Workstation is great. The version 6 beta has even more awesome features… but it’s slower than dirt, because debugging mode is turned on by default.
If you’ve worked on a network with Windows servers, you’ve encountered this error message at least 37,000 times:
One of the more annoying things about visiting blogs is having to fill out all the comment fields. They are the same on every blog (including this one). Sure, you can hit the down arrow key and Firefox might remember what you typed last, but it’s still a pain, especially as a blogger when you want to leave a lot of comments.
If you are using an identity column on your SQL Server tables, you can set the next insert value to whatever value you want. An example is if you wanted to start numbering your ID column at 1000 instead of 1.
The find utility on linux allows you to pass in a bunch of interesting arguments, including one to execute another command on each file. We’ll use this in order to figure out what files are older than a certain number of days, and then use the rm command to delete them.
If you can’t stand the User Account Control prompts, but you’d still like to retain a little bit of security, you can disable it for Administrator accounts only. What we’ll be doing is actually changing Windows Vista to automatically elevate the privilege level for administrators without prompting.
Note that this is Not very secure, and should only be used for a local development box where you don’t feel like setting up individual permissions, but still need to connect from other machines.
If you want to share files between your Ubuntu and Windows computers, your best option is to use Samba file sharing.
If you are using the linked clone feature in VMware (and you should be), then you might be annoyed that you can’t move the base virtual machine around without breaking all of the linked clones.
Installing MySQL 5 Server on Ubuntu is a quick and easy process. It almost feels like it should be more difficult.
Installing MySQL 4.1 Server on Ubuntu is a quick and easy process. It almost feels like it should be more difficult.
Ubuntu Server is like any Linux variety, and has full multi-user capabilities, and a common task on any server is adding users.
Screen is like a window manager for your console. It will allow you to keep multiple terminal sessions running and easily switch between them. It also protects you from disconnection, because the screen session doesn’t end when you get disconnected.
Connecting to a server across the internet is much more secure using SSH. There is a way that you can mount a folder on a remote server using the SSHFS service.
If you install Ubuntu from a cd-rom, when you try to use apt-get to install new software it will prompt you for the cdrom every time. Kinda frustrating!
Ubuntu Server has the native ability to run multiple console sessions from the server console prompt. If you are working on the actual console and are waiting for a long running command to finish, there’s no reason why you have to sit and wait… you can just open another console and keep working.
When you are on the Ubuntu server console, you will invariably run commands that scroll past too far to see them on the screen. Since you aren’t in X, there’s no scrollbar for you to use to look back.
If the Ubuntu Server installer has set your server to use DHCP, you will want to change it to a static IP address so that people can actually use it.
Solaris is usually used as a server operating system. Because of this, you want to make sure that you shut the system down as gracefully as possible to ensure there isn’t any data loss.