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
Blogs Phil Factor in Blogs 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
Joe Celko SQL GROUP BY Basics It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives... 08 February 2016 15 min read
Robert Sheldon Five Online Database Modelling Services To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have... 08 February 2016 13 min read
Jonathan Lewis Massive Deletes – Part1 In a recent article about dropping columns from a table I left hanging the question of what you might do... 29 January 2016 12 min read
Robert Sheldon SQL Server System Views: The Basics When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the... 27 January 2016 19 min read
Sergei Dumnov Using R Machine Learning Script as a Power BI Desktop Data Source You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom... 27 January 2016 11 min read
Houri 12c Hybrid histogram In the previous article about the Oracle 12c TOP-Frequency histogram, we saw that Oracle carries out a preliminary determination step... 26 January 2016 20 min read
