Gitflow Workflow Hotfix Branching for SQL Database Projects
Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.
2021-02-05
Additional Articles
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
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
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers