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

SQL Server Index Scan: How to Find & Fix Scan Problems

Find and fix SQL Server index scan problems using plan cache analysis. Covers identifying scans with DMVs, converting scans to...

10 March 2015 25 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

Anju Garg

Oracle 12c DataGuard: Roll Forward a Physical Standby with RECOVER FROM SERVICE

Roll forward an Oracle 12c DataGuard physical standby database that has fallen behind the primary using the RECOVER...FROM SERVICE command....

17 February 2015 16 min read

Tony Davis

Questions About SQL Server Transaction Log You Were Too Shy To Ask

You can give a deep-dive presentation about SQL Server's transaction log, and round it off by inviting questions. Your audience...

11 February 2015 26 min read

Joe Celko

The DRI Subject of References

A database must be able to maintain and enforce the business rules and relationships in data in order to maintain...

11 February 2015 13 min read

Dennes Torres

SQL Server Plan Cache Warnings: Detecting PlanAffectingConvert, MissingIndexes, and More

Detect query plan warnings in the SQL Server plan cache - PlanAffectingConvert (implicit conversion), ConvertIssue, NoStatsFound, MissingIndexes, and others -...

11 February 2015 11 min read

Feodor Georgiev

Curing Data-Obesity in OLTP Databases

OLTP databases work best when data that becomes no longer current is then transferred to a separate database for analysis...

06 February 2015 13 min read

Jonathan Watts

The Promise – and the Pitfalls – of In-Memory OLTP

When SQL Server 2014 was released, it included Hekaton, Microsoft's much talked about memory-optimized engine that brings In-Memory OLTP into...

04 February 2015 7 min read

Michael K Campbell

The Importance of Caching

Performance tuning and optimization definitely have their place in minimizing SQL Server Licensing costs - by helping keep CPU utilization...

04 February 2015 15 min read

Satishbabu Gunukula

Oracle Database 12c – RMAN New Features: Part 3

Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN). The Recovery Manager continues to enhance and extend...

02 February 2015 8 min read

Robert Sheldon

Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask

Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What,...

26 January 2015 29 min read

Dennes Torres

Centralize Your Database Monitoring Process

SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about...

26 January 2015 17 min read

Dwain Camps

Bowled Over by SQL Window Functions

What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the...

26 January 2015 27 min read

Phil Factor

A Start with Automating Database Configuration Management

For a number of reasons, it pays to have the up-to-date source of all the databases and servers that you're...

16 January 2015 24 min read

AWS

Robert Sheldon in AWS

Amazon’s Aurora: A Distributed SQL Database Alternative For MySQL Applications

SQL-based distributed Cloud Relational databases aren't new, but Amazon's Aurora offers an alternative to SQL Azure, and, being MySQL-compatible, provides...

15 January 2015 13 min read