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 Saturday Orlando is this Saturday, Oct. 25
In case you've missed, you still have a chance to attend SQL Saturday
this weekend in Orlando. I've been to SQL Saturdays in Orlando and Jacksonville before and they've both been great events. I've also heard some…
I'm Speaking at SQL Saturday Jax
It's been confirmed that I'm speaking at SQL Saturday Jacksonville on May 3, 2008.
For those of you low on caffeine, that's a Saturday, hence the name, SQL Saturday. My topic is on reporting out of Dynamics GP and I'll be covering one of my favorite topics, how do you figure…
Early Thoughts on Dynamics GP and SQL Server 2008
I haven't played with the SQL Server 2008 Community Technology Previews but I've read and listened to a lot about the upcoming release and a few things really stuck out as being helpful to DBA's supporting Microsoft Dynamics GP, even without any tweaking of the application for SQL Server 2008.
The items that hit me were:
- Resource Governor - this allows a DBA to define workload limits on the SQL server. For example, if GP shares the server with another application and you want GP to be primary, you could limit the other application to 20% of the processor power and grant GP 80% of the processor. A user on the other app gets 100% of the processing power until someone starts using GP. Then it throttles back to 20%. This scenario solves a couple…
SQL Server Unplugged - FREE!
More great free SQL Server resources for you. First there was SQL Saturday Orlando, then Tampa and coming in May is Jacksonville .
Now there's full day with 3 SQL…
Don't Hold Your Breath For SQL Server 2008
Soon you're going to see a lot of launch events around SQL Server 2008, Visual Studio 2008 and Windows Server 2008. Well, VS2008 is available now, Windows Server 2008…
Basic SSIS Tuning
I hit the oPASS
meeting last night and Brian Knight of End to End Training
did a nice job of presenting some tuning examples for SQL Server Integration Services. I can't begin to do his presentation justice but I can pass along a few things I learned.
1) SSIS processes information asynchronously, that is, in parallel, whenever it can. asynchronous processing is good, Ferrari good. Synchronous items in your SSIS package are bad…