Search SSWUG.ORG:

Latest Video Programs





        
 

From the Editor's Desk...

When Should You Tune a Query?  -  Maybe not as often as you might think. If your query is slow you may need to look elsewhere. How do you know it's time to work on the query itself? Today I share my opinion. Read on...see if you agree. then tear it up with your comments :-)

Tune Your Database Before Your Query  -  Query hints are often used to optimize query performance. Efforts made toward tuning your database may provide more value.

CAP Compared with ACID  -  CAP and ACID strategies for database persistence have a lot of overlap. So, what makes them different?

Start with Simplicity  -  Do you ever find you have pet solutions for solving problems. You like them because they are sophisticated, or are very flexible. Is that where we need to start?

A Tip from the Trenches  -  When systems slow down the database is often the first place we look. It's not always the database that is the problem.

Another Database Management Tool - 0xDBE  -  All of the reasonably priced database management software has gone commercial. TOAD was the last to be reasonably priced. JetBrains has 0xDBE in the works. Today it is free in a pre-release form. It might be worth taking a look.

Database Design Process  -  Yesterday I shared the environment I like to use for database design. We had some good comments reminding us that database design is not only a working environment, but a process. Be sure to read the comments. Today I share my preferred process.

Creating an ERD  -  Entity Relationship Diagrams are extremely useful for a larger size team, or complicated projects. As the number of tables grows, so does the importance of a good ERD. How do you create yours. Today I share a little bit about my configuration and design technique.

Triggers - The Good, Bad, and the Ugly  -  I just like the title. Even so, the topic for today is "Triggers". Let's talk about trigger use and abuse.


Community Content - News, Articles, How-To Information and More from Around the World