In the first article, I described the characteristics of Change Tracking, how to activate and deactivate it, and how the system objects that support this feature are structured. Assuming that you have mastered these concepts, I will now describe the functions that SQL Server provides to work with Change Tracking. (more…)
Over time, our databases get bigger and bigger. One possible solution to reduce this problem is the use of backup compression. Mind you – wouldn’t it be better to start by reducing the volume of information to back up? In databases, most of the information to be backed up is in these three types of object:
Great news yesterday and today the whole day after our Spanish SolidQ Summit 2012 in Madrid in Windows Azure with the new version of the Microsoft’s Cloud Platform full of new features and new names for the big amount of cloud services.
Suppose that you need to do query tuning in a system that suffers from performance problems. There could be requests from users to tune very specific queries, but there could also be requests to improve the system’s performance as a whole. (more…)
As I write this blog post, There are six location options while provisioning a SQL Azure server. And so while provisioning a SQL Azure server, who may have to decide the optimal location of the SQL Azure server based on the criteria that the latency between your application and the SQL Azure server is the minimum. And as you may know, we get better performance – if we are are able to minimize the latency between client and SQL Azure. So let’s get into action.