Microsoft Dynamics GP DBA

Microsoft Dynamics GP DBA
  • Moving Dynamics-GP databases to a new SQL Server

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

    • 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...
  • Sending Emails from Business Alerts

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

    • 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

    • 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...
  • Deploying SSRS Reports

    • 2 Comments
    Ok, I know I have done this dozens of times if not more. However, I was deploying the SSRS reports for GP2013 SP1 and once again got that error (The Deployment has exceeded the Maximum Request Length Allowed by Target Server. Set the maxRequestLength...
  • Check out Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2012

    • 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

    • 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

    • 2 Comments
    So that you get this information as well please check out my post on the The Dynamics GP Administrator site. Till later,
  • Moving Dynamics - GP Databases

    • 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...
  • Slow Dynamics GP Login

    • 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

    • 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...
  • Dynamics GP Appears Locked-Up or Not Responding

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

    • 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

    • 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...
  • Synchronizing Dynamics GP Test Databases from your Production System

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

    • 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

    • 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

    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

    • 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...
  • ODBC Connections on x64

    • 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

    • 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

    • 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...
  • Just some things I found recently

    • 1 Comments
    SQL Server xact abort setting breaks Microsoft Dynamics GP on Developing for Dynamics GP Opening PDF Documents with Word on About Dynamics, Development and Life W-2 Other Codes for Box 12 on Dynamics Confessions Blogspot Review of Victoria Yudin's...
  • Complete Re-Install of Microsoft Dynamics GP

    • 0 Comments
    Ok, so several months ago I started a series of post (all one of them) about doing a complete re-install of Microsoft Dynamics GP. You can read that post here , if you so desire. Now one of the things that has taken so long is that I wanted to write the...