Artemakis Artemiou Introducing SQL Server In-Memory OLTP In-Memory OLTP, aka Hekaton, originally shipped with 2014, and although it certainly helped the performance of certain types of workload,... 30 September 2015 10 min read
Joshua Feierman Checklists: A DBA’s Best Friend Because so much of the work of the DBA involved doing things in the right order without missing steps out,... 30 September 2015 11 min read
Adam Aspin SQLXML Bulk Loader: The Sequel SQLXML isn't exactly new technology, and parts of it aren't pretty, but if you need to heave vast quantities of... 25 September 2015 24 min read
Phil Factor Dependencies and References in SQL Server It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you... 24 September 2015 20 min read
Robert Sheldon Power Query Formula Language in Power BI Desktop The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to... 21 September 2015 19 min read
David Njoku Introduction to Analytic Functions (Part 2) In the first part of this series I introduced you to the analytic functions family, outlined its close relationship to... 17 September 2015 7 min read
Uwe Ricken How Forwarded Records are Read and Processed in a SQL Server Heap Before you deliberately use a heap in SQL Server rather than a table, it is worth understanding why a heap... 09 September 2015 16 min read
Gail Shaw How to Confuse the SQL Server Query Optimizer Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the... 09 September 2015 35 min read
David Njoku Introduction to Analytic Functions (Part 1) Analytic functions have been part of Oracle for a very long time now – ever since 8i back in 1999.... 07 September 2015 10 min read
Dwain Camps How to Avoid Conditional JOINs in T-SQL Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within... 07 September 2015 14 min read
Kathi Kellenberger T-SQL Window Functions Speed Phreakery Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to... 27 August 2015 12 min read
Robert Sheldon Working with SQL Server data in Power BI Desktop What's the best way of providing self-service business intelligence (BI) to data that is held in on-premise SQL Server? Not,... 24 August 2015 24 min read
Tony Davis Basic SQL Server Performance Troubleshooting For Developers The speed of a slow SQL Query can almost always be improved. In SQL Server, the query optimizer determines the... 14 August 2015 39 min read
Anju Garg TSPITR Using ACFS Snapshots Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database... 10 August 2015 16 min read
Robert Sheldon The Evolution of SQL Server BI It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Over the years, we've been presented with... 27 July 2015 14 min read
Anju Garg Integrating ACFS Snapshots With RMAN In my last article, I demonstrated that starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster... 14 July 2015 10 min read
Jonathan Lewis Basics of the Cost Based Optimizer – Part 4 In the first three installments of this series I outlined the mechanisms used by Oracle to analyze a very simple... 09 July 2015 14 min read
Satishbabu Gunukula Why Virtual Private Catalog? Recovery Manager (RMAN) is the preferred tool to backup and recover the Oracle Database. You can use recovery catalog or... 08 July 2015 8 min read
David Njoku Anatomy Of A SELECT Statement – Part 3: Recursive Subquery Factoring We need a baritone voiceover man. You know how those huge TV shows – 24, Prison Break, Jane the Virgin... 07 July 2015 7 min read
Ravi Kumar Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c Introduction For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and... 03 July 2015 12 min read
