Microsoft Dynamics GP

Home » Microsoft Dynamics GP » Microsoft Dynamics GP DBA

Microsoft Dynamics GP DBA

Microsoft Dynamics GP DBA

About Microsoft Dynamics GP DBA

JOHN LOWTHER 
Director of Software Development & Integration for Sta-home Health & Hospice, Inc.
Chairman of the Board of Advisors for the Dynamics GP User Group (GPUG)
10+ years with Dynamics-GP (GL, AP, HR, Payroll, Maintenance, Training, Upgrades, Security)
15+ years as a Database Administrator (Maintenance, Performance, Warehousing, Validation, Correctness, Alerts, BI & Reporting)
20+ years as a Developer (Written software for IBM, BCBS, Schools, Nursing Homes, & Home Health)
 
You can follow my blog here or my other networks below:

Any views contained within are my personal views and not necessarily Microsoft policy or the policy of Sta-home Health & Hospice, Inc.
All posts are provided "AS IS" with no warranties, and confers no rights.  

Blog Actions
Favorite Content List
12
Blogs Outside of the Dynamics Community

In Recovery  by Paul Randal
SQL Skills    by Kimberly Tripp

Post Series

Creating an EDW for CBI Series
Getting Data from Point A to Point B

Tags
Sort by: Most Recent | Most Views | Most Comments
Excerpt View | Full Post View

  • Moving Dynamics-GP databases to a new SQL Server

    Posted over 2 years ago
    by John Lowther John Lowther
    • 5 Comments
    Well, I just got finished moving my Dynamics-GP databases from an old SQL2005 server to a new SQL2008 server. The move was actually quite easy for the most part. Here's what I did and where I had problems. Removed the ODBC connection on the...

  • 100 Most Influential People in Microsoft Dynamics for 2011 (New Links)

    Posted over 2 years ago
    by John Lowther John Lowther
    • 4 Comments
    By now everyone has probably heard about voting for the 2011 100 Most Influential People in Microsoft Dynamics that DynamicsWorld in the UK are putting together. And as the voting page is broken into polls (13 in total) a lot of bloggers have created...

  • Speechless

    Posted 8 months ago
    by John Lowther John Lowther
    • 3 Comments
    For anyone that knows me, I think they will all agree that I have the “Gift of Gab”. In other words, In other words I am not afraid to talk. However, on October 1, 2012, Microsoft found a way to make me utterly, and totally speechless! I received an email...

  • Microsoft Dynamics Most Influential People Top 100 for 2012

    Posted over 1 year ago
    by John Lowther John Lowther
    • 0 Comments
    The list is out for 2012! You can get to the list from the DynamicsWorld website here . First, I congratulate all those that made the list! Especially those that I know and follow, you all are GREAT!   I do not wish to detract from the achievements...

  • Check out Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2012

    Posted over 1 year ago
    by John Lowther John Lowther
    • 0 Comments
      Check out Doug's list of Influential Dynamics People. Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2012 Just my own opinion but I personally I have to agree with Doug.   till later,

  • Some great scripts that I recently found

    Posted over 1 year ago
    by John Lowther John Lowther
    • 0 Comments
    A few days ago I was searching for something and ran across this post from Jivtesh Singh . One of the scripts that he points out is a post from Mariano Gomez and lets you search for all tables for columns with the same name. Another one is a stored procedure...

  • Check Links and Reconcile

    Posted over 1 year ago
    by John Lowther John Lowther
    • 2 Comments
    So that you get this information as well please check out my post on the The Dynamics GP Administrator site. Till later,

  • Dynamics GP Appears Locked-Up or Not Responding

    Posted over 1 year ago
    by John Lowther John Lowther
    • 1 Comments
    Over the years I have had quite a few fellow users both where I work; and other companies as well, report to me that Dynamics GP locks up on them from time to time. And I myself have noticed that on occasion it initially appears  even to me that...

  • Where to put “my” stuff?

    Posted over 1 year ago
    by John Lowther John Lowther
    • 0 Comments
    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...

  • Script History Table and Procedures

    Posted over 1 year ago
    by John Lowther John Lowther
    • 0 Comments
    As I do a lot of Data Warehousing I am always concerned that the data warehousing process itself could possibly impact performance. In order to track the various data warehousing procedures and insure that they do not harm performance I came up with...

  • Moving Dynamics - GP Databases

    Posted over 2 years ago
    by John Lowther John Lowther
    • 1 Comments
    Moving Dynamics-GP Databases: When I was moving my databases in a previous post , I had a problem with the user passwords. David has done a wonderful job of explaining exactly what was happening internally . Specifically the part about Dynamics-GP...

  • Sending Emails from Business Alerts

    Posted over 2 years ago
    by John Lowther John Lowther
    • 2 Comments
    First of all let's look at a little bit of the difference between xp_sendmail and sp_send_dbmail. These are the two methods of sending email from a SQL Server and all Dynamics-GP Business Alerts are in fact emails from the SQL Server. Also while you’re...

  • Slow Dynamics GP Login

    Posted over 2 years ago
    by John Lowther John Lowther
    • 2 Comments
    Login getting slow? While I was doing some research, I ran across this KB in CustomerSource . I gave it a try and decrease the login time by a nice amount. And as this is a "FAST PUBLISH" article I though I would help spread the word. ...

  • 2011 Round 4 Payroll Tax Update for Dynamics GP

    Posted over 2 years ago
    by John Lowther John Lowther
    • 2 Comments
    The R4 U.S. Payroll Tax Update for Microsoft Dynamics GP 10.0 has just been released. You can download it from customersource . For those of you on Dynamics GP 2010, I did not notice a R4 release yet but keep you eyes on this page . I would hazard...

  • ODBC Connections on x64

    Posted over 2 years ago
    by John Lowther John Lowther
    • 1 Comments
    I have been running my SQL databases on a x64 machine for quite a while now. However, my users are still using a 32bit Terminal Server to actually run Dynamics GP. I should also mention that I use two ODBC connections for our system. One is for production...

  • Data has been deleted

    Posted over 2 years ago
    by John Lowther John Lowther
    • 1 Comments
    Ok, just before lunch today the Payroll Manager call me about an error message she has in Dynamics GP. So I walk over to her desk to see what is going on, and as I sit there staring at the message below, I overhear the Controller and the Payables...

  • Employer FICA Owed for Direct Deposit

    Posted over 2 years ago
    by John Lowther John Lowther
    • 1 Comments
    If you are using Direct Deposit in Dynamics - GP, do not use the Check Register Report, instead use the Reprint Check Register Report to see the correct Employer FICA Owed amount. Of course Microsoft already has a fix for the problem, but just in case...

  • Synchronizing Dynamics GP Test Databases from your Production System

    Posted over 1 year ago
    by John Lowther John Lowther
    • 0 Comments
    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...

  • Searching for Data (updated)

    Posted over 1 year ago
    by John Lowther John Lowther
    • 0 Comments
    Now that I have finally gotten rid of my final SQL 2000 Server, I have updated my Data Search Script to take advantage of the VARCHAR(Max) data type. No more tables that is too wide for the @SQL variable. If you still have a SQL 2000 Server my old post...

  • Using "Select *" in code examples on my blog post

    Posted over 1 year ago
    by John Lowther John Lowther
    • 0 Comments
    A friend of mine pointed out that I really should not be using "*" in select statements and leaving out field names in Insert statements and that by doing so it might lead someone into bad habits, so I thought I would post this for everyone's...

  • SQL Server Backup, Integrity Check, Index and Statistics Maintenance

    Posted over 1 year ago
    by John Lowther John Lowther
    Please vote for Ola Hallengren, in my opinion he has the best maintenance scripts, and best of all “THERE FREE!”. You can check out his scripts and well as the link to vote from this page SQL Server Backup, Integrity Check, Index and Statistics Maintenance...

  • How to REALLY be Influential in Microsoft Dynamics

    Posted over 2 years ago
    by John Lowther John Lowther
    • 0 Comments
    Mark Polino does a fantastic job of telling everyone in the Dynamics Community how each of us can be influential in the Microsoft Dynamics Community and influence the future of Dynamics itself by using MS Connect . Read his post here and then become an...

  • Where oh where has John been hiding?

    Posted 11 months ago
    by John Lowther John Lowther
    • 0 Comments
    Actually I have not been hiding, well kind of. Between getting ready for the Microsoft Technical Educational Conference (Tech-Ed), then attending the conference, and then trying to get caught up at work after being gone for a week it has been a little...

  • Deadlocks caused by Implicit Conversion

    Posted 11 months ago
    by John Lowther John Lowther
    • 0 Comments
    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...

  • Notes on Performance for Microsoft Dynamics GP

    Posted 11 months ago
    by John Lowther John Lowther
    • 0 Comments
    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...
12345»