After many years of seeing a large number of IT projects fail, a group of experienced and recognized software development "gurus” met “in the need for an alternative to a documentation driven, heavywe...
I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS. It is not simply “SSIS in the cloud”. See What is Azure Data Factory? for an overview of ADF, and I’ll...
Hi, This article will include a couple of great tips…one using a hint I work with in my SQL Tuning class and the other solving a performance issue with partitioning using PL/SQL Dynamic Execute Immedi...
Watch as Toad Expert, Robert Pound, demonstrates how to configure your connections within Toad for SQL Server....
For this blog post I want to discuss the meaning behind SQL Server: Memory ManagerTarget Server Memory (KB) and SQL Server: Memory Manager Total memory (KB) Perfmon counters. I will mention how under...
This article explains the step-by-step approach for creating a database service using Oracle Cloud DBaaS, during which we will create the needed Storage Containers that can be used by the Database Clo...
As we launch our Postgres community, we're fortunate for the support of our partner, EnterpriseDB, and a special association with Postgres thought leaders Marc Linster and Bruce Momjian . Marc Linst...
Postgres extensions are a powerful way to add functionality to Postgres and dozens of extensions are available. However, it can be difficult to manage them. By default, extensions are loaded into the ...
Postgres introduced JSON and JSONB in versions 9.3 and 9.4, respectively, with JSONB (Binary Javascript Object Notation) being the canonical form of JSON, stored as binary objects with improved compre...
This might not be an issue which would be faced by SQL DBAs regularly because databases are generally already created. There might be few DBAs out there who take care of deployment as well. So, if you...
Ergh, not a fun weekend rugby wise. But anyway… Last week Microsoft released an image for SQL Server 2016 SP1 Developer Edition in containers. Previously the only edition available was vNext Enterpri...
We performed an EBS R12.2 RAC to RAC clone and after successful completion of cloning we were not able to connect database using sqlplus command and it was giving the below error: [oracle@racnode1 12...
