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

  • Two ways to Export data from SSMS to Excel

    Posted 7 days ago
    by John Lowther John Lowther
    • 0 Comments
    One of the things a DBA does is run some sort of query in Microsoft SQL Server Management Studio (SSMS) and export the results for someone else to use in Microsoft Excel. So let us look into two of the ways to do just that. In both cases, we will be...

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

    Posted 4 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,

  • Deprecated Database Engine Features in SQL Server 2012

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

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

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

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

    Posted 5 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,

  • The Dynamics GP Blogster: Microsoft Dynamics GP Excel Dashboards

    Posted 5 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,

  • Reporting Resources for Dynamics GP | Dynamics GP Insights

    Posted 5 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,

  • Speechless

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

  • Blog Posts by Mark Polino

    Posted 8 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 8 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,

  • GPUG DBA SIG (2012 - 09 - 20) Voting for Topics

    Posted 8 months ago
    by John Lowther John Lowther
    • 0 Comments
    All the request for our next webinar are in and the top three are ready for your votes and comments . You can register for the webinar here . till later,

  • Getting entire databases from one point to another.

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

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

  • You have to Read and Never Stop Learning!

    Posted 9 months ago
    by John Lowther John Lowther
    • 0 Comments
    While I posted this on my Accidental Administrator site I wanted to make sure everyone saw it as it really applies to everybody. So have a few giggles on me as you read my post You have to Read and Never Stop Learning!   till later,

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

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

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

  • Vote for the GPUG 2012 All Star

    Posted 9 months ago
    by John Lowther John Lowther
    • 0 Comments
    Each year, GPUG recognize 3 Premium Members who represent the community well by having: Courage – The strength to persevere, hold the talent to teach fellow GP users. Passion – For those who share their GP and technology passion with others. Resolve ...

  • Jonathan Kehayias | Identifying High Compile Time Statements from the Plan Cache

    Posted 10 months ago
    by John Lowther John Lowther
    • 0 Comments
    Jonathan Kehayias digs into Identifying High Compile Time Statements from the Plan Cache . till later

  • GP - Multiple Company Support in Single Database | Microsoft Connect

    Posted 10 months ago
    by John Lowther John Lowther
    • 0 Comments
    Ever wanted needed multiple companies but wanted the advantages of a single database? Go here to vote on this item in Microsoft Connect ==> GP - Multiple Company Support in Single Database | Microsoft Connect till later,

  • How to use Word Mail Merge and Macros to Import Data - Developing for Dynamics GP - Site Home - MSDN Blogs

    Posted 10 months ago
    by John Lowther John Lowther
    • 0 Comments
    I was nicely surprised on my GPUG DBA SIG webinar today when someone told me about a post from my friend David Musgrave on How to use Word Mail Merge and Macros to Import Data . Check it out! till later,

  • Alerts: 401k Setup

    Posted 10 months ago
    by John Lowther John Lowther
    • 0 Comments
    For years I have been writing alerts to let either myself of someone else know that there is a problem somewhere so that it can be fixed before it becomes a major issue. Now, over the years I have boiled my alerts down into a few generic types. And while...

  • SQL Script for Account Level Security - Developing for Dynamics GP - Site Home - MSDN Blogs

    Posted 10 months ago
    by John Lowther John Lowther
    • 0 Comments
    Check out Sivakumar's post on SQL Script for Account Level Security till later,

  • Integration Manager: Error - The 'Microsoft.ACE.OLDB.12.0' provider is not registered on the local machine

    Posted 10 months ago
    by John Lowther John Lowther
    • 0 Comments
    Frank Hamelly has not one but two resolutions. Check out his post at GP2themax 'Microsoft.ACE.OLDB.12.0' provider is not registered on the local machine till later,

  • Notes on Performance for Microsoft Dynamics GP

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

  • Deadlocks caused by Implicit Conversion

    Posted 10 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...
12345»