Joe Celko The SQL of Parts Explosions Parts explosions present a classic IT problem. How can one calculate such things as weight or cost of assemblies in... 30 May 2013 11 min read
Tools Michael Sorens in Tools MySQL Data Compare: The Manual that Time Forgot MySQL Data Compare can both compare the data in MYSQL databases and also synchronise them. It is handy for a... 28 May 2013 16 min read
Robert Sheldon Getting Started with the SSAS Tabular Model SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to... 22 May 2013 16 min read
Andy Brown Moving Data From Excel to SQL Server – 10 Steps to Follow SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates... 21 May 2013 15 min read
Grant Fritchey The DBA Detective: The Case of the Missing Index When problems arise in SQL Server, we're faced with a server full of suspects, including disk I/O, memory, CPU, incorrect... 15 May 2013 12 min read
Allen White Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell.... 03 May 2013 15 min read
Tools Michael Sorens in Tools MySQL Compare: The Manual That Time Forgot, Part 1 Although SQL Compare, for SQL Server, is one of Redgate's best-known products, there are also 'sister' tools that allow you... 03 May 2013 14 min read
Aman Sharma RAC One Node In the past few years, technology has become a very important aspect of our lives. There isn’t any moment when we are... 25 April 2013 20 min read
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
