Kal-Admin

Additional features

Methodology Based Software

Provides database functionality tailored for all stages of the Software Development Life Cycle (SDLC).

Data Dictionary

A repository for Business Analysts to store definitions, descriptions, and business terminology of data elements, used for building database tables.

Tables Design

Allows defining table structures using the Data Dictionary without immediately building them in the database, with a click-to-build option after QA.

Documentation

Enables documenting every object in the database, including column descriptions and linked lookup tables for code translation.

Permission Management

Centralized control for managing SQL Server user permissions, displaying user rights across servers and databases, and identifying admin/ownership roles.

Version Control

Associates all database changes with specific version numbers and allows assigning different versions to different users for simultaneous work.

Version Distribution

Facilitates one-click distribution of version-related database changes from Development to Test to Production environments.

Distribution History

Displays a detailed history of object distributions, including who, when, where, and the script of the distributed object.

Data Comparison

Compares data between two or more tables and provides synchronization capabilities.

Database Structure Comparison

Synchronizes database structures and is noted for its user-friendliness and simplicity.

Change Management

Tracks who changed what, when, and the nature of changes, allowing searching by Version, Dates, User, or Object, and distribution to multiple databases.

Task Management

Provides a powerful yet simple project management tool for team or individual tasks.

Activity Management

Enables planning and synchronizing the work of multiple team members and monitoring real-time progress, ideal for time-sensitive deployments.

SQL Jobs Management

Displays all SQL Jobs across servers, including failed jobs, last run times, average durations, Gantt chart views, and customizable alerts for job failures or completions. It also allows documenting jobs and assigning alert recipients.

Organization-Wide Database Information

Quickly provides information such as a list of all databases, the biggest database, monthly growth rates, and recent Sysadmin permission grants.

User Control Information

Lists users with control over databases and recent changes made by specific users to procedures that failed.

SQL Server Health Information

Identifies SQL Servers lacking the latest service pack and lists blocking locks that occurred.

Deployment Information

Provides insights into recent production changes and the duration of deployments.

Task Efficiency Insights

Helps identify the most time-consuming tasks and the average time for specific deployments.

Object Discovery

Quickly locates specific tables (e.g., a 'countries' table) across the organization's databases.

Database Structure Analysis

Identifies tables without a Primary Key and procedures using a specific table.

Lookup Table Management

Displays a list of lookup tables, allows copying them to other databases with a click.

Object Cleanup

Facilitates deleting objects with "tmp" in their name, with an option to rename tables with data instead of deleting them.