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.
SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key
Along with performance consulting, sometimes I also get requests from a few clients to look at the AlwaysOn availability group related problems.
SQL SERVER – Unable to Apply Security Patch – The setup has encountered an unexpected error in datastore
One of my clients reported that he is trying to apply security patch for SQL Server clustered instance and it was failing. Since this is SQL 2005 instance, there is no official support available from Microsoft at this point. So, they contacted me. I asked to share setup logs and found a very interesting note.
SQL SERVER – Fix – Error 15240, Severity: 16, State: 2 – Cannot write into file
I always keep playing with my virtual machine which has SQL Server installed. Recently I was trying to apply the patch of SQL Server and I was surprised to see that SQL Server was not getting started after patching. The error was Error 15240 it cannot write into file.
How to Query Multiple SQL Server with a Single Query? – Interview Question of the Week #106
Question: How to Query Multiple SQL Server with a Single Query?
SQL SERVER – SSMS Tip – Using Drag and Drop Capability
SQL Server Management Studio is an interesting tool. The more you work, the more you discover tricks from it. It doesn’t come as a surprise to how I get to know something new whenever I talk with someone. People have figured out new ways to work with SSMS. In this blog, let me talk about something interesting that has been with SSMS for ages but lesser known. Let us see today a time about SSMS related to Drag and Drop Capability.
SQL SERVER – The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid
Let us learn in this blog how to fix The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid. Let us learn in this blog post.
SQL SERVER – Why Cluster Network is Unavailable in Failover Cluster Manager?
It’s always a good experience to visit customer sites and talk to people. Sometimes I get to see things outside SQL world as well. There is a lot to learn and I believe that I can do that by sharing what I learned. In this blog post we will discuss Why Cluster Network is Unavailable in Failover Cluster Manager?