.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
SSISDB Catalog Database In earlier versions of SQL Server Integration Services (SSIS), we used to keep SSIS packages either on a file share or in the MSDB database and configuration parameters such as connection strings and sensitive data either in an XML file or in a SQL Server table. The downside to this was that... » read more
In 2008R2, I would always using BIDS to deploy packages to MSDB. All permissions were then controlled through SQL Server. In 2014, I see that you can still save to the file system or MSDB, but that there is now the SSISDB that you create as an Integration Services Catalog. This method clearly allows a... » read more
Export SSIS Package Open up SSMS -> Integration Services Catalogs -> SSISDB -> Projects -> Export This should create a .ispac file. Import SSIS Package Copy over the .ispac file to new server. Double click on the .ispac file to start the Integration Service Deployment Wizard. Select “Project deployment file” and set the “Path” to... » read more
Copy Deployment File to SQL Server File Type Note MyPackage.dtsx Integration Services Package MyPackage.SSISDeploymentManifest Integration Services Deployment Manifest Double click to launch Package Installation Wizard MyPackageInterfaceConfig.xml XML Configuration Document Select “SQL Server deployment” and check “Validate packages after installation” Enter “Server name”, Use Windows Authentication, and “Package path”, check “Rely on server storage for encryption”.... » read more
Error: Could not start the <service name> service on Local Computer. Error 1069: The service did not start due to a logon failure. Resolution: Service account might be disabled. Try using another service account. Sources: https://www.codetwo.com/kb/troubleshooting-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sent-items-update/
https://www.mssqltips.com/sqlservertip/6481/install-sql-server-integration-services-in-visual-studio-2019/ Adding the SSIS Projects extension to the Visual Studio 2019 When Visual Studio is opened, we click on “Continue without code” to add the necessary extension: In this window, we click on “Extensions” > “Manage Extensions”: In the search bar of the opened window, we type “Integration Services” to easily locate the extension. From the appeared list we choose “SQL... » read more
Issue: Always On database stuck in “Restoring” state after setting up Always On Fix: Go to Always On High Availability -> Database -> “Join to Availability Group” Sources: https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/
SQL Server 2019 (15.x) Edition Upgrade The following table lists the supported edition upgrade scenarios in SQL Server 2019 (15.x). For step-by-step instructions on how to perform an edition upgrade, see Upgrade to a Different Edition of SQL Server (Setup). Upgrade From Upgrade To SQL Server 2019 (15.x) Enterprise (Server+CAL and Core)** SQL Server 2019 (15.x)... » read more
CURL: HTTP POST: https://api.sendgrid.com/v3/mail/send Header Header Name Header Value Authorization Bearer <YOUR_API_KEY> Body Example: SendGridEmail.cs Sources: https://docs.sendgrid.com/for-developers/sending-email/api-getting-started
IPStack https://ipstack.com/ IPAPI.co https://ipapi.co/ Sources: https://www.learmoreseekmore.com/2020/12/users-ip-geolocation-blazorwebasm.html