Database

Connecting to MS SQL Server 2008 R2 Exp via EMS SQL Mgr for SQL Server
Connecting to Microsoft SQL Server 2008 R2   Express via EMS SQL Manager for SQL Server   EMS SQL Manager for SQL Server is a high performance   tool for M...
Thu, 15 Oct, 2015 at 4:36 PM
Upgrade/Upload an Access database to SQL database using DTS?
The following article describing the steps you can take to convert your existing Microsoft Access database to a SQL Server database using component of Micro...
Thu, 15 Oct, 2015 at 4:50 PM
Connecting to MS SQL Database, MS Access Database or MySQL Database
Applied on Windows Server   Connection String is a string which contains database connection information and it will be passed to the Driver Manager and dri...
Tue, 20 Oct, 2015 at 12:21 PM
Securing a Microsoft Access Database (MDB) File
On windows (ASP) hosting account, many account holders are using MS Access for their database needs. The MS Access Database is a single file containing vari...
Tue, 20 Oct, 2015 at 12:21 PM
Trim Your SQL DBs Log Remotely
The SQL Log records transaction made into database. These log-entries can be used later to check the actions with database. It also used to ensure database ...
Tue, 20 Oct, 2015 at 12:21 PM
How to Easily Check Space Usage in Your Microsoft SQL Database
Applied on: Windows Hosting Account with SQL Server Database   This step show you the space usage by your SQL database and by its log file. This will show ...
Tue, 20 Oct, 2015 at 12:22 PM
Referenced Objects Finding in SQL Server
Applied on: Windows Hosting Accounts   When working with a large amount of objects in sql server there are times when you want to know what columns or fiel...
Tue, 20 Oct, 2015 at 12:22 PM
Repair and Optimize MySQL Databases with WebsitePanel and phpMyAdmin
In this article I will explain how to repair and optimize MySQL databases with WebsitePanel and phpMyadmin.   Overview   Databases need maintenance from t...
Tue, 20 Oct, 2015 at 12:22 PM
Using Microsoft SQL Management Studio for knowing Database Disk Usage Report
Microsoft SQL Server Management Studio can be used to generate Standard Reports for viewing system activity, statistics and performance. In this article I wi...
Tue, 20 Oct, 2015 at 12:23 PM