Softpedia >Windows >Internet >Servers >Database Utils >SqlDbAid >  Changelog

SqlDbAid Changelog

What's new in SqlDbAid 2.6.1.7

Feb 23, 2021
  • Fixed Indexes Status Report error when trying to run it from the table context menu

New in SqlDbAid 2.6.1.5 (Jan 25, 2021)

  • Improved Indexes Status Report performance

New in SqlDbAid 2.6.1.4 (Dec 29, 2020)

  • Fixed column store index scripting
  • Added Missing Indexes for views

New in SqlDbAid 2.6.1.1 (Feb 11, 2018)

  • Fixed check for update

New in SqlDbAid 2.6.1.0 (Feb 11, 2018)

  • Processes report is no longer filtered by the current database and the column layout has changed
  • SqlDbAid now requires .NET Framework 4.5 or later

New in SqlDbAid 2.6.0.0 (Sep 4, 2017)

  • Option form allows to manage your servers list
  • Search Text now supports regular expressions
  • Added Deadlocks report
  • Filtered indexes are now supported
  • Improved Processes Report

New in SqlDbAid 2.5.0.0 (Oct 24, 2016)

  • Indexes Status Report now shows total reads and last read date
  • Offline Compare now highlights most recent modify date

New in SqlDbAid 2.4.5.0 (Sep 12, 2015)

  • Processes Report now shows the script fragment currently running (full script moved into sql_task column)
  • Minor bugs fixed

New in SqlDbAid 2.4.3.0 (Nov 3, 2014)

  • Added Column Definition Inconsistency Check from my blog

New in SqlDbAid 2.4.2.0 (Feb 17, 2014)

  • Color scheme updated to SQL 2012
  • Fixed Server Properties Report not working on SQL 2012

New in SqlDbAid 2.4.1.0 (Jan 27, 2014)

  • Added Server Roles Report
  • Added Database Roles Report
  • Jobs Report now requires less privileges

New in SqlDbAid 2.4.0.0 (Jan 14, 2014)

  • Added Server Configurations Report
  • Added Server Properties Report
  • Added wait resource info to Processes Report
  • Minor bugs fixed

New in SqlDbAid 2.3.2.0 (Aug 19, 2013)

  • Added next run info to Jobs Report
  • Removed plan info from Precesses Report

New in SqlDbAid 2.3.1.0 (Jun 19, 2013)

  • Jobs Report speedup
  • Precesses Report speedup

New in SqlDbAid 2.3.0.0 (May 22, 2013)

  • Added Database Permissions report from my blog
  • Minor bugs fixed

New in SqlDbAid 2.2.2.3 (Feb 18, 2013)

  • Fixed date/time types formatting in Data Export tool

New in SqlDbAid 2.2.2.2 (Feb 4, 2013)

  • Fixed current duration formatting in Jobs report

New in SqlDbAid 2.2.2.1 (Feb 4, 2013)

  • Added total elapsed time to Processes report
  • Added current duration to Jobs report

New in SqlDbAid 2.2.2.0 (Jan 21, 2013)

  • Fixed Offline compare false mismatches
  • Added Cpu report
  • Improved Processes report

New in SqlDbAid 2.2.0.0 (Nov 5, 2012)

  • Fixed missing first column when copying compare results
  • Fixed possible empty login name in Processes report
  • Added query plan column to Processes report
  • Added file id column to Database Files report
  • Added Jobs report

New in SqlDbAid 2.1.0.0 (Sep 3, 2012)

  • Added Table Statistics report
  • Added Top Queries (by time) report
  • Improved Processes report
  • Database Files report now includes free MBytes
  • Indexes reports now include compression info
  • Table MBytes report now requires less privileges
  • Offline compare ignore CR by default
  • Fixed possible duplicates in Indexes statistics
  • Gui improvements

New in SqlDbAid 2.0.7.0 (Sep 3, 2012)

  • Fixed Ignore Empty Lines in compare module (scripts without line end)

New in SqlDbAid 2.0.6.0 (Apr 9, 2012)

  • Fragmentation Analysis is now optional to speedup other statistics extraction
  • Per table Indexes Statistics via context menu
  • Additional infos in Missing Indexes and Database Files reports
  • Fixed invalid characters check in suggested filenames

