YourSqlDba

  •        75

T-Sql Database script that automate database maintenance using SQL Agent an DB Mail. Performs optimizations (index, statistics), integritry check, databases backups (complete and tx logs).

http://yoursqldba.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

Jailer - Database Subsetting and Browsing Tool

  •    Java

Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML.

MySQL Workbench - Visual database design tool for MySQL

  •    C++

MySQL Workbench is a visual database design tool. The tool is specifically for designing MySQL database. MySQL Workbench provides DBAs and developers an integrated tools for Database Design & Modeling, Query browser, Database Administration.

SQL Server Backup

  •    

SqlAdmin Backup makes it easier to created and maintain database backups in a organisation with several installations. The database backups are standarzied to help quick and safe administration and recovery. This tool is developed in C# using ADO.NET with prototyping in Powe...

phpMoAdmin - MongoDB administration tool for PHP

  •    PHP

phpMoAdmin is a MongoDB administration tool for PHP. It helps to create, drop and repair database and indexes. It provides support to view and search on data, Provides stats on database uptime and memory, Import/export data in JSON format.

FlameRobin - Database Administration Tool for Firebird

  •    C++

FlameRobin is lightweight cross platform database administration tool for Firebird RDBMS.


Chive - MySQL Data Management tool

  •    PHP

Chive is a free, open source, web-based database management tool, designed to bring joy to web developers - with easy administration and super fast UI. It supports Repeated administration of your SQL queries by saving and re-execute them, Analyze and Optimize your queries with Profiling and lot more.

DBeaver - Universal SQL Manager and SQL Client

  •    Java

DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

IBPP, a C++ API for Firebird Server

  •    

IBPP is a C++ client class library for FirebirdSQL

Barman - Backup and Recovery manager for PostgreSQL

  •    Python

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers . It allows your organisation to perform remote backups of multiple servers in business critical environments and to help DBAs during the recovery phase. Its features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups.

RockMongo - MongoDB Administration Tool in PHP

  •    PHP

RockMongo, a MongoDB administration tool, written in PHP5, is Best in PHP world, more like PHPMyAdmin.

django-smuggler - Django Smuggler is a pluggable application for Django Web Framework that helps you to import/export fixtures via the automatically-generated administration interface

  •    Python

Django Smuggler is a pluggable application for Django Web Framework to easily dump/load fixtures via the automatically-generated administration interface. A fixture is file with model data serialized to e.g. JSON or XML that Django knows how to import to the database. Smuggler is especially useful for transporting database data between production and development environments, but can also be used as a backup tool.

PHPMyAdmin

  •    PHP

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Apache Rivet - Server-side Tcl programming system combining ease of use and power

  •    Tcl

Server-side Tcl programming system combining ease of use and power

pgAdmin - Administration and development platform for PostgreSQL

  •    C

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

JavaDB

  •    Java

Java DB is Sun's supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2.5 MB.

PostgreSQL - Powerful, Open Source Object-Relational Database System

  •    C

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It has native programming interfaces for most of the programming language.

GLPI - Asset Management Software

  •    PHP

GLPI is the Information Resource-Manager with an additional Administration- Interface. You can use it to build up a database with an inventory for your company (computer, software, printers...). It has enhanced functions to make the daily life for the administrators easier, like a job-tracking-system with mail-notification and methods to build a database with basic information about your network-topology.

Infobright - The Database for Analytics

  •    C++

Infobright combines a columnar database with our Knowledge Grid architecture to deliver a self-managing, self-tuning database optimized for analytics. Infobright eliminates the need to create indexes, partition data, or do any manual tuning to achieve fast response for queries and reports.

MDT Administrator

  •    

A fast and slick administration tool for doing everyday tasks with the MDT database, like staging computers, managing roles etc.

MapD - The MapD Core database

  •    C++

MapD Core is an in-memory, column store, SQL relational database that was designed from the ground up to run on GPUs. MapD Core is the foundational element of a larger data exploration platform that emphasizes speed at scale. By taking advantage of the parallel processing power of the hardware, MapD Core can query billions of rows in milliseconds. Furthermore, by using the graphics pipelines of GPUs, MapD Core can render graphics directly from the server.