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]

Network Addressed Storage.. [NAS]

Looking for a NAS, with gigabit interface (l’m done with slow access speeds via usb interface to my internal gigabit network) so as to speed up my rendering server farm file access, and expandable with support for additional sata drives and affordable. Finally settled for the DLINK DNS-321 for $130 and bought just one 1Tb SATA drive that was on sale for $87 – a Samsung 10,000rpm 32Mb buffer drive. As sata drives fall in price and l get more bang for a buck l can add to this unit. I can mirror a drive, but the unit doesnt support ntfs etc – which is fine for me since my shared files on this will be media files, mp3 and rendered jpeg pictures. It has a web interface control and can be accessed remotely via ftp anywhere on the net. This system is built on a GPL / Linux based system, and will format your drive to ext2 format. There might be a hack out there for a more native windows file system support.

Update: 5/14/09. I’m returning this item. The file transfer time to and fro ext2 to my ntfs formatted drives is so so slow, about 10-20x (even by Windows wrong estimates). The gigabit connectivity makes no noticable difference, even when on the same Cisco 5 port Gigabit switch as my server. I’ve ended up overloading my faithful dell sc430 server by “creatively” adding this 1Tb drive to it, the server is designed to support only 2 sata hard drives. See picture below.

capture_dns321_300

dns-321_main

capture_dns001

See this website on links for DNS-321 NAS Hacking

dellsc430

This week 04252009….

Got a good deal on an executive chair with good back support (really need it) from Office Depot – seems tons of items are marked for clearance. They may be closing soon some say…

Cant wait to see the movie X-Men: Origins Wolverine which comes out on 5/1/2009 [USA] He is my favorite character of them all.

4-25-2009-10-21-34-pm

Update on Wolverine 5/14/2009:

Amazed to find out the african city where the x-men travel to is LAGOS, NIGERIA !! Also guess what, my tribe [ibo] seem to be [according to the movie] the source of adamantium – the core metal used to make Wolverine invincible – hmm, wonder why l’m not. Sad – my tribesmen and women get wiped out in the movie, such is how most tales mentioning africa go. For more upbeat fealing, listen to Akons Africa song.
Installed Ubuntu 9.04, this install went flawlessly on my HP laptop as well as the updates, wireless card support and nvidia video card support.  To get ubuntu to run/play DVD’s, mp3, quicktime, windows media files etc – run:
sudo apt-get install ubuntu-restricted-extra

Finally gave up on working on my stop and go, 2 year old lawn mower – had a choice between a basic new push mower for 149 and and electric (no gas, no fumes etc) mower for 50 more, went for the second. Seems the old one may have some rusts parts in it, and l’ve done the drain fuel/dis-assemble/assemble routine one too many times as well as some creative engineering for the pull rope to work. Now if only l could afford a robot lawn mower and gardner….

NBA: Saw Yao Ming of the Houston rockets at the Starbucks – Pioneer square early last week. He’s 7’6″ and had to bend down to get out of the door. We werent allowed to take pictures, besides seems no one was crazy to see him given that Houston beat the Portland TrailBlazers on the 1st playoff games. Sucks – SAS lost today to Dallas. Hope the Blazers win the next game against Houston. Here are some pictures l took at the Rip City Party on the Portland Blazers getting into the playoffs. Didnt get pictures of the players while at a meeting for work.

Posted pictures l captured as l used 3Ds max 2009 with V-ray at this link.

Benchmarking my system using Maxon Cinebench R10

My results: OpenGL test – 2868, single CPU 2692, Multiple CPU render test: 9374.