They noticed that application jobs are failing with the below error message about running a new system task. Let us learn more about this.
How to List All ColumnStore Indexes with Table Name in SQL Server? – Interview Question of the Week #153
Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.
SQL SERVER – Msg 32055 – sp_refresh_log_shipping_monitor – There Was an Error Configuring the Remote Monitor Server
Msg 32055, error configuring the remote monitor server, hides the real error. Read from the procedure on SQL Server 2025, with a safer fix than sa.
Moving From Express to Standard Without Reinstalling
Plan how to upgrade SQL Server edition from Express to Standard, preserve the instance, and verify databases and applications after setup.
SQL SERVER – Fix: Error – VS Shell Installation Has Failed with Exit Code 1638
A customer’s SQL Server 2017 install kept failing with “VS Shell installation has failed with exit code 1638”. Here is what caused it and how we fixed it.
SQL SERVER – List Users with System Admin (sysadmin) Rights – Part 2
After my post on listing users with System Admin (sysadmin) rights, Chris Mangrum shared a better script that also covers CONTROL SERVER. Here it is.
SQL SERVER – Too many dumps generated. CPerIndexMetaQS::ErrorAbort – Index Corruption
A reader had too many dumps with CPerIndexMetaQS::ErrorAbort. Here is how we traced them to index corruption and the steps we took to fix it.