Audit Trigger Generation
Use this script to Generate Audit Triggers for tables in your database
Content:
Development:
SQL Server 7.x and later
|
Full Compress Backup of All User Databases
This T-SQL script is full compress backup of all user databases
Content:
Administrative:
SQL Server 2008
|
Calculating Uptime when support window isn't 24/7
In some corporates there are permissible down time windows, i.e. in the evenings or weekends or both. And then public holidays need to be factored in as well. You want to work out the number of work seconds between two dates and then use this as your total to divide your actual uptime into.
Content:
Administrative:
SQL Server 7.x and later
|
View Database growth over time
This script uses the backup size as an indication of the real amount of space used by a database. A database with a 1GB mdf that only has 10MB of data is in fact only 100MB in size. This db may grow by 100MB per month. If the mdf size is used, no growth will be observed for 10 months.
Content:
Administrative:
SQL Server 7.x and later
|
View any new databases created on multiple servers
This Powershell script uses the native Provider that comes standard with SQL 2008. From one function I can see any new (created in the last 30 days, for example) databases that are created on any server and the database size. Great for capacity planning and billing!
Content:
Administrative:
SQL Server 7.x and later
|
Kill the users before the automatic restore
works on 7, 2000, 2005, 2008
Content:
Administrative:
SQL Server 7.x and later
|
Analyzing SQL Agent Job and Job Step History in SQL Server
--Analyzing SQL Agent Job and Job Step History in SQL Server
-- Written By: Atif Shehzad MSSqlTips.com
Have not tested yet...ejm
Content:
Monitoring:
SQL Server 2000 and later
|
Data_Time_Master_Table
This Script is step 2 to see the Impact of Forced Parameterization this will populate the data in time master table which was created in Step 1
Content:
Development:
SQL Server 7.x only
|
Time_Master_tbl_ForcedParameterization
This Script is the Step 1 for creating a table in order to see the impact of Forced Parameterization
Content:
Development:
SQL Server 7.x only
|
Permissions Scripts plus some......
Will give a listing of all permissions on database objects.
Content:
Administrative:
SQL Server 6.x and later
|
dba3_sys_IndicesAudit
Audit indices ss2k5 and beyond only
Content:
Administrative:
SQL Server 2005 only
|
dba3_DeleteTopByIncrements_demo
Requires TOP (variable) support of 2k5 & later - demo script
Content:
Administrative:
SQL Server 2000 and later
|
dba3_fx_DateOnly
DateOnly function demo where date only portions of Dt variables are needed
Content:
Tuning:
SQL Server 7.x and later
|
TupleDifferencesAndEquivalentsBetweenSetsDisambiguation
Content:
General SQL Script
|
dba3_Monthly_DateTimeDemarcations
Content:
General SQL Script
|
dba3_dbmail_Troubleshoot
Content:
General SQL Script
|
Removal of User Login from ALL databases and SQL Server
Need to remove a login\user from SQL server and all databases? This script will look for the id in all the databases and generate a script to remove it from all databases and SQL server.
Input - it the login\user name.
Output - Copy/Paste/Execute
Content:
Administrative:
SQL Server 2000 and later
|
dba3_GrantLoginUserAccessInDb_DataReaderRoleForUserDatabases
Content:
General SQL Script
|
RANK(), PARTITION, and CTE Demo
A demonstration piece of code allowing you to see how to use RANK(), PARTITION, and CTE's to solve a business need.
Content:
Development:
SQL Server 2005 only
|
dba3_MemoryPressure_diagnostics
Content:
General SQL Script
|
Resource Memory Available External
Use to help determine memory leaks and use by OS.
Content:
Tuning:
SQL Server 2005 only
|
dba3_sp_RestoreDump_ConcurrentVersionInstall_2k8
Content:
General SQL Script
|
dba3_DBMS_Reporting_ReportingConfiguration
Content:
General SQL Script
|
dba3_sp_Generate_Select_NoLock_FQN_View_DDL
Content:
General SQL Script
|
dba3_sp_Generate_Select_NoLock_FQN_View_DDL
Content:
General SQL Script
|
dba3_Remote_DAC_ss2k5
Content:
General SQL Script
|
dba3_Create_SpaceUsedDetail_2k5_AND_SpaceUsed_2k5_ForAllDatabases
Content:
General SQL Script
|
dba3_FileGroup_Usage_Demo_2k5_WithObjectDistViews
Content:
General SQL Script
|
dba3_DBMS_DataLogBackupDirectoryDatabaseMailProfile_Standards
Content:
General SQL Script
|
dba3_ss2k58_ProductLevel_And_Version
Content:
Administrative:
SQL Server 2005 only
|
|
(520) 760-2400
Email