PASS SQL Saturday Parma Agenda now available!

PASS SQL Saturday Parma agenda is now available!

This is the timetable:
From        To
10:00       11:00
11:15       12:15
12:30       13:30
13:30       14:30
14:30       15:30
15:45       16:45
16:45       17:00
17:00       18:00
We will have three tracks:
  • BI, for Business Intelligence, BigData, xVelocity, etc.
  • DEV, for developers 
  • OPS, for operations and administration
Checkout the agenda here and organize your Saturday with the schedule builder!
Stay Tuned! 🙂

Backup Windows Azure SQL Database with Sql Server Management Studio

Recently I had to create a backup procedure on my Windows Azure SQL Database.  SQL Server Management Studio allows us to access to our SQL Databases and provides the user interfaces for creating backup files.

In this post we will understand:

  •  how to create a Azure SQL Database copy
  •  how to save a logical file backup on the cloud storage
  •  how to restore the logical file on a new Azure SQL Database

Since the database copy can be considered as a full backup, we want to create also a file in order to place it on another place, that could be a local or a cloud storage.

Continue reading “Backup Windows Azure SQL Database with Sql Server Management Studio”

Windows Azure Service Bus Topics, the first encounter

Service Bus is the infrastructure provided by Windows Azure for implementing messaging patterns. Click here for further information about messaging management on Windows Azure.

I’m currently thinking about a “notification server” using the cloud and Service Bus seems to fit my requirements. This article describes “Queues, Topics and Subscriptions” concepts:

These “brokered” messaging capabilities can be thought of as asynchronous, or decoupled messaging features that support publish-subscribe, temporal decoupling, and load balancing scenarios using the Service Bus messaging fabric. Decoupled communication has many advantages; for example, clients and servers can connect as needed and perform their operations in an asynchronous fashion.

Yes, it’s what I need.. let’s start to develop a test project, in order to understand also the development time (I’m a dba, but please appreciate my efforts 🙂 )

Continue reading “Windows Azure Service Bus Topics, the first encounter”