Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.
SQL SERVER – Msg 15137, Level 16 – Error Related to sp_xp_cmdshell_proxy_account
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.
SQL SERVER – How to Measure Page Splits Counter Value via T-SQL?
Question: How to Measure Page Splits Counter Value via T-SQL?
SQL SERVER – How to Update Two Tables in One Statement?
Question: How to Update Two Tables in One Statement?