Patrick Barel ANSI SQL if you can’t beat them, join them. Gregory Y. Titelman Since Oracle 9i, Oracle SQL supports the ANSI SQL... 18 July 2012 6 min read
Jonathan Lewis ANSI Outer 2 A comment on a recent post of mine pointed me to a question on the OTN SQL and PL/SQL Forum where someone... 17 July 2012 1 min read
Dominic Delmolino Hate the player, not the game — or my case for Data Engineers Has “database” become a dirty word within your organization lately? If you’re someone who has been a data technologist for... 16 July 2012 4 min read
Chet Justice Fun with OBIEE SQL I posted a couple of tweets yesterday about this crazy query I had to work with. I won’t Storify you... 13 July 2012 2 min read
Jonathan Kehayias Optimizing tempdb configuration with SQL Server 2012 Extended Events One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the... 13 July 2012 20 min read
Doug Burns Falling in Love All Over Again: OEM 12c Performance Page Enhancements Oracle Enterprise Manager 12c introduces the latest evolutionary stage of the Performance Pages demonstrated in the previous webinar. This session... 10 July 2012 1 min read
Seth Delconte NULL-Friendly: Using Sparse Columns and Column Sets in SQL Server Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always... 10 July 2012 14 min read
Randolf Geist Dynamic Sampling (III) – Real-Life Data – Part II In the previous installment of this series we saw that Dynamic Sampling wasn’t of great help when dealing with certain... 05 July 2012 11 min read
Warwick Rudd Encrypting Your SQL Server 2012 AlwaysOn Availability Databases It is likely that you'll want to add a database with TDS Encryption to your AlwaysOn Availability Group. If you... 04 July 2012 8 min read
Robert Sheldon Working with SSIS Data Types In order to be able to take data from a variety of sources, manipulate it, and then export it to... 02 July 2012 14 min read
Phil Factor Handling Constraint Violations and Errors in SQL Server The database developer can, of course, throw all errors back to the application developer to deal with, but this is... 29 June 2012 27 min read
Doug Burns How I Learned to Love Pictures: OEM Performance Page Fundamentals The following video and set of resources are from the webinar broadcast by Red Gate on 03 July 2012. Watch... 26 June 2012 1 min read
Glenn Berry Provisioning a New SQL Server Instance – Part One Before you even install SQL Server, there a number of preparatory steps you need to take in order to get... 21 June 2012 11 min read
Randolf Geist Dynamic Sampling (III) – Real-Life Data – Part I In the previous parts of the series I outlined the basics on Dynamic Sampling. Let’s see how Dynamic Sampling deals... 20 June 2012 9 min read
Dominic Delmolino Pascal matrix SQL puzzle solution I’ve been impressed with the solutions to my little problem of generating a symmetric Pascal matrix using SQL. Charles Hooper in particular has provided... 19 June 2012 1 min read
Laerte Junior The PoSh DBA – The Attributes of Advanced Functions Once you pass that point of just hurriedly writing PowerShell scripts for immediate use and start to write PowerShell functions... 19 June 2012 18 min read
Randolf Geist Nested Loop Join Costing The basic formula for calculating the costs of a Nested Loop Join is pretty straightforward and has been described and... 14 June 2012 2 min read
Martin Giffy DSouza SELECT INTO Techinques One thing that bothers a lot of PL/SQL developers is when they have to select some data from a table... 13 June 2012 1 min read
David Njoku Introduction to Oracle Flashback Technology (Part 3: Flashback Database) In this series of articles, we are discussing the collection of tools that make up the Oracle Flashback Technology suite.... 12 June 2012 6 min read
Alex Kuznetsov Developing Low-Maintenance Databases Alex's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take... 12 June 2012 21 min read
