Merry Christmas 2011 and Happy New Year 2012 to you

It is that time of year again…. The silly season is upon us. It seems that the religious meaning of Christmas has taken a back seat to the commerical side and spending money shopping. Even if you are not interested in the religious meaning, this is a time to celebrate life with friends and family. Mike Tompkins is…

1

From the Blogsphere: Microsoft Dynamics GP 2010 R2 64-bit Hyper-V, Microsoft Dynamics GP 2010 Performance White Paper and Dynamics GP Blogster YouTube Channel

This is just a quick post to update you with some of the recent happenings around the blogsphere. On the Inside Dynamics GP Blog, Jay Manley (with help from Kelly Youells, Lyle Curry, Jason Siever, Ryan Sandness, Daniel Sly, Jon Studsrud, and John Dooley) has completed the first-ever 64-bit Hyper-V images for Microsoft Dynamics GP…

0

Quick Tip: Working with VBA, Extender and Sales Transaction Entry

I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server. The project involved…

1

Cool Videos: Nokia Lumia 800 UK Launch & Bing with Jay-Z’s Book – Decoded

Another week has gone without any posts.  That’s OK as I have a number of posts to publish with some GP related news, another Quick Tip and some fun videos. So starting with the fun Microsoft related videos.   Nokia Lumia Live ft deadmau5 lights up London with amazing 4D projection On Monday 28th November Nokia…

0

Quick Tip: Passing Date and Time Variables to SQL Server

As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server, I wanted to discuss the related topic about passing of date and time variables. There are two main issues we see with passing Dates and Times and both can cause SQL Server to throw the following exception: /*  Date: 12/15/2011  Time:…

4

Quick Tip: Passing Variables to SQL Server

Wow, the week is almost over and I am yet to post something. This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows passed through…

7

SQL Server Error: Cannot resolve the collation conflict

Today I have a post on the solution to a tricky SQL issue. When working with SQL Server and creating a join that links tables in two databases, all goes well when the two databases have the same collation. However, if the databases have different collations the query it will fail in a writhing blubbery gelatinous…

9

No Blog Post Today

Hey everyone, today there will be no blog post. This is because it is my 20th Wedding Anniversary and I have decided that I don’t have to post anything today. Not even a picture that shows how young, slim and clean shaven I looked back then, like the one below:    I am sure you…

10

Granting Access and Binding Defaults when recreating SQL Tables

Added to the Useful SQL Scripts Series. This is a follow on post from my previous article: Backing up and Restoring data when recreating SQL Tables which explains how to recreate tables (usually to fix table structure issues) while making sure that the data is preserved. In the previous post; it has a step 3 to recreate the…

3

Support Debugging Tool at Decisions Fall 2011 and more

Find the Support Debugging Tool Portal here: https://blogs.msdn.microsoft.com/developingfordynamicsgp/support-debugging-tool-portal/   The Decisions Fall 2011 virtual conference is almost here. The Microsoft Dynamics GP day is Tuesday, 6th December 2011 (US Time). There are a dozen great sessions for you from the Microsoft Dynamics GP MVPs and other community members. Have a look at the link below for the…

2