The type or namespace name ‘Dymo’ could not be found
Error in Visual Studio: The type or namespace name ‘Dymo’ could not be found (are you missing a using directive or an assembly reference?) Fix: Interop.Dymo.dll
Author
Git Workflow
https://www.atlassian.com/git/tutorials/comparing-workflows/gitflow-workflow
Delete User Account from SQL Server Database
Note: Make sure the user you are about to delete does not own anything in the database, else you will get an error message saying unable to delete user. Make sure the user does not own any of the SQL jobs.
Azure Storage Type
Core storage services The Azure Storage platform includes the following data services: Azure Blobs: A massively scalable object store for text and binary data. Also includes support for big data analytics through Data Lake Storage Gen2. Azure Files: Managed file shares for cloud or on-premises deployments. Azure Queues: A messaging store for reliable messaging between... » read more
Remove Duplicate Record
Look for duplicate records. Remove duplicate records
Remote Query Timeout
Now the common misconception with this option is probably because of the following screen within SQL Server Management Studio (Server Properties -> Connections) where we see the following. So the first checkbox allows remote connections to the server so we could assume that the remote query timeout value underneath (here set to 600, the default)... » read more
SQL Compare and Indexes
If need to include indexes during SQL compare, make sure the following boxes are unchecked in the “options” section… Ignore indexes Ignore performances indexes Adding Missing Index
Failed to load expression host assembly. Details: Could not load file or assembly or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingExprHostAssembly)
Error: Got the following error after upgrading SSRS. Failed to load expression host assembly. Details: Could not load file xxxxxxx or assembly or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingExprHostAssembly) Fix: For SQL Server 2014 to 2016, copy the missing dll to the new folder. From… C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting... » read more
SQL Server Jobs Permission
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. If you have several SQL Agent jobs on your system, it is inevitable that at some point in some of your in-house... » read more
Microsoft Report Builder
Install Report Builder https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-report-builder?view=sql-server-ver15