This post is not about SQL Server but WordPress. As many of you know that I host SQLAuthority.com on self hosted Wordpress. This blog is powered by PHP and MySQL and hosted on an Apache Server.
Domain Controller – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved
But now, as per company standards, they need to use a domain account as the service account. Let us learn more about that in this blog.
SQL SERVER – How to Enable Lock Pages in Memory?
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.