(Stacia Misner) Thus far in this series, I have described using the IN operator and the LIKE operator. Today, I’ll continue the series by reviewing the TOP and BOTTOM operators.
Other News
Extracting Images from SSRS reports
(Jason Thomas) What do you do when you want to re-use an image in one of those old forgotten reports that was developed by that weird guy who left your company an year ago? No matter how much you hate or abuse that guy now, it is not going to do you any good as he didn’t save those images […]
First Houston Area DB2 User Group for 2011 coming on January 19.
(Willie Favero) Well, we’re at it again. We are once again attempting to get the Houston Area DB2 User Group functional.
Writing Reusable Queries in MySQL
(Rob Gravelle) When someone mentions the term “reusable query”, the first thought that comes to mind is usually stored procedures. While they are an integral part of writing reusable code, they are only one ingredient in a bigger pie. Other key players include views and native as well as user-def
IBM Cognos Proven Practices: Customizing IBM Cognos 10 Login
(Antonio Marziano, Andreas Weber and Chris Shepherd) This document is meant to supplement the Security and Administration Guide of IBM Cognos 10 by providing sophisticated examples for customizing the login page. The examples provided shall support the understanding of the possibilities and flexibil
Database smart flash cache wait events
(Yasin Baskan) When you enable the database smart flash cache and start using it you will see new wait events related to that. These events help to find out if the problem is about the flash cache or not.
Basics of Join Predicate Pushdown in Oracle
(Maria Colgan) Happy New Year to all of our readers! We hope you all had a great holiday season. We start the new year by continuing our series on Optimizer transformations. This time it is the turn of Predicate Pushdown. I would like to thank Rafi Ahmed for the content of this blog.
How Oracle Locking Works
(Arup Nanda) A week or so ago I started a new series – 100 Things You Probably didn’t Know about Oracle Database . Part 1 of the series proved quite popular, as I surmise from the emails I received. Here is the Part 2 of the series.
Executing Queries against linked servers
(Nakul Vachhrajani) Recently, a team at the office asked me how could they fire off a query against a linked server. The condition was that the server where the query would originate from was going to be a Microsoft SQL Server 2008 instance whereas the target was Microsoft SQL Server 2005 instance.
How to Setup Row-Level Security for SQL Server
(K. Brian Kelley) I’ve been tasked to put together a row-level security model for a database where users are connecting with their Windows user accounts. I’m not sure how to go about this. How do I setup such a security model?