Stock Market Technical Analysis

Although the technical approach to stock market analysis has been around since the 1800s, some improvements have obviously been made...

07 September 2011 15 min read

David Njoku

Introduction to Regular Expressions in Oracle

Regular expressions – RegEx or RegExp to their friends – were fashionably late in coming to the Oracle party. The...

06 September 2011 5 min read

Michael Williamson

Writing Maintainable Code

Writing maintainable code is hard. It must be understandable, testable and readable. Any one of these can be tricky, and...

06 September 2011 11 min read

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

Tony Davis

SQL Code Reuse: teaching a dog new tricks

Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so,...

01 September 2011 4 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

Laerte Junior

Storing Windows Event Viewer Output in a SQL Server table with PowerShell

My good friend Marcos Freccia (blog | twitter) asked me for a simple and fast way to save the output...

31 August 2011 3 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

Louis Davidson

PASS First Timer Advice–Make it worth it!

I have seen a lot of other people giving advice about what to do on your first trip to the...

26 August 2011 6 min read

Michael Sorens

Further Down the Rabbit Hole: PowerShell Modules and Encapsulation

Modules allow you to use standard libraries that extend PowerShell's functionality. They are easier to use than to create, but...

24 August 2011 24 min read

David Berry

Designing C# Software With Interfaces

The best way to understand how interfaces improve software design is to see a familiar problem solved using interfaces. First,...

24 August 2011 30 min read

Grant Fritchey

Exploring SQL Azure

I’m spending a little bit of time each week trying out a few things in SQL Azure. I’m convinced that...

23 August 2011 4 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

Tony Davis

A DBA’s best friend is his tempdb

There is a saying amongst welfare agencies that one can tell how well a family is functioning by looking at...

18 August 2011 3 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

Dom Smith

Objects or instances

Why we renamed some features in ANTS Memory Profiler 7 When you are designing a complex product, it is important...

17 August 2011 3 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

Register for Simple Talk

Articles