T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
4 reads
Blog Posts
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
4 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
4 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
3 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
6 reads
Unconscious Bias
This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.
Related Posts:
Note to Self June...
2020-08-11
12 reads
What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just to be clear, I should have. ... Continue reading
2020-08-11
30 reads
Why a 60GB Database Backup Grew to 1TB in Size
Recently, I was alerted to a network file share that was running low on disk space. This interesting as there was only one process that used this particular location...
2020-08-11
3,957 reads
Azure SQL Database – Maxdop Updated
About 1.5 years I wrote about MAXDOP setting within Azure SQL DB, more specifically the fact that the default setting being 0. (https://blobeater.blog/2018/09/12/maxdop-and-azure-sql-db/) Now, you should be aware that...
2020-08-10
294 reads
Daily Coping 10 Aug 2020
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...
2020-08-10
22 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
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