Other News

Community

Embedding a Text Resource

(Jim Mischel) Most programs work with at least some constant data. A reporting program, for example, will have constant strings that define column names, report titles, and other such things. A 3D world simulation could include huge tables of object definitions that consist of names, positions, vert

Editorials

Trigger Tension

$$SWYNK$$ Trigger Tension You have a process that inserts a record into a table. You also have a trigger that fires after the insert event on the same table. Inside that trigger, you insert a record into a second table. When you attempt to get the identity value assigned from the insert, what value will be returned? The identity value […]

Uncategorized

Your Future as a DBA? Secure.

Your Future as a DBA? Secure. Bright even. But perhaps not for the reasons you anticipate! I’ve been talking with more and more DBAs about the fact that the architecture and performance side of things is becoming increasingly important. Perhaps surprisingly, it’s not because of current applications support, but rather design of applications to support mobile devices and cloud-based solutions. […]

Uncategorized

Covering Index

Covering Index Today I decided to talk about covering indexes. I was pleased to find there has been a lot of recent activity on covering indexes posted here at www.sswug.org. Simply go to our site and type “Covering Index” in the search box. You’ll find many posts. For our Accidental DBA friends, or those new to relational databases, a Covering […]