Custom Database Integrity Check Script
Source: https://ola.hallengren.com Database Integrity Check: System Database Database Integrity Check: User Database DatabaseIntegrityCheck Script
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Source: https://ola.hallengren.com Database Integrity Check: System Database Database Integrity Check: User Database DatabaseIntegrityCheck Script
Source: https://ola.hallengren.com Backup: SYSTEM FULL Backup: USER FULL Backup: USER DIFF Backup: USER LOG [dbo].[DatabaseBackup] Script
Create table to store log data. Create stored procedure to insert data into log table. Add logging to user stored procedure. dbo.tbMyLog.sql dbo.uspInsertMyLog.sql Logging in uspMySP01 Remove log entries older than 1 month
Delete records from log table where the records are older than 1 month.
Sources: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/waitfor-transact-sql?view=sql-server-ver15
Use Transact-SQL To manually fail over an availability group: Connect to the server instance that hosts the target secondary replica. Use the ALTER AVAILABILITY GROUP statement, as follows:ALTER AVAILABILITY GROUP group_name FAILOVER In the statement, group_name is the name of the availability group.The following example manually fails over the MyAg availability group to the connected secondary replica: Sources: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/perform-a-planned-manual-failover-of-an-availability-group-sql-server?redirectedfrom=MSDN&view=sql-server-ver15
MyTableType Table Type List all permissions for all table types.