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 ...

Maybe I'm going about this the hard way, but here's what I'm trying to do:<BR><BR>I need to run a script on a central workstation that will run a query on two remote MySQL boxes and return the output ...

<B>Background</B>:<BR>My only real programming experience is a C++ course I took nearly 10 years ago. My current job has me all sort of things, one of which is some rudimentary level IT work. Usually ...

Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

Importing MySQL databases into FileMaker Pro offers a quick-start to the development of new workgroup solutions.

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

The MySQL Workbench main window. How to create tables and add data to MySQL database with MySQL Workbench Your email has been sent The MySQL Workbench GUI is cross-platform, open source, and ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...