Browse By Tags

  • Sage 500 RAID Configuration

    Hello Everyone, We are in the process of setting up our new server and was wondering if Sage 500 will work in a RAID environment? The SQL Server will be running in a VM and we have 16 1TB SSD drives to "play" with.What RAID configuration would be best…
  • How to create a new index that supports the "Include" option on an X3 table?

    How to create a new index that supports the "Include" option on an X3 table?

    It's always the way isn't it? You don't see any articles about creating indexes then several come all at once! Chris Hann recently wrote the article " How to use the Database Optimization function " but what if you want to create a new index which uses…
  • How to find the SQL Server version from a bak file

    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…

  • MAS 90 Providex to SQL Conversion / Archive Reporting purposes

    FormerMember
    FormerMember
    Hello, I am completely new to this. I am a SQL DBA and I have been asked to take our OLD MAS90 system convert the data to SQL and write reports to allow accounting people to find data from our old system. We currently use MS Dynamics NAV. We switched…

  • v13.1 and databases

    Hi folks, We're going to be upgrading to v13.1 here soon and I was wondering if anyone can confirm if Pervasive is the only option available for a database? I say a thread where someone said they were on SQL Server, I would prefer to use that over Pervasive…

*Community Hub is the new name for Sage City