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.
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.
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 remove 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.
If you are running an Ubuntu guest in VMware, you may have found that you cannot switch into the Console mode using Ctrl+Alt+F1. If you try, you will encounter a blank screen and won’t see a login prompt at all.