T-SQL Tuesday #155 –The Dynamic Code Invitation
Apologies for the late invitation. A minor snafu has me hosting again. This is the monthly blog party where someone hosts and you all write a response. I’d like...
2022-10-06
82 reads
Apologies for the late invitation. A minor snafu has me hosting again. This is the monthly blog party where someone hosts and you all write a response. I’d like...
2022-10-06
82 reads
Azure Managed Instances are provisioned by default with a yourname.uniqueid.databases.windows.net DNS fully qualified domain name (FQDN). Even on your private virtual network you will still have to use this...
2022-10-05 (first published: 2022-09-20)
312 reads
Today’s coping tip is to choose to see your mistakes as steps to help you learn. I preach this with the kids I coach. Mistakes will happen, but let’s...
2022-10-05
20 reads
I was reminded this week that I needed to get registered for the Data Community Summit 2022 since I’m speaking. I also needed a hotel, so I took some...
2022-10-05
38 reads
I previously wrote a post on how to convert a SQL Server Docker image to a Windows Subsystem for Linux distribution. I did this because if you tried to...
2022-10-05 (first published: 2022-09-27)
5,296 reads
Today’s coping tip is to free up time by canceling any unnecessary plans. I. Suck. At. This. I don’t like to blow things off, and I do like to...
2022-10-04
12 reads
In August we started taking a look at replication. We learned some of the terms used, and set up a ... Continue reading
2022-10-04
28 reads
If you are like me and still prefer the physical book as your primary reading material, Benjamin Nevarez's book from Packt Publishing is a great book to add to...
2022-10-03 (first published: 2022-09-19)
419 reads
Today’s coping tip is to write down three things you appreciate about yourself. I don’t mind self-evaluation, but I struggle a bit to publicly talk about things I do...
2022-10-03
9 reads
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that I decided to answer. I went off, set up a test database and some test...
2022-10-03
25 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
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...
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