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
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
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
2021-02-04
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
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
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
Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works.
2021-02-02
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
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
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
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
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item Migration Assistant Issues
Comments posted to this topic are about the item Converting Old Running Total Code...
Comments posted to this topic are about the item Effective Engineering
If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)
See possible answers