Deepesh Shah

Magic Script for restoring a SQL Database

This is a small magic script to quickly restore a SQL Server database

<Script>

RESTORE DATABASE  MyDatabase // Where MyDatabase is the database name you want to create

FROM DISK = 'C:\MyDatabase.BAK'  // the physical path of the '.bak file'

WITH MOVE 'MyDatabase_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDatabase.mdf',   \\ this needs to be the installation path of the SQL Server

MOVE MyDatabase_Log' TO C:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDatabase.ldf'      \\ this needs to be the installation path of the SQL Server

GO

</Script>

 Enjoy !!

Inside 'Yukon': XML

An excellent article has been posted on  DNJ Online , examining the use of XML in the forthcoming SQL Server 2005 (also known as 'Yukon'). Mark Whitehorn  looks at the implications of supporting XML in a relational database.

A must read article for all the software developers. 

Gmail Accounts to give away

Hi All,

I have some Gmail invites to give away. If anyone fancys it just leave a comment on this blog and will email u the invite.

Happy Gmailing

New MSDN Website

Now you can use "http://msdn2.microsoft.com/library/<namespace>.aspx" to get the documents for a particular namespace. For example If you type http://msdn2.microsoft.com/library/System.Reflection.aspx, all the documents for classes under System.Reflection are right there.

This also works for classes, properties and methods . To look for documentation of System.Reflection.Assembly class, simply type http://msdn2.microsoft.com/library/System.Reflection.Assembly.aspx.

or

 http://msdn2.microsoft.com/library/System.Reflection.Assembly.FullName.aspx.

Gr8 Stuff

Useful Resource for CSS Tricks

Hi ALL,

Just found a very useful resource for CSS Tricks on

http://www.evolt.org/article/Ten_CSS_tricks_you_may_not_know/17/60369/

Also you can subscribe to http://del.icio.us/rss/tag/css the one place for lots of useful info / resources / tricks and tips for CSS.

Happy Styling !

MSDN Event 'Yukon'