Databases Archives

SQL Server System Functions: The Basics

Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as...

31 March 2016 22 min read

Kartik Balachandran

Siebel CRM Part 5: The Ancillary Software

Before we can start installing the Siebel Application software we have a few more steps to complete. Just to recap...

29 March 2016 6 min read

David Njoku

XQuery for Absolute Beginners: Part 3 – FLWOR

This is the third instalment in a series of articles that I’m hoping will serve as a primer for Oracle...

21 March 2016 9 min read

Kartik Balachandran

Siebel CRM Part 4: The Extract

The extraction of zip files is usually a fairly simple exercise, but in the case of Siebel CRM it is...

17 March 2016 4 min read

SQL Server

Kathi Kellenberger in SQL Server

FIFO Stock Inventory in T-SQL: The Window Function Approach vs Dave Ballantyne’s Original Set-Based Solution

Solving the FIFO (first-in, first-out) stock inventory problem in T-SQL with window functions (Kathi Kellenberger's approach using SUM() OVER with...

16 March 2016 14 min read

Enrico van de Laar

The SQL Server 2016 Query Store: Forcing Execution Plans using the Query Store

The SQL Server 2016 Query Store can give you valuable performance insights by providing several new ways of troubleshooting queries,...

16 March 2016 7 min read

Dennes Torres

Creating a Date Dimension in a Tabular Model

As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either...

15 March 2016 23 min read

Kartik Balachandran

Siebel CRM Part 3: The Download of the Siebel Installation and Ancillary Application Files

This article requires that you have an Amazon AWS instance set up, as detailed in the previous article in this...

14 March 2016 4 min read

Anju Garg

Oracle Database 12.1.0.2c: Automatic Big Table Cache

Serial direct path reads were first introduced in Oracle 11g to prevent wiping out a large number of buffers from...

11 March 2016 18 min read

Robert Sheldon

SQL Server Metadata Functions: The Basics

To be able to make full use of the system catalog to find out more about a database, you need...

09 March 2016 21 min read

Uwe Ricken

When AUTO_UPDATE_STATISTICS Doesn’t Happen

When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the...

07 March 2016 10 min read

Laerte Junior

The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters

Sometimes, it is the small improvements in a language that can make a real difference. PowerShell is able to introduce...

07 March 2016 7 min read

David Njoku

XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database

In this series of articles I’m hoping to provide a primer for newish Oracle developers who are curious about XQuery...

02 March 2016 7 min read

Dennes Torres

Creating a Date Dimension in an Analysis Services (SSAS) Cube

A walk-through can be a great help to understanding SQL Server Analysis Services, especially when it solves the problem of...

24 February 2016 33 min read

Kartik Balachandran

Siebel CRM Setup on AWS EC2: Upgrade Guide (Legacy)

Legacy guide to setting up Siebel CRM on an Amazon EC2 instance for upgrade testing. Covers Windows Server 2008 R2...

22 February 2016 22 min read

Kartik Balachandran

Siebel CRM Part 1: Should I Upgrade or Re-implement?

As of the most recent Forrester Wave Report for Customer Relationship Management applications, Oracle’s Siebel CRM is still quite a...

18 February 2016 7 min read

Jonathan Lewis

Massive Deletes – Part 2

In Part 1 of this short series I provided an informal description of a couple of scenarios where we might...

17 February 2016 15 min read

Other

Phil Factor in Other

The Luhn Algorithm in SQL

The Luhn test is used by most credit card companies to check the basic validity of a credit card number....

16 February 2016 7 min read

Anju Garg

ASM Proxy: New Instance Type in Oracle 12c

Prior to Oracle Database 12c, an ASM instance ran on every node in the cluster and ASM Cluster File System...

15 February 2016 11 min read

Sander Stad

Documenting SQL Server with PowerShell

SQL Server instances are generally poorly-documented. How easily can you tell if something has changed? How easily can you check...

11 February 2016 20 min read