Microsoft Dynamics GP DBA - GP Technical Blogs - Microsoft Dynamics Community

| |

Microsoft Dynamics GP DBA
Dynamics GP Land: Clearing remembered / default login for SQL Server Management Studio
Posted by John Lowther on
Posted 5-17-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Check out Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2012
Posted by John Lowther on
Posted 5-11-2012
- 2 Comments
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...
Microsoft Dynamics GP DBA
Microsoft Dynamics Most Influential People Top 100 for 2012
Posted by John Lowther on
Posted 5-9-2012
- 3 Comments
The list is out for 2012! You can get to the list from the DynamicsWorld website here . First, I congratulate all those that made the list! Especially those that I know and follow, you all are GREAT! ...
Microsoft Dynamics GP DBA
Rebooting because of an Automatic Update does interrupt SQL job execution.
Posted by John Lowther on
Posted 5-9-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Problem with SQL Server 2008 and Exchange 2010
Posted by John Lowther on
Posted 4-23-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Excel for Reporting needs
Posted by John Lowther on
Posted 4-23-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Backing up the Tail of the Log
Posted by John Lowther on
Posted 4-17-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Database Snapshots - Something's do not always work the way you think they should.
Posted by John Lowther on
Posted 4-17-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
From an Excel spreadsheet to a specific Microsoft Dynamics GP screen
Posted by John Lowther on
Posted 4-17-2012
- 0 Comments
Mark Polino did a great post on using and explaining the drill down functions from Microsoft Excel to Dynamics GP. Check out his post DynamicAccounting.net: Weekly Dynamic: Drill Down in Dynamics GP and...
Microsoft Dynamics GP DBA
Check Links and Reconcile
Posted by John Lowther on
Posted 4-16-2012
- 2 Comments
So that you get this information as well please check out my post on the Accidental Administrator site. Till later,
Microsoft Dynamics GP DBA
Some great scripts that I recently found
Posted by John Lowther on
Posted 4-10-2012
- 2 Comments
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...
Microsoft Dynamics GP DBA
The Microsoft Dynamics Most Influential People Top 100 List for 2012
Posted by John Lowther on
Posted 3-29-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Top 100 Most Influential People in Microsoft Dynamics 2012 Nominations
Posted by John Lowther on
Posted 3-12-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Best Jobs in America 2011 - Money Magazine on CNNMoney
Posted by John Lowther on
Posted 3-6-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Round 3 Tax update for 2012 is out!
Posted by John Lowther on
Posted 3-6-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Changing your Dynamics GP - SQL Server Reporting Services from Native Mode to SharePoint Integrated Mode?
Posted by John Lowther on
Posted 3-1-2012
- 0 Comments
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...
Microsoft Dynamics GP DBA
Script History Table and Procedures
Posted by John Lowther on
Posted 2-21-2012
- 2 Comments
As I do a lot of Data Warehousing I am always concerned that the data warehousing process itself could possibly impact performance. In order to track the various data warehousing procedures and insure...
Microsoft Dynamics GP DBA
Resetting the users passwords after updating your test system
Posted by John Lowther on
Posted 2-17-2012
- 0 Comments
Ok, when you have multiple test servers and you have to refresh them more than just once in a while, or if you only have one test server but lots of users, resetting everyone’s password can become...
Microsoft Dynamics GP DBA
User Translation of the Payroll Tax Cuts
Posted by John Lowther on
Posted 2-10-2012
- 0 Comments
Terry Heley, MSFT does a good job of explaining the Payroll Tax cuts and how they effect Dynamics GP. Check out the entire post here. Payroll Tax Cut Temporarily Extended into 2012 ....translated so a...
Microsoft Dynamics GP DBA
Where to put “my” stuff?
Posted by John Lowther on
Posted 2-1-2012
- 2 Comments
It has been a while since my last post as I have been really busy, but as I sit here during an install staring at a blue bar slowly going across the screen, I might as well multitask. So, as a DBA we are...