SQL 2022 introduced the function generate_series which permits us to solve problems for which we previously had to use a table of numbers (also known as a "tally table"). generate_series is a great addition, because when using a table of numbers there was always a risk that you could run out of numbers. Or some joker could have deleted rows from the table. All these worries are gone with generate_series.
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.
Steve has a few thoughts on natural keys, which often turn out not to be as unique as we expect.
Do you wonder why SQL Server ignores an index? Do you think about how you can deal with this problem? When you include too many columns in a query you decrease index selectivity. So, if you write a query like “Select * From …” the chance of choosing your nonclustered index will decrease.
There was a post on X I read today about valuing your time. The gist was that since this person had waited 9 minutes to save $4, they valued their time at $27 an hour. I get the point being made. Time is valuable and you need to set the value of your time. It […]
Today Steve asks which data model issues are most annoying to you.
In this article, we look at how to create a SQL backup to network share or restore a backup from a network share.
Steve re-posts a question from someone else, asking why you wouldn't want to use an AI.
This next article in the Data Engineering with Fabric series showcases how tally tables can help load data in a Fabric warehouse.
How can we get familiar with Azure Databricks with Spark Dataframes?
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
Komp, Jl. Taman Ratu Raya Bl. Bl No.5/8, Duri Kepa, Kec. Kb. Jeruk, Kota...
Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blok 02, Kec. Kembangan,...
BCA KCU BINTARO Hubungi Cs.0851•8812•0691 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers