Peter Larsson The Road to Professional Database Development: Database Normalization Not only is the process of normalisation valuable for increasing data quality and simplifying the process of modifying data, but... 07 June 2012 27 min read
David Njoku Introduction to Oracle Flashback Technology (Part 2: Database Administrators) In the first in this series of articles on the tools in the Oracle Flashback Technology armoury, I discussed what... 31 May 2012 6 min read
Jonathan Lewis Ch-ch-ch-ch-changes For those not familiar with Richard Foote’s extensive blog about indexes (and if you’re not you should be) – the title of... 29 May 2012 2 min read
Joe Celko SQL View: Beyond the Basics Following up from his popular article, SQL View Basics, Joe delves into the main uses of views, explains how the... 28 May 2012 13 min read
Joe Sack A first look at SQL Server 2012 Availability Group Wait Statistics If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to... 21 May 2012 15 min read
Annette Allen SSIS Basics: Setting Up Your Initial Package When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often needs to be... 21 May 2012 19 min read
Fabiano Amorim SQL Server Prefetch and Query Performance Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting... 21 May 2012 11 min read
Brad McGehee Checking Out SQL Backup Pro 7's New Automatic Backup Verification Wouldn't it be great to offload the daily chore of checking the integrity of your production databases, and checking that... 18 May 2012 13 min read
David Njoku Introduction to Oracle Flashback Technology (Part 1: Application Developers) Imagine, if you will, that someone invented time travel. What would you do with it? Nip back into the past... 16 May 2012 7 min read
Warwick Rudd SQL Server 2012 AlwaysOn SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It makes use of existing SQL Server... 15 May 2012 19 min read
Wissem El Khlifi Auto Restart Enterprise Manager Cloud Control Agent 12c Introduction: Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database... 10 May 2012 1 min read
Laerte Junior The PoSh DBA: Grown-Up PowerShell Functions Laerte goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing... 10 May 2012 19 min read
Joe Celko SQL VIEW Basics SQL Views are essential for the database developer. However, it is common to see them misused, or neglected. Joe Celko... 10 May 2012 19 min read
Jonathan Kehayias Handling Deadlocks in SQL Server In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan Kehayias provides a guide... 10 May 2012 45 min read
Timothy Wiseman SQL Scripts Manager and IronPython As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows... 04 May 2012 10 min read
Jonathan Lewis Oracle Heap Tables or SQL Server Clustered Indexes? Jonathan Lewis and Grant Fritchey Live Debate The following video and set of resources are from the webinar broadcast by Red Gate on 7 June 2012. Oracle... 30 April 2012 1 min read
Karen Morton How to Gather SQL Resource Consumption Metrics in Oracle The following video and set of resources are from the webinar broadcast by Red Gate on 8 May 2012. The... 26 April 2012 2 min read
Robert Sheldon Implementing Lookup Logic in SQL Server Integration Services With SSIS, you can perform a lookup on data in the course of a task, using referenced data from any... 26 April 2012 14 min read
Greg Larsen SQL Server Transaction Log Fragmentation: a Primer Generally, you will have no need to worry about the number of virtual log files in your transaction log. However,... 26 April 2012 17 min read
Cary Millsap Real Developers DO use Tools This video is a recording from the webinar broadcast by Red Gate on 24th January 2012. You may’ve heard the... 19 April 2012 1 min read
