With the world moving to cloud, one of the major concerns for the SQL Server Database Administrators (DBAs) is performance of SQL Server running on virtual machine (VM) as compare to an on-premises machine. In case of on-premises machine, hardware is owned by company but on the other hand, in case of IaaS, the hardware, […]
Read More
Be it SQL Server or the improved version of SQL Server on the cloud called as SQL Azure, when it comes to monitoring, there is nothing as powerful as DMVs (Dynamic Management Views). For a primer, Dynamic Management Views (DMVs) are a set of virtual views which expose the internal states of SQL Server deployment. […]
Read More
Learn how to run on-premises versions of SQL Server with the instance hosted in the cloud by using SSMS to connect to Windows Azure virtual machines.
Read More
Learn what SQL Server database fragmentation looks like for databases running on Windows Azure.
Read More