Glenn Berry Provisioning a New SQL Server Instance – Part One Before you even install SQL Server, there a number of preparatory steps you need to take in order to get... 21 June 2012 11 min read
Randolf Geist Dynamic Sampling (III) – Real-Life Data – Part I In the previous parts of the series I outlined the basics on Dynamic Sampling. Let’s see how Dynamic Sampling deals... 20 June 2012 9 min read
Dominic Delmolino Pascal matrix SQL puzzle solution I’ve been impressed with the solutions to my little problem of generating a symmetric Pascal matrix using SQL. Charles Hooper in particular has provided... 19 June 2012 1 min read
Laerte Junior The PoSh DBA – The Attributes of Advanced Functions Once you pass that point of just hurriedly writing PowerShell scripts for immediate use and start to write PowerShell functions... 19 June 2012 18 min read
Randolf Geist Nested Loop Join Costing The basic formula for calculating the costs of a Nested Loop Join is pretty straightforward and has been described and... 14 June 2012 2 min read
Martin Giffy DSouza SELECT INTO Techinques One thing that bothers a lot of PL/SQL developers is when they have to select some data from a table... 13 June 2012 1 min read
David Njoku Introduction to Oracle Flashback Technology (Part 3: Flashback Database) In this series of articles, we are discussing the collection of tools that make up the Oracle Flashback Technology suite.... 12 June 2012 6 min read
Annette Allen SSIS Basics: Adding Data Flow to Your Package Annette continues her popular series for SSIS beginners by showing how a data flow task can be used in a... 12 June 2012 16 min read
Alex Kuznetsov Developing Low-Maintenance Databases Alex's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take... 12 June 2012 21 min read
Cary Millsap An Organizational Constraint that Diminishes Software Quality One of the biggest problems in software performance today occurs when the people who write software are different from the... 11 June 2012 1 min read
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
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
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
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
