Iain ‘Cutty’ Carlin – Page 2

Configuring SSIS on SQL 2017

Posted on February 14, 2018December 1, 2019 by Iain 'Cutty' Carlin

Not as easy as you would think, once installed, the service wouldn’t start, then I couldn’t log on (Access Denied) then I couldn’t connect remotely.

Install and Configure DCOM: https://docs.microsoft.com/en-us/sql/integration-services/service/integration-services-service-ssis-service
Configure Firewall to allow RPC: http://slavasql.blogspot.com.au/2016/07/ssis-rpc-server-is-unavailable-error.html
Create SSIS Catalog: https://technet.microsoft.com/en-us/library/gg471509(v=sql.110).aspx
Run SSIS Package with Powershell: https://docs.microsoft.com/en-us/sql/integration-services/ssis-quickstart-run-powershell

…

+

SSIS Toolbox missing in Visual Studio 2017

Posted on November 2, 2017 by Iain 'Cutty' Carlin

I have installed the Data-Tier Application Framework and SQL Server Data Tools for VS 2017 . I created a solution then returned to it a week later and the SSIS toolbox had disappeared.

I opened the toolbox window using View -> Toolbox but it was empty.

To get the SSIS toolbox back, right-click on the SSIS design surface in the project and select SSIS Toolbox – hey presto! it reappears.

…

+

Jim Redgate Guitars

Posted on August 28, 2017November 6, 2019 by Iain 'Cutty' Carlin

Interesting article about SA man Jim Redgate making world class guitars right here in Port Noarlunga: http://insidesouthaustralia.com.au/stringing-success-with-adelaides-guitar-man/

(He also happens to share an interest in Chrysler products!)

…

+

SharePoint Calendar – Offset and length were out of bounds….

Posted on September 19, 2016September 23, 2016 by Iain 'Cutty' Carlin

When swapping from the Day view to Week view of a SharePoint calendar, we were getting the following error message: “Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection”.

Tried setting the Information Management Policy Settings to 2 months (was 3) to archive list down to less items (It had about 4800 records, got it down to 4200). [NB: Run Information Management Policy job first, then Expiration Policy]. Problem was not resolved.

We have 2 views of the data, filtered to a different number of items in each.…

+

Error opening SharePoint calendar item

Posted on May 17, 2016December 1, 2019 by Iain 'Cutty' Carlin

“Item does not exist. It may have been deleted by another user.”

Remove everything after the ID value in the url for the item, after and including the first dot. You can then use the view screen to delete the item.

http://blog.incworx.com/blog/sharepoint-developer-blog/let-me-tell-you-how-i-conquered-item-does-not-exist-it-may-have-been-deleted-by-another-user…

+

Week 31 – The final cut

Posted on November 11, 2015November 6, 2019 by Iain 'Cutty' Carlin

Same as last week, cut back 3rd coat with 320 grid – coat still had some dimples and holes in it.
Had to re-fill some of the binding edges with wax as they were also still visible.
Sanding wasn’t as hard this week because there wasn’t as much to take off

…

+

Week 30 – More cutting back

Posted on November 4, 2015November 11, 2015 by Iain 'Cutty' Carlin

As per last week except:

Where holes exist that lacquer isn’t going to fill, need to fill with wax. Scrape off excess wax with razor blade
Some of back has deep holes that will require 2 more coats to finish off

…

+

Week 29 – Cutting back

Posted on October 28, 2015November 11, 2015 by Iain 'Cutty' Carlin

(Not at TAFE this week but picked up guitar to work on at home)

Guitar sprayed with lacquer
With 320 grit paper sand over all surfaces with lacquer on them until wipe over with hand shows no dimples
Make sure sanding is white – if wood colour comes through then have gone too far
Wiped down all over with a damp cloth

…

+

Week 28 – Bridge and masking

Posted on October 21, 2015November 11, 2015 by Iain 'Cutty' Carlin

Located bridge on body by measuring 645.2mm down from bottom of nu to bottom E string crossover point
Centred by laying straight edge down side of fretboard and measuring distance across to holes of both E strings. Once distance is the same, bridge is centred.
Make square with neck by using fret ruler laid centrally on neck to flat edge of bridge with end of ruler
Put masking tape in approximate position across bridge location
Clamped in place with bridge clamps through sound hole then drilled through E string pin holes with 2 drill bits to locate
Carefully score around bridge location with knife and remove around bridge
Masked up sound hole by gradually building up tape from the outer edges of sound hole till small hole left in centre.

…

+

Week 27 – Bridge Shaping

Posted on October 14, 2015November 11, 2015 by Iain 'Cutty' Carlin

Put bridge into jig
Measured length and location of slot from template bridge
Mark out length on jig top so router only moves that length
Cut channel through jug top using 1.5mm bit in router
Fit jig top to bottom at location of slot as marked on bridge. Screw top of jig to bottom
Route through top plate of jig in 3mm increments till saddle slot is 9mm deep

Marked outline of bridge onto block
Cut outline roughly on band saw
Shape to final outline on bobbin sander
Used routing table and 6mm bit to route bottom edge
Finished off on bobbin sander & with sandpaper, file and spokeshave

…

+