So far, I have written many blogs and I still feel that there are many errors and scenarios which are still uncovered. Whenever I see a new error and find a new solution, I always share it via this blog. Let us see how we can fix errors related to sp_xp_cmdshell_proxy_account.
SQL Server Performance Tuning Practical Workshop – Forward Looking
In the month of January, I had offered a unique offering for training – “SQL Server Performance Tuning Practical Workshop”. I was initially planning to offer this for one month, however the response for this training was so much that I had to extend it for the entire first quarter. At this point of time, I am still delivering 2-3 classes every week as the training is extremely popular.
SQL SERVER – Learning New Multipurpose FORMAT Function
In versions prior to 2012, you need to use the CONVERT function with different styles to convert the date values into a different format. Let us learn about the FORMAT function in this blog post.
How to Add Column at Specific Location in Table? – Interview Question of the Week #126
Question: How to Add Column at Specific Location in Table?
Answer: Order of the column in the table should not matter.
SQL SERVER – Not Able to Kill SPID with KILL WITH STATUSONLY
Question: Why I am not able to KILL a SPID with command KILL (spid) WITH STATUSONLY?
SQL SERVER – Installation Error – Status Code: 183 Description: Cannot Create a File When that File Already Exists
One of my client was unable to install SQL Server 2014 on a Windows 2012 Cluster. They were using mount points with below the structure. Let us learn about installation error.
SQL SERVER – Quickest Way to Add LoopBack Linked Server for OpenQuery
Here is the question which I received the other day from a user who was trying to add a linked server pointing its own server as he wanted to use OpenQuery. Let us read his question in details.