Oracle archived redo size – the research
Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.
2021-02-04
Additional Articles
SQL Server SET STATISTICS IO ON Deep Dive
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
2021-02-04
CRUD Operations in SQL Server using Python
This article goes through a process to show how you can use Python to perform create, read, update, and delete (CRUD) operations on SQL Server data.
2021-02-03
Managing database changes using Flyway: an Overview
This article describes the principles of using Flyway migrations to build a database from scripts, to a specified version, and to track, manage and apply all database changes.
2021-02-03
Create Azure VM from a VHD image
Learn how to create an Azure VM image that can be used to quickly deploy new Azure VMs that are preconfigured based on your image settings.
2021-02-02
Database version control: Getting started with Flyway
Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works.
2021-02-02
Simple way to find errors in SQL Server error log
In this tip we look at how to parse the SQL Server error log to only extract the errors and corresponding error messages.
2021-02-01
SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL
In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.
2021-01-29
Finding Inactive SQL Server Databases
Phil Factor demonstrates how to use Extended Events to detect acquisition of Intent locks, and so determine which databases are active or apparently 'dormant', and then on which tables data has been modified recently, or which views and stored procedures have been run.
2021-01-28
Power BI Theme Generator New Methods and Customizations
New methods and usage for themes were recently introduced for Power BI and in this article we cover how you can use these and customize them for Power BI.
2021-01-28
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Raden Saleh,Telp/Wa 0821.3111.159
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
BCA KCP Mandala Raya HUB/WA 08216977701
Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Hasyim Ashari Tlp (+62 821°3111°179
Jl. KH. Hasyim Ashari No.5 AA, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers