#sql azure

Como trazer um banco de dados do Azure SQL Database para o servidor local?

 Essa é uma pergunta clássica! Principalmente quando é necessário trazer um banco de dados do Azure SQL Database para um ambiente local. 

Neste post irei apresentar formas simples para tal. Contudo, em algum momento é possível que você se depare com um ambiente complexo e precise partir para uma solução de HA.

Uma das formas que eu mais gosto é através do Import/Export Wizard do SQL Server…

SQL Server Management Studio v 17.8.1 is released

SQL Server Management Studio v 17.8.1 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=875802

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=875804

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio…

SQL Server Management Studio v 17.7 is released

SQL Server Management Studio v 17.7 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=870039

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=873128

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-s…

SQL Server Isolation Level

ISO Standard Isolation

The ISO standard defines 4 different isolation levels, from lowest to highest: – Read uncommitted – Read committed – Repeatable read – Serializable, where transactions are completely isolated from one another.

SQL Server Database Isolation

SQL Server Database supports all levels of isolation defined by ISO standard. In addition, it adds another isolation levels: the…

How easy to do a database Copy in SQL Azure?

Sometimes, you might require a copy of your database for some R&D purpose and there are various ways to achieve this.

If you are new to Azure SQL then you might think of those traditional ways which are good. Let me share a simple command here which do the same task of a database copy.

CREATE DATABASE <New Database Name> AS COPY OF <Source Database>

Suppose, we have a database with the name…

SQL Server Management Studio v 17.6 is released

SQL Server Management Studio v 17.6 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=870039

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=870041

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-…

Galera de BSB!

Dia 2 de dezembro acontecerá o PGDay na UniCEUB!

Será um sábado com 3 trilhas de palestras e uma de oficinas.

Eu estarei palestrando na trilha de Inovação falando sobre o PostgreSQL no Azure.

Então, não perca o evento e principalmente a minha palestra 😉

Mais informações sobre o evento veja http://www.pgdaybrasilia.com.br/.

Vejo vocês lá.

Abraço, Rodrigo

Simple Guide to restore SQL Server Backup from Azure Blog Storage using Management Studio

In previous post, we saw

1. How to implement Off-site/Cloud backup in SQL Server 2017 using Azure Blob Storage

2. How to restore SQL Server Backup from Azure Blog Storage using queries

In this post we will see how to restore SQL Server Backup from Azure Blog Storage using SQL Server Management Studio

Step 1: Open SQL Server Management Studio 2017 and connect to SQL Server on which you would like…