Azure SQL Data Sync Limitations Pricing and Alternatives
Before we talk about the Azure SQL Data Sync Limitations, we will need to understand the prerequisites first. The Azure Data Sync has been around for a while (October 2011), and...
How To Do Point In Time Restore of Azure SQL Databases From Backups
If you have your Databases hosted on Microsoft’s Azure cloud service, you can breathe easy. Microsoft automatically takes backups of all your databases. It is a part of...
SQL Server Disk Configuration SAN SSD and Partitioning Best Practices
SQL Server Disk configuration settings are one of the most important aspects of SQL Server performance tuning. Typically, disks are one of the slowest parts of the entire SQL...
System Center Deployment Requirements and Restrictions for SQL Server
System Center contains a suite of products for Enterprises which enables them to deploy and manage Windows (Wintel) datacenter environments. The suite of upper growth include the...
How To License Your SQL Server on Google Cloud
In my previous post, we deployed SQL Server 2016 on a Windows Server 2012 R2 Operating system on Google Cloud. When you use the SQL Server Public Images, SQL Server and Windows...
How to Run Microsoft SQL Server 2016 on Google Cloud Step by Step
Google Cloud Services recently added Microsoft SQL Server to its offerings. Google’s move is primarily due to a strong customer demand. The customer wants to run...
How to Shrink SQL Server Database Log in Availability Groups using TSQL
In my previous posts, I have already spoken about the best practices of Shrinking Log files and Database Files. From the recommendations, it is quite evident that Microsoft...
How to Manage your SQL Server Log and Database File Size Growth
Before going into the discussion of managing SQL Server files (*.MDF & *.LDF ) it is essential to know the reasons why your files are growing in the first place. Understanding...
How to Upgrade from Expired SQL Evaluation Edition
Looking to Upgrade from Expired SQL Evaluation Edition? Upgrading or recovering your data from an expired edition of SQL Server is not easy. It is always recommended to upgrade...
Shrink SQL Server Databases for Mirroring & Availability Groups
We know you will not like it, but, shrinking databases is a bad idea. Ask any experienced DBA or a database architect and he/she will tell you why. You can only make it a one-time...
