SQL Homework – December 2021 – Changing collation
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading
2021-12-02
9 reads
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading
2021-12-02
9 reads
I was doing some conversion of Oracle code (PL/SQL) to SQL Server code (T-SQL) – which had some quirks. I just thought that I’d share a quick tip that...
2021-12-02
18 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-12-01 (first published: 2021-10-12)
401 reads
One of the biggest announcements at Microsoft Ignite that seemed to be overlooked by a lot of people was Azure Synapse Analytics database templates, now in public preview. I...
2021-12-01 (first published: 2021-11-22)
242 reads
The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those of us who need...
2021-12-01
138 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-01
20 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-30
20 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-29
18 reads
If you’re like me, your palms went into a cold sweat to get your grubby fingers on the bits for SQL Server 2022 a few nanoseconds after you heard...
2021-11-29
66 reads
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-29 (first published: 2021-11-01)
858 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...
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
WhatsApp:0821-8154-398 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
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