Microsoft Dynamics GP DBA

Microsoft Dynamics GP DBA
  • 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...
  • 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...
  • 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...
  • 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...
  • 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,
  • 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,
  • 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,
  • Blog Posts by Mark Polino

    • 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...
  • 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,
  • Reporting Resources for Dynamics GP | Dynamics GP Insights

    • 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,
  • GP2themax - Helping users get the 'max' from Dynamics GP: Field Service Business Alerts

    • 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,
  • 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...
  • Getting entire databases from one point to another.

    • 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

    • 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...
  • GPUG DBA SIG (2012 - 09 - 20) Voting for Topics

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