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
Take a Hot Lap around SQL 2008 R2
http://blogs.msdn.com/ceibner/archive/2010/01/12/take-a-hot-lap-around-sql-2008-r2.aspx
I just heard about a great FREE event taking place in in Melbourne, Brisbane and Sydney at the end of January that I thought I recommend you attend to find out more about the great new features in SQL 2008 R2. Its the SQL Server 2008 R2 Hot Lap which is being run by Wardy IT Solutions.
The SQL Server 2008 R2 Hot Lap will be the first…
New Local SQL Server Resource for Australia on Technet
http://blogs.msdn.com/ceibner/archive/2009/11/26/new-local-sql-server-resource-for-australia-on-technet.aspx
Marcella Larsen, our Senior Product Marketing Manager for SQL Server has just put the finishing touches on the TechNet SQL Server TechCentre. This site has been set up…
SQL Code Camp 2008
http://blogs.msdn.com/ceibner/archive/2008/10/14/sql-code-camp-2008.aspx
SQL Server Management Studio Standard Reports 
If you have worked with SQL Server Management Studio (SSMS) in either Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you may have inadvertly overlooked one of its key features: Standard Reports.
Standard Reports are Reporting Services (SSRS) reports that can provide all sort of statuses and and information about the database engine and its management components and well as the databases themselves in real time -- the reports are refreshable! When executed, the reports are embedded in tabs within a new SSMS tab. As a consultant, I find these reports particularly useful when attempting to establish the health of a Microsoft Dynamics GP SQL Server installation. I can immediately relay critical SQL Server performance information to my clients and suggest preventative or corrective actions to mitigate the issues, saving them money in the process.
So lets take a look at the available reports by node...
http://dynamicsgpblogster.blogspot.com/2009/07/sql-server-management-studio-standard.html
If you have worked with SQL Server Management Studio (SSMS) in either Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you may have inadvertly overlooked one of its key features: Standard Reports.Standard Reports are Reporting Services (SSRS) reports that can provide all sort of statuses and and information about the database engine and its management components and well as the databases themselves in real time -- the reports are refreshable! When executed, the reports are embedded in tabs within a new SSMS tab. As a consultant, I find these reports particularly useful when attempting to establish the health of a Microsoft Dynamics GP SQL Server installation. I can immediately relay critical SQL Server performance information to my clients and suggest preventative or corrective actions to mitigate the issues, saving them money in the process.
So lets take a look at the available reports by node...
| Node | Report |
| Server | Server Dashboard |
| Server | Configuration Changes History |
| Server | Schema Changes History |
| Server | Scheduler Health |
| Server | Memory Consumption |
| Server | Activity – All Blocking Transactions |
| Server | Activity – All Cursors |
| Server | Activity – Top Cursors |
| Server | Activity – All Sessions |
| Server | Activity – Top Sessions |
| Server | Activity – Dormant Sessions |
| Server… |
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
The inner workings of Microsoft Dynamics GP on Microsoft SQL Server 
Unless you have been working with Dynamics GP from the days of Ctree and Btrieve, it is quite difficult to comprehend why Dynamics GP seems to behave (as in act up) in certain ways on SQL Server -- how would I say this... not quite like your other Windows applications that run on SQL Server.
To understand some of these behavioral issues, David Musgrave brings a two-part series on Understanding how Microsoft…
http://dynamicsgpblogster.blogspot.com/2009/05/inner-workings-of-microsoft-dynamics-gp.html
Unless you have been working with Dynamics GP from the days of Ctree and Btrieve, it is quite difficult to comprehend why Dynamics GP seems to behave (as in act up) in certain ways on SQL Server -- how would I say this... not quite like your other Windows applications that run on SQL Server.To understand some of these behavioral issues, David Musgrave brings a two-part series on Understanding how Microsoft…
Posted by
Microsoft SQL Server codename "Kilimanjaro" 
Oh my goodness! Just when I was getting comfortable with SQL Server 2008...The toys, for us SQL Server developers and practicioners, are seemingly becoming endless. Microsoft SQL Server codename 'Kilimanjaro' (my gut feeling tells me this will become SQL Server 2010) will be released in its Community Technology Preview (CTP) version by mid-January '09, with a duration of 4 to 5 weeks.
Kilimanjaro is jammed-packed with improvements to the BI engine and during…
http://dynamicsgpblogster.blogspot.com/2008/12/microsoft-sql-server-codename.html
Oh my goodness! Just when I was getting comfortable with SQL Server 2008...The toys, for us SQL Server developers and practicioners, are seemingly becoming endless. Microsoft SQL Server codename 'Kilimanjaro' (my gut feeling tells me this will become SQL Server 2010) will be released in its Community Technology Preview (CTP) version by mid-January '09, with a duration of 4 to 5 weeks.
Kilimanjaro is jammed-packed with improvements to the BI engine and during…
Posted by
Microsoft Rolls Out SQL Server 2008... Finally! 
http://dynamicsgpblogster.blogspot.com/2008/08/microsoft-rolls-out-sql-server-2008.html
These are exciting times for the Microsoft SQL Server database community of customers, administrators and developers. Microsoft SQL Server 2008 was released to manufacturing just yesterday, Thursday.
So what's in it for you?
With SQL Server 2008, Microsoft is adding a number of features to improve scalability. New capabilities include support for policy-based management,…
So what's in it for you?
With SQL Server 2008, Microsoft is adding a number of features to improve scalability. New capabilities include support for policy-based management,…
Posted by
The Saga Continues: Microsoft SQL Server 2008 to be Shipped in August
http://dynamicsgpblogster.blogspot.com/2008/07/saga-continues-microsoft-sql-server.html
More Microsoft SQL Server 2008 News!
http://dynamicsgpblogster.blogspot.com/2008/06/more-microsoft-sql-server-2008-news.html
Fresh from Tech-Ed: Microsoft unveils SQL Server 2008 release candidate (RC) which has been declared the last public release before release to…
Posted by
Sharepoint 2010 and SQL database mirroring
http://ddelprado.blogspot.com/2010/05/sharepoint-2010-and-sql-database.html
My favorite SQL Server sites
http://ddelprado.blogspot.com/2009/01/my-favorite-sql-server-sites.html
SQL Server 2005 vs 2000 Components
http://ddelprado.blogspot.com/2006/07/sql-server-2005-vs-2000-components.html
SQL Server 2005 SP1
http://ddelprado.blogspot.com/2006/04/sql-server-2005-sp1.html
SQL Server Security - SQL Injection
http://ddelprado.blogspot.com/2006/02/sql-server-security-sql-injection.html
Microsoft SQL Server 2005 System Table Map
http://ddelprado.blogspot.com/2006/01/microsoft-sql-server-2005-system-table.html
How to read an attribute from an XML field in SQL Server 2005
http://vstoolsforum.com/blogs/sqlserver/archive/2008/01/18/how-to-read-an-attribute-from-an-xml-field-in-sql-server-2005.aspx
Converting a sqlDataReader to a dataSet
http://vstoolsforum.com/blogs/aspnet/archive/2008/01/02/converting-a-sqldatareader-to-a-dataset.aspx
What is the best recovery model for SQL Server?
http://forum.4penny.net/blogs/sqlserver/archive/2007/12/19/what-is-the-best-recovery-model-for-sql-server.aspx
From a recent email:
What, in your opinion, is the best recovery model for a GP database? Full? Bulk_Logged? Simple? They all seem to have their pros & cons but I can't find anyplace where someone says this model is better than the other two because of X, Y or Z reasons.
A:
Simple
If you use Simple, transaction logging is disabled. Simply backing up the database will truncate the transaction logs. (If the…
Posted by
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
Latest links
- Taking Your Financial Reports to the Next Level with Management Reporter – Statement of Cash Flows (6 of 8)
- Technical Tips for Management Reporter 2012 with Data Mart
- 8 steps to update internal control
- How Maintenance Plans are a Big Plus for SQL Server Administration
- Online Bill Pay + Recurring Invoicing/Payment + Web-Based Order Entry for Microsoft Dynamics® GP | Dynamics Care Services
- 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 ?
- Dynamics GP 2013 appears to still have bug in Payables EFT CTX File Format
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.