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
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.
GTX1080 at about 80 degrees C – and doing 474 Sol/s
GTX970 at aboyt 56 degrees C – and doing 275 Sol/s
OS – Linuxmint
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
Useful commands I’ve found from various sources for Microsoft Sql Server 2005/2008 include:
–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
–Database level principals.
SELECT * FROM sys.database_principals
SELECT * FROM sys.database_role_members
ALTER LOGIN sa WITH NAME = hiddenSaAccount
–Check your user execution context
SELECT SUSER_SNAME(), USER_NAME()
–View the list of objects in the database
SELECT * FROM sys.objects
–Change user context
EXECUTE AS USER = ‘AnotherUserName’
–Return to your login
–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
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
SELECT * FROM sys.symmetric_keys
SELECT * FROM sys.certificates
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]
Heres how to add meta tags automatically to your pictures using Adobe Bridge CS4, which helps protect your photo with information relating to you the owner, no matter where the photos end up.
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)
Delete from sysmaintplan_subplans
Where subplan_name = ‘xyz’
If theres a reference error to sysmaintplan_log, first get the subplan_id
Delete from sysmaintplan_log
Where subplan_id = ‘0805BDF5-4A25-4175-8D3E-D6B041714D30’
(above subplan_id was from my server)
Then run query #1 again.
Posted a dual-boot installation guide here.
Boot up with your original Vista DVD
Select the command prompt