Microsoft Dynamics GP

Home » Microsoft Dynamics GP » Microsoft Dynamics GP DBA » All Tags » 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: In Recovery... | Using fn_dblog, fn_dump_dblog, and restoring with STOPBEFOREMARK to an LSN

    John Lowther
    Paul Randal digs into how to recover from someone dropping a table in your database. Read all about here In Recovery... till later,
    on 30 May 2012

  • Blog Post: Rebooting because of an Automatic Update does interrupt SQL job execution.

    John Lowther
    I am not sure where I got it from, if it was incorrect information, if it is just outdated information, or if it is one of those "It Depends" things. But I have always been under the impression that a reboot caused by automatic updates would not occur if the SQL Server was busy. However as...
    on 9 May 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: Where to put “my” stuff?

    John Lowther
    It has been a while since my last post as I have been really busy, but as I sit here during an install staring at a blue bar slowly going across the screen, I might as well multitask. So, as a DBA we are constantly getting this stored procedure from here or that one from somewhere else, all of which...
    on 1 Feb 2012

  • Blog Post: Steps to change the server name for a SQL Server machine

    John Lowther
    Ok, admit it, a lot of us just rerun the setup for SQL Server whenever we have to change the physical machine name for a standalone SQL Server. Maybe that is just a hold-over from our earlier days. But Jugal Shah has a post at MS SQL Tips that list the steps necessary to change the physical machine name...
    on 9 Dec 2011

  • 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

  • Blog Post: Introduction to Microsoft Dynamics GP DBA

    John Lowther
    For my initial blog let me describe the intended audience of this blog by asking a few questions: Are you responsible for backing up the Dynamics-GP databases but don’t know anything about SQL? Are you responsible for the performance of Dynamics-GP? Do you just want increase...
    on 8 Nov 2010