Anju Garg Defragmentation Can Degrade Query Performance As data in tables is updated and / or deleted, pockets of empty space can be created, leading to fragmented... 16 June 2016 15 min read
Joshua Feierman 3 Built-In Technologies for Centralizing SQL Server Administration DBAs can be more effective in managing their workload by centralizing their procedures. There are several features of SQL server... 01 June 2016 13 min read
Laerte Junior The PoSh DBA: Accessing SQL Server from PowerShell The worst part for a DBA of getting started with PowerShell is often just figuring out the best way of... 01 June 2016 17 min read
Hitendra Patel Dynamic Images in SQL Server Reporting Services It is relatively easy to provide a smart BI solution when your customer has all the resources for a new... 01 June 2016 16 min read
Aman Sharma Oracle SCN (System Change Number): How It Works Learn how Oracle's System Change Number (SCN) maintains read consistency and data integrity. Covers SCN structure, where it's stored (control... 23 May 2016 13 min read
Feodor Georgiev Predictive Analysis Basics Statistics holds out the promise of teasing out significant relationships and to determine cause and effect. Now that so much... 18 May 2016 15 min read
Joe Celko Looking at VIEWs, Close Up Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how... 10 May 2016 23 min read
Joshua Feierman The Enterprise DBA Mindset as a Practical Problem-solving Approach In order to keep the demands of the job under control, any DBA needs to automate as many as possible... 10 May 2016 13 min read
Murilo Miranda In-Memory OLTP – Row Structure and Indexes There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the... 04 May 2016 12 min read
Murilo Miranda In-Memory OLTP – Understanding Memory-Optimized Tables How do you get started with In-memory OLTP? Murilo Miranda first advises on the setup of the server and the... 04 May 2016 13 min read
Kartik Balachandran Running Siebel CRM on Non-Standard Versions of Internet Explorer Traditionally Siebel CRM has been heavily dependent on ActiveX controls. Oracle offers lifetime support on any Siebel version post version... 03 May 2016 5 min read
Phil Factor SQL to UML: Auto-Generate Database Diagrams with PlantUML Auto-generate UML database diagrams from SQL Server metadata using PlantUML and GraphViz. T-SQL scripts create class diagrams, ER diagrams, and... 03 May 2016 20 min read
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
