Microsoft Dynamics GP DBA

Microsoft Dynamics GP DBA
  • Beta Testers Requested

    • 0 Comments
    I have been working on a SQL script to restore transaction log backup files to a log shipped database regardless of the actual transaction log backup filename. In other words, I cannot use the filename or part of the filename to know the order to restore...
  • Some things that I ran across today

    • 0 Comments
    As I was searching the web this evening here’s a few things that I ran across. Of course this list is not inclusive nor is it in any peculiar order. From Victoria Yudin SQL view for Dynamics GP open year GL trial balance From GP2TheMAX Need to upgrade...
  • 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...
  • 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...
  • Blogging from Microsoft Word

    • 0 Comments
    Here is what I have discovered so far in my some 50 minutes of using Microsoft Word to Blog rather than Microsoft Live Writer. First, the biggest difference is just a matter of preference, so use whichever tool to blog with that you wish. I did notice...
  • Complete Re-Install of Microsoft Dynamics GP (Table of Contents)

    • 1 Comments
    When I wrote my first post a few minutes ago, I was thinking I would do a simple Introduction with a series of post afterwards, as I have done in the past. However, I got to thinking, that maybe for this series of post I would test out something a little...
  • Where oh where have I been hiding?

    • 0 Comments
    So, where oh where have I been hiding? Well, actually I have not been hiding per say, just lots of stuff going on like all of us. However, one project has been quite an adventure. It sounded simple to start with, but turned out to be so much more...
  • 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...
  • My two favorite DEX.INI settings

    • 0 Comments
    If I had to pick only two settings for my dex.ini file they would have to be the following: 1) EmpLookUp=2 This setting make the employee card lookup default to the employees name rather than by id. 2) SQLLoginCompatibilityMode=TRUE While I do not normally...
  • What are Business Intelligence Cubes?

    • 0 Comments
    Now this is a nice easy for the end user to understand definition of What are Business Intelligence Cubes? Till Later,
  • SQL view for SOP sales by customer by month

    • 0 Comments
    Victoria is at it again! Check out SQL view for SOP sales by customer by month . Till Later,
  • I admit defeat.

    • 0 Comments
    Ok, so I was not able to post at least something each day at Tech-Ed 2013. I blame it totally on Microsoft Windows Surface. Not that there is anything wrong with the Surface, but that I was able to buy a Surface Pro and a Surface RT at unbelievable prices...
  • Decisions at Tech-Ed NA 2013

    • 0 Comments
    Decisions, decisions, decisions, no matter how hard I try I still cannot figure out how to be in two places at once. Maybe it is something that I am just doing wrong, or I am just not smart enough to figure it out. So, what do I do, lots of excellent...
  • Microsoft Tech-Ed North America 2013

    • 0 Comments
    WOW, So much to learn, fantastic speakers, experts, and networking. So little time to blog. till later,
  • Another Day at Microsoft Tech-Ed

    • 0 Comments
    Man, oh man, just soaking up the knowledge on SQL Server, SharePoint, Visual Studio. How much more can I pack into my head? till later,
  • SQL Server Data Tools

    • 0 Comments
    To summarize SQL Server Data Tools (SSDT) in a single word, WOW! till later,
  • Pre-Con Class at Microsoft Tech-Ed

    • 0 Comments
    Enjoying a great Pre-Con class “How to Be a Successful DBA in the Changing World of Cloud and On-Premise Data”. Really looking forward to applying this for Microsoft Dynamics GP and my Data Warehouse!!! Till later,
  • Trying to Blog while attending a Conference

    • 0 Comments
    Starting today I will be attending Microsoft’s Technical Educational (Tech-Ed) North America 2013 in New Orleans, LA. Now, if you haven’t noticed I am usually not very successful at blogging while I am at a conference, but I am at least going to try and...
  • Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013

    • 0 Comments
    Ok, so I am playing catch-up on my blogging Be sure to read Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013 on his Rose Business Solutions, Inc. Blog post! Till Later,
  • Two ways to Export data from SSMS to Excel

    • 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

    • 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

    • 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

    • 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

    • 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

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