As many of you know that this blog runs on Wordpress and under the hood of Wordpress there is a MySQL database. MySQL database is quite good and is able to hold massive traffic this blog receives every day. However, just like any database MySQL needs tuning as well as proper management of the same. In this blog post we will discuss about how I received a very weird error Wordpress Database Error and how I resolved it.
How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of the Week #088
Question: How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?
SQL SERVER – Setup Screen Not Launching While Updating a Patch
This is one of the client contacts where I realized the importance of looking at right log file. The client said that he double clicks the.exe, a window flash by and disappears. It looked like something was happening, but it’s failing to move forward. Let us learn a very rare but critical error about setup screen not launching while updating a patch.
SQL SERVER – How to Increase the SSMS Grid Font Size?
SQL Server Management Studio (SSMS) is part of SQL DBAs life. I use it while doing the presentation. If you are sitting in a big room like below, then the guy sitting in the last row may not be able to see it properly. As a conference speaker and trainer, it is very critical for me to make sure that everyone in the room understand and learn from me. Let us learn in this blog post how to increase the SSMS Grid Font Size?
SQLAuthority News – New SQL in Sixty Seconds Video
Today I am going to discuss the new SQL in Sixty Seconds Videos which I have released. Let us learn about them together. Do not forget to subscribe.
SQL SERVER – FIX Error 18456, Severity: 14, State: 5. Login failed for user
Some errors are historic and have the most common root cause. Sometimes we really don’t know why they happen and I have seen clients go nuts to identify the real reason for the problem. In a recent email interaction with one customer – who was migrating from Oracle to SQL Server. He kept telling me that they were getting login errors from their Java application. And even when they used the SQL Server Management Studio it was erroring out with Error 18456 code. They sent me a snapshot like this for login failed:
SQL SERVER – Database Backup and Restore Job Management
ApexSQL Backup is a tool for Microsoft SQL Server, intended for database backup and restore job management. The application supports all native SQL Server backups (full, differential and transaction log backups), and allows users to easily create, save and manage all backup related jobs. ApexSQL Backup can be used to run, schedule and monitor all backup operations across the domain from a single location.
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.