Earlier I wrote a blog about DBA doing detective work. SQL SERVER – Why We have an Audit, Trace in DATA Folder? What are These Files?. Now today there is another similar situation where the account is added automatically in SQL Server used by SharePoint.
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use
People generally ask me; how do I manage to find a blog topic for every day blogging? And my answer is – “Connect yourself to the ground, try to help people with the basics, have open eyes & ears and promise yourself to learn one new thing every day”. If one can achieve these, every day blogging is easier. As a part of my consulting, I was helping a client to run some scripts and while testing, I learned something new. In this blog, we would learn about cause and solution of the error, the local device name is already in use.
SQL SERVER – Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It
While trying to create linked server, sometimes there are errors. One of the error is below which is related to TCP Provider.
SQL SERVER – The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005
While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error.
SQL SERVER – How to Install New Sample Database WideWorldImportersDW.bak
Last year, I have written a blog to install sample database WideWorldImporters SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters. Recently, while I was showing demo to a client, they informed that I don’t have a blog about data-warehouse database WideWorldImportersDW. In this blog we would learn about how to install database WideWorldImportersDW.bak
SQL SERVER – Error: 17300 – SQL Server Was Unable to Run a New System Task
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.