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
On a new instalaltion of SQL Server 2008, running on Windows Server 2008, l cannot connect to SSIS from SSMS (Sql server management console) 2008 running on a client workstation. I can connect from the local server end.
I tried adding the users Group to the permissions option on Component Services/MsdtsServer100 as suggested by many sites since this problem is common also in SSIS/Sql Server 2005. This didnt work.
Solution was to add the user group to the Windows Server Distributed COM Users group.
See also: Technet link
Have this video card on my main CAD workstation (Q8200 2.33Ghz Quad-core 8Gb RAM Vista 64bit).
Updated the video driver to a nvidia 182.08 windows Vista 64 release after some windows vista problems with the 182.20 release. Seems to be working great.
Ran POV-RAY 3.6.1 Benchmark version 1.02
Render averaged 103.58 PPS over 147456 pixels, in a total time of 1423.63 seconds.
Boinc manager benchmark results:
2344 FP MIPS (whetstone) per CPU
6656 Integer MIPS (dhrystone) per CPU
My Workstation Cinebench R10 benchmark results: 5/15/2009
Intel Quad Q8200 64bit Vista Ultimate 8Gb DDR2
OpenGL = 2417, i CPU = 2641, Multi-CPU=8879
The HP xw8600 which uses the Xeon 5400 processor, has this specs 3888 (1 cpu) , 23,445 (multi-cpu) and 6571 for opengl
Steps l took in exploring this technology.
“Windows® Azure is a cloud services operating system that serves as the development, service hosting and service management environment for the Azure Services Platform” Click here for the Microsoft Website
1. Download the SDK – January 2009 CTP
2. Download Windows Azure Tools for Microsoft Visual Studio January 2009 CTP
5. Start Visual Studio 2008 , New project, Cloud service, Web and worker cloud service
Working on code using the REST API Reference for Windows Azure Storage services
Also download the Azure Services Training Kit – February Update
Will update this blog soon as l make progress….