Using SQLPackage to import or export Azure SQL DB

Purpose: Explain how to easily and quickly use SQLPackage to import or export your Azure SQL Database. Locating the SQLPackage.exe: The SQLPackage.exe is part of the DacFramework which installed with SSMS or with SQL Server Data Tools Or you can download only the DacFramework if you do not have already the management tools Once the…


Lesson Learned #20: What happen with my connection inside Azure when SQL Auditing is enabled?

Hello Everyone, Here we are with another lesson learned. At this time, I would like to show you what happen with my connection to my Azure SQL Database inside Azure when I have SQL Auditing enabled. The first thing that we need to read is the documentation placed here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-develop-direct-route-ports-adonet-v12, when we have all information about the…


Connect to your Azure SQL DB behind MsAccess web application

Note: Access web app has been deprecated now, review the full information about Access services in SharePoint Roadmap Background: When you create new Custom web application from Ms Access on your Office 365 SharePoint your application will be hosted on Microsoft Cloud. Sometimes you can have more value if you can gain direct access you your…


Lesson Learned #19: How to obtain the deadlocks of your Azure SQL Database?

In Azure SQL Database we have already running an Extended Event that captures the deadlocks without any additionally action for customer side. In this post we are going to learn how to obtain the deadlocks, how to obtain the deadlock graphic and how to reproduce a deadlock for testing.   How to obtain the deadlocks  …


Lesson Learned #18: Database cannot be downgraded to a lower database tier.

Hello again, I worked on another very interesting service request when our customer received the message: “MODIFY FILE failed. Size is greater than MAXSIZE. Please query sys.database_files and use DBCC SHRINKFILE to reduce the file size first” trying to scale down the Azure database tier. This message happens when the database file size is greater…


Lesson Learned #17: Should I cancel or kill a session running a huge transaction?

Hello Everyone,   We are receiving multiple service requests where our customers cancelled or kill a session that was running a huge transaction (delete/insert/update). After this cancelation, they were waiting for the same time that the huge transaction took to be able to do any action with the tables involved in this transaction. This situation is normal in any SQL Server edition,…


Lesson Learned #16: How to change the default language of Azure SQL Database

Hello Everyone, We got several questions how is possible to change the default language using server level ( trough sp_configure ) or login definition.   Option 1: Change the default language using ‘sp_configure’  Unfortunately, there is not possible to configure a server level the default language , if you try to change it running EXEC sp_configure ‘default…


Lesson Learned #15: Securing our Azure SQL Datawarehouse

Hello Everyone, Nowdays, the security is a key element for all databases, for this reason, in Azure SQL we have several options depending on our needs. In this picture you could see the different available options that we have right now. In this post, I would like to share some points about two important topics…


ARM Template to deploy server with Auditing and Threat Detection turned ON

I would like to share an example of a template that can be used to deploy server with multiple databases and to turn ON Auditing and Threat Detection at server and individual database levels. A few guidelines: Auditing server policy can be set after creation of all databases, so you should add dependency on all databases to…

0

ARM template – turning on blob auditing

Azure SQL Database Auditing is a popular feature which helps to track events on the databases. Recently Blob Auditing was introduced, at the time of writing this post it is still a preview feature. The advantages of blob auditing over table auditing are higher performance and higher granularity. To turn on blob auditing you can…