How to scan QR code on your Android phone

How to scan QR code on your Android phone and open up websites. Open up Google Photos. Go to “Modes” tab. Tap “Lens”. Point your camera at the QR code, a URL should appear on the focus area. Tap on the URL to open up the link in the phone’s browser. Note: You can also... » read more

Deploy SSIS Package via .SSISDeploymentManifest file

Copy SSIS package file (.dtsx) to server. Run xxxxxx.SSISDeploymentManifest file to start the Package Installation Wizard. Make sure the configuration file xxxxxxConfig.xml also exist in the same folder. The Package Installation Wizard will look for this file for configuration setup. Deployment with this method will set the database connection string. SSIS Package deployment using SSIS... » read more

Unable to Connect to Integration Services

Issue: Unable to view SSIS packages via Integration Services in SSMS. Get “Access is denied” when trying to connect to Integration Services service on the computer xxxxxx. Fix: Run SSMS in “Administrator” mode. Then access the SSIS package by connecting to Integration Services instead of the Database Engine.

SQL Profiler: Filter By Database Name

Filter result by database name. Under Trace properties > Events Selection tab > select show all columns. Now under column filters, you should see the database name. Enter the database name for the Like section and you should see traces only for that database. Note: Make sure you show all columns and select database name.... » read more

Failed to find a valid digest in the ‘integrity’ attribute for resource in Blazor app

Error: Failed to find a valid digest in the 'integrity' attribute for resource xxxx with computed SHA-256 integrity xxxx. The resource has been blocked. Fix: Close Visual Studio 2022 Delete the obj and bin folders from all your projects. Start Visual Studio 2022 Rebuild solution. Try Publish again. Sources: https://stackoverflow.com/questions/69926878/failed-to-find-a-valid-digest-in-the-integrity-attribute-for-resource-in-blazo

Enable SSRS Email Subscription

Go to Report Server Configuration Manager and set the E-mail Settings. Restart SSRS services. On SSRS, you will now see an “Email” subscription option when you create new SSRS subscription.

Unable to add secondary server to AlwaysOn

Error: Failed to obtain cluster information. Either the specificed instance of SQL Server is not running on a Windows Server Failover Cluster (WSFC) node, or the user lacks sysadmin permissions on the SQL Server instance to obtain the cluster information. Resolution: Make sure you restart SQL Server services after setting the AlwaysOn setting. Error: SQL... » read more

SQL Server Permission to Backup Database

db_backupoperator – This role will allow the user to take backups of the database. Server Level – PUBLIC ROLEDatabase Level – DB_BACKUPOPERATOR This is the least privilege to take backups for a database.