Tag Archives: Database

Just an example How to create a new database in Microsoft SQL Server by using SQL statement. Before creating, we need to check whether the database is already exited or not. Continue reading →

Another half of hour to find the database configuration in a very popular CMS: CakePHP but I don’t know, unfortunately. What’s a beautiful day when I have change to configure 2 new (with me) CMS: Drupal and CakePHP. Continue reading →

I’ve received a request to modify some pages of a website which is based on Drupal. Unfortunately, I hear about Drupal so many times but I don’t have any experience about it at all. Continue reading →

SQL Server Express 2008 is the best solution for those who want to minimize the cost with full-featured relational database. It fully support Tables, Views, T-SQL, Stored procedure, Functions and Trigger. It’s FREE so you can save a lot of money when build and deploy from small to medium desktop applications or web applications. Continue reading →

Creating a job to schedule backup databases automatically is a very important task for each database administrator. Database is always irreplaceable and is the heart of all online business therefore this process must be the first thing in the process of database administrating to ensure it’s super safe. Continue reading →

It’s good idea to monitor or log all SQL Queries to your MySQL Database. There is a simple way and tool to trace all MySQL activities similar to Microsoft SQL Server Profiler. This is great stuff for both developers and database administrators to debug, troubleshoot and deeper understand which SQL commands are submitted to your MySQL database. Continue reading →

We usually use phpMyAdmin which is written in PHP to manage MySQL but with SQL Server or Oracle, there is a tool called 1 Click DB which is an Open Source Web Database Administration using ASP to handle almost features to manage database, tables, indexes, users and triggers via a web-based interface. Continue reading →