The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should know appeared first on Joyful Craftsmen.
2025-01-20 (first published: 2024-11-04)
703 reads
Blog Posts
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...
2025-01-19
249 reads
SQL Server 2025
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release /revolution from Microsoft SQL Server prospect, including – AI Buildin’, as AI plays an important...
2025-01-19
127 reads
Advice I Like: Apologies
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse – from Excellent Advice for Living This is great advice. I remember myself often saying “I’m...
2025-01-17
16 reads
Build a Serverless Todo App With AWS, Pulumi, and Python
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible through a RESTful API.Developers charged with building modern, scalable applications often face the burden of having...
2025-01-17
36 reads
Friday Flyway Tips: Chaining Commands for State-based Deployments
One of the cool things I’ve seen with the new Flyway CLI is that I can combine multiple actions together in one call, which can make the process of...
2025-01-17 (first published: 2025-01-10)
419 reads
Have a Plan for Your Personal Downtime
Most of us know that spending a lot of time on social media and surfing the web isn't good for us, but we still do it. Why? Because it...
2025-01-17 (first published: 2025-01-07)
497 reads
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro....
2025-01-16
33 reads
2025-01-16
5 reads
How to Convert FileTime to DateTime
One of my customers recently wanted to rename each of the SQL audit files will the datetime stamp of when it was created. I explained to them the filename...
2025-01-15 (first published: 2024-11-05)
598 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers