Today’s landscape for data warehousing is a rapidly evolving space and most of that evolution is happening in the cloud. The cloud has long offered ways to scale analytic workloads for data warehousing with services like Azure SQL Data Warehouse. However, this only solves one part of the data warehousing workload and as the complexity... » read more
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
Error: Upload of file ‘test.txt’ was successful, but error occurred while setting the permissions and/or timestamp. Resolution: Turn off preserve timestamp setting. Sources: https://winscp.net/eng/docs/message_preserve_time_perm
Error: XML configuration file contains illegal characters in xml. Resolution: Escapes or unescapes an XML file removing traces of offending characters that could be wrongfully interpreted as markup. The following characters are reserved in XML and must be replaced with their corresponding XML entities: ‘ is replaced with ' “ is replaced with " & is replaced with & < is replaced... » read more
Escapes or unescapes an XML file removing traces of offending characters that could be wrongfully interpreted as markup. The following characters are reserved in XML and must be replaced with their corresponding XML entities: ‘ is replaced with ' “ is replaced with " & is replaced with & < is replaced with < > is replaced with > https://www.freeformatter.com/xml-escape.html
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
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
There are many documents that require a signature like a lease, medical forms, and basically anything official in your life. When you need to make a document that requires a signature, here are the steps to add a signature to your Word document. Place the cursor in your Word document where you want to insert a signature.... » read more