By Adam Bean, on December 12th, 2011
http://www.sqlslayer.com/wp/admin-database/
- Completely rewrote all database maintenance routines!
- Added new object (DeployDatabaseMirroringNotification) to notify via email of any Database Mirroring state changes
By Adam Bean, on October 7th, 2011
http://www.sqlslayer.com/wp/admin-database/
- Added @AddStandardPermissions to NativeRestoreDB
- Added new object: Foreign Keys & RecursiveTruncate
- Added VIEW SERVER STATE permissions to StandardGroupPermissions
- Updated WhereAMI to include @IgnoreIdentifiers
- Updated Reindex procedure for partitions
- Updated BackupDB to cleanup backup logic to check only the most recent backup time
- Updated ShowChangedExtents to add @DiffBackupMB to estimated resulting size of a DIFF [...]
By Adam Bean, on July 6th, 2011
http://www.sqlslayer.com/wp/admin-database/
- Added TableSizes procedure
- Updated ReadErrorLog to support @FindRestarts which will show when SQL was restarted, and how long it was down for.
- Man, MoveBetweenFilegroups & who all fixed for case sensitive collations.
- ShowPermissions fixed to resolve collation issues.
- StandardGroup permissions updated to drop non standard users from standard roles.
By Adam Bean, on May 3rd, 2011
http://www.sqlslayer.com/wp/admin-database/
- BackupDB procedures updated for model tlog issues and added @SkipRecentRestoreMinutes
- Added function JobHistoryDateTime_fn.sql
- Added new procedure DeploySQLServerStartupInstructions
- Updated maintenance procedures to resolve collation issues
- Updated NativeRestoreDB to not drop backup/restore history when dropping a database via KillProcess on restore
By Adam Bean, on April 18th, 2011
http://www.sqlslayer.com/wp/admin-database/
- Updated BackupDB to support @CopyOnly.
- Updated WhereAmI to support searching jobs (@SearchJobs).
- New Object: DatabaseAttributes_vw.
By Adam Bean, on December 1st, 2010
http://www.sqlslayer.com/wp/admin-database/
We’re on a roll! Finally working towards some inline documentation with the recent addition of the man procedure. Very exciting stuff! We’re getting there, slowly but surely.
Fixed CheckDB logging issues
Updated ReadErrorLog to resolve collation/cursor issue
Removed buildmax of 11.0.0
Updated objects to 3042 where they were 4053
Added dbo.RemoveComments_fn
Added dbo.man
Added dbo.GetManSection_fn
Updated both versions of WhereAmI to include @IgnoreComments, [...]
By Adam Bean, on November 17th, 2010
http://www.sqlslayer.com/wp/admin-database/
Big update!
Added ReadErrorLog
Added sysserver_principals_vw compatibility view
Added CacheKeyAttributesWide_fn
Removed PlanCache_vw, logic placed in ExecutionPlanAttributes_vw and ExecutionPlans_vw is an extension of that (including QueryPlans).
FileIO – added addition columns and output.
IndexInfo – Added the NONE @ScanType, also changed default @ScanType to LIMITED (the actual system default)
IndexInfo – Fixed an overflow in the rank calculation
MissingIndexes – Added Schema name
By Adam Bean, on August 18th, 2010
http://www.sqlslayer.com/wp/admin-database/
Resolved collation issues with 2000 version of IndexInfo.
Added new Split_fn for 2005 and later (to support VARCHAR(MAX)).
Renamed 200x.dbo.Split_fn.sql to 2000.Split_fn.sql.
By Adam Bean, on July 8th, 2010
http://www.sqlslayer.com/wp/admin-database/
Updated MissingIndexes_vw to include support for ONLINE operations (Enterprise Edition). Also added DROP statements.
By Adam Bean, on July 7th, 2010
http://www.sqlslayer.com/wp/admin-database/
Updated who to resolve collation issues with joining with split_fn.
Updated DefaultTrace_vw to only pull is_default.
Comments