Cristi Cotovan

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.

We have completed a new set of 3D apartment tours.

I have developed a website where you can buy land in an almost fairy tale location — Bran, Romania. The website included something new, never before done on one of my websites — 360-degree panoramic views for the plots being sold.

Photography for it has been also shot by me. View some of my photos on flickr.

I have developed a new site for a company that builds new, and very cheap apartments in Brasov. The site included availability information, customised filtering, 3D virtual tours of the apartments and slideshows. Go check it out: www.avantgarden3.ro