Home
»
Microsoft Dynamics GP
»
Microsoft Dynamics GP DBA
»
All Tags
»
GP
Browse by Tags
Application Management
CBI
Code
Consolidated Business Intelligence
Data Warehouse
DBA
Dynamics
Dynamics GP
Dynamics GP Users Group
EDW
Enterprise Data Warehouse
FYI
GPUG
GPUG SIG - BI and Reporting
GPUG SIG - DBA
Microsoft
Microsoft Dynamics
Microsoft Dynamics GP
Payroll
Performance
SQL
SQL Administration
SQL Code
SQL Maintenance
SQL Server
Related Posts
Blog Post:
Two ways to Export data from SSMS to Excel
John Lowther
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 executing a select statement in SSMS, and to keep...
on
16 May 2013
Blog Post:
Wondering what I am up to??? Read this other post
John Lowther
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,
on
31 Dec 2012
Blog Post:
Deprecated Database Engine Features in SQL Server 2012
John Lowther
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 me. Things change, that is life. The only constant...
on
28 Dec 2012
Blog Post:
Disk and File Layout for SQL Server - SQL Server Team Blog - Site Home - TechNet Blogs
John Lowther
Here is an excellent post on Disk and File Layout for SQL Server till later,
on
26 Dec 2012
Blog Post:
Finding out what the values mean in a static field in a Dynamics GP Database
John Lowther
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,
on
27 Nov 2012
Blog Post:
The Dynamics GP Blogster: Microsoft Dynamics GP Excel Dashboards
John Lowther
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,
on
26 Nov 2012
Blog Post:
Reporting Resources for Dynamics GP | Dynamics GP Insights
John Lowther
Christina Phillips has a great list of Reporting Resources for Dynamics GP So, what are you waiting for, go check it out! Till later,
on
23 Nov 2012
Blog Post:
Speechless
John Lowther
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 that stated “Congratulations! We are pleased...
on
3 Oct 2012
Blog Post:
Blog Posts by Mark Polino
John Lowther
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 a list. Leslie Vail takes us inside Installing the...
on
17 Sep 2012
Blog Post:
GPUG DBA SIG (2012 - 09 - 20) Voting for Topics
John Lowther
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,
on
5 Sep 2012
Blog Post:
Getting entire databases from one point to another.
John Lowther
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 amounts of data from one place to another. ...
on
5 Sep 2012
Blog Post:
About Dynamics, Development and Life: Data Warehouse / Business Intelligence Solution for Dynamics GP–Part 1 Overview
John Lowther
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 post of the series ==> Data Warehouse / Business...
on
22 Aug 2012
Blog Post:
GPUG DBA SIG (2012 - 09- 20) Topic Request
John Lowther
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 here . till later,
on
21 Aug 2012
Blog Post:
GP - Multiple Company Support in Single Database | Microsoft Connect
John Lowther
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,
on
19 Jul 2012
Blog Post:
Alerts: 401k Setup
John Lowther
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 I will keep you guessing as to the types of alerts...
on
18 Jul 2012
Blog Post:
SQL Script for Account Level Security - Developing for Dynamics GP - Site Home - MSDN Blogs
John Lowther
Check out Sivakumar's post on SQL Script for Account Level Security till later,
on
13 Jul 2012
Blog Post:
Integration Manager: Error - The 'Microsoft.ACE.OLDB.12.0' provider is not registered on the local machine
John Lowther
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,
on
12 Jul 2012
Blog Post:
Dynamics GP SOP line items with serial numbers and comments
John Lowther
Victoria shows us how to get the Dynamics GP SOP line items with serial numbers and comments till later,
on
5 Jun 2012
Blog Post:
Using Lookups in GP Reports Viewer to make parameter selection more user friendly | Victoria Yudin
John Lowther
Victoria Yudin takes a look at using data lookup as parameters for reporting. See her post for details Using Lookups in GP Reports Viewer to make parameter selection more user friendly till later,
on
31 May 2012
Blog Post:
Excel for Reporting needs
John Lowther
Mark Polino checks out the features of using Excel with Pivot Tables and Formulas. Check out his post here: DynamicAccounting.net: Weekly Dynamic: Filtering a Pivot Table with a Formula - Technology Till later, John
on
23 Apr 2012
Blog Post:
Check Links and Reconcile
John Lowther
So that you get this information as well please check out my post on the The Dynamics GP Administrator site. Till later,
on
16 Apr 2012
Blog Post:
Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 7 – Putting it all together.
John Lowther
RECAP As the last post in this series, I wanted to recap and try to give a high level of what we wish to accomplish. If you remember on the first post we wanted to achieve two things, and that was not to hurt the performance of the Applications or of the BI Solution. In the second post , we...
on
16 Jan 2012
Blog Post:
Running into Steve Ballmer
John Lowther
Ok, everyone knows that Steve Ballmer was at Convergence in Atlanta for the Keynote on Monday morning 4/11/2011. Nevertheless, here is how I started that day. Wake up at 6:00am like always, put on some old sweat pants, and throw on a ragged t-shirt I probably should have thrown away years ago....
on
20 Apr 2011