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
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.
See this website on links for DNS-321 NAS Hacking
Very interesting article on Social Engineering a hack into a “secure” IT facility.
You may also find Bruce Schneier’s Crypto-Gram Newsletter interesting.
Heres a video clip of Jack Bauer’s 24 TV Show which l dont miss, mentioning Blowfish encryption and showing some “impossible” cracking time…
Heres a link to the actual dialog.