Cristi Cotovan

I know this kind of slideshow is pretty comon stuff in the jQuery world as well as other frameworks but I thought the Apple-like Slideshow gallery presented by Tutorialzine was pretty slick and managed to very closely resemble the one used on Apple’s website.

Of course you will customize it if you are going to use it on your site, aren’t you? View the demo here and the original tutorial here.

This may be trivial to some, but I thought I’d share it anyway, since the links I found online were a bit hard to dig up about this one: If you need to make a column in a MSSQL table UNIQUE, using SQL Server Management Studio Express, here’s how:

1. Open your tables, right-click on the table you need to make the unique key,  and select ‘Design’ (or Modify):

2. Right-click on any of the columns in the righ panel and select ‘Indexes/Keys…’

3. On the window that opens up, click ‘Add’ on the bottom-left corner

4. A new entry is created on the left. Select it and notice on the right side the ‘Columns’ field. Click the three dots to select the desired column(s), then change the ‘Is Unique’ setting to ‘Yes’.

5. Click ‘Close’ and save your table. That’s it!

Note that you will not be able to add this Unique key if the desired column has duplicated data in it.