Loading...

Database tool

  • How to PHP/MySQL/HTML Register Form

    How to PHP/MySQL/HTML Register Form

    View: 591    Download: 0   Comment: 0

    Category: MySQL     Fields: Other

    First we need to create a database to hold the user accounts. This is done through MySQL/PHPMyAdmin.

  • Create Some SQL Query Optimization Technique

    Create Some SQL Query Optimization Technique

    View: 504    Download: 0   Comment: 0

    Category: MySQL     Fields: Other

    It is very important to avoid unnecessary data selection of the query. We should select data field that we need but not all fields of the table.

  • Create Set Up Master And Slave MYSQL

    Create Set Up Master And Slave MYSQL

    View: 566    Download: 0   Comment: 0

    Category: MySQL     Fields: Other

    In this tutorial I am going to teach you one of the most important MySQL techniques that you must use in your software development

  • Insufficient access rights error when doing backup in SQL Server

    Insufficient access rights error when doing backup in SQL Server

    View: 660    Download: 0   Comment: 0

    Category: SQL Server     Fields: none

    All of sudden SQL Server Management studio gives me the following error message when I'm trying to browse for the backup file location.

  • Databases: Visual Database Creation with MySQL Workbench

    Databases: Visual Database Creation with MySQL Workbench

    View: 2244    Download: 0   Comment: 0

    Category: MySQL     Fields: Other

    In today’s tutorial, you’ll learn how to use a visual database modeling utility to draw a database diagram and automatically generate SQL. Specifically, we’ll review how to use MySQL Workbench, a cross-platform, visual database design tool.

  • SQL vs NoSQL: The Differences

    SQL vs NoSQL: The Differences

    View: 628    Download: 0   Comment: 0

    Category: MySQL     Fields: none

    SQL (Structured Query Language) databases have been a primary data storage mechanism for more than four decades. Usage exploded in the late 1990s with the rise of web applications and open-source options such as MySQL, PostgreSQL and SQLite.

  • SQL vs NoSQL: How to Choose

    SQL vs NoSQL: How to Choose

    View: 655    Download: 0   Comment: 0

    Category: MySQL     Fields: none

    In the previous article we discussed the primary differences between SQL and NoSQL databases. In this follow-up, we’ll apply our knowledge to specific scenarios and determine the best option.

  • Fix jtablesession::Store Failed trong Joomla

    Fix jtablesession::Store Failed trong Joomla

    View: 1044    Download: 0   Comment: 0

    Category: MySQL     Fields: Other

    This morning, I recently received an email client notices on their websites to be decommissioned and appearance line error:

  • Accessing: MySQL Database using MySQL C API

    Accessing: MySQL Database using MySQL C API

    View: 2659    Download: 2   Comment: 0

    Category: PostgreSQL     Fields: Other

    This article was written for beginners, developers that do not know how to access MySql database using MySQL C API and would like to have a small introduction.

  • Full Database Abstraction Layer Generator

    Full Database Abstraction Layer Generator

    View: 2774    Download: 0   Comment: 0

    Category: PostgreSQL     Fields: Other

    This article presents yet another Data Abstraction Layer generator (popular topic). The DAL structure is directly inspired from the DotNetNuke, DAL document and the SQL generation is done using SQLpp. The generator takes care of pretty much...

  • Code .NET 2.0; Build Java; Run Linux

    Code .NET 2.0; Build Java; Run Linux

    View: 2265    Download: 0   Comment: 0

    Category: PostgreSQL     Fields: Other

    This article is in the Product Showcase section for our sponsors at CodeProject. These reviews are intended to provide you with information on products and services that we consider useful and of value to developers. This is a showcase review for...

  • Postgres Database Backup/Restore From C#

    Postgres Database Backup/Restore From C#

    View: 3279    Download: 3   Comment: 0

    Category: PostgreSQL     Fields: Other

    This article provides Postgres database backup/restore functionality. By using this application we can check whether a Postgres database is installed or not in a system. If a Postgres database is installed then the Postgres databases list is...

  • Installing Redmine on Windows in production

    Installing Redmine on Windows in production

    View: 7055    Download: 0   Comment: 0

    Category: PostgreSQL     Fields: Other

    This is a very simple step by step guide to install Redmine on Windows server in production. This guide is applicable to IIS 7+ based servers, which include Windows Server 2008, 2008 R2, Windows Vista and Windows 7. Latter two should not be used for...

  • A SQL Management Console for MSSQL 2000 & 2005, MySQL 5.0,...

    A SQL Management Console for MSSQL 2000 & 2005, MySQL 5.0,...

    View: 3583    Download: 2   Comment: 0

    Category: PostgreSQL     Fields: Other

    Since MSSQL is not holding the lion share of the market yet, integration/interaction with other RDBMS like PL/Oracle, MySQL, FireBird, DB2, is inevitable. With the class System.Data.Common in ADO .NET 2.0, different data providers can write the...

  • Migrate MySQL to Microsoft SQL Server

    Migrate MySQL to Microsoft SQL Server

    View: 2781    Download: 0   Comment: 0

    Category: SQL Server     Fields: none

    This article describes a few simple steps in order to migrate MySQL into Microsoft SQL Server 2005. The technique is very easy, but useful if you plan to move your data from MySQL and upgrade it finally to a Microsoft SQL Server environment.

  • COUNT of DISTINCT Rows in SQL Server

    COUNT of DISTINCT Rows in SQL Server

    View: 1584    Download: 0   Comment: 0

    Category: SQL Server     Fields: Other

    SQL Server does not support COUNT(DISTINCT *). For example, the below query fails.

  • Finding SQL Servers on the Network

    Finding SQL Servers on the Network

    View: 925    Download: 0   Comment: 0

    Category: SQL Server     Fields: Other

    I am a TSQL fanatic. The programs I code are highly dependent upon MS SQL stored procedures. I pay for this love of TSQL when a major overhaul of the system is necessary. Sometimes my code needs to be updated heavily in two places; client and...

  • SQL Server and Database Enumerator

    SQL Server and Database Enumerator

    View: 936    Download: 0   Comment: 0

    Category: SQL Server     Fields: Other

    This sample helps you to enumerate the list of SQL Servers and the databases and languages that a particular SQL server has. The class CSQLInfoEnumerator encapsulates this functionality into it.

  • Dynamic Management Views [DMV] – A SQL Server 2005 Feature

    Dynamic Management Views [DMV] – A SQL Server 2005 Feature

    View: 906    Download: 0   Comment: 0

    Category: SQL Server     Fields: Other

    The DMVs; newly introduced in SQL Server 2005 gives the database administrator information about the current state of the SQL Server machine. These values will help the administrator to diagnose problems and tune the server for optimal performance....

  • Creating an Interactive Map in ASP.NET 2.0 Using SharpMap

    Creating an Interactive Map in ASP.NET 2.0 Using SharpMap

    View: 4702    Download: 5   Comment: 0

    Category: PostgreSQL     Fields: Other

    Showing maps on the web is becoming more and more common. The most well-known ones are Google Maps and Microsoft's Virtual Earth. Creating your own websites with interactive maps require you to get hold on the map-data and convert this data to...

 
File suggestion for you
Loading...
File top downloads
Loading...
Loading...
Codetitle - library source code to share, download the file to the community
Copyright © 2018. All rights reserved. codetitle Develope by Vinagon .Ltd