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.
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
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.
Windows PowerShell Commands
https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/?view=powershell-7.2
Windows PowerShell ISE
Editor for PowerShell script.
Accounting Reconciliation
In accounting, reconciliation is the process of ensuring that two sets of records are in agreement. Reconciliation is used to ensure that the money leaving an account matches the actual money spent. This is done by making sure the balances match at the end of a particular accounting period.
Log was not truncated because records at the beginning of the log are pending replication or Change Data Capture
Issue: Log has grown to be very large and unable to trunk log file even after database and transaction log backup. Get the following error message when trying to truncate log. The log was not truncated because records at the beginning of the log are pending replication or Change Data Capture. Ensure the Log Reader... » read more
Deploy SSIS Packages using .ISPAC File
Copy .ISPAC file to the server. Click on the .ISPAC file on the server, this should bring up the Integration Services Deployment Wizard. Select packages and deployment server to deploy SSIS packages. Note .ISPAC file is generated in the bin\Development folder of Visual Studio project. SSIS Package deployment using .ISPAC file seems to be the... » read more
Server is not configured for remote access
Linked Server Error: Could not execute procedure on remote server ‘XXXX’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access. Fix: Make sure remote access is enabled on the database server and that the server has been restarted if the configuration changed. Also... » read more
Visual Studio 2022 Launch
https://visualstudio.microsoft.com/launch/