Earlier back, I wrote blog to help my blog reader SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage
How to Write Case Statement in WHERE Clause? – Interview Question of the Week #127
Question: How to Write Case Statement in WHERE Clause?
WordPress – How to Rollback Plugin or Theme Changes? – WP Rollback
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.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.