Dwain Camps Time Slots – An Essential Extension to Calendar Tables After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges,... 22 April 2015 24 min read
David Njoku In Defence of Triggers Database triggers. If you have spent any length of time within the Oracle development circle you might have noticed something... 15 April 2015 5 min read
Adam Aspin Mobile BI with SQL Server Reporting Services For users to get the information they need from mobile reports, we frequently have to tailor the way we design... 15 April 2015 30 min read
Grahaeme Ross Understanding Cross-Database Transactions in SQL Server Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database... 11 April 2015 19 min read
Phil Factor Schema-Based Access Control for SQL Server Databases Access-control within the database is important for the security of data, but it should be simple to implement. It is... 09 April 2015 25 min read
Anju Garg Oracle Multitenant : Super-fast Provisioning of Standby Databases In this article, I will demonstrate how to quickly create a standby database for a non-multitenant container database (NCDB) by... 07 April 2015 8 min read
Robert Sheldon How to Get SQL Server Data-Conversion Horribly Wrong One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit... 02 April 2015 34 min read
Joshua Feierman How DBAs Can Adopt the Craftsman Mindset The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen... 01 April 2015 16 min read
Jonathan Lewis Execution Plans Part 14: SQL Monitoring This is the last part of my series on Execution plans, and features an option which is only available if... 26 March 2015 14 min read
Alex Kuznetsov Painless Refactoring of SQL Server Database Objects Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted... 26 March 2015 25 min read
Roy Ernest SQL Server Spatial Indexes Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example,... 18 March 2015 20 min read
Fabiano Amorim Never Ignore a Sort Warning in SQL Server It is always bad news if your SQL queries are having to use the SORT operator. It is worse news... 18 March 2015 9 min read
David Njoku The Problem With Triggers Feeling brave? Enjoy danger? Well, I dare you to walk into a room full of Oracle experts wearing an I... 16 March 2015 5 min read
Jonathan Lewis Execution Plans Part 13: SQL Trace In parts 11 and 12 of this series I described the “rowsource execution statistics” that we can collect as Oracle... 11 March 2015 12 min read
Dwain Camps Self-maintaining, Contiguous Effective Dates in Temporal Tables 'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they... 10 March 2015 38 min read
Dennes Torres Identifying and Solving Index Scan Problems When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once... 10 March 2015 24 min read
Robert Sheldon How to get Database Design Horribly Wrong Database Design is one of those tasks where you have to carefully get all the major aspects right. If you... 06 March 2015 34 min read
David Njoku Oracle Programming Basics: Overloading It is probably a bad idea to define a word by using a bigger one, but I really can’t introduce... 02 March 2015 5 min read
Thomas LeBlanc Defusing Database Time Bombs: Avoiding the Need to Refactor Databases Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges... 27 February 2015 23 min read
Steve Harville Data Masking using SQL Loader I use Enterprise Manager Cloud Control to mask Oracle databases so they can be shared with our ERP vendor. I intended to... 25 February 2015 5 min read