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.
Take a Hot Lap around SQL 2008 R2
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…
SQL Code Camp 2008
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...
|Server||Configuration Changes History|
|Server||Schema Changes History|
|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|
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…
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…
Microsoft Rolls Out SQL Server 2008... Finally!
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,…
The Saga Continues: Microsoft SQL Server 2008 to be Shipped in August
Microsoft announced on Wednesday, July 9, 2008, at Worldwide Partner Conference that it will be shipping SQL Server 2008 in August with RTM set for sometime during Q3. I had the opportunity…
Sharepoint 2010 and SQL database mirroring
My favorite SQL Server sites
Data Mining http://www.sqlserverdatamining.com/ssdm/
Best Practice …
SQL Server 2005 vs 2000 Components
When customers received from Microsoft the latest CDs it included GP 9.0, FRx 6.7 and SQL Server 2005.
SQL Server 2005 SP1
SQL Server 2005 SP1 is now available for download. These packages can upgrade the Enterprise, Standard,…
SQL Server Security - SQL Injection
For the past year I've been working on security policies and procedures. One of the most challenging part of…
Microsoft SQL Server 2005 System Table Map
You can find the poster of the SQL Server 2005 System Table Map in the December 2005 issue…
What is the best recovery model for SQL Server?
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.
If you use Simple, transaction logging is disabled. Simply backing up the database will truncate the transaction logs. (If the…
How to automatically run a stored procedure in SQL Server 2005
From a recent email:
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…