Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]
2021-04-19
7,751 reads
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Comments posted to this topic are about the item Resolving Access Denied Errors During...
Comments posted to this topic are about the item The Lesser Used Functions
Comments posted to this topic are about the item SQL in an Azure VM...
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers