Microsoft Certified Technology Specialist: Sql Server 2008…


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
–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
–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
–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


SELECT * FROM sys.symmetric_keys

SELECT * FROM sys.certificates

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)

Delete from sysmaintplan_subplans
Where subplan_name = ‘xyz’

If theres a reference error to sysmaintplan_log, first get the subplan_id
FROM [msdb].[dbo].[sysmaintplan_subplans]

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

(above subplan_id was from my server)

Then run query #1 again.

Error: Connect to SSIS Service on machine “” failed:

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

Nvidia Quadro FX 370

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


Microsoft Windows Azure…

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

3. Download

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….