SQL Server with Rick Martinez:

April, 2010

1

April 9, 2010  9:55 PM

SoCal Code Camp June 2010



Posted by: Rick Martinez

I got a couple of sessions up at the SoCal Code Camp site! I am very excited about this one! Thank you for all your support. SQL...

Bookmark and Share     0 Comments     RSS Feed     Email a friend

April 2, 2010  10:04 AM

SQL Server Shortcut Keys



Posted by: Rick Martinez

To access your shortcut keys within SQL Server Management Studio click Tools, Options, Environment, Keyboard. There you can customize your shortcut keys or create your own. A shortcut key I created was Ctrl + F1 (select top 100 * from ). When you highlight a table name and hit Ctrl + F1 it will...


April 2, 2010  9:45 AM

SQL Server Login SID



Posted by: Rick Martinez
SQL, SQL Login, SQL Security, SQL Server, T-SQL

If you restore a database on a second sql server and you need to be changing the sql login every time you restore that database you can use CREATE LOGIN. You can use the following sql to create the account on the second server using the same sid from server 1.


April 2, 2010  9:17 AM

SQL Server Study Group



Posted by: Rick Martinez
SQL, SQL Server, T-SQL

There will be a course on "Beginning Database Design" Class runs from Saturday, April 03, 2010 through Saturday, June 05, 2010 its FREE! For more information and to register please visit the site. Seats are limited! Study Group or


1