Release 2.5.0 (Build 2534)

Release Date: May 04, 2025

What's New in This Update?

We are excited to announce the release of AI-DBA Version 2.5.0, introducing several new features and enhancements aimed at improving the performance, functionality, and security of your database management experience. Below are the key highlights of this release:

Improvements:

1. Performance Insight: Automation rules have been added to the blocking tab, allowing users to set rules to automatically terminate head blockers based on predefined criteria. This enhancement streamlines the process of resolving blocking issues and optimizing performance.
2. Health Check: Users now have the ability to abort a health check process midway, enabling them to release resources and manage system resources more efficiently. This feature provides greater flexibility during health check operations.
3. Portal Search: The portal now features a global search bar that allows users to search across all resources and configurations from a centralized location. This enhancement simplifies navigation and improves the user experience when searching for specific information within the portal.

New Features:

1. Data Access Pattern: A new graphical user interface and graphs have been introduced to showcase user/login behavior and data access patterns. The backend engine closely monitors activities to identify abnormal behaviors, providing users with valuable insights into data access patterns.
2. Vulnerability and Exposure: AI-DBA now integrates with the Microsoft Security Response Center to identify cybersecurity threats and provide users with timely information and security updates. This feature enhances the security posture of your database management system by proactively addressing potential vulnerabilities. We believe that these new features and improvements in AI-DBA Version 2.5.0 will enhance your database management capabilities, improve performance insights, streamline operations, and bolster security measures. We are committed to continuously evolving and enhancing AI-DBA to meet the dynamic needs of modern database environments.

Release 2.4.0 (Build 2426)

Release Date: March 10, 2025

What's New in This Update?

We are excited to announce the release of AI-DBA for SQL Server Version 2.4.0. This version introduces a host of new features, enhancements, and fixes aimed at improving the functionality and user experience of our database administration tool. Below is a detailed list of what's new in this release:

1. Credit Voucher System: Users can now enjoy discounts provided by principals through our new credit voucher feature. This addition is designed to make our services more accessible and cost-effective.
2. Enhanced Subscription Page: The subscription page has been revamped to display the daily cost forecast, providing users with valuable insights into their consumption patterns. This feature aims to help users manage their expenses more effectively.
3. Multiple Payment Methods: To enhance the flexibility of our payment system, users can now add multiple payment methods, including primary and secondary credit cards. This update provides a seamless payment experience, accommodating different user preferences.
4. Upgraded Capacity Planning: The capacity planning feature has been significantly enhanced. It now offers a detailed trend analysis and forecast of resource consumption, including storage, memory, and processor resources. This upgrade includes a descriptive analysis to help users plan and optimize their resource allocation more efficiently.
5. Advanced Performance Insights: The performance insight feature has been upgraded to provide detailed information on memory consumption by objects and databases. This enhancement allows for more precise performance tuning and management.
6. Fixed Recommendation Bugs: Issues with the 'Approve' and 'Abort' buttons in our recommendation engine have been resolved, ensuring a smoother and more reliable user interaction. 

We believe these updates will significantly enhance your experience with AI-DBA for SQL Server, making it more powerful, user-friendly, and aligned with your business needs. We encourage all users to update to the latest version to take full advantage of these improvements. Thank you for your continued support and trust in AI-DBA. We are committed to continuously improving our software to meet your evolving needs in database administration.

Release 2.3.0 (Build 2347)

Release Date: January 28, 2025

What's New in This Update?

We are excited to announce the release of AI-DBA version 2.3.0, packed with new features and enhancements to optimize your database management experience. Here's what's new:

1. Gateway Resource Optimization: Experience enhanced resource utilization with our gateway service. Now, a single gateway can support up to 58 enrolled database servers with 8 processor cores and 32GB of main memory, ensuring efficient performance.
2. Gateway Processor Affinity Setting: Take control of your gateway service's processor usage. With the new "ProcessorAffinity" application key in the configuration file, administrators can limit the processor usage of the gateway by setting processor affinity.
3. Database Server Uptime Tracking and Analysis: Gain valuable insights into your SQL Server instances' uptime. Our system now tracks the uptime of enrolled servers and provides analysis on the uptime percentage, helping you monitor and optimize your database performance.
4. Multi-Account per User: Account administrators can now invite independent consultants to manage their AI-DBA accounts. With granular permissions, you can collaborate seamlessly and ensure efficient database management across your team.
5. Multi-Factor Authentication with SMS: Strengthen your account security with our new Multi-Factor Authentication feature. Receive One-Time Passcodes (OTPs) via SMS for an added layer of protection, ensuring only authorized access to your AI-DBA account.
6. Multi-Language Support: We understand the importance of a user-friendly experience for users of different languages. Our portal now supports multiple languages, making it easier for non-English speakers to navigate and utilize the AI-DBA platform.

