Temporal Tables, and how to deal with computed columns
Long time readers will know I’m a big fan of Temporal Tables since their introduction in SQL Server 2016. Thanks to my friend Erik Darling (blog | Twitter), I...
2019-12-25
324 reads
Long time readers will know I’m a big fan of Temporal Tables since their introduction in SQL Server 2016. Thanks to my friend Erik Darling (blog | Twitter), I...
2019-12-25
324 reads
I was experimenting with visualizations the other day, and started playing with SandDance, a tool from Microsoft that you can use in Power BI or Azure Data Studio. I’ll...
2019-12-24 (first published: 2019-12-02)
292 reads
2019-12-24
21 reads
It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the past year. So what do I have to be...
2019-12-24 (first published: 2019-12-10)
249 reads
My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants us to talk about Gifts received ... Continue reading
2019-12-23 (first published: 2019-12-10)
290 reads
MERRY CHRISTMAS! HAPPY YULETIDE! HAPPY HANUKKUH! Instead of something technical, let’s take a moment to just kick back and enjoy a few great Christmas movies. Now, let’s be clear....
2019-12-23
19 reads
At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve gotten during the year. I’ve been gifted with a lot of things this year personally...
2019-12-23 (first published: 2019-12-10)
246 reads
Hello. It’s been a while since the last post of this series appeared. I will do my best to keep this going. So, without unnecessary introductions – let’s move...
2019-12-22
6 reads
Hello. It’s been a while since the last post of this series appeared. I will do my best to keep this going. So, without unnecessary introductions – let’s move...
2019-12-22
13 reads
The JOIN() function in SQL Server Reporting Services is a handy tool that allows you to turn a list into a delimited string value. This function accepts two parameters,...
2019-12-22
9 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
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