PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language. Can be run as Jobs in SQL Server. Example Run Script From SQL Job Type: Operating system (CmdExec) Remove all files greater than a certain date. Type: PowerShell PowerShell Commands Here are 25 basic PowerShell... » read more
DBCC CHECKDB is used to check the physical integrity of the entire database. DBCC CHECKDB is used to detect corruption in the database, and should be run regularly. This is accomplished by running several of the other DBCC commands, then doing some extra verification. Runs DBCC CHECKALLOC. Runs for every table DBCC CHECKTABLE. Runs DBCC... » read more
Every time SQL Server is started, the current error log is renamed to errorlog.1; errorlog.1 becomes errorlog.2, errorlog.2 becomes errorlog.3, and so on. sp_cycle_errorlog enables you to cycle the error log files without stopping and starting the server. Return Code Values 0 (success) or 1 (failure) Source: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-cycle-errorlog-transact-sql?view=sql-server-2017
Query to return info about replicas. Query to return a list of Primary Replicas databases. Query to return a list of Non-Primary Replicas databases.
Save template file as xxxxx.sqldoc Adding extended note to database table… Important: Remember to use “MS_Description” instead of “Description”.
Error when using msdb.dbo.sp_send_dbmail: SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Database Mail XPs’ by using sp_configure. For more information about enabling ‘Database Mail XPs’, search for... » read more
Resolution: SSIS feature not installed on the database server. Install SSIS to fix the problem.
Setup Availability Replicas – Select Server Availability Databases – Select Database Availability Group Listeners – Select Listeners (optional) Note Two servers setup in Availability Group. One Primary and one Secondary. (Can have multiple Secondary) Secondary setup as read-only. Listener setup as the pointer. Connection string should point to listener. (Optional) On Primary Server, will display... » read more