Date: Thu, 28 Mar 2024 23:14:09 +0000 (UTC)
Message-ID: <1642701502.69461.1711667649308@ip-10-0-1-26.ec2.internal>
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_69460_382030465.1711667649305"
------=_Part_69460_382030465.1711667649305
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Location: file:///C:/exported.html
This build of SQL Admin Toolset includes many fixed issues, incl=
uding the following updates.
1.6 New features=
h2>
SQL Server 2=
012 support
The tools available in the SQL Admin Toolset now support SQL Server=
2012.
1.5 New features=
h2>
The new Linked Server Copy tool lets you quickly and easily copy our Lin=
ked Servers from one SQL Server instance to another along with the ass=
ociated settings, logins, passwords, and permissions.
The Quick Re-Index tool now allows you to:
- Specify which fill factor you want to use when the selected index is re=
built.
- Enable online processing during rebuild.
- Use the Maxdrop setting to specify he maximum degree of parallelism to =
use during the rebuild.
1.5 Fixed issues=
h2>
Index Analyzer
You can now view a list of columns of an index in the order that they we=
re defined.
Patch Analyzer
Patch Analyzer now includes the latest SQL Server service packs.
Multi Query
- Multi Query now correctly sorts the returned results.
- You can now use multi-line strings when performing a query.
Space Analyzer
The Space Analyzer tool now correctly reports the value for the =
Maximum Potential Size metric.
1.3 Fixed issues=
h2>
Job Editor
You can now successfully retrieve job information from a server group th=
at contains duplicate SQL Server instances.
Job Mover
You can now successfully move SQL Server jobs whose names contain s=
ingle quote marks (').
Multi Query
You can now successfully clear the returned results of your query from t=
he Query Execution and Results pane.
Server Groups
Special characters are no longer supported when naming new SQL Serv=
er groups. Support does continue for existing server groups which were crea=
ted by SQL Admin Toolset version 1.2 or earlier, that contain special chara=
cters.
SQL Search
You can successfully search for text strings in a SQL Server job ev=
en if the MSDB system database is not listed in your search criteria.<=
/p>
1.2 Fixed issues=
h2>
General
- This release offers full support for SQL Server 2008.
- You may now browse and select databases on a single server. Multiple da=
tabases on server groups must be added manually.
- All server browse lists include any servers defined in server groups.=
li>
- You can copy error reports to the clipboard.
Connection Check<=
/h4>
Windows Authentication field allows a connection test to be run under an=
alternate user account.
Database Co=
nfiguration
Added a new comparison report.
Database Mover
- Database Mover now supports database clusters.
- When moving a database, you have the option to set the default database=
for all of the migrated users to be the matching databases on the destinat=
ion server.
- When a database is moved, the database owner is also copied to the dest=
ination server.
- When selecting a destination, you can browse to servers on different dr=
ives.
- A database can be renamed and copied to the same server instance.
Index Analyzer
You can select individual or multiple databases before running the Index=
Analyzer.
Inventory Repor=
ter
Server Inventory now includes fields for: TCP Port Setting, Memory Allocation Type, Minimum SQL Server Me=
mory, Maximum SQL Server Memory, Allocate=
d CPU Count, Allocated CPU Count I/O, Num=
ber of Physical Processors, Number of Logical Processors=
strong>, and a list of enabled SQL Server Network Libraries.
Job Mover
Moving jobs with multiple steps no longer causes an error.
Partition Gene=
rator
Viewing details of a partitioned table no longer generates an error mess=
age.
Password Checker<=
/h4>
- Results can be exported as a TXT, CSV, or XML file.
- Results show the servers tested, the number of logins tested, bad passw=
ords, blank passwords, and passwords that match the login.
- Additional password dictionaries have been added to the default list.=
li>
- You may select multiple dictionaries to use simultaneously.
Patch Analyzer
Results are sorted by SQL Server name, and can be further sorted by colu=
mn within each group.
Quick Reindex
- The index results are no longer automatically resorted after reindexing=
.
- You have the option to turn off the reindexing warning message.
- You can select individual databases before loading index statistics.
Server Config=
uration
- Configuration information now includes service pack level, server colla=
tion, and login audit information.
- Comparison results now display differences in server collation values. =
These differences cannot be updated.
Server Ping
You can now start, stop, pause, resume, and restart SQL Server inst=
ances.
Server Statistic=
s
- The server state is now correct for SQL Server 2000.
- The results for per-second counters (e.g. logins/sec) are more accurate=
.
Space Analyzer
- The Space Analyzer tool now has the ability to display space informatio=
n for local mount points. However, it only detects mount points on Windows =
2003, 2008, and Vista, and the mount point must host a valid database.
- Results now include system databases (e.g. tempdb, msdb).
- Results include a new column % Disk Used by Database File showing how much disk space is used by the selected file.
SQL Discovery=
h4>
When scanning, you may enter a range of IP addresses or a local subnet.<=
/p>
User Clone
- The Default Database field for a new user correctly displays databases =
from the destination SQL Server.
- Source User displays all Windows authenticated group logins.
- You have the option to exclude role-level object permissions.
------=_Part_69460_382030465.1711667649305--