Removing a PowerShell Array Element–#SQLNewBlogger
I saw an article on this and realized I had no idea how to do this, so I decided to practice a bit. I don’t work with PoSh arrays...
2023-12-05 (first published: 2023-12-04)
181 reads
PostgreSQL Backup Failure
In this blog post I wrote a tip about fixing the PostgreSQL backup failure issue. The error was directing about the permission issue.
The post PostgreSQL Backup Failure appeared first...
2023-12-04
1,373 reads
Dynamic Data Masking – SQL Server
Use Dynamic Data Masking to protect your data
The post Dynamic Data Masking – SQL Server appeared first on Tim Radney.
2023-12-25 (first published: 2023-12-03)
238 reads
Using ThinOptics to Read Data
As I’ve aged, I find myself struggling to read many things in my life. It started with difficulties seeing menus, but moved on to other areas. During the pandemic,...
2023-12-01
59 reads
PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple question: What do you think about PostgreSQL events? Prior to this year, I’d never attended...
2023-12-01
73 reads
Set-Based vs Row-Based Database Code
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...
2023-12-18 (first published: 2023-12-01)
615 reads
A New Word: Nighthawk
nighthawk – n. a recurring thought that only seems to strike you late at night – an overdue task, a nagging guilt, a looming future – which you sometimes...
2023-12-01
87 reads
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in SSMS, but I wanted to learn how to use them in Azure Data Studio (ADS)....
2023-12-20 (first published: 2023-11-30)
337 reads
Testing Microsoft Fabric - Part 3
Sorry to disappoint you. In this post, we won't test Microsoft Fabric directly. We will compare Azure Data Factory (ADF) to Microsoft...
2023-11-30
10 reads
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I am trying to reproduce it in workbooks. While it isn’t an exact match, workbooks provide...
2023-12-13 (first published: 2023-11-29)
335 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers