Kartik Balachandran Siebel CRM Part 7: Installation of the Siebel Application Software As mentioned in the last article in this series, we have completed all the tasks necessary to create the Siebel... 05 April 2016 6 min read
Jonathan Lewis Massive Deletes – Part 3 In the previous installment of this series we looked at methods for seeing the pattern of the changes that would... 05 April 2016 16 min read
Kartik Balachandran Siebel CRM Part 6: Configuring the Siebel Database The final step before we can start the Siebel Server installation is to configure the database server. In the last... 01 April 2016 8 min read
Robert Sheldon 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
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
Kathi Kellenberger T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless... 16 March 2016 14 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 Part 2: Initial Upgrade and Setup of an Amazon Instance A Siebel CRM upgrade project typically consists of numerous iterations even before the actual development and bug fixes take effect.... 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
