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]

Jun 022016
 
 Posted on: June 2, 2016  Posted by  No Responses »
AT Time Zone – Convert timezone directly using SQL

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]

error: Content is protected !!