Archive for the ‘SQL’ Category
MySQL WorkBench - A great tool for your databases (Part - 2)
Monday, August 18th, 2008MySQL 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
Monday, August 18th, 2008MySQL 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 - A great tool for your databases
MySQL WorkBench
MySQL WorkBench
Related:
MySQL WorkBench - A great tool for your databases (Part - 2)
Links For August 7th 2008
Friday, August 8th, 2008SQL
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
More Sql Server 2008 resources
Friday, August 8th, 2008More Sql Server 2008 resources
Now that SQL Server 2008 has RTM’ed, you may want to jump in and learn the exciting new product. So here is a collection of links and resources for you to jump on.
Microsoft SQL Server Community & Samples
An overview of the key changes and what you can expect from SQL Server 2008
An Overview of SQL Server 2008 installation
SQL Server 2008 Books Online
Sql Server 2008 Tutorial
TechNet Webcast: Security Enhancements in SQL Server 2008 (Level 300)
TechNet Webcast: SQL Server 2008 (Part 1 of 3): High-Performance Data Warehousing (Level 300)
TechNet Webcast: SQL Server 2008 Performance and Scalability Technologies (Level 300)
All Sql Server 2008 Webcasts
Virtual Labs
Podcasts
Sql Server 2008 Learning Portal
Sql Server 2008 Resources
If you want even more leave a comment and I will post more tommorrow.
Related Posts:
Sql Server 2008 Learning Portal
Sql Server 2008 Resources
