• SQL Server Topic - Max Degree of Parallelism

    Last month in June, I wrote about capping SQL Server's memory so that it does not use up all available memory. You can read about it here . In this blog, I want to look at another setting in SQL Server, and that setting is the Max Degree of Parallelism…
  • SQL Server Topic - SQL Server has to know its limitations

    The main objective in this blog is to draw your attention to SQL Server and the min/max memory setting . Why is this setting important? Well, SQL Server is a memory hog. It would take all the memory if you let it. SQL Server has got to know its limitations…
  • Limit SQL Server memory to a fixed amount

    Have you ever noticed that SQL Server loves to use memory, even when there is not much activity happening on the server? Is there a way to manage the amount of memory utilized by SQL Server? Yes, you can limit the amount of memory SQL Server can use.…
  • How to find the SQL Server version from a bak file

    If you work with lots of different SQL Server backup files, is there a way to find out what version of SQL Server they came from without having to restore it? Short answer, Yes! If you work with many backup files from different versions of SQL Server…
  • Latest V12 & SQL SERVER 2014 R1

    Hi everyone someone has successfully installed the latest V12 update ( V12.0.21 - 2020 R1) with SQL SERVER 2014 (not R2) I receive this message while configuring the database by the console any help please
  • Microsoft Azure Environment

    Hi, One of our new customer is looking to implement Sage X3 ERP in Azure environment. They have a couple of questions which I have to answer before the Azure services procurement. Web Server: Can it be hosted using Azure App Service? Database…
  • Alert! (Part 1)

    In this blog I want to introduce to you a tool you can use directly from Microsoft SQL Server. The tool I am talking about is an Alert. The function of an Alert is to notify you when a particular condition has occurred. This is similar to when running…
  • problem with sequence number not getting updated

    We have an issue when we're busy, the sequence number that is used by our sales order document does not get incremented, so when the next person (or web service) tries to create a sales order, they get an error about how that number already exists. …