Using DATETRUNC–#SQLNewBlogger
I saw someone using DATETRUNC recently in some code and realized I hadn’t really looked at this function before. It’s one that was added in SQL Server 2022, though...
2023-12-29 (first published: 2023-12-18)
467 reads
I saw someone using DATETRUNC recently in some code and realized I hadn’t really looked at this function before. It’s one that was added in SQL Server 2022, though...
2023-12-29 (first published: 2023-12-18)
467 reads
In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.In Part 3, we deployed our fist solution (Azure...
2023-12-28 (first published: 2023-12-27)
31 reads
When I first started working with SQL on Linux one of the first things I did was to remove the default the [BUILTINAdministrators] login. This is pretty much standard...
2023-12-27 (first published: 2023-12-15)
248 reads
Recently I was working with Flyway Desktop (FWD) and helping a customer work on deploying part of their work. They weren’t sure how easy this could be, but this...
2023-12-27 (first published: 2023-12-15)
127 reads
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)
216 reads
In June this year I took redundancy from the company I’d worked at for the previous 11 years. It was of course an uncertain time while I figured out...
2023-12-25 (first published: 2023-12-07)
204 reads
whipgraft delusion – n. the phenomenon in which you catch your reflection in the mirror and get the sense that you’re peering into the eyes of a strange, as...
2023-12-22
22 reads
I wrote about arrays in PowerShell last week, but I realized one of the things I did while experimenting was look up how to run code a line at...
2023-12-22 (first published: 2023-12-11)
330 reads
Recently I was working with Flyway Desktop (FWD) and practicing deploying certain migrations and not others. I don’t recommend this, but a customer was doing this and I wanted...
2023-12-22
11 reads
Recently, one of my customers considered enabling Trace Flag 3625 on one of their SQL Servers, but they wanted a way to quickly test its functionality beforehand. For those...
2023-12-22 (first published: 2023-12-12)
515 reads
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Why Data Modelling Still Matters...
Hi when i think of server hops , i think of how kerberos assists...
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers