SQL Server

September, 2018

  • 25 September

    Announcing the preview of SQL Server 2019

    Content copied from Microsoft email: SQL Server 2019 is now available to preview. Take advantage of built-in advanced analytics and data lake capabilities and easily integrate data from multiple sources, including Oracle, MongoDB, and Teradata—without moving your data via extraction, transformation, and load (ETL). Learn more about this latest SQL …

July, 2018

  • 6 July

    SQL Server Always On availability group on Azure virtual machines

    Hey everyone, Recently I have explored and prepared a demo in my lab environment with the help of Microsoft Docs. Please note that on this page I have listed the required steps to Install Always On availability groups on Azure virtual machines. Additionally, for better understanding, I mentioned in brackets …

June, 2017

  • 12 June

    How to Shrink database logs when databases are in availability group

    One of my customers reported an issue, saying, log disk drive was almost full. When I checked, there are no jobs configured in SQL to shrink log files and databases are in the availability group. I had executed below mentioned steps to free up space on the log disk drive. …

January, 2017

October, 2016

  • 7 October

    Shrink SQL Database log file to One MB

    Every AX administrator should know how to shrink AX database logs from the SQL management studio. You can run below SQL command with respect to your AX database. ** Replace ‘AdventureWorks2012‘ with your database name < p style=”text-align: left;”>USE AdventureWorks2012; GO /Truncate the log by changing the database recovery model to SIMPLE/ ALTER …