Kartik Balachandran Siebel CRM Part 12: Upgrading a Non-Development Database In the last two articles we covered the process of upgrading a development database. The steps involved were as follows:... 26 April 2016 10 min read
Kartik Balachandran Siebel CRM Part 11: Performing the Siebel incremental Repository Merge As mentioned in the last article in this series, the Siebel upgrade process is split into 3 separate parts: Upgrade... 25 April 2016 8 min read
David Njoku XQuery for Absolute Beginners: Part 5 – XQuery Update Facility There’s something slightly oxymoronic about the phrase XQuery Update Facility. Make your mind up, dude – are you querying or... 19 April 2016 7 min read
Kartik Balachandran Siebel CRM Part 10: Upgrading the Siebel Database In the nine previous articles in this series, we have learnt how to set up a Siebel Sandbox instance for... 18 April 2016 9 min read
Database Administration Feodor Georgiev in Database Administration SQL Server Security Audit Basics SQL Server Server Audit has grown in functionality over the years but it can be tricky to maintain and use... 18 April 2016 17 min read
Kartik Balachandran Siebel CRM Part 9: Upgrading the Application Servers for 8.1.1.X Deployments In the first article in the series we talked about having multiple paths for a Siebel upgrade. In a nutshell:... 15 April 2016 6 min read
Anju Garg Automatic Big Table Caching in RAC In an earlier article, I discussed Automatic big table cache (ABTC) which is a new feature introduced in Oracle Database... 13 April 2016 14 min read
Kartik Balachandran Siebel CRM Part 8:- Configuring and Starting the Siebel Sandbox In the last article in this series, we completed the installation of all of the Siebel components for our sandbox.... 13 April 2016 11 min read
Enrico van de Laar The SQL Server 2016 Query Store: Analyzing Query Store Performance There are some obvious advantages to having the Query Store, but what is the performance impact that it is likely... 13 April 2016 8 min read
David Njoku XQuery for Absolute Beginners: Part 4 – Conditions & Custom Functions This is the fourth part of a series introducing Oracle developers to XQuery. In the first three parts we’ve talked... 12 April 2016 8 min read
Artemakis Artemiou Implementing SQL Server In-Memory OLTP How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables?... 11 April 2016 12 min read
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
