Making an offline installer for Visual Studio 2017

This is based on an article by Scott Hanselman – click here for it.

Below code worked for me

vs_community.exe –layout c:\vscommunity\vs2017offline –lang en-US –add Microsoft.VisualStudio.Workload.Azure Microsoft.VisualStudio.Workload.ManagedDesktop Microsoft.VisualStudio.Workload.NetCoreTools Microsoft.VisualStudio.Workload.NetWeb

 

 

Exploring Adobe CC

Tried out the latest versions of Adobe Creative cloud – CC, and l must say l am impressed over the new features and capabilities compared to the former Photoshop CS6, Lightroom etc.

Had about 16Gb 7800 files of HD/UHD pictures and videos from a recent vacation, using 3 cameras – 7DM2, Sony A7 and for UHD 4K videos the Panasonic Lumix G85 – Unfortunately l could not get Adobe CS6 Photoshop using Camera Raw 9.x.x to accept the Lumix RW2 [I only shoot pictures in RAW] images, and using the versatile Adobe DNG converter – which works – was a workflow step l didnt want to go through.
Solution, l downloaded a trial version of Adobe CC Photoshop, which came witht he laterst Camera Raw 10.x.x and both Photoshop/Lightroom opened and processed all Lumix files seamlessly.

Some screenshots:

ZCash mining – using GTX1080 GTX970 Stats

Screenshots:

GTX1080 at about 80 degrees C – and doing 474 Sol/s

GTX970 at aboyt 56 degrees C – and doing 275 Sol/s

OS – Linuxmint

 

Microsoft Certified Technology Specialist: Sql Server 2008…

mctsrgb

Passed my Microsoft Cerfification Exam on first attempt on Tuesday June 2nd! Score: 814

The certificate says l’m now recognized as a MCTS – Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance. The exam is the MCTS 70-432. Next goal is the 70-450 which has no study book in print, and the only material l can find so far is the CBT-NUGGETS training video on Exam 70-450 which is very good.

Materials l used to study other than multiple SQL Server instances on my laptop, Virtual PC Windows 2008 Machines with SQL Server 2008 installed – for database replication, mirroring and failover clustering practise!!!
– MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 – Implementation and Maintenance by Mike Hotek (Very good, in-depth all round material, lab oriented book with real life stories). This seems to be the only main book out there.
– Self Test Software for MCTS 70-432, bought the download version of this excellent practise test program.
– Microsoft Sql Server 2008 Books on line (download the latest update from Microsoft)
– Took the official Microsoft 6231 course at SQLSoft (Beaverton)
– Books on Microsoft SQL Server 2005 exam 70-431

Microsoft Sql Server Administration…

Useful commands I’ve found from various sources for Microsoft Sql Server 2005/2008 include:

EXEC sp_configure
GO
–Instance level principals.
SELECT * FROM sys.asymmetric_keys
SELECT * FROM sys.certificates
SELECT * FROM sys.credentials
SELECT * FROM sys.linked_logins
SELECT * FROM sys.remote_logins
SELECT * FROM sys.server_principals
SELECT * FROM sys.server_role_members
SELECT * FROM sys.sql_logins
SELECT * FROM sys.endpoints
GO

–Database level principals.
SELECT * FROM sys.database_principals
SELECT * FROM sys.database_role_members
GO
ALTER LOGIN sa WITH NAME = hiddenSaAccount
GO
–Check your user execution context
SELECT SUSER_SNAME(), USER_NAME()
GO
–View the list of objects in the database
SELECT * FROM sys.objects
GO
–Change user context
EXECUTE AS USER = ‘AnotherUserName’
GO
–Return to your login
REVERT
GO
–explore database files
select * from AdventureWorks.sys.database_files
select * from master.sys.database_files
select * from msdb.sys.database_files
select * from tempdb.sys.database_files
–explore endpoints
select * from sys.endpoints
select * from sys.tcp_endpoints
select * from sys.http_endpoints
select * from sys.database_mirroring_endpoints
select * from sys.service_broker_endpoints

–Security

SELECT * FROM sys.symmetric_keys
GO

SELECT * FROM sys.certificates
GO

Build your own Virtual World…

Check out this amazing video – World Builder by Bruce Branit Some day l guess we might be building entire cities virtually like this, walk through them and then create them. Beats a 3D object molder.

Heres a direct link to the quicktime .mov file for faster viewing on your PC. [ Right click, save as, download]

Deleting a SQL Server maintenance plan….

If you keep getting this error:
The DELETE statement conflicted with the REFERENCE constraint “FK_subplan_job_id”. The conflict occurred in database “msdb”, table “dbo.sysmaintplan_subplans”, column ‘job_id’.
The statement has been terminated. (Microsoft SQL Server, Error: 547)

RUN:
(1)
Use MSDB
GO
Delete from sysmaintplan_subplans
Where subplan_name = ‘xyz’
GO

If theres a reference error to sysmaintplan_log, first get the subplan_id
(2)
SELECT
[subplan_id]
–,[subplan_name]
–,[subplan_description]
–,[plan_id]
–,[job_id]
–,[schedule_id]
–,[msx_job_id]
–,[msx_plan]
FROM [msdb].[dbo].[sysmaintplan_subplans]

then RUN:
Use MSDB
GO
Delete from sysmaintplan_log
Where subplan_id = ‘0805BDF5-4A25-4175-8D3E-D6B041714D30’
GO

(above subplan_id was from my server)

Then run query #1 again.