Yes, it’s true. You can indeed recover deleted Azure SQL database during the retention period for the SQL Database automated backups for your service tier. To know more about automated backups and retention period refer this post. Database recovery is possible but there are a few caveats like: You can restore the deleted database [Read More]
If you are supporting Azure you might have to copy Azure SQL Database, In-fact sometimes this becomes a daily task at big\dynamic environments. So before its too late, let’s learn the process inside-out to perform this confidently. (In-case you’re just a beginner and don’t know how to create\provision Azure SQL Database kindly refer this post) [Read More]
Hi Friends Azure has a new functionality called Automated SQL Database backup, since its new you all must be having lot of questions regarding the same. I’ve compiled a list of questions with their answers, here you go: What is Automated SQL Database backup? Azure SQL Database has inbuilt functionality to backup all databases automatically [Read More]
In the last couple of blogs we learned the basic intro about the Active Geo Replication and also learned step-by-step how to configure Active Geo Replication using Azure Portal. In this post we will cross verify Active Geo Replication whether it is working or not & if the secondary database is read only or in [Read More]
In the last blog post we learned the basic concepts of Active Geo Replication, in this blog we’ll see how to configure Active Geo Replication using Azure portal. We’ll go step-by-step and see each and every step in detail. Let’s begin. A few things to note: Please make a note, that you must be the [Read More]
MS introduced new Database scoped configurations in SQL Azure (V12) and SQL Server 2016; Need for new Database Scoped Configurations Have you ever faced a situation where one of the database requirements are totally different from other like MAXDOP settings and you wanted to set a different MAXDOP for a single DB; or you wanted [Read More]
A timestamp is the time at which an event is recorded (inserted or updated), and timestamp is guaranteed to be unique in the database. So what will you do if for some reason you need to find the last used timestamp in SQL Azure Database? Well, the answer is @@DBTS function. @@DBTS This function is [Read More]
Globalization brings new opportunities and enhance economic growth to any business, but along with all the goodness it also brings complexity to manage different time zones. One has to be always on toes to match different times. but what if you’ve got an application\code where you have to convert timezone within SQL Server data? If [Read More]