Patrick Barel Collections in Oracle Part 2 “The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This... 02 September 2011 6 min read
Database Administration Fabiano Amorim in Database Administration Statistics on Ascending Columns It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an... 01 September 2011 10 min read
Alex Nuijten Business Rule: Only One per Day, but Keep the Time The business rule states: Only one entry is allowed per ID and per day and the time should be recorded.... 30 August 2011 1 min read
Cary Millsap Mastering Oracle Trace Data A one-day course taught by Cary Millsap London, UK, 8 Sept 2011 Oracle trace data is an extraordinarily rich information... 19 August 2011 1 min read
Patrick Barel Collections in Oracle Part 1 “The beginning of knowledge is the discovery of something we do not understand.” Frank Herbert. Collections are single-dimensioned lists of... 19 August 2011 5 min read
Chris Hritzuk Can PL/SQL be Faster than SQL? PL/SQL and SQL both are incredibly powerful languages that allow us to do some pretty amazing things with data. If... 19 August 2011 11 min read
David Njoku Autonomous Transactions in Oracle Autonomous transactions are a bit like that dark part of the forest, beyond the rickety bridge, where the shadows are... 18 August 2011 6 min read
BI Robert Sheldon in BI XML Configuration files in SQL Server Integration Services Package configuration files are a great way of providing the values of SSIS package properties so that packages can be... 18 August 2011 10 min read
Joe Celko Mimicking Magnetic Tape in SQL The sequential nature of early data storage devices such as punched card and magnetic tape once forced programmers to devise... 17 August 2011 10 min read
Grant Fritchey Preventing Problems in SQL Server It is never a good idea to let your users be the ones to tell you of database server outages.... 15 August 2011 9 min read
Phil Factor SQL Programmer’s workshop Phil Factor records, as closely as possible, the twists and turns of creating a SQL Server T-SQL stored procedure, describing... 05 August 2011 26 min read
Benjamin Nevarez The SQL Server Query Optimizer To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the... 03 August 2011 35 min read
Database Administration Laerte Junior in Database Administration Using PowerShell and WMI Events Queries for Powerful Notifications With PowerShell in one hand, and WMI in the other, DBAs can do almost anything in their Window's environments, and... 25 July 2011 11 min read
T-SQL Programming Solomon Rutzky in T-SQL Programming CLR Performance Testing Are Common Language Runtime routines in SQL Server faster or slower than the equivalent TSQL code? How would you go... 21 July 2011 19 min read
BI Robert Sheldon in BI Adding the Script Task to Your SSIS Packages Script tasks are a great way of extending SSIS functionality, when the buit-in functionality isn't quite Script tasks are a... 21 July 2011 19 min read
Patrick Barel Working with Table Functions in PL/SQL Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be... 20 July 2011 2 min read
Database Administration Glenn Berry in Database Administration Configuring the Storage Subsystem The storage subsystem for a SQL Server can prove to be a bottleneck if the best choices of hardware aren't... 20 July 2011 42 min read
Learn SQL Server Chris Shaw in Learn SQL Server Building Your DBA Skillset As a DBA and hiring manager, Chris Shaw has been on those sides of the recruitement process. As an MVP... 06 July 2011 23 min read
Laerte Junior PowerShell Eventing and SQL Server Restores When you're managing a large number of servers, it makes no sense to run maintenance tasks one at a time,... 05 July 2011 13 min read
Joe Celko Arrays in SQL that Avoid Repeated Groups It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would... 05 July 2011 11 min read
