.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
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.
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
Look for duplicate records. Remove duplicate records
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
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
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
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
Install Report Builder https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-report-builder?view=sql-server-ver15
Semantic Modeling Language (SMDL) SQL Server 2016+ SMDL models were deprecated as of the release of SQL Server 2014, the ability for them to function was still there. SSRS 2016 or later doesn’t support the Report Models feature. Uploading and managing report models is a discontinued feature on SQL Server 2016 (is no longer a... » read more
A certificate used in TDE will continue to work even after its expiration date. This is because the Database Encryption Key (DEK) in the user database is the key that encrypts the data at rest. DEK is the symmetric key stored in the user database boot record. The certificate which is stored in the master... » read more