Home
»
Microsoft Dynamics GP
»
Microsoft Dynamics GP DBA
»
All Tags
»
FYI
Browse by Tags
Application Management
CBI
Code
Consolidated Business Intelligence
Data Warehouse
DBA
Dynamics
Dynamics GP
Dynamics GP Users Group
EDW
End of Year
Enterprise Data Warehouse
GP
GPUG
GPUG SIG - DBA
Maintenance
Microsoft
Microsoft Dynamics
Microsoft Dynamics GP
Payroll
Performance
SQL
SQL Administration
SQL Code
SQL Server
Related Posts
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:
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:
Vote for the GPUG 2012 All Star
John Lowther
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 – Willing to take the time to help others with challenges...
on
17 Aug 2012
Blog Post:
Jonathan Kehayias | Identifying High Compile Time Statements from the Plan Cache
John Lowther
Jonathan Kehayias digs into Identifying High Compile Time Statements from the Plan Cache . till later
on
19 Jul 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:
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:
Where oh where has John been hiding?
John Lowther
Actually I have not been hiding, well kind of. Between getting ready for the Microsoft Technical Educational Conference (Tech-Ed), then attending the conference, and then trying to get caught up at work after being gone for a week it has been a little hard to find time to blog. How some of the others...
on
26 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:
Dynamics GP Land: Problem with Dynamics GP 2010 EFT Payables CCD+ CTX File Format
John Lowther
Steve Endow from Dynamics GP Land runs into a Problem with Dynamics GP 2010 EFT Payables CCD+ CTX File Format till later,
on
29 May 2012
Blog Post:
Dynamics GP Land: Clearing remembered / default login for SQL Server Management Studio
John Lowther
If you have every had this problem then you know exactly how annoying it can be. Check out Christina Phillips post on getting rid of the default login in SQL Server Management Studio. Dynamics GP Land: Clearing remembered / default login for SQL Server Management Studio till later,
on
17 May 2012
Blog Post:
Check out Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2012
John Lowther
Check out Doug's list of Influential Dynamics People. Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2012 Just my own opinion but I personally I have to agree with Doug. till later,
on
11 May 2012
Blog Post:
Rebooting because of an Automatic Update does interrupt SQL job execution.
John Lowther
I am not sure where I got it from, if it was incorrect information, if it is just outdated information, or if it is one of those "It Depends" things. But I have always been under the impression that a reboot caused by automatic updates would not occur if the SQL Server was busy. However as...
on
9 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
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:
Backing up the Tail of the Log
John Lowther
One of the secrets to recovering that last piece of data that has changed since your last backup when disaster strikes is to backup the tail of the log. To find out multiple ways to backup the tail of the log when disaster strikes, check out this post from Pau Randall. In Recovery... | Disaster recovery...
on
17 Apr 2012
Blog Post:
Database Snapshots - Something's do not always work the way you think they should.
John Lowther
While there are a lot of good things about database snapshots, and a lot of good reasons for using them. Under certain circumstances they can cause problems. In his Blog ( In Recovery ) Paul Randall goes over a bug when you are reverting back from a database snapshot. You can get all the details from...
on
17 Apr 2012
Blog Post:
Some great scripts that I recently found
John Lowther
A few days ago I was searching for something and ran across this post from Jivtesh Singh . One of the scripts that he points out is a post from Mariano Gomez and lets you search for all tables for columns with the same name. Another one is a stored procedure to search the entire database for a specific...
on
10 Apr 2012
Blog Post:
The Microsoft Dynamics Most Influential People Top 100 List for 2012
John Lowther
Voting has started for the top 100 for 2012 While I will admit that I would appreciate your vote, I am really just happy to be nominated. And there are lots of great people on the list. This page has a complete list of everyone in the running. Note: as the actual voting pages are broken into smaller...
on
29 Mar 2012
Blog Post:
Top 100 Most Influential People in Microsoft Dynamics 2012 Nominations
John Lowther
Please take a look at this post on the "Developing for Microsoft Dynamics GP" blog. And nominate the people you feel should be on the list. Top 100 Most Influential People in Microsoft Dynamics 2012 Nominations - Developing for Microsoft Dynamics GP - GP Technical Blogs - Microsoft Dynamics...
on
12 Mar 2012
Blog Post:
Best Jobs in America 2011 - Money Magazine on CNNMoney
John Lowther
Hey Folks, Considering that I wear multiple hats were I work, like most people these days, this years list of the Best Jobs in America does a person good. You can check out the Best Jobs in America for 2011 here: Best Jobs in America 2011 - Money Magazine on CNNMoney Till later & hope to see you...
on
6 Mar 2012
Blog Post:
Round 3 Tax update for 2012 is out!
John Lowther
The round 3 tax update has been released! You can download them from here. Now Available Round 3 U.S. Payroll Tax Update for Microsoft Dynamics GP 10.0 This page contains the latest U.S. Payroll Tax Update for Microsoft Dynamics GP 10.0. Now Available Round 3 U.S. Payroll Tax Update for Microsoft Dynamics...
on
6 Mar 2012
Blog Post:
Changing your Dynamics GP - SQL Server Reporting Services from Native Mode to SharePoint Integrated Mode?
John Lowther
Like most people when I first setup SQL Server Reporting Services I used the Native mode. For awhile I have been toying with the idea of switching to SharePoint Integrated Mode but with so many things on my task list, this idea just kind of sits on the back burner. However, I was looking for something...
on
1 Mar 2012
1
2
3