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
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
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
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
Aman Sharma An Introduction to 11.2 RAC Server Pools Oracle RAC is designed to cater for Oracle specific applications and also non-oracle applications. These applications, both Oracle and non-Oracle,... 18 April 2012 19 min read
Syed Jaffar Hussain Migrating Oracle Single Instance to RAC This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have... 17 April 2012 1 min read
Phil Factor The TSQL of CSV: Comma-Delimited of Errors Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from,... 13 April 2012 20 min read
Buck Woody Big Data is Just a Fad The Term 'Big Data' is nothing more than a fad, and we'll soon be cringing with embarrassment at the thought... 13 April 2012 12 min read
