SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

Here is a link to article by MVP Pinal Dave:

http://digg.com/software/Differences_in_Vulnerability_between_Oracle_SQL_SERVER

This article busts the myth that Oracle is better than SQL Server.

Link to original article: http://blog.sqlauthority.com/2009/12/18/sql-server-differences-in-vulnerability-between-oracle-and-sql-server/

Assign Primary Key in SQL Server Management Studio

How to Create Primary Key in SQL Server Management Studio

1. In Table Designer, click the row selector for the database column you want to define as the primary key. If you want to select multiple columns, hold down the CTRL key while you click the row selectors for the other columns.
2. Right-click the row selector for the column and select Set Primary Key. A primary key index, named "PK_" followed by the table name, is automatically created; you can find it on the Indexes/Keys dialog box.

Primary Key in SQL SERVER
Primary Key Index

How to add Next and Previous Topic buttons to the SQL Server Help toolbar

1. With SQL Server tutorials open, right-click an empty area of the toolbar, and then click Customize.
2. In the Customize dialog box, click the Commands tab.
3. In the Categories list box, click Help.
4. From the Commands list box, drag the Next Topic button to the desired location on the toolbar.
5. From the Commands list box, drag the Previous Topic button to the desired location on the toolbar.
6. Click Close.

SQL Server Help File

Categories Box - Help