Always On and Database Backup

Database backup will not happen on the primary server unless you specific in the “Backup Preferences” of Availability Group Properties. Note: Default is set to “Prefer Secondary”. When setting up database backup via maintenance plan, the job will still run and report success, however the backup files will not be created because the fn_hadr_backup_is_preferred_replica(‘MyDB’) flag... » read more

Maintenance Plans for SQL Server

SSMS -> Management -> Maintenance Plans Maintenance Plan Tasks Back Up Database Check Database Integrity Execute SQL Server Agent Job Execute T-SQL Statement History Cleanup Maintenance Cleanup Notify Operator Rebuild Index Reorganize Index Shrink Database Update Statistics Sources:

Change SQL Server Authentication Mode

Change authentication mode with SSMS In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode, and then click OK. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server. In Object Explorer, right-click your server, and then... » read more

SSRS: Enable Remote Errors

Enable remote errors through SQL Server Management Studio (Native Mode) Start Management Studio and connect to a report server instance. Right-click the report server node, and select Properties. Click Advanced to open the properties page. In the Security section, in EnableRemoteErrors, select True. Click OK. Sources:

Installing SQL Server Checklist

What Version and Edition to install? Developer, Standard, or Enterprise Edition If not Developer, need license key Account to use for install? Local Account or Network Account Collation Drives? Data, Log, Index, Backup Space Requirements Features to install? Analysis Services, Machine Learning Services, PolyBase Query Service, Integration Service, Reporting Service

SQL Profiler for Specific Stored Procedure

Create a new Trace In the “Events Selection” tab, click on “Column Filters” In the TextData column add a filter: Like %uspMySP01% Note: Make sure the TextData is checked. Make sure you include your stored procedure name between %% because sometime the stored procedure name can be called with additional to other data. TextData Examples: declare... » read more