Microsoft Dynamics GP

Home » Microsoft Dynamics GP » Microsoft Dynamics GP DBA » All Tags » DBA » Dynamics GP » SQL Administration

Browse by Tags

Related Posts

  • Blog Post: Getting entire databases from one point to another.

    John Lowther
    This is an addendum to the Getting Data from Point A to Point B series. When I first started this line of thought I was thinking more about SQL Queries, Triggers, etc.; however, as time when by I realized that there was an incredible need to get massive amounts of data from one place to another. ...
    on 5 Sep 2012

  • Blog Post: GPUG DBA SIG (2012 - 09- 20) Topic Request

    John Lowther
    To enter your request for the list of topics to be voted on please take this quick three question survey located here . After the results are in I will post the list of general topics for everyone to vote for their favorite. You can register for the webinar here . till later,
    on 21 Aug 2012

  • Blog Post: Notes on Performance for Microsoft Dynamics GP

    John Lowther
    When it comes to the performance of Microsoft Dynamics GP one of my favorite links is to the  Optimizing and Maintaining Performance for Microsoft Dynamics GP 2010 white paper on Customer Source.  But rather than just downloading the file I keep a link to it because it is updated as new things...
    on 11 Jul 2012

  • Blog Post: Deadlocks caused by Implicit Conversion

    John Lowther
    Sans SQL has a good post on how implicit Conversion can call deadlocks in SQL Server. Check out their post at Sans SQL: Deadlock - Implicit Conversion I would also like to thank Vaidy for letting us know about this in his post Implicit Conversions Causing Deadlocks in SQL Server . Till later,
    on 29 Jun 2012

  • Blog Post: Problem with SQL Server 2008 and Exchange 2010

    John Lowther
    First please keep in mind that I know almost nothing about Exchange or how it works. The parts about Exchange that I will be discussing I am just paraphrasing from my Exchange Server Admin. Here is what happened: For years we have been using Exchange 2003 with no problems. And for years I have had SQL...
    on 23 Apr 2012

  • Blog Post: Backing up the Tail of the Log

    John Lowther
    One of the secrets to recovering that last piece of data that has changed since your last backup when disaster strikes is to backup the tail of the log. To find out multiple ways to backup the tail of the log when disaster strikes, check out this post from Pau Randall. In Recovery... | Disaster recovery...
    on 17 Apr 2012

  • Blog Post: Database Snapshots - Something's do not always work the way you think they should.

    John Lowther
    While there are a lot of good things about database snapshots, and a lot of good reasons for using them. Under certain circumstances they can cause problems. In his Blog ( In Recovery ) Paul Randall goes over a bug when you are reverting back from a database snapshot. You can get all the details from...
    on 17 Apr 2012

  • Blog Post: Synchronizing Dynamics GP Test Databases from your Production System

    John Lowther
    I was replying to an email when it hit me that this information would probably help a lot of other people as well as the person I was replying to, so how about posting it instead. The question was how to keep multiple test servers synchronized with Production information. Now, reasons for having...
    on 29 Sep 2011