Tag Archives: SQL Server
examine files

SQL stored procedure to search an entire database

I don’t often re-post things from other blogs, but this is just too good not to share. David Musgrave recently published an update to his spSearchOnAllDB stored procedure on his blog, Developing for Dynamics GP. Simply run the script to create the stored procedure and you can search all the tables in a database for a […]

Continue reading
mechanism

How to add a sparkline to a report in SSRS

Introduction: This blog post is written by my friend and colleague Mickie Stamm. Mickie is a fabulous Dexterity, SQL and application developer and is one of the great minds behind GP Reports Viewer. By Mickie Stamm: In the last GP Reports Viewer newsletter I wrote about using rectangles as containers in SQL Server Reporting Services […]

Continue reading
binoculars

Finding resources

Almost on a daily basis I find myself looking for things like system requirements, end of support dates, build numbers and downloads for the various products that I work with. Even though search engines have greatly improved over the last few years, I still often struggle to find this information. While I consider myself to […]

Continue reading
SQL Server Poll Results

Results of SQL Server poll

It has been about a month and 119 people voted, so I wanted to share the results of my SQL Server poll. I asked what version of SQL Server my readers were using for their Dynamics GP and here are the results: While I am glad to see that only a few voters (5%) are on […]

Continue reading
SQL Server Poll Results

SQL Server poll

I am starting to see articles and blog posts about Microsoft SQL Server 2011 everywhere, so I thought I would poll my readers to ask versions of SQL Server you are using. The poll is below: Once I have some results back, I will post an update. In the meantime, keep in mind that SQL Server […]

Continue reading
0325EN_MockupCover

Dynamics GP 2010 implementation book coming soon

My book, Microsoft Dynamics GP 2010 Implementation, is off to the publishing house and should be ready to ship soon.  While the primary goal of the book is to help with new implementations of GP in small to mid-size companies, there’s something in it for everyone. Just to highlight part of the content, this book has step-by-step […]

Continue reading
Calendar. September 2010.

Coding specific dates in SQL Server

Quite often when writing reports I need to write a formula to calculate dates. Dates are not very straightforward to code in SQL Server, and I have started keeping a list of various formulas so that I do not have to re-write the code every time. I have previously posted some code on calculating date differences in SQL, […]

Continue reading

How to find all SQL tables with a column name

Often I need to find all the tables in Dynamics GP that have a particular column or search for all columns where I only have a partial column name. Over the years I have seen lots of different code to accomplish this, so this is nothing new. But I am asked about this enough that […]

Continue reading

Searching for strings in SQL Server using LIKE

Many times when searching for data in SQL Server we need to search for strings and use wild cards. One common wild card is %. As an example, I am going to use the Customer Master table (RM00101) in the Dynamics GP sample company, Fabrikam, Inc. If I want to all customers with ‘USA’ in the Class ID, […]

Continue reading

New page with resources

I have published a new page called Resources that has links to information I am either frequently looking up or I am being asked for routinely.  Stuff like Dynamics GP system requirements, printer compatibility lists, how to translate a build number in GP, FRx or SQL Server to a specific service pack, when support for various versions […]

Continue reading

When does my SQL Server support end?

Did you know that mainstream support for SQL 2000 ended in April of 2008? Here is a list of the SQL versions and the relevant release and support end dates: SQL Server Version Release Date End of Mainstream Support End of Extended Support Link SQL 7 Mar 01 1999 Dec 31 2005 Jan 11 2011 […]

Continue reading

What version of SQL Server am I running?

Here is a summary list of the major releases and service packs for Microsoft SQL Server: SQL Server RTM SP 1 SP 2 SP 3 / 3a SP 4 2000 8.00.194 8.00.384 8.00.532 8.00.760 8.00.2039 2005 9.00.1399 9.00.2047 9.00.3042 9.00.4035 9.00.5000 2008 10.00.1600.22 10.00.2531 10.00.4000 10.00.5500 2008 R2 10.50.1600.1 10.50.2500 10.50.4000 2012 11.00.2100.60 11.00.3000  11.00.5058 […]

Continue reading

SQL Server 2008 Videos

I just came across this very un-Microsoft looking Microsoft webiste for SQL Server.  There are a number of videos here geared towards different audiences.  I haven’t watched them all, but I did find Scott Konersmann’s video about upgrading to SQL 2008 very interesting.  And some of the For Fun videos are pretty funny – especially “It […]

Continue reading

Limitations on data in GP?

One of the benefits of Dynamics GP being on Microsoft SQL Server is that there are virtually no limitations on the number of entries of a particular type.  But the question does come up a lot.  What’s the maximum number of customers or customer addresses, or sales transactions, or line items can I have in GP […]

Continue reading

Follow

Get every new post delivered to your Inbox.

Join 1,560 other followers