Along with long term performance tuning engagement, I also provide quick consult (On Demand) to assist with any short-term issue, which might get fixed by talking to an expert. Some of the questions are very good and I get to learn something. This blog is the result of one such conversation like Case of Different Default Collation on Two Servers.
SQL SERVER – How to Downgrade SQL Server Edition?
One of a unique advantage of freelancing is learning more and more. I get a chance to hear some of the real word problem and it gives me immense pleasure to provide a feasible solution to them. In this blog post we will discuss How to Downgrade SQL Server Edition?
MySQL – Fix Error – WordPress Database Error Duplicate Entry for key PRIMARY for Query INSERT INTO wp_options
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.
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 – 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.
SQL SERVER – Understanding How to Play With Row Constructor
Every version of SQL Server brings in something new that challenges our understanding of how the software product works. For me, working with SQL Server is quite refreshing and fulfilling because every single day there is something about the product that I discover and learn. There are tons of professionals who are working on this product and they push the limits of use and bring interesting use cases which I get to learn. Let us learn about Row Constructor.