SQL#: Enabling more powerful SQL

One of the new features in SQL Server 2005 is CLR integration. And here is a class library called SQL# claiming it is to enable more powerful and more functional SQL. If you simply look at its homepage or feature list, I guess you are same as me, still confusing of the purpose of SQL#. Is it a query language like LINQ? Is it enabling you to write CLR store procs more easily?

Everything becomes clear until I read its documentations. It is in fact a bunch of CLR stored procs and CLR user defined functions / aggregates which are to be install into your SQL Server 2005 databases. And you can use CLR stored procs and UDFs to help you or make easier to write SQL statements. There are a lots of useful functions included in the class library. I feel excited now.

Go to SQL# website to find out more. SQL# comes with a free version and a paid version costing USD$25.

Best resources for Web developers and designers

* denotes new links added on 28th March

CSS

• TabCreator - A CSS Menu generator*
• Write a well structured CSS file without becoming crazy*
• Most used CSS tricks*

Data Management

• 50 Content Management Systems - some are free...

Design > Guidelines

• 20+ Free Web Design Ebooks And Guides
• 20 Free Ebooks and Whitepapers for Better Web Design*
• 20 Websites That Made Me A Better Web Developer*
  

Design > Icons

• 35 (Really) Incredible Free Icon Sets
• Best Small Web Design Icon Download Sites
• PI Diagona Pack

Design > Photoshop

• 45 Photoshop Tutorials for Better Navigation - I finally know how to make a nice looking button...
• Photoshop actions: 124+ Free Photoshop Actions to Boost Your Designs - some are really cool..
• 100 Photoshop Tutorials for Creating Beautiful Art
• 23 Most Incredible Photoshop Tutorials*
• 33 awesome body enhancement photoshop tutorials*

Javascript

• FancyZoom 1.1 Smooth Javascript Image Zooming For Your Web Pages - something different from the widely used Lightbox
• iCarousel - creating image / text carousel like widgets
• dfFlexiGrid - Liquid Javascript Grid Layout*
• 10 JavaScript Effects to Boost Your Website’s Fanciness Factor*
• Mootools - Allow you to write flexible, and cross-browser code with its API*

Security

• How Hackers Hack Your Website - informative...

Testing

• Browsershots - Free online service to test your web design in different browsers with just a few mouse clicks

Other great lists..

• 99 Sites ALL Designers Must Know About
• 100+ Resources for Web Developers

SQL Server 2005 Backup / Restore Troubleshooting

Some information on troubleshooting SQL Server 2005: Click here.

Resources on Data Modeling

Even though the resources aren't quite useful to me by now, it is a great reference for students who are learning data modeling or database schema design. Check it out: http://databaseanswers.org/