Install Microsoft SQL Server
The installation of Microsoft SQL Server, like that of various modern products is fairly easy, whether you are using a CD called SQL Server Developer …
Latest articles for category: Database
Using the mysql_upgrade Command
What is mysql_upgrade? If your server runs MySQL databases, then the mysql_upgrade command is one you’ll want to familiarize yourself with. Available only in Unix, …
How to Install MySQL Server
With it’s ease of use and high reliability, MySQL is one of the most popular database solutions in the world. If you’re looking for instructions …
Access MySQL from the command line
mysql -u -p -h By default you would use the root user with no password if connecting to localhost only. While it does simplify administration …
MySQL Cluster vs. Replication
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave …
What to Do if MySql.sock File is Missing
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your …
Enable the full text indexing for a MSSQL database
Syntax sp_fulltext_database Initializes full-text indexing or removes all full-text catalogs from the current database. sp_fulltext_database [@action =] ‘action’ Arguments [@action =] ‘action’ Is the action …
View the Contents of a Table in a SQL Server Database Using Enterprise Manager
How to View a Table in a SQL Server Database Need to know how you can view a table within a SQL server database? Using …
Connect to my MSSQL database via Enterprise Manager?
To connect to your MSSQL database using Enterprise Manager, please perform the following: 1. Bring up Enterprise Manager. 2. Go to menu “Action”->”New SQL Server …
Reset the SQL Server ‘sa’ user password?
Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on Logins. Right-click the user “sa” and select Properties. Type the new password …
Restrict clients using my SQL Server by their IP Address?
SQL Server has no built-in support for restricting clients by IP address. The most common work-arounds are firewalls, IPSec, or third-party network layer filters to …
Showing 23 - 33 of 47 articles