SQL Server: How to get table schema via SQL

April 9th, 2011
Comments Off

SELECT table_name,ordinal_position,column_name,data_type, is_nullable,character_maximum_length FROM
information_schema.COLUMNS WHERE table_name LIKE '%TABLENAME%'
ORDER BY ordinal_position;

SQL, Tech

Rackspace provides “BEST” customer support ever!!!

April 8th, 2011
Comments Off
Welcome to Rackspace. How can I assist you?
You have been connected to Natalie P.
Customer:  hi, here’s the situation:
Natalie P:  Hi, how can I help?
Customer:  i have an .mdf, over 77 megs, i need a sql server environment to attach this file and retrieve the data (since i don’t own a windows machine)
Customer:  can you help?
Natalie P:  Are you able to manage and configure a server?
Customer:  not really, i just need to be able to pull this information out of this file, somehow
Natalie P:  I’m afraid I cant help!
Natalie P:  If you were able to manage and config a server I would have suggested using a cloud server which has no contract, which you can spin upand turn off and only use for the hours in use
Customer:  wait a second
Customer:  so you’re saying that if someone has a backup of an sql server instance in a common format, needs to have server admin skills to query a database?
Customer:  hello?
Natalie P:  Apologies for the delay
Natalie P:  If you could manage and admin a server, you could have spun up a server and only paid for the server to obtain your files
Thank you for visiting Rackspace. You may now close this window.
Your session has ended. You may now close this window.

Funny, Tech

India Graduates Millions, but Too Few Are Fit to Hire

April 8th, 2011
Comments Off

India projects an image of a nation churning out students who are well educated, but in reality, companies are having increasing difficulty finding new recruits who can answer questions by phone and email.

via India Graduates Millions, but Too Few Are Fit to Hire – WSJ.com.

Management, WSJ