Choosing between Windows Azure SQL Database and Windows Azure VM hosted SQL Server

July 12th, 2012 0 Comments
Recently, Windows Azure has entered in the Infrastructure as a Service (IaaS) territory by announcing Windows Azure Virtual Machines (VMs), currently in public preview. Along with VMs came the possibility to host SQL Server databases directly inside Azure cloud. Previously, the only option for relational databases inside Windows Azure was represented by Windows Azure SQL … Continue reading

Transaction log recovery in SQL Server

September 18th, 2010 0 Comments
How to use the transaction log of a database in order to perform a recovery operation, when is that possible, when should it be used and what are the advantages? In this post I will try to provide an answer to the above questions. Continue reading