Adobe

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:

Computers

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

Computers

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

Camera World

Using Adobe Bridge CS4….

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.

3-29-2009-9-31-28-am_300

Software

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.