(Giuseppe Maxia) Imagine having a database with 100 tables and you want to allow a user to read from all of it, except one.
Other News
Mainpulating Files and Directories in ASP.NET
Let’s suppose, you have to enable your website users to upload their pictures. Or suppose you have to place functionality of uploading product images along with the product description. In this article, we will explain how you can provide such functionalities.
Columns to Rows
(Joseph Fuda) Transforming columns into rows is easily accomplished with the SELECT command’s UNPIVOT clause, introduced in Oracle 11g. (For database versions earlier than 11g see the remaining topics in this section for alternative techniques.)
APEX + Flashback + SQL Developer = Undo
(Tyler Muth) Application Express doesn’t really have an undo button. Fortunately, since it runs in the database it can leverage one of my favorite database features: Flashback. I strongly urge every developer and DBA to get more familiar with flashback (OTN overview here). Some things to consider be
Oracle BI EE 10.1.3.3/2 – Using IndexCol Function – Varying Underlying Columns based on User Login
(Venkatakrishnan J) One of the interesting features of BI EE is its ability to bring up different Business Model columns for a single Presentation Layer column based on different user logins. For example, say if you are creating the following report (all columns point to presentation layer columns),
The 900 byte index limitation in SQL Server
One restriction that you might have faced at times with SQL Server is that the maximum size for an index can only be up-to 900 bytes. It is important to note that it is 900 bytes and not 900 characters.
Building a BizTalk Pipeline Content Enricher with SQL Server 2005
(Jeffrey Juday) Allocating resources until you need them often improves your software’s responsiveness and reduces runtime footprint. Allocating just before you use something, though, may not always be the best approach. Balancing allocating early or just-in-time is a decision we all face.
Did You Know? SP2 does NOT limit the amount of plan cache you can have
(Kalen Delaney) As I am preparing my talk for the UK SQL Server Users Group on November 16, I was going through other presentations on plan cache management. At the PASS Conference in Denver in September there was a session on management of cache, and I was surprised to find a slide that indicated t
Moving the tempdb database
(Bill Graziano) Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.
Programmers Only: Optimistic Locking, Part 2
(Bonnie Baker) In my last column I explained the concept of optimistic locking in DB2 for z/OS. I explained how optimistic locking techniques can be used in application programs to reduce locking overhead (including potential timeouts) and improve performance. I explained that SQL functions — such a