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 and enterprises who have investments in them deploy them together. However, there are restrictions when it comes to settings. Individual...
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...
All You Need To Know About The Windows 10 Anniversary Update
All You Need To Know About The Windows 10 Anniversary Update and Issues Windows 10 has been arguably the most successful Windows yet from Microsoft. With over 350 Million users at...
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
How to Manage your SQL Server Log and Database File Size Growth Managing the Database and log file size growth can be a difficult task sometimes. When things go out of hand, DBA...
How to Upgrade from Expired SQL Evaluation Edition
How to Upgrade from Expired SQL Evaluation Edition SQL Server Evaluation Edition is a full-blown Enterprise Edition that you can run for 180 days. That is a right amount of time...
Shrink SQL Server Databases for Mirroring & Availability Groups
Shrink SQL Server Databases for Mirroring & Availability Groups Shrinking SQL Server Databases and Log Files is a popular discussion among both experienced and entry level...
How to Upgrade to SQL Server 2016 from Earlier and Older Versions
How to Upgrade to SQL Server 2016 from Earlier and Older Versions SQL Server 2016 comes with multiple components. Upgrade considerations for each one of them is different. Before...
