In the last month, I have received calls from quite a few of my customers about Ransomware. Particularly this weekend it has been very busy with over 8 customers had issues with Ransomware. However, we were lucky enough to have proper database backups and pre-cautions in the place and hence we were able to recover quickly and without downtime. Today, I decided to write up small notes for everyone who wants to protect their database from Ransomware.
SQL SERVER – Why We have Audit Trace in DATA Folder? What are These Files?
There are many times when a DBA should work like a detective and find the cause of the issue which is reported by various teams. Sometimes it is an application team, sometimes an infrastructure team and sometimes its own learning. I always believe looking at the data points and finally connect the dots to make a story. Let us learn about why we have audit trace in the data folder.
What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan? – Interview Question of the Week #122
Question: What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan?
SQL SERVER – Fix: The EXECUTE Permission was Denied on the Object ‘xp_cmdshell’, Database ‘mssqlsystemresource’,schema ‘sys’.
I write and play around a lot with SQL object level permissions and I love working with them. Having said that, I also explore the ways people want to run code to achieve certain objectives. In the DBA’s world when the number of servers we are talking is not a single digit, they are looking for ways to automate and script out. Recently I was at a retail company backed team in India and they said they have close to 1500+ databases which are running at their various outlets and point of sale counters and the DBA team working to manage these were still less than 10. I was pleasantly surprised by this level of details. To achieve certain tasks, they have to allow non-sysadmin users to run xp_cmdshell. Here is the issue which was they wanted to solve.
SQL SERVER – Error Installing Microsoft Visual Studio 2010 Shell
There have been many situations where rather than performance tuning, I am contacted for an installation issue. Due to my knowledge by looking at logs and pin pointing at the error message, I am able to fix them as well. In this blog post we will learn how to fix Error Installing Microsoft Visual Studio 2010 Shell.
SQL SERVER – Could Not Load the DLL xpstar.dll, or One of the DLLs it References
Once upon a time a customer wanted to apply a patch on SQL Server instance, but it failed at the end to start SQL Server services. As usual, I asked to check ERRORLOG and found below information. Let us see errors related to the DLL.
SQL SERVER – Edition Upgrade – Invoke or BeginInvoke Cannot be Called on a Control Until the Window Handle has Been Created
One of a unique advantage of freelancing is learning more and more. I get a chance to hear some of the real word problem and it gives me immense pleasure to provide a feasible solution to them. This blog is interaction on the airport when I was coming back from a recent trip from Canada. After seeing me on airport, an old client of mine met and said hello. While having a discussion, he told an interesting issue of SQL upgrade and he wanted an idea. He showed me below error message related to edition upgrade.