You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
20 March 2013
Dynamics GP Land: Updating Records with Excel
By a hack I mean that if you show this off to SQL professionals they will laugh at you...and it won't matter because your work will be done and you'll be going home.
11 March 2013
Changing part of a string in SQL Server using REPLACE | Victoria Yudin
29 January 2013
SQL settings causing GP performance issues | Dynamics University
19 December 2012
03 December 2012
DYNSA and SQL Maintenance for Dynamics GP
11 October 2012
Dynamics GP Land: Calculating the number of fiscal periods between two dates
22 August 2012
Yes, Dynamics GP 2010 is Compatible with Microsoft SQL Server 2012
06 August 2012
Weekly Dynamic: Line Numbers in SQL Server
But how do figure out what line is what? Do line numbers include spaces? There is a line number listed in the bottom right but even that is a pain to use.
In SQL Server Management Studio you can turn on line numbers with Tools | Options, expand Text Editor, Expand Transact-SQL, select General and check Line Numbers under Display.
10 May 2012
Rebooting because of an Automatic Update does interrupt SQL job execution. - Microsoft Dynamics GP DBA
03 May 2012
RAID and Its impact on your SQL performance - SQLServerCentral
If this isn't geeky enough for you, make sure to check out the comment at http://www.sqlservercentral.com/Forums/Topic1292935-143-1.aspx
This table summarizes the pros and cons of each of the Standard RAID Levels
| RAID Level | Fault Tolerance | Read Performance | Write Performance | RAID Write Penalty | Cost |
| 0 | None | Good | Excellent | 1 | Excellent |
| 1 | Good | Good | Good | 2 | Fair |
| 5 | Fair | Good | Poor | 4 | Good |
| 1+0 | Excellent | Excellent | Excellent | 2 | Poor |
| DP | Good | Good | Terrible | 6 | Good |
SQL Error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) - Developing for Dynamics GP - Site Home - MSDN Blogs
23 April 2012
19 April 2012
16 April 2012
11 April 2012
Some great scripts that John Lowther recently found - Microsoft Dynamics GP DBA
John Lowther shows off Some great scripts that he recently found.
I feel like this is a good time to point out the SQL Script section of DynamicAccounting.net
10 April 2012
09 April 2012
Free ebook: Introducing Microsoft SQL Server 2012 - Microsoft Press
For those of you looking for information about SQL Server 2012, Microsoft has a Free ebook: Introducing Microsoft SQL Server 2012. This is 288 pages of new stuff.
I’m impressed that MS is offering this in Mobi (Kindle), epub(other ereaders) and PDF formats. They recognized the growth of eBooks and responded.
29 March 2012
Data Analytics with SQL Server 2012
For those of you looking to go beyond my basic Excel dashboard session and beyond some of the Excel Deep Dive information check out RunAs Radio’s new episode on Data Analytics with SQL Server 2012.
Microsoft Dynamics GP and Microsoft SQL Server 2012 Compatibility | DynamicsCare
DynamicsCare has the scoop on Microsoft Dynamics GP and Microsoft SQL Server 2012 Compatibility
You know that you were holding your breath for this news!
28 March 2012
Dynamics GP 2010 R2 Database SDK | Interesting Findings & Knowledge Sharing
Sivakumar couldn’t make it to Convergence this year so he stayed home and pouted…or rather built a very cool Dynamics GP 2010 R2 Database SDK documenting GP objects in an easy to use manner.
