TSQL: Replicas Database
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.
Database Documentation with RedGate SQL Doc
Save template file as xxxxx.sqldoc Adding extended note to database table… Important: Remember to use “MS_Description” instead of “Description”.
SQL Server: Enable Send Mail
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
Create SSIS Catalog Database Error
Resolution: SSIS feature not installed on the database server. Install SSIS to fix the problem.
Example of AlwaysOn High Availability Setup
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
Deploying SSIS Packages from SSMS
There are 2 ways to deploy SSIS packages. #1 Directly from Visual Studio #2 From SQL Server Management Studio SQL Server Management Studio Create specific folders under SSISDB. To deploy a project deployment file that you created by building a project in the development environment, select Project deployment file and enter the path to the .ispac... » read more
Database Clustering, Mirroring, Log Shipping, and Replication for SQL Server 2008
Prior to SQL Server 2012 Availability Group, SQL Server 2008 uses Mirroring and Log Shipping. Database Mirroring Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. A copy of the database is created... » read more