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

Microsoft Hyper-V…

Using Windows 2008 Server Operating system, this allows you to create a server based virtualized computing platform.

  • An x64-based processor. Hyper-V is available in x64-based versions of Windows Server 2008—specifically, the x64-based versions of Windows Server 2008 Standard, Windows Server 2008 Enterprise, and Windows Server 2008 Datacenter.
  • Hardware-assisted virtualization. This is available in processors that include a virtualization option; specifically, Intel VT or AMD Virtualization (AMD-V).
  • Hardware Data Execution Protection (DEP) must be available and be enabled. Specifically, you must enable Intel XD bit (execute disable bit) or AMD NX bit (no execute bit).
  • An applicable example is the Intel XEON E5430 Quad core CPU

Good microsoft setup link here.