Well last night was a great achievement for Intergen, collecting the award of Microsoft Partner of the Year. This comes just weeks after Intergen was awarded a member of the 2008 President's Club for Microsoft Dynamics.  This is a great achievement rewarding our ongoing sales and development successes for Microsoft Dynamics products.

Our Software + Services solution ActionThis also won the award of Software + Services Solution of the Year. Sign up at http://www.actionthis.com to start using this!

Award Listing from last night:

• Core Infrastructure Solution of the Year: Datasouth Business Solutions
• Businesses Productivity Solution of the Year: Datacom Systems (Wellington)
• Application Platform Solution of the Year: Axon
• Software Solution of the Year: Fronde Systems Group
• Software + Services Solution of the Year: ActionThis
• Microsoft Dynamics CRM Solution of the Year: Complete Solutions
• Microsoft Dynamics ERP Solution of the Year: Adaptable Solutions
• Learning Solutions Partner of the Year: Auldhouse
• Citizenship Solution of the Year: The Simpl Group
• Microsoft Technology Advocate of the Year: Provoke Solutions
• Partnering Award of the Year: Axon & Enlighten Designs
• Licensing Partner of the Year: Gen-i
• Distributor of the Year: Ingram Micro
• Microsoft Rising Star of the Year: Gareth Tucker of Complete Solutions
• Small Business Specialist of the Year: Kinetics Group
• Microsoft Partner of the Year: Intergen

Greg Olsen
Yellow Duck Guy

SQL Server 2008 has been released last week and is now available via MSDN for download.

Below you can see the versions available for download. Enjoy!

Greg Olsen
Yellow Duck Guy

This is a handy little piece of code I wrote, which can help if you ever need to refresh your database views within SQL Server. I have tested this on SQL Server 2005 recently. I have also had a SQL Job run this stored procedure to update my views more frequently.  I had used this to keep views up-to-date for database integration projects.

   1: CREATE Procedure dbo.RefreshAllViews

   2: AS

   3:  

   4: DECLARE @ViewName nvarchar(max)

   5: DECLARE @SQL nvarchar(max) 

   6:  

   7: DECLARE extensionViews CURSOR FOR

   8:     -- Get all views within the database

   9:     SELECT [name] As ViewName

  10:     FROM sys.views

  11:  

  12: OPEN extensionViews

  13:  

  14: FETCH NEXT FROM extensionViews

  15: INTO @ViewName

  16:  

  17: -- Check @@FETCH_STATUS to see if there are any more rows to fetch.

  18: WHILE @@FETCH_STATUS = 0

  19: BEGIN

  20:  

  21: -- Build the dynamic SQL for updating the view on the fetched row

  22: SET @SQL =

  23: 'IF EXISTS (SELECT * FROM sysobjects WHERE type = ''V'' AND name = ''' + @ViewName +''')

  24:     BEGIN

  25:         exec sp_refreshview N''dbo.'+ @ViewName + '''END'

  26:  

  27: exec(@SQL)

  28:      

  29:    -- This is executed as long as the previous fetch succeeds.

  30:    FETCH NEXT FROM extensionViews

  31:    INTO @ViewName

  32: END

  33:  

  34: CLOSE extensionViews

  35: DEALLOCATE extensionViews 

  36:  

  37: GO

Hope you find a use for this!

Greg Olsen
Yellow Duck Guy