New in SqlDbAid 2.0.1.0 (Jan 24, 2012)

  • Fixed object names containing "]" not scripted correctly
  • Fixed shrink script in Database Files report created when not applicable
  • Fixed Missing foreign key indexes search
  • Fixed compare form scrolling

New in SqlDbAid 2.0.0.0 (Dec 12, 2011)

  • New compare engine
  • Added Database Files report
  • Table scripts now include indexes

New in SqlDbAid 1.5.8.0 (Dec 12, 2011)

  • Added a light version of Indexes Status report
  • Fixed duplicates in Indexes Status report

New in SqlDbAid 1.5.7.4 (Oct 27, 2011)

  • Fixed locks retrieving objects matadata
  • Fixed possible missing processes in Processes report

New in SqlDbAid 1.5.7.3 (Sep 13, 2011)

  • Added selected text execution
  • Fixed error selecting the same column multiple times in query editor

New in SqlDbAid 1.5.7.1 (May 30, 2011)

  • Fixed renamed objects detection

New in SqlDbAid 1.5.7.0 (Apr 18, 2011)

  • Added update statistics script to table MB report
  • Added Data Search Query
  • Fixed 32k maximum code size in query form
  • Fixed main form check boxes not visible (Win7 only)

New in SqlDbAid 1.5.6.0 (Feb 25, 2011)

  • Added unicode option to data exporter
  • Fixed generated insert script not working exporting NVARCHAR NULL values

New in SqlDbAid 1.5.5.0 (Dec 13, 2010)

  • Added Plan Caches report
  • Added Use Local settings option to the data exporter
  • Fixed data exporter not using execution timeout from settings
  • Fixed find next (F3) not working in code viewer

New in SqlDbAid 1.5.4.0 (Dec 13, 2010)

  • Added find (CTRL+F) to the code viewer
  • Alternative method to download newer versions

New in SqlDbAid 1.5.3.2 (Dec 13, 2010)

  • Added option to avoid getting locked object name in Locks report
  • Improved Table MBytes report by adding weight %

New in SqlDbAid 1.5.3.1 (Dec 13, 2010)

  • Fixed minor syntax highlitghting issue
  • Improved renamed objects detection
  • Unique constraints indexes are now scripted only inside table definition

New in SqlDbAid 1.5.3.0 (Dec 13, 2010)

  • Added append and run option to directly compare databases
  • Added Processes report
  • Added Locks report
  • Added code viewer to all reports that include a sql script
  • Added sql user types scripting
  • Added option to filter queries within N minutes in Top Queries report
  • Fixed case sensitive collation prevents objects scripting
  • Fixed connection leaks
  • Fixed serching text containing an open square bracket
  • Fixed server list not dropped down after servers search
  • Improved database name identification in Top Queries report
  • Improved Indexes Status report by adding new statistics
  • Improved Count Distinct report by adding selectivity
  • Improved query form by adding open/save options
  • System databases are now hidden by default
  • Application queries are now hidden by default
  • Several gui improvements
  • Server Activity reports (processes, locks and top queries) filtered by selected database

New in SqlDbAid 1.5.2.0 (Dec 13, 2010)

  • Fixed missing prefix N generating insert scripts
  • Program name has changed

New in SqlDbAid 1.5.1.0 (Dec 13, 2010)

  • Fixed unicode characters scripting
  • Filtered out internal queries from Top Queries report

New in SqlDbAid 1.5.0.1 (Dec 13, 2010)

  • Fixed count distinct report 30 s timeout
  • Improved count distinct report

New in SqlDbAid 1.5.0.0 (Dec 13, 2010)

  • Added existing indexes script
  • Added indexes status report
  • Added count of distinct table values
  • Added basic query form
  • Added basic table/view data viewer
  • Fixed trigger creation order
  • Fixed SQL 2008 new types export
  • Script execution timeout default is now 120 s
  • Gui improvements

New in SqlDbAid 1.4.2.0 (Dec 13, 2010)

  • Added schemas
  • Fixed incomplete table script after dropping first column

New in SqlDbAid 1.4.1.0 (Dec 13, 2010)

  • Added top expensive queries report
  • Added table MBytes report
  • Missing indexes are now shown before the export
  • Fixed possible duplicates in missing indexes search

New in SqlDbAid 1.4.0.0 (Dec 13, 2010)

  • Added table/view data export
  • Fixed arithabort error