Kirill Loifman High Availability and SLA requirements for Oracle database Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements.... 24 November 2013 1 min read
Alex Kuznetsov Lessons Learned from Six Years of Agile Database Development Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a... 19 November 2013 26 min read
Robert Sheldon Microsoft’s Log Parser Utility: Swell ETL For loading text, CSV or XML files into SQL Server, the Log Parser utility, with its amazing SQL engine, is... 12 November 2013 21 min read
Laerte Junior The PoSh DBA – Getting Airborne with PowerShell Maybe the best way of helping the busy database professional to get started with practical PowerShell-based administration is to pull... 31 October 2013 26 min read
Joe Celko Window Functions in SQL SQL's windowing functions are surprisingly versatile, and allow us to cut out all those self-joins and explicit cursors. Joe Celko... 31 October 2013 16 min read
Bobby Curtis Overview of a few features in Oracle Pluggable Database 12c By now, many of us have downloaded, installed and either played with or implemented the latest release of the Oracle... 22 October 2013 6 min read
Dwain Camps Calculating Values within a Rolling Window in Transact SQL Before the SQL Window functions were implemented, it was tricky to calculate rolling totals or moving averages efficiently in SQL... 17 October 2013 19 min read
Jonathan Lewis Histograms Part 3 – When? In part 2 we looked at the way that Oracle collects and uses height –balanced histograms, and raised the problem... 16 October 2013 11 min read
Annette Allen SSIS Basics: Using the Merge Join Transformation SSIS is able to take sorted data from more than one OLE DB data source and merge them into one... 16 October 2013 19 min read
Nigel Rivett The ETL from Hell – Diagnosing Batch System Performance Issues Too often, the batch systems that underlie a lot of database processing just grow without conscious design. When runs start... 15 October 2013 17 min read
Robert Sheldon SQL Server SQLCMD Basics Sqlcmd makes many SQL Server tasks, such as automating test runs and maintenance tasks, easier and quicker. The sqlcmd command-line... 15 October 2013 15 min read
Mark S Rasmussen SQL Server Storage Internals 101 This article is an extract from the book Tribal SQL. In this article, Mark S. Rasmussen offers a concise introduction... 09 October 2013 32 min read
Scott Murray SQL Server Reporting Services Advanced Charting SQL Server Reporting Services (SSRS) has evolved over the years to incorporate many new data visualization capabilities. In this article,... 08 October 2013 21 min read
Jonathan Lewis Histograms Part 2 In part 1 of this series we discussed the reasons why we might want to create some histograms to help... 01 October 2013 14 min read
Rodney Landrum SSRS Reports as a Data Source in Excel 2013 DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To... 26 September 2013 11 min read
Robert Sheldon DAX Statistical Functions Following on from his first four articles on using Data Analysis Expressions (DAX) with tabular databases, Robert Sheldon dives into... 23 September 2013 22 min read
Richard Morris Developing for Delivery, a Practical Example Richard Morris interviewed Michael Stoop, a database developer at Calvi, Europe's leading provider of Telecom Invoice Management software. The discussion... 17 September 2013 8 min read
Neil Anderson Protecting your changes when working in a shared environment Over the last few months, we’ve been visiting customers and helping them get up and running with Red Gate tools.... 16 September 2013 4 min read
Laerte Junior The PoSh DBA – Getting to know PowerShell Although it was primarily designed for System Administrators, PowerShell is now extending its use to Database, SharePoint, Exchange and all... 10 September 2013 18 min read
Joe Celko Databases and Dominoes A Dominoes game of Texas 42 inspires Joe to explore unusual uses for check constraints and views. Sometimes, the best... 09 September 2013 14 min read
