Wissem El Khlifi Data Guard Physical Standby Database Best Practices – Part 1 Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases.... 07 August 2012 8 min read
Randolf Geist Oracle Cost-Based Optimizer Advanced This video and set of resources is a follow up to the webinar broadcast by Red Gate on 01 August... 02 August 2012 2 min read
Dave Ballantyne Cleaning Up SQL Server Deployment Scripts Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema... 02 August 2012 22 min read
Randolf Geist Incremental Partition Statistics Review Here is a summary of the findings while evaluating Incremental Partition Statistics that have been introduced in Oracle 11g. The... 01 August 2012 2 min read
Doug Burns Statistics on Partitioned Tables When Jonathan Lewis decided it was time to post a list of the Partition Stats posts on his blog and... 01 August 2012 1 min read
Grant Fritchey The Seven Sins against TSQL Performance There are seven common antipatterns in TSQL coding that make code perform badly, and three good habits which will generally... 31 July 2012 15 min read
Richard Morris Database Continuous Integration with Bamboo We were so interested in Atlassian's Bamboo, and it's role in Continuous Integration, that we wanted to find out more,... 26 July 2012 15 min read
Michael Sorens Practical PowerShell for SQL Server Developers and DBAs – Part 1 There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS... 23 July 2012 16 min read
Phil Factor PowerShell SMO: Just Writing Things Once Sometimes, you can tire of writing the same PowerShell code once again. After this happened to Phil whilst keying in... 19 July 2012 26 min read
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
