2025-12-31
112 reads
Editorials
2025-12-29
110 reads
Happy Holidays, Let's Do Nerdy Stuff
I'm actually writing this on my day off. I took a bunch of vacation around the holidays because I could, and because I don't take enough the rest of the year. Anyway, I'm just going to share how I've been spending my time (not counting time with the family, which I am certainly doing). I […]
2025-12-27
120 reads
The Tally Table
The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?
2025-12-26 (first published: 2015-08-13)
826 reads
The DBA's Twelve Days of Christmas
On the first day of Christmas my new DBA sent to me A table with a primary key On the second day of Christmas my new DBA sent to me Two Foreign Keys, and A table with a primary key On the third day of Christmas my new DBA sent to me Three stored procs […]
2025-12-24 (first published: 2019-12-24)
410 reads
What's Your Area of Expertise?
We might be smart in one area, but not others. That's worth remembering.
2025-12-22 (first published: 2016-06-16)
209 reads
The Microsoft SQL Year in Review
Microsoft gives a year in review from the SQL Server and Azure SQL teams. Steve sees a lot of accomplishments from this past year.
2025-12-20
190 reads
Your Value from a Conference
Today Steve asks what value you get from attending conferences or other events.
2025-12-19
106 reads
The Challenge of AI
Steve sees a lot of challenges ahead for AI, especially in the area of labor and employment.
2025-12-17
104 reads
Growing Artificial Intelligence
This week Steve Jones discusses artificial intelligence and one of the building blocks that will be needed: data.
2025-12-15 (first published: 2016-07-04)
216 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers