SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

If you use the SQL command line to mine the records in your tables, you’ll discover that a JOIN may be the best tool for finding the information you need. This week, I’ll explain the basic ...

You’re looking to use the MySQL database for your web-based tool, but can’t connect that tool to an empty database. The MySQL command line can be a bit daunting at first, but once you get the ...