by Eric Isaacs | Jun 6, 2017 | Azure, Blog, Microsoft SQL Server
When scripting out SQL Server objects in earlier versions of SQL Server, you’ve historically had the option to do so with “CREATE”, “DROP and CREATE”, or as “ALTER” scripts. Each option has advantages over the others for…
by Vatsana Kongtakane | Sep 30, 2016 | Azure, Blog, Microsoft SQL Server
In our last post – SQL Server Availability Groups in a Workgroup Failover Cluster inside Microsoft Azure, we created a domain-less Windows Server 2016 Technical Preview 5 Failover Cluster with SQL Server AlwaysOn Availabilty Groups. For anyone that has had to…
by Eric Isaacs | Feb 11, 2016 | Blog, Microsoft SQL Server
I had a recent experience with a SQL Server 2012 database that was in SIMPLE RECOVERY MODE that was not releasing log space and the LDF file was growing and consuming excessive drive space. Generally a log backup is all that is required to reclaim log file…