One of my client was trying to deploy his product on their test servers. They found that the SQL Server installation was failing with below error. Let us learn about error Wait on the Database Engine recovery handle failed.
SQL SERVER – Using dm_db_stats_properties With InMemory OLTP Tables
The whole concept of InMemory OLTP has been around for a while and still there are areas that I try to go back to learn every single time. If you are new to InMemory OLTP, I would highly recommend searching this blog for more content. For a starter, the blow blog is a great start.
SQL Server – When to Use a Sledgehammer and When to use a Screwdriver
While it is almost always a good idea to place the data near the application, choosing Always On may be using a sledgehammer to do a screwdriver’s job.
SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database
SQL Server troubleshooting topics seem to be the most searched for in this blog. In continuation to this, blog for today is also inspired with one such error message. Some time back I have written below blog which talks about the upgrade script mode of SQL Server: SQL SERVER – Login Failed For User – Reason Server is in Script Upgrade Mode
SQL SERVER – Generate Live Currency Exchange Rates using dbForge Data Generator for SQL Server
When you test an application that implements billing features, meaningful test data is extremely important. This article teaches how to quickly obtain and populate your database with live currency exchange rates in a few simple steps. Let us learn about Generate Live Currency Exchange Rates.
SQL SERVER – Beautify SQL Code with dbForge SQL Complete
Often when you write a large piece of SQL code, it eventually becomes a bit disorganized, or when a big team of developers is working on one project, the code differs between individual developers, the code formatting throughout the project gets inconsistent and hard to read. Let us learn about how to Beautify SQL Code with dbForge SQL Complete.
SQL SERVER – Understanding JSON Use is Case-Sensitive
The things I get to learn from my daughter is amazing. I think all of us need to constantly explore without any prejudice and set biases. Whenever I get a new toy for some occasion, I see there is at least a half hour of exploration to understand how the toy works and she goes into a whole new world of searching new ways to play. This makes the whole experience worth it. Let us learn about JSON.