(Troy Coleman) Last year I wrote a post about plan stability in a skip migration scenario. As I later told a reader who was having little success finding more information on this topic, another–and perhaps more common–term for plan stability is access path stability. And in general, these terms fa
Other News
Got Oracle Database Skills? Get DB2 Skills at No Charge…
(Conor O’Mahony) IBM has a couple of great ways for people with Oracle Database skills to easily add DB2 skills to their resumes. These are available at no charge, allowing you to add skills to your resume and become more attractive to potential employers.
SQL Server: Move a Table from the Primary Partition to a Secondary Partition
(Emrikol007) I get often asked by customers how they can best move data from their primary partition to a secondary partion. Often databases are created with a simple MDF & LDF set up and the data is on the Primary Default partition.
Calculate the Distance Between Two Latitude/Longitude Points using Plain SQL
(Charles Hooper) A question recently appeared on the comp.databases.oracle.server Usenet group that oddly made me recall a lesson from a mathematics class that I taught in the early 1990s. A bit strange how a question related to Oracle Database would trigger such a memory, but it happened.
ADF BC 11g R2 – Java Extended For Oracle Data Type Map
(Andrejus Baranovskis) There is one fundamental change in ADF BC from 11g R2. It’s not recommended anymore to use oracle.jbo.domain.Number type for numeric data types. As per ADF developer guide for 11g R2 – New Fusion web applications should use the default Java Extended for Oracle type.
IBM Cognos Proven Practices: Using IBM Cognos 10 Virtual View Manager for Federated Queries
An overview of the IBM Cognos Virtual View Manager semijoin functionality and how it affects the federated queries.
How Secure is Secure?
How Secure is Secure? It wasn’t more than a few years ago when Microsoft was the whipping kid when it came to inadequate security measures. Apple, Unix/Linux, Solaris, OS 400, MVS, CMS, etc. were considered more secure because they either didn’t have enough market share, or had less vulnerabilities. Less focus was paid to our own practices in writing code […]
SQL Injection – What to Do?
SQL Injection – What to Do? Lots of good responses regarding what to do in the short term for SQL Injection. Before I list some of the great triage answers today, let me make a simple reminder of how to stop SQL Injection. The easiest answer is simple…use strongly typed parameters whenever you interact with your database. Most data access […]
How to Apply Skew in SVG
(Darla Ferrara) Skew is all about angles and part of the transformation elements. Learning how to apply skew in SVG allows you to change the angle of a shape along the X or Y axis. This is different from using rotate, which will adjust the angle of the entire shape.
Control Templates, Styles and Triggers in WPF
(Ged Mead) One of the really useful features of the control template and style architecture in WPF is the way it lets you define templates and styles at various levels of scope throughout the application. This means you can create a control, tore it at the application level and use it as a kind of