Troubleshoot SQL Server Error for backups–: Msg 3136, Level 16
Is it possible to use COPY_ONLY backup for restoring differential backups? No, if you try to do so, SQL Server raises error Msg 3136, Level
2022-01-17
68 reads
Is it possible to use COPY_ONLY backup for restoring differential backups? No, if you try to do so, SQL Server raises error Msg 3136, Level
2022-01-17
68 reads
One of my previous blogs looked at using the free resources that Microsoft provides to link to an Azure Data Explorer Cluster and start using Kusto Query Language. In...
2022-01-14
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...
2022-01-14
15 reads
I saw an episode of Data Exposed with my good friend, Hamish Watson. He talked about KQL (Kusto Query Language) being the next query language you need to learn....
2022-01-14 (first published: 2022-01-03)
986 reads
I set goals at the beginning of last year, and I’m doing the something similar this year. Last year I didn’t do well in my goals. I definitely had...
2022-01-14
21 reads
Today’s post will not be your regular tech or leadership blog from me today. The Hubbard family suffered a tragic loss on January 12th, 2022. They lost their home,...
2022-01-14
19 reads
Having a Database Owner is not something that most people think about until something breaks. Usually, people will just kind of ignore it because it is just so innocuous...
2022-01-14 (first published: 2021-12-31)
362 reads
OK so maybe not replacing, this is more like emulating VS Code in Vim. Disclaimer – I like VS Code and I won’t be uninstalling it anytime soon and...
2022-01-14
112 reads
I’ve worked with Log Analytics quite a bit over the years and that’s taken me down the road of the Kusto Query Language – or KQL So, using Azure...
2022-01-13
33 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...
2022-01-13
16 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