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
Since I started consulting, I never had “Monday Blues” because I don’t get any weekends. I am always ready to help without time boundaries. Consulting gives me exposure to the real customer issue, learn more and blog more. This also helps me to see what customers are implementing rather than what Microsoft has provided as features. This blog is an outcome of a consulting where everything was deployed successfully, but project sign-off was pending due to an issue with log-shipping monitoring. In this blog we would learn about fixing error There was an error configuring the remote monitor server.
Download and Install SQL SERVER 2017 Developer Edition for FREE
SQL Server 2017 has been released for a while. I have been using it for a while and it is a pretty stable release from Microsoft.
SQL SERVER – Fix: Error – VS Shell Installation Has Failed with Exit Code 1638
Recently I got called in by a regular customer for my On Demand (50 minutes) service. Every single day I keep two hours available to help DBAs who need urgent help with SQL Server. When I connected with a customer, I was expecting to solve their SQL Server performance tuning problem. However, I quickly realized that the issue was not SQL Server Performance but was rather with SQL Server 2017 installation. Let us see how we can fix the error users are receiving related to VS Shell.
SQL SERVER – List Users with System Admin (sysadmin) Rights – Part 2
Yesterday I shared a blog post where I discussed how to list all the users with the System Admin (sysadmin) rights. I have received a quite a few emails and comments on this subject. The comment which got the most attention is from SQL Expert Chris Mangrum. He has shared a very interesting script with modification from the original script where he has also included additional permission of Control Server.
SQL SERVER – Too many dumps generated. CPerIndexMetaQS::ErrorAbort – Index Corruption
I always try to share my knowledge and learning from a client engagement. This helps me in remembering the steps I took to reach to the solution. It also helps my blog readers to follow the same steps and fix their problem rather than waiting for some expert to fix it. So you see, this is a WIN-WIN situation for both of us. Let us learn in this blog post how to fix index corruption.