Policy-Managed Oracle RAC One Node Databases

Oracle RAC One Node, introduced in Oracle Database 11g Release 2 (11.2.0.2), is a single instance of an Oracle RAC-enabled...

09 February 2017 13 min read

.NET

Sophia Segal in .NET

User Acceptance Testing and the Application Lifecycle

User Acceptance Testing (UAT) is an important part of the development process. If carried out as early as possible and...

03 February 2017 24 min read

Oracle

Aman Sharma in Oracle

Understanding Oracle SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking

Learn all about Oracle SQL bind variables: the potential issues surrounding bind variables and how to handle them.…

03 February 2017 8 min read

David Njoku

Oracle for Absolute Beginners: Date, Timestamp and Interval

All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy...

02 February 2017 12 min read

David Njoku

Oracle for Absolute Beginners: Other SQL Functions

Here’s a simple trick you can play on your friends. Ask them to pick a number from 1 to 10,...

30 January 2017 8 min read

Database Administration

Alex Grinberg in Database Administration

Migrating to SQL Server Memory-Optimized Tables: Indexes, Computed Columns, and Triggers

Migrate existing SQL Server disk-based tables to memory-optimized (In-Memory OLTP) tables - covering limitations to plan for, new indexing strategy...

26 January 2017 21 min read

Blogs

Phil Factor in Blogs

Kadane’s solution to the Maximum Subarray problem

Sometimes, you can be asked an awkward question about data that doesn't quite fit with the SQL way of thinking....

25 January 2017 8 min read

Anju Garg

Duplicate Point-In-Time Recovered PDB Using Backup

At times, we might need to duplicate a production pluggable database to a Past Point in Time without disturbing the production...

25 January 2017 9 min read

Jonathan Lewis

Snapshots

While looking at the results from a query against the dynamic performance view v$active_session_history during a recent trouble-shooting assignment I...

24 January 2017 11 min read

Jonathan Lewis

Index Costing Threat

In the previous post I described a problem with the strategy that the optimizer uses for costing an index fast...

24 January 2017 9 min read

T-SQL Programming

Joe Celko in T-SQL Programming

Handling Graphs in SQL

Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are...

20 January 2017 17 min read

Oracle

Aman Sharma in Oracle

Understanding Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing

In this third article, we will look at the issue of duplicate SQL statements and how Bind Variables can help...

20 January 2017 9 min read

Jonathan Lewis

Problems with Indexes

In my book “Cost Based Oracle – Fundamentals” (Apress 2005) I described a problem with the cost calculation for the...

20 January 2017 7 min read

T-SQL Programming

Robert Sheldon in T-SQL Programming

Core Database Source Control Concepts

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and...

13 January 2017 30 min read

T-SQL Programming

Robert Sheldon in T-SQL Programming

Encrypting SQL Server: Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the...

12 January 2017 16 min read

BI

Nat Sundar in BI

Deployment Automation for SQL Server Integration Services (SSIS)

SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages...

12 January 2017 16 min read

Houri

Oracle Data Type Implicit Conversion Hierarchy

In Oracle, under certain circumstances, an implicit data type conversion precludes the use of indexes. Perhaps you have a vague...

09 January 2017 10 min read

Jonathan Lewis

Investigating Indexes – 2

In an earlier article on investigating indexes I described some methods for looking at the internal structure of an index...

09 January 2017 16 min read

Database Administration

Joshua Feierman in Database Administration

Exploring Azure Storage for SQL Server DBAs

If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a...

04 January 2017 14 min read

Database Administration

Enrico van de Laar in Database Administration

Query Store with In-Memory OLTP: What Gets Captured for Memory-Optimized Tables and Natively Compiled Procedures

How SQL Server Query Store interacts with In-Memory OLTP features - the statistics available for regular queries against memory-optimized tables...

04 January 2017 12 min read