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.
SQL Transaction Logs Explained
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…
SQL 2008 Performance
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.
Sharepoint 2010 and SQL database mirroring
GP 10 on Windows XP/SQL Express (Don't Try this at Home)
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…
Getting to Know and Love the SQL Server Browser Service
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…
Steve Gray Takes on SQL Optimization
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…
SQL Server 2005 Performance Dashboard
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…
SQL Maintenance Scare - Janakiram MP
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…
Things I Had To Do To Get Replication Working
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…
What version of SQL Server am I running?
Here is a summary list of the major releases and service packs for Microsoft SQL Server:
SP 3 / 3a
Scheduling Jobs in SQL 2005
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.
My favorite SQL Server sites
Data Mining http://www.sqlserverdatamining.com/ssdm/
Best Practice …
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…
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…