Home
»
Microsoft Dynamics GP
»
Microsoft Dynamics GP DBA
»
All Tags
»
Dynamics GP
Browse by Tags
Application Management
CBI
Code
Consolidated Business Intelligence
Data Warehouse
DBA
Dynamics
Dynamics GP Users Group
EDW
Enterprise Data Warehouse
FYI
GP
GPUG
GPUG SIG - BI and Reporting
GPUG SIG - DBA
Maintenance
Microsoft
Microsoft Dynamics
Microsoft Dynamics GP
Payroll
Performance
SQL
SQL Administration
SQL Code
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:
You have to Read and Never Stop Learning!
John Lowther
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,
on
21 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:
Cleaning up after a Payroll Error
John Lowther
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 like to know what I am about to delete! Select * From...
on
20 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:
How to use Word Mail Merge and Macros to Import Data - Developing for Dynamics GP - Site Home - MSDN Blogs
John Lowther
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,
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:
Notes on Performance for Microsoft Dynamics GP
John Lowther
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 keep a link to it because it is updated as new things...
on
11 Jul 2012
Blog Post:
Deadlocks caused by Implicit Conversion
John Lowther
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 Deadlocks in SQL Server . Till later,
on
29 Jun 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:
Table Links in Extender - Microsoft Dynamics GP Support Blog - Site Home - MSDN Blogs
John Lowther
The Microsoft Dynamics GP Support Team takes a look at deleting Extender data when Dynamics GP data is deleted via Table Links in Extender .
on
31 May 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:
Problem with SQL Server 2008 and Exchange 2010
John Lowther
First please keep in mind that I know almost nothing about Exchange or how it works. The parts about Exchange that I will be discussing I am just paraphrasing from my Exchange Server Admin. Here is what happened: For years we have been using Exchange 2003 with no problems. And for years I have had SQL...
on
23 Apr 2012
1
2