Upgrade to version 2.3.0 today and take advantage of these powerful new features to optimize your database management workflow. If you have any questions or need assistance, our support team is here to help. Enjoy the enhanced capabilities of AI-DBA.

Release 2.2.0 (Build 2283)

Release Date: December 31, 2024

What's New in This Update?

Here's an explanation of the new feature and bug fixes for the AI-DBA product:

1. Tag Management: Easily manage and search for enrolled servers with user-defined tags, improving resource management.
2. Query Templates: Access a variety of pre-defined query templates for administration, security, performance, and maintenance. Save queries as templates within your subscription or share them globally with other users.
3. Enhanced Security: Whitelist specific user access through designated IP addresses for added security.
4. Data Profiling: Analyze and gain insights from existing data with the new data management and profiling feature.
5. Improved Performance Insight: Detect and resolve query blocks with dynamic visual enhancements for a better performance monitoring experience.

These feature enhancements aim to enhance usability, performance monitoring, proactive issue resolution, data security analysis, and query optimization, providing users with a more powerful and efficient AI-DBA experience.

Release 1.8.0 (Build 1800)

Release Date: February 14, 2024

What's New in This Update?

Here's an explanation of the new feature and bug fixes for the AI-DBA product:

1. Backup and Recovery: This new feature allows users to perform database backups and recoveries directly through the portal. It simplifies the process of safeguarding and restoring databases, providing users with a seamless and intuitive experience when managing their database backups and recoveries. It supports local storage, Azure blob storage, and remote server storage.
   
2. Backup verification in the documentation: This enhancement adds the functionality to export backup verification results into the documentation. Users can now easily access and review the backup verification results, providing them with a comprehensive record of the backup status and ensuring data integrity.
   
3. Engagement: This new feature allows users to engage the services of a support engineer at a flat rate per support session or for a specified period for project based works. Users can get an expert assistance to troubleshoot or implement SQL Server projects, ensuring timely and efficient solutions to any database issues they may encounter.
   
4. Subscriptions and payment methods: This new feature enables users to manage their subscriptions within the AI-DBA product. Users can review invoices, manage payment methods, and access cost forecasts, providing a convenient and transparent way to handle their subscription details.
5. User Sign-Up: The User Sign-up Process now features a user-friendly interface, designed to provide a smooth and effortless sign-up experience. Users will be guided through each step, making it easier than ever to create an account.

Fixed Issues:

1. Data Gateway service unable to start: this bug was related to permissions on the service assemblies to reference KERNELBASE.DLL file located in C:\Windows\System32.

Release 1.6.0 (Build 1600)

Release Date: November 05, 2023

What's New in This Update?

 Here are the explanations of the new features for the AI-DBA product:

1. Descriptive database insight via OpenAI: This feature utilizes OpenAI technology to generate in-depth insights for hosted databases. By analyzing the database structure, schema, and data patterns, it provides valuable information to database administrators. These insights help DBAs make informed decisions about performance optimization, data management, and security measures.
2. Move and copy databases to another server: With this feature, DBAs can effortlessly transfer or duplicate databases to another server with minimal effort. This simplifies the process of database migration or replication, allowing DBAs to efficiently manage and distribute databases across different servers as per their requirements.
   
3. Exclude databases from telemetry data and recommendation service: This feature allows DBAs to exclude specific databases from the telemetry data and recommendation service. By doing so, DBAs can ensure the privacy and confidentiality of sensitive databases or those with special requirements. These excluded databases will not be considered for data analysis or AI-generated recommendations.
4. Recommendation script explanation by AI: With this feature, every recommendation provided by the AI is explained in a clear and concise manner. This helps DBAs understand the reasoning behind each recommendation and addresses any doubts or questions they may have about the recommended scripts. This enhances the transparency and confidence in implementing the recommended actions.
   
5. Generate documents based on specific topics and health check periods: This feature enables DBAs to generate comprehensive documents and benchmarks for specific topics or defined health check periods. DBAs can specify the areas they want to focus on and the desired scan period. The AI-DBA system then generates insightful reports and benchmarks that assist in database performance monitoring, capacity planning, and maintenance tasks.
6. Database snapshot directly from the new portal: This feature allows DBAs to create database snapshots directly through the new portal. With just a few clicks, DBAs can capture a point-in-time snapshot of a database, providing a backup or recovery option in case of any issues. This simplifies the process and ensures the availability of reliable snapshots when needed.
   
7. Database insight in documentation: As part of this feature, the database insights are integrated into the documentation. This means that DBAs can access relevant database insights directly from the documentation, making it convenient and efficient to access the necessary information when managing and maintaining databases.
   
   These new features enhance the capabilities of the AI-DBA product, providing DBAs with advanced tools and functionalities to streamline database management, optimize performance, and make informed decisions.