How Important Are Real Time Decisions?
There has been a push to build real time analytics and decision support systems. Steve discusses whether this is a good idea for many organizations.
2025-12-05
61 reads
There has been a push to build real time analytics and decision support systems. Steve discusses whether this is a good idea for many organizations.
2025-12-05
61 reads
Over the years I've had no shortage of licensing questions for SQL Server. At times it's felt a little crazy. Look at the licensing guide. Choose EE or SE and the number of cores. Then check if you're using VMs. Oh, and consider the cloud, and which cloud you're running a workload on. It's simple […]
2025-12-03
137 reads
When we design a database or system, we often do so with corner cases in mind. We don't have to do this.
2025-12-01
94 reads
2025-11-28
53 reads
Getting something done is important, but so is the quality level. Steve has a few thoughts today.
2025-11-26
80 reads
This week Steve Jones discusses artificial intelligence and one of the building blocks that will be needed: data.
2025-11-25 (first published: 2016-07-04)
97 reads
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-11-25 (first published: 2019-12-24)
264 reads
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-11-25 (first published: 2015-08-13)
698 reads
We might be smart in one area, but not others. That's worth remembering.
2025-11-25 (first published: 2016-06-16)
134 reads
Today Steve tasks data modeling and wonders how many people still build and maintain models.
2025-11-24
112 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
All week we've had issues with the site being up and down. There's been...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers