Holger Schmeling Developing a Report Definition Customization Extension for Multi-Language Reports When you need to present the same SQL Server Reporting Services (SSRS) report in eight or more different languages, or... 19 April 2013 31 min read
Seth Delconte Introduction to SQL Server Filtered Indexes SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they... 19 April 2013 13 min read
Randolf Geist Analyzing and Troubleshooting Oracle Parallel Execution Watch video The video above is accompanied by the following resources: Analysing and Troubleshooting Parallel Execution presentation slides (.pdf)... 17 April 2013 1 min read
Grant Fritchey Custom Metrics for Monitoring Database Mirroring SQL Monitor comes with plenty of metrics, but there are always going to be things that you want to measure... 16 April 2013 7 min read
Martin Giffy DSouza Console Wrapper 1.0.4 Console Wrapper 1.0.4 is officially out. You can download it from the project page: https://code.google.com/p/js-console-wrapper/ The only change for this release... 11 April 2013 1 min read
Robert Sheldon Getting Started Testing Databases with tSQLt There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is... 08 April 2013 22 min read
Patrick Barel PL/SQL Subtypes Technology is dominated by two types of people: those who understand what they do not manage, and those who manage... 03 April 2013 6 min read
Erin Stellato Managing SQL Server Statistics Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but... 03 April 2013 31 min read
Hugh Bin-Haad TSQL Pivot Rotations using only REPLACE Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the... 01 April 2013 8 min read
Doug Burns Oracle SQL Monitoring – Performance Analysis This video is a follow up to the webinar broadcast by Red Gate on 27th February 2012. Please leave a... 27 March 2013 1 min read
Nick Celis A valuable component in your APEX ECO-System When working with APEX, you also need a number of tools to improve the efficiency of your work. It isn’t... 26 March 2013 2 min read
Kat Hicks Diagnosing Common Database Ails When a database starts showing signs of an illness, it's up to the DBA to get to the root of... 25 March 2013 13 min read
Kathi Kellenberger Solving Complex T-SQL Problems, Step-By-Step What should you do if your first, most intuitive solution to a problem ends up scanning the data more than... 18 March 2013 19 min read
Tony Davis Shawn McGehee Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth You've just become responsible for a database, only to find that the log file is growing out of control. Why... 14 March 2013 13 min read
Dominic Delmolino Bridging the Developer/DBA Divide: Advances in Database Source Control For over 10 years now, I’ve been a huge advocate of integrating database development, design and architecture practices into application... 13 March 2013 7 min read
Jan Leers Introduction to Table Partitioning Divide and conquer is what Oracle was thinking with this one. Table partitioning is about optimizing “medium selectivity queries”. The... 07 March 2013 8 min read
Seth Delconte Ad-Hoc XML File Querying When you need to shred just part of the data within a large XML file into a SQL Server table,... 05 March 2013 15 min read
Robert Sheldon SQL Server 2012 Window Function Basics For some time, Microsoft had a few window functions, but not the full set specified in the SQL 2003 standard.... 05 March 2013 21 min read
Fabiano Amorim Join Reordering and Bushy Plans Normally, the query Optimiser won't consider 'bushy' plans, where both operands to a join operator could be intermediate results from... 05 March 2013 17 min read
Satishbabu Gunukula Oracle Database Source Control made easy using Red Gate’s new tool Red Gate is launching new tool “Source Control for Oracle tool” on March 12, 2013. How this tool can help... 01 March 2013 2 min read
