Syed Jaffar Hussain Oracle Database 12c New Features – Part 4 Parts 1,2 & 3 focusssed more on the most useful improvements and enhancements of Database administration: Performance Tuning, RMAN, Data... 25 July 2013 6 min read
Dwain Camps Gaps and Islands in SQL Server data The fun of exploring problems such as Gaps and Islands is all the greater when we have a test-harness to... 25 July 2013 16 min read
Kirill Loifman Enable Oracle database to send emails via SMTP server Often in a complex enterprise Infrastructure Oracle DBAs face issues by enabling SMTP mail traffic on the databases through corporate... 22 July 2013 1 min read
Robert Sheldon Using Microsoft Excel to Retrieve SSAS Tabular Data Although it is well-known how to create a tabular database in PowerPivot, it is less obvious that there are several... 16 July 2013 19 min read
Syed Jaffar Hussain Oracle Database 12c New Features – Part 3 During this Oracle Database 12c new features article series; I shall be extensively exploring some of the miscellaneous, yet very... 11 July 2013 8 min read
Phil Factor SQL Server ALTER TABLE syntax diagrams The words in the documentation for the ALTER TABLE syntax on MSDN are accurate with forensic precision, but the potentially-useful... 09 July 2013 8 min read
Bobby Curtis Upgrade to Oracle Database 12c – Single Instance With every release of the Oracle database there is always an upgrade path that should be followed. For many, they rush... 08 July 2013 7 min read
Syed Jaffar Hussain Oracle Database 12c New Features – Part 2 During this Oracle Database 12c new features series, I shall be extensively exploring some of the miscellaneous, yet very useful,... 03 July 2013 10 min read
Louis Davidson Baselining with SQL Server Dynamic Management Views When you're monitoring SQL Server, it is better to capture a baseline for those aspects that you're checking, such as... 02 July 2013 18 min read
Feodor Georgiev Collecting the Information in the Default Trace The default trace is still the best way of getting important information to provide a security audit of SQL Server,... 02 July 2013 14 min read
Syed Jaffar Hussain Oracle Database 12c New Features – Part I During this Oracle Database 12c new features article series, I shall be extensively exploring some of the very important new... 27 June 2013 10 min read
Rob Garrison Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1 The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you... 25 June 2013 12 min read
Robert Sheldon Using DAX to retrieve tabular data Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window... 24 June 2013 17 min read
Gert Poel Using Subtypes for Booleans I try to use subtypes as much as I can and after reading the “All Things Oracle” article of Patrick... 21 June 2013 5 min read
Jonathan Allen Preparing to Upgrade your SQL Server It isn't a problem to use deprecated TSQL features until it comes to the time to move the database to... 12 June 2013 17 min read
Hugo Kornelis Painless management of a logging table in SQL Server Tables that log a record of what happens in an application can get very large, easpecially if they're growing by... 11 June 2013 26 min read
Alexander Karmanov Automating SQL Server Database Deployments: Scripting Details To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted... 06 June 2013 30 min read
Phil Factor SQL Server CREATE TABLE syntax diagrams Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough... 06 June 2013 8 min read
Patrick Barel Views Success always occurs in private and failure in full public view. – Unknown When working with views you have several... 05 June 2013 5 min read
Satishbabu Gunukula Oracle Database Replay for your Workload Test Database replay was introduced in Oracle 11g R1, and it allows you to capture workloads on a Production system and... 30 May 2013 8 min read
