It is possible to setup SQL Server AlwaysOn without Windows Failover Clustering. The feature “Windows Failover Cluster” does not need to be installed on the server. There will still be Primary and Secondary AlwaysOn servers. This setup is useful when you do not need failover, but simply to setup for a read-only secondary server. Note:... » read more
Error: SSRS service will not start. Ended up un-install and re-install SSRS to get SSRS working again. Ran into error with un-install SSRS. Ran into the same error with re-install SSRS. Resolution: Remove the following directory… and then run install SSRS. C:\Program Files\Microsoft SQL Server Reporting Services
https://www.solarwinds.com/sql-sentry SolarWinds SQL Sentry License by server instance. Use client application instead of web application.
https://www.brentozar.com/blitz/slow-storage-reads-writes/ SQL Server feels the need – the need for speed. Storage speed, to be more specific. One of the most common bottlenecks is underperforming storage subsystems. SQL Server tracks read and write speeds for each database file – both data and log files. This part of our SQL Server sp_Blitz script checks sys.dm_io_virtual_file_stats looking for average... » read more
https://www.brentozar.com/blitz/dbcc-checkdb-not-run-recently/ When SQL Server writes data to your drives, it just assumes everything’s okay until it needs to read the data back again. Unfortunately, in the event of storage corruption, the storage isn’t so kind as to alert SQL Server. And sometimes, SQL Server has even been known to corrupt itself. We need to periodically check... » read more
https://www.brentozar.com/archive/2019/02/what-should-you-do-about-memory-dumps/
To rename the SSRS SQL Server databases.. Stop SSRS service from Report Configuration Manager. Rename the ReportServer and ReportServerTempDB database in SSMS. Restart the SSRS service from Report Configuration Manager. Go to the Database tab, and select Change Database. Select “Choose an existing report service database” and select the renamed database.
Error: Getting the following error when trying to install SQL Server Reporting Services (SSRS) 2022 Dev. Stuck on “Installing Microsoft .NET 4.8” Error code 0x800713ec-Asia Fix: Install the offline .NET Framework installer version first, then go back and install SSRS. The server might not have internet access. SSRS install will need to download specific packages... » read more
Error: SELECT failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. Fix: Replace… SET QUOTED_IDENTIFIER OFFGO with… SET QUOTED_IDENTIFIER ONGO SET QUOTED_IDENTIFIER must... » read more
Error: Getting the following error when trying to set a network account to run SQL Server service. The service did not start due to logon failure. Fix: Make sure the network account has “logon as a service” permission. Enable service log on permission for Run As accounts Go to Administrative Tools and select Local Security... » read more