Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 300 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Dynamics CPM
Over 200 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: SQL Server
Links Sort by: Hits | References | Alphabetical
SQL Transaction Logs Explained
http://computerationdynamics.blogspot.com/2009/03/sql-transaction-logs-explained.html
If you are a SQL Database Administrator, set up transaction logging on the DYNAMICS and company SQL databases so the users don’t shoot you. Then you don’t have to read this short post.
This explanation is for anyone who doesn’t understand Microsoft SQL, isn’t a SQL DBA, and doesn’t ever want to become a SQL DBA.
SQL Transaction Logs (T-Logs) keep track of everything that’s done inside Microsoft Dynamics GP, as you’re doing it. Think of T-Logs as your time machine. If you just imported 200 customer records and determined you mapped the state codes to the country field, utilizing T-Logs…
This explanation is for anyone who doesn’t understand Microsoft SQL, isn’t a SQL DBA, and doesn’t ever want to become a SQL DBA.
SQL Transaction Logs (T-Logs) keep track of everything that’s done inside Microsoft Dynamics GP, as you’re doing it. Think of T-Logs as your time machine. If you just imported 200 customer records and determined you mapped the state codes to the country field, utilizing T-Logs…
Posted by
Microsoft SQL Server 2008-Runtime Now Available For Microsoft Dynamics
http://blogs.msdn.com/dynamicsgp/archive/2008/11/21/microsoft-sql-server-2008-runtime-now-available-for-microsoft-dynamics.aspx
SQL 2008 Performance
http://blogs.msdn.com/ukgp/archive/2009/05/22/sql-2008-performance.aspx
I was looking through PartnerSource recently and came across a new white paper on benchmarking Dynamics GP on SQL Server 2008. We added this compatibility into the product back when we launched the feature pack and often I get customers asking me about why they should go to SQL 2008.
The performance…
Posted by
Why you should upgrade to Microsoft SQL Server 2008 if you are using Microsoft Dynamics GP 
The Microsoft Dynamics GP Product Management and Marketing team has published some performance stats that are good enough reasons to upgrade to Microsoft SQL Server 2008 if you are a Microsoft Dynamics GP customer running SQL Server 2005 or even SQL Server 2000. Their stats revolve around the use of SQL Server 2008's row compression and page compression features and their ability to save a good amount of storage space.
Don't…
http://dynamicsgpblogster.blogspot.com/2009/06/why-you-should-upgrade-to-microsoft-sql.html
The Microsoft Dynamics GP Product Management and Marketing team has published some performance stats that are good enough reasons to upgrade to Microsoft SQL Server 2008 if you are a Microsoft Dynamics GP customer running SQL Server 2005 or even SQL Server 2000. Their stats revolve around the use of SQL Server 2008's row compression and page compression features and their ability to save a good amount of storage space.Don't…
Posted by
Sharepoint 2010 and SQL database mirroring
http://ddelprado.blogspot.com/2010/05/sharepoint-2010-and-sql-database.html
GP 10 on Windows XP/SQL Express (Don't Try this at Home)
http://www.jivtesh.com/2007/12/gp-10-on-windows-xpsql-express-don-try.html
We installed GP 10 Server on a Windows XP machine recently. I don't recommend this as Windows XP is not supported as a server. However, a client didn't want to upgrade his server which was on GP 7 , and well ... the client is *always* right!
Everything seems to be working reasonably well till now.
Earlier, during our testing, we faced an interesting issue - we could not add any users.
It was one of those issues where…
Posted by
Getting to Know and Love the SQL Server Browser Service
http://dynamicsgpland.blogspot.com/2009/08/getting-to-know-and-love-sql-server.html
A while ago I wrote about some problems I had logging into GP that were caused because the SQL Server browser service was not running.
I'd like to (belatedly) follow up with an explanation of the history behind the SQL Server Browser service, and why you should make sure it is running on a Dynamics GP SQL 2005 server.
Back in the days of SQL Server 7.5, you could only have one "instance" of SQL Server on a machine. That single SQL server listened for connections on port 1433. Life was simple, and all was peaceful. (except for the single instance limitation)
With the release of SQL Server 2000, you could install multiple SQL instances on the same machine, effectively allowing you to host multiple SQL Servers on one physical box. This was great, but there…
I'd like to (belatedly) follow up with an explanation of the history behind the SQL Server Browser service, and why you should make sure it is running on a Dynamics GP SQL 2005 server.
Back in the days of SQL Server 7.5, you could only have one "instance" of SQL Server on a machine. That single SQL server listened for connections on port 1433. Life was simple, and all was peaceful. (except for the single instance limitation)
With the release of SQL Server 2000, you could install multiple SQL instances on the same machine, effectively allowing you to host multiple SQL Servers on one physical box. This was great, but there…
Posted by
Technet Radio -Performance Improvements SQL 2008 Analysis Services
http://msdynamicsgp.blogspot.com/2008/08/technet-radio-performance-improvements.html
Technet Radio has a very approachable podcast in their August 19th show that describes the…
Posted by
Steve Gray Takes on SQL Optimization
http://msdynamicsgp.blogspot.com/2007/10/steve-gray-takes-on-sql-optimization.html
Steve Gray of 4Penny.net gets pointed to quite a bit here. Of course, I've stood over Steve's shoulder and told him what I wanted while he wrote some really complex SQL Stored Procs for Crystal Reports. I also called him to help me write the core…
Posted by
SQL Server 2005 Performance Dashboard
http://msdynamicsgp.blogspot.com/2007/06/sql-server-2005-performance-dashboard.html
For those of you looking to tune the SQL performance of your GP installation, take a look at the new Performance Dashboard from Microsoft. This is a free add on to SQL Server 2005 but you have to be running SP2.
So what is SQL Server 2005 Performance Dashboard? I'll let the MS folks tell you:
The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SP2 release of SQL Server Management Studio.
The reports allow a database administrator to quickly…
Posted by
Using SQL Server CLR stored procedures to integrate Microsoft Dynamics GP and Microsoft CRM: Configuring SQL Server and creating table triggers
http://dynamicsgpblogster.blogspot.com/2010/08/using-sql-server-clr-stored-procedures.html
Posted by
SQL Maintenance Scare - Janakiram MP
http://www.vaidy-dyngp.com/2009/08/sql-maintenance-scare-janakiram-mp.html
Alright, this one was a real scary incident.
I was wondering what would have happened if Janakiram MP did not find that 2 months prior backup of DYNAMICS. Worst, if the mentioned guy had done anything on any Company Database, life would have been even more miserable.
Just some addition of my thoughts:
1. Always be there for your client when they try doing any sort of maintenance that involve Dynamics…
I was wondering what would have happened if Janakiram MP did not find that 2 months prior backup of DYNAMICS. Worst, if the mentioned guy had done anything on any Company Database, life would have been even more miserable.
Just some addition of my thoughts:
1. Always be there for your client when they try doing any sort of maintenance that involve Dynamics…
Posted by
Things I Had To Do To Get Replication Working
http://greatplainsguy.blogspot.com/2008/04/things-i-had-to-do-to-get-replication.html
I recently had a fight/set up transactional replication (with updating subscribers!) on my databases.
Here's some of the crazy stuff I had to do:
1) Go into the bowels of my DCOM security setup and open everything up (more details to come).
2) Run msdtc -install / hack the registry / run msdtc -reinstall.
3) Create some funky looking user in my SQL…
Here's some of the crazy stuff I had to do:
1) Go into the bowels of my DCOM security setup and open everything up (more details to come).
2) Run msdtc -install / hack the registry / run msdtc -reinstall.
3) Create some funky looking user in my SQL…
What version of SQL Server am I running?
http://victoriayudin.com/2008/10/05/what-version-of-sql-server-am-i-running/
Here is a summary list of the major releases and service packs for Microsoft SQL Server:
SQL Server
RTM
SP 1
SP 2
SP 3 / 3a
SP…
Scheduling Jobs in SQL 2005
http://mbsguru.blogspot.com/2009/05/scheduling-jobs-in-sql-2005.html
After posting Automatic Aging for GP a request to explain how to schedule such a script to run unassisted was posed. Leveraging SQL Server Agent Jobs to schedule tasks that can execute a myriad of different types of events is a powerful way to improve productivity and automate processes among other things. On top of that, it's incredibly simple!
In this example, I'm going to use SQL 2005. The process would vary depending on which version of SQL Server you are running. In SQL Management Studio expand the SQL Server Agent and right click on Jobs to create a new Job.
In this example, I'm going to use SQL 2005. The process would vary depending on which version of SQL Server you are running. In SQL Management Studio expand the SQL Server Agent and right click on Jobs to create a new Job.
In…
Posted by
Microsoft SQL Server versions and editions
http://dynamicsgpblogster.blogspot.com/2009/05/microsoft-sql-server-versions-and.html
Posted by
My favorite SQL Server sites
http://ddelprado.blogspot.com/2009/01/my-favorite-sql-server-sites.html
Microsoft SQL Server 2005 System Table Map
http://ddelprado.blogspot.com/2006/01/microsoft-sql-server-2005-system-table.html
How to automatically run a stored procedure in SQL Server 2005
http://vstoolsforum.com/blogs/sqlserver/archive/2007/11/28/how-to-automatically-run-a-stored-procedure-in-sql-server-2005.aspx
Customer has SOP batches that are created periodically without transactions in them and they want to clean them out on a regular basis. I have the script to do so but now I want to create a scheduled task in SQL Server 2005 to run this during off hours, say, weekly. What is the best way to accomplish this task? Customer is now running GP v10 but in this…
Posted by
Inventory Item Creation Error - Dynamics GP 10 & SQL Server 2008
http://waqasb.blogspot.com/2009/11/inventory-item-creation-error-dynamics.html
Latest links
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- AX 2012 R2 - Lista de nuevas funcionalidades
- AX 2012 - Dimensiones financieras para las letras de cambio
- Microsoft Dynamics GP Technical Airlift 2013 – Registration Now Open
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.