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)
484 reads
Blog Posts
Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 4 - Using Github)
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)
56 reads
BUILTINAdministrators in SQL Server on Linux
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)
263 reads
Friday Flyway Tips–Deploying Migrations with a Target
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)
144 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)
231 reads
What I Love About My Job
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)
211 reads
A New Word: the whipgraft delusion
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
38 reads
Executing One Line in VSCode–#SQLNewBlogger
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)
343 reads
Friday Flyway Tips–Above Target Migrations
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
17 reads
How to Test Trace Flag 3625
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)
525 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers