A New Word: the standard blues
the standard blues– n. the dispiriting awareness that the twists and turns of your life feel new and profound, but are not unique – marked by the same coming-of-age...
2024-04-26
33 reads
Blog Posts
DevOps Book Recommendations
I’m out today, coaching in Salt Lake City. However, I’ve been thinking about a few books after discussions with various customers and attendees at a few events. I wanted...
2024-04-26 (first published: 2024-04-08)
262 reads
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your passport to understanding databases, making it essential for data analysts, developers, and anyone who wants...
2024-04-25 (first published: 2024-04-23)
275 reads
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop in, wielding the power to extract meaningful answers from the chaos. Mastering SQL for data...
2024-04-25
82 reads
Book Review – Deciphering Data Architectures
I recently purchased and read the book Deciphering Data Architectures – Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh by James Serra. James –...
2024-04-24 (first published: 2024-04-08)
887 reads
Data Search within SQL Server Databases
Search and Export Script for SQL Server Databases
Plainly speaking, this article is about searching for a specific value inside all tables and their columns of a SQL database and...
2024-04-24 (first published: 2024-04-09)
678 reads
Going to Cloud? Look at the Shared Responsibility Model
The bottom line here is this: the idea that a CSP takes care of everything for you is a fallacy that really needs to die. Thompson, Graham. All-in-One CCSK...
2024-04-24
88 reads
Why Test SQL Server Backups
For a lot of us data professional types, this seems like a silly topic, however I constantly hear of companies that aren’t testing their backups by restoring them, or...
2024-04-23
14 reads
Azure SQL DB Failover Groups
In today’s fast-paced digital world, keeping your data safe and accessible is more important than ever. That’s where Azure SQL Database steps in, offering a suite of tools to...
2024-04-22 (first published: 2024-04-05)
406 reads
Flying Halfway Around the World to Australia
I leave tonight for Australia. I was in London 3 days ago, so this will complete my halfway around the world trip when I time travel tomorrow and skip...
2024-04-22
23 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