Jul 012016
 
 Posted on: July 1, 2016  Posted by  No Responses »
Active Geo Replication Failover

In last couple of blogs we learned the basics of Active Geo Replication, how to configure Active Geo Replication using Azure Portal and verified the replication working. In this blog post Active Geo Replication Failover we’ll see how to manually initiate the failover process using Azure portal.   How to Failover Active Geo Replication Initiating [Read More]

Jun 252016
 
 Posted on: June 25, 2016  Posted by  No Responses »
Recover deleted Azure SQL Database

  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]

Jun 232016
 
 Posted on: June 23, 2016  Posted by  No Responses »
Copy Azure SQL Database Deep-dive

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]

Jun 152016
 
 Posted on: June 15, 2016  Posted by  No Responses »
Verify Active Geo Replication

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]

Jun 102016
 
 Posted on: June 10, 2016  Posted by  No Responses »
Configure Active Geo Replication using Azure portal

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]

Jun 072016
 
 Posted on: June 7, 2016  Posted by  No Responses »

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]

Jun 062016
 
 Posted on: June 6, 2016  Posted by  No Responses »
How to get last used timestamp in SQL Azure database?

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]

error: Content is protected !!