INFORMATION TECHNOLOGY ARTICLES
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.
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.
The next important thing is to get your Mini actually connected to the television. For this you’ll need two cables and (at least one adapter). The adaptor can be purchased from Apple here ($20 USD). Basically what it does is convert DVI (Digital Video Interface) to either S-Video or RCA video out (I recommend using S-Video). (note, you may be lucky enough to have a DVI-in on your television. Check for this first) At this point, you should be able to turn the mini on and use the television as a monitor.
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.
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.
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.
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.