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]

Internet Explorer 8….

Installed this on my laptop and workstation.
I visited Wellsfargo online banking and immediately got a warning that it only supports the older browser, IE7 or Firefox 3. I could not go on further, and either have to use firefox which l have installed or re-install IE7.
Then l remembered that IE8 offers a compatibility mode, so l simply added to my list of sites under this option and bingo – it worked! l could use the banks website from IE8!

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