Note: SSRS 2025 is now called Power BI Reporting Services (PBIRS). Power BI Report Server (PBIRS) is Microsoft’s on-premises solution for hosting Power BI reports, paginated reports, mobile reports, and KPIs, offering a web portal for management and viewing, ideal for organizations needing to keep data within their own infrastructure, consolidating traditional SQL Server Reporting Services... » read more
DQS & MDS Retired: Data Quality Services (DQS) and Master Data Services (MDS) are removed in SQL Server 2025, supported only in SQL Server 2022 and earlier. Note: You will need to uninstall DQS from SQL Server 2022 before you can upgrade to SQL Server 2025. To Uninstall DQS from SQL Server 2022, go to... » read more
Issue: Maintenance Plan option greyed out in SQL Server Management Studio version 21. Fix: Make sure SSIS is installed and “Business Intelligence” option is selected in the Visual Studio Installer. By default new SSMS 21, this feature is not enabled. Note: SSMS 21 is based off of Visual Studio and uses Visual Studio Installer to... » read more
Reference: https://stackoverflow.com/questions/31124963/how-to-determine-if-sql-table-is-temporal
2 Options… Use a DELETE without a where clause and then RESEED the identity (or) Remove the FK, truncate the table, and recreate the FK. TRUNCATE TABLE xxxxxxxx; — Cannot truncate table ‘tblImageReference’ because it is being referenced by a FOREIGN KEY constraint. DELETE FROM xxxxxxxxxx; Because TRUNCATE TABLE is a DDL command, it cannot... » read more
Error: Getting the following error when trying to build SQL project… Only one statement is allowed per batch. A batch separator, such as ‘GO’, might be required between statements. Fix: I have found the problem. When I added the file in VS I forgot to set Build Action = None from the file properties. So changing that... » read more
Error: Running into the following error when trying to publish a SQL Server project in Visual Studio… A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to SQL Server 2019 Fix: Go to Project -> Properties Change the “Target platform:” to SQL Server 2019
Error: Msg 976, Level 14, State 1, Line 1The target database, ‘xxxxx’, is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read... » read more
Issue: Secondary database stuck in “Initializing / In Recovery” mode or “Reverting / In Recovery” mode after AlwaysOn failover. Fix: Wait until the secondary database has synced up with the database on the primary. This may take a while if there are pending transactions. Recommend waiting for the secondary database to sync back up with... » read more
Issue: There was a server crash on the database server. After the crash, Always On has been failing. Windows Failover Cluster log indicate cluster resource failure. SQL Server log has a lot of “sql server i/o request taking longer than 15 seconds”. Cluster Event: EventID 1069 Cluster resource ‘xxxxx’ of type ‘SQL Server Availability Group’... » read more