Screen Capture on Windows
Press Windows logo key + Shift + S for a static image snip. https://support.microsoft.com/en-us/windows/use-snipping-tool-to-capture-screenshots-00246869-1843-655f-f220-97299b865f6b
Author
Truncate table for system versioned table
Error: Msg 13545, Level 16, State 1, Line 14Truncate failed on table ‘tbXXXXX’ because it is not a supported operation on system-versioned tables. Resolution: Links: https://rajeevdotnet.blogspot.com/2019/05/truncate-system-version-table-temporal.html
Unable to Install SSRS 2022
Issue Unable to install SSRS 2022. Setup failed UnexpectedError: Bundle action failed: The system cannot locate the resource specified (0x800C0005) Setup: Install Completed for package Installing Microsoft .NET 4.8 Resolution Server does not have internet access. Unable to download and install supporting component Microsoft .NET 4.8. Download offline installer for “Microsoft .NET Framework 4.8 offline... » read more
SQL Server Database AlwaysOn without Clustering
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
Unable to uninstall or reinstall SSRS
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
SolarWinds SentryOne Database Monitor
https://www.solarwinds.com/sql-sentry SolarWinds SQL Sentry License by server instance. Use client application instead of web application.
Blitz Result: Slow Storage Reads or Writes
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
DBCC CHECKDB Not Run Recently
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
What should you do about memory dumps?
https://www.brentozar.com/archive/2019/02/what-should-you-do-about-memory-dumps/
Rename ReportServer database for SSRS
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.