“Life a good life. If there are gods and they are just, then they will not care how devout you have been, but will welcome you based on the virtues you have lived by. If there are gods, but unjust, then you should not want to worship them. If there are no gods, then you will be gone, but will have lived a noble life that will live on in the memories of your loved ones.” – Marcus Aurelius (Roman Emperor and Philosopher)…
Author: Iain 'Cutty' Carlin
Lichty Guitars
Listening to the Luthier on Luthier podcast this morning about Jay Lichty and his guitars. Interesting the way they set up their business and ability to pick guitars based on tone and price. Some great designs too. lichtyguitars.com…
Configuring SSIS on SQL 2017
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
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
Interesting article about SA man Jim Redgate making world class guitars right here in Port Noarlunga: https://www.adelaidenow.com.au/ipad/making-music/news-story/03af6084a69841a2009fbde62e9dfc25
(He also happens to share an interest in Chrysler products!)
SharePoint Calendar – Offset and length were out of bounds….
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
“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
- 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
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
(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