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...

  • 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...

  • 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...

  • 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...

  • Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 2

    Posted over 2 years ago
    by John Lowther John Lowther
    • 0 Comments
    This seems to be a lot harder and taking a lot longer that I initially thought. How hard can it be to pull data from several applications into a single EDW, right? Well, here is a monkey wrench for you. Just about every application has some amount...

  • Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Introduction

    Posted over 2 years ago
    by John Lowther John Lowther
    • 0 Comments
    Sorry it's been so long, seems like the more I have to do, the less time I have to do it in. :) Anyway, my next project is a single point of entry application for a multi-application, multi-process, data integration, and BI solution. ???...

  • Deprecated Database Engine Features in SQL Server 2012

    Posted 5 months ago
    by John Lowther John Lowther
    • 0 Comments
    I do not know if everyone has seen this but you really should go take a look! You can find it here ==> Deprecated Database Engine Features in SQL Server 2012 Now, for me there is not too many things that list that make that much of a difference to...

  • Why reinvent the wheel? Use Automated Solutions on Customer Source.

    Posted over 2 years ago
    by John Lowther John Lowther
    • 0 Comments
    Why try creating sql scripts or anything that someone else has already done? When it comes to the most common problems in Dynamics GP, Microsoft has created Automated Solutions had has published them on Customer Source for most versions of Dynamics GP...

  • Wondering what I am up to??? Read this other post

    Posted 5 months ago
    by John Lowther John Lowther
    • 0 Comments
    So, while everyone is enjoying their New Year’s eve and New Years day. What am I up to? Read this to find our. ==> 2012 End of Year till later,

  • 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. ...

  • 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...

  • Upgrading from SQL 2005 to SQL 2008 or SQL 2008 R2?

    Posted over 2 years ago
    by John Lowther John Lowther
    • 0 Comments
    If you are thinking about upgrading your SQL server here is a GPUG Tech Tip that you should check out. Three Ways to Upgrade SQL 2005 for Dynamics-GP Till next post, John

  • Disk and File Layout for SQL Server - SQL Server Team Blog - Site Home - TechNet Blogs

    Posted 5 months ago
    by John Lowther John Lowther
    • 0 Comments
    Here is an excellent post on Disk and File Layout for SQL Server till later,

  • Getting entire databases from one point to another.

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

  • Finding out what the values mean in a static field in a Dynamics GP Database

    Posted 6 months ago
    by John Lowther John Lowther
    • 0 Comments
    Check out what one of my coworkers figured out!  Additional Field Information Just goes to show to never get too old to learn   Till later,

  • Cleaning up after a Payroll Error

    Posted 9 months ago
    by John Lowther John Lowther
    • 0 Comments
    If during the Payroll Process the Payroll Clerk gets an error to the effect of "an Open Operation error, a Get/Change error, or a Save Operation error " Then give these scripts a try: --Find let us find out where the error actually is: -- I...

  • 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...

  • Blog Posts by Mark Polino

    Posted 9 months ago
    by John Lowther John Lowther
    • 0 Comments
    First, I have to admit I have no idea how one person can blog so much, but somehow he manages to out blog me by an unimaginable amount. So, rather than create an individual post for each thing he has posted over the last few days I will just give you...

  • GP2themax - Helping users get the 'max' from Dynamics GP: Field Service Business Alerts

    Posted 9 months ago
    by John Lowther John Lowther
    • 0 Comments
    Frank Hamelly shows us how to add Field Service to Dynamics GP Business Alerts. Check out his post here ==> GP2themax - Helping users get the 'max' from Dynamics GP: Field Service Business Alerts till later,

  • About Dynamics, Development and Life: Data Warehouse / Business Intelligence Solution for Dynamics GP–Part 1 Overview

    Posted 9 months ago
    by John Lowther John Lowther
    • 0 Comments
    MVP Jivtesh Singh starts a series of post on building a Data Warehouse using Kimball’s approach . Check out his first post of the series located ==> Data Warehouse / Business Intelligence Solution for Dynamics GP–Part 1 Overview And here is his second...

  • 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...

  • Memory Settings for SQL Server on 32-bit Systems

    Posted over 2 years ago
    by John Lowther John Lowther
    • 0 Comments
    With some of the 32-bit Operating Systems (depending on version and service pack) which could not handle all the memory you could physically install into the server and different applications needing memory in different ways a multitude of settings came...

  • Reporting Resources for Dynamics GP | Dynamics GP Insights

    Posted 6 months ago
    by John Lowther John Lowther
    • 0 Comments
    Christina Phillips has a great list of Reporting Resources for Dynamics GP So, what are you waiting for, go check it out! Till later,

  • The Dynamics GP Blogster: Microsoft Dynamics GP Excel Dashboards

    Posted 6 months ago
    by John Lowther John Lowther
    • 0 Comments
    Mariano Gomez does a fantastic job of describing some of the research that Microsoft is doing with Excel Dashboards in Microsoft Dynamics. Be sure to read his post here for all the details ==> Microsoft Dynamics GP Excel Dashboards Till later,
12345»