Some organizations use SQL Server Always On Availability Groups to help boost performance of applications where the users are geographically dispersed. They accomplish this by placing the secondary database in the same facility as the remote users. While it is almost always a good idea to place the data near the application, choosing Always On may be using a sledge hammer to do a screwdriver’s job, given the very high cost of Always On from a software, hardware, and implementation perspective. Of course, RTO (Recovery Time Objective) and RPO (Recovery Point Objective) are prime factors in deciding whether you need Always On, but these factors are related to recovery and not performance. Many organizations overstate their RTO/RPO requirements as most companies are not under the tight requirements of an airline reservation system or financial trading system. In fact, transactional or merge replication may be just the tool you need to meet both the application performance and recoverability requirements of your organization. Let us learn about When to Use a Sledgehammer and When to use a Screwdriver.
Question: When was Database Last Backed Up in 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.
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.
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.