.Net

Links For August 18th 2008

Web:
YUI 3.0 Preview Release 1
Scaling Web Application - Recommended Readings

C#:
Enumeration Classes

Tools:
Google Unveils Open Source Security Tool

SQL:
Understanding SQL Execution Plan (Part I)
SQL For Developers - 9 Reasons to bother

Silverlight:
Taking your first steps into Silverlight

Links For August 18th 2008

MySQL WorkBench - A great tool for your databases (Part - 2)

This is a continuation to an earlier entry by the name “MySQL WorkBench - A great tool for your databases“.

In the previous article we just talked the features and what can be done with MySQL WorkBench. In this I added a dummy table with few columns, indexes and I showed how you can create a ER (Entity Relationship) Diagram. Attached are the screenshots that were taken during each step. These screenshots talk for themselves.

MySQL WorkBench - Default

MySQL WorkBench - Naming a database

MySQL WorkBench - Adding a new table

MySQL WorkBench - Adding Columns

MySQL WorkBench - Adding Indexes

MySQL WorkBench - Adding ER Diagram

MySQL WorkBench - A great tool for your databases (Part - 2)

MySQL WorkBench - A great tool for your databases

If you use MySQL and design databases for MySQL, then this is the tool for you. This is a free download that you can download from MySQL’s website and use it. With this tool you can design your database, tables, relationships, triggers etc.. And you have a great GUI for specifying various tbale level options. You can save all these to a file, and open it and continue your work. When you think you are done. You can export to .sql file and run the .sql file against your database which creates the required tables, indexes, relations etc.. When you export you can export either as Create statements / Alter statements. Now for some greate screenshots of the tool. Can be downloaded from here.

Below are some screenshots:

MySQL WorkBench

MySQL WorkBench

MySQL WorkBench

MySQL WorkBench

Related:
MySQL WorkBench - A great tool for your databases (Part - 2)

MySQL WorkBench - A great tool for your databases

Links For August 7th 2008

SQL
Microsoft Source Code Analyzer for SQL Injection
SQL Academy 2008 (free training for Database Professionals)
SQL Server 2008 Jump Start
More Sql Server 2008 resources

F#:
Exploring the F# Language Series Part 2 - Installation and Configuration

CSS:
CSS variables considered harmful?

Sharepoint:
Sharepoint Training Solutions

Silverlight:
Program Silverlight with the CoreCLR
The Silverlight Security Model
Silverlight Security Cheat Sheet

ASP.Net:
Data Access Layers in ASP.NET Applications

Links For August 7th 2008

Stored Procedure Generator (for SQL Server 2000/2005)

Stored Procdure Generator (for SQL Server 2000/2005) is a simple utiliyy that can generate Sql Stored Procs and Data Access Layer for you. The description as per the website:

This utility automatically creates all basic stored procedures (SelectAll, SelectRow, InsertRow, UpdateRow, DeleteRow) necessary to access the SQL Server Tables.
It also has options to create Data Access Layers for those stored procedures.

Here is the website.

Stored Procedure Generator (for SQL Server 2000/2005)