Anju Garg Oracle Data Pump in RAC Oracle Data Pump was introduced in Oracle Database 10g to enable very high-speed transfer of data and metadata between databases.... 10 December 2015 15 min read
Joe Celko Declarative SQL: Using UNIQUE Constraints In SQL, you can express the logic of what you want to accomplish without spelling out the details of how... 04 December 2015 14 min read
Laerte Junior The PoSh DBA – Using the Basic PowerShell Paradigms PowerShell is like any computer language: you must understand the paradigms, the constructs, and the way it is designed to... 04 December 2015 10 min read
David Njoku SQLcl: The new challenger for the SQL Plus crown I’m that grumpy old guy who comes to your party and sits in a corner with a face like a... 30 November 2015 9 min read
Gert Poel About functions, records and result cache This article is about functions and how to get more out of them if you combine them with record structures.... 20 November 2015 6 min read
Omid Afzalalghom Doing a SQL Server Healthcheck via PowerShell PowerShell is an ideal tool for doing health checks of a collection of SQL Server instances, and there are several... 16 November 2015 13 min read
Enrico van de Laar The SQL Server 2016 Query Store: Overview and Architecture SQL Server's Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information... 16 November 2015 14 min read
Edward Elliott SQL Server Data Tools (SSDT) and Database References SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database,... 16 November 2015 12 min read
David Njoku Multi-Table Insert Statements in Oracle We all know this: if a long-bearded prophet came down from a mountaintop bearing the ten commandments of Oracle programming,... 09 November 2015 7 min read
Jonathan Lewis Basics of the Cost Based Optimizer – part 6 In part 5 of this series I started working through a list of queries designed to demonstrate ways in which... 04 November 2015 14 min read
Grant Fritchey Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts There may be some people who enjoy repetitive typing, but Grant Fritchey doesn't. He's always preferred SQL Prompt. The standard... 04 November 2015 8 min read
Phil Factor Routine SQL DML Testing for the Unenthusiastic Tester There are more exciting things in life than unit testing SQL Statements, checking the results, timings, and execution plans. Phil... 03 November 2015 16 min read
William Brewer Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the... 03 November 2015 17 min read
Neeraj Tripathi SQL Server Heaps, and Their Fragmentation In SQL Server, heaps are rightly treated with suspicion. Although there are rare cases where they perform well, they are... 02 November 2015 11 min read
Jonathan Lewis Basics of the Cost Based Optimizer – Part 5 It’s been three months since I last published anything in this series on the Cost Based Optimizer, so a thumbnail... 30 October 2015 17 min read
Laerte Junior Automating Your SQL Server Best Practice Reports: The Document If you're making a report from table-based data, an MS Word document is often a good option. In the second... 21 October 2015 10 min read
Grant Fritchey Top 10 Most Common Database Scripts What are the scripts that a working DBA uses so often that they become part of the 'muscle memory'? Grant... 15 October 2015 14 min read
Laerte Junior Automating Your SQL Server Best Practice Reports:The Checks A DBA in charge of a whole lot of databases and servers has to check regularly that there are no... 06 October 2015 13 min read
David Njoku Introduction to User-Defined Aggregate Functions OK, let’s speed past the easy bits, the parts we all already know: standard aggregate functions. Aggregate functions, unlike regular... 30 September 2015 7 min read
Anju Garg Oracle 12c Cluster: ACFS Leverages Flex ASM In Oracle Database Releases earlier than 12c, an Automatic Storage Management (ASM) instance runs on every node in the cluster,... 30 September 2015 10 min read
