A Fine Slice Of SQL Server
Richard Vale digs into a dataset:
In this post, I would like to draw attention to a very interesting data set collected by Guan, Palma and Wu as part of the replication package for their paper The rise and fall of paper money in Yuan China, 1260-1368. The paper describes inflation, money and prices during the Yuan Dynasty era in China.
First, a little historical background.
Read on for the analysis. H/T R-Bloggers.
Leave a CommentI was editing an article the other day that uses the
BIT_COUNTfunction that was added to SQL Server 2022. The solution presented is excellent, and I will try to come back and link to it here when I remember. (It will be linked the other way.Reading that did two things for me. First it cave me an idea of how the
BIT_COUNTfunction might be actually be used in a useful way. The solution that was presented would only work in SQL Server 2022 (It will work in earlier compatibility levels, based on the tests I have done.)
Read on for what Louis tried out.
Leave a CommentIn a number of previous blogs and in my session on loadtesting Microsoft Fabric, I’ve always questioned the metrics app and one specific point is the timepoint detail. When you click on a graph, you get the option to go to the timepoint detail and read more.
This is all fun and games but looking at the list of active processes at that specific point in time, you’ll quickly see processes that are way out of the selected point in time. For me, it rendered this thing useless because it messed up the things I wanted to see.
Read on to see the right way to handle this app.
Leave a CommentRadim Marek shows off how the PostgreSQL database engine can inline a view:
Database VIEWs are powerful tools that often don’t get the attention they deserve when building database-driven applications. They make our database work easier in several ways:
- They let us reuse common query patterns instead of writing them over and over
- They give us a place to define business rules once and use them everywhere
- They help us write cleaner, more organized queries
Let’s see how this works with a practical example.
I’m not sure how well PostgreSQL manages nested views, as the biggest problem in SQL Server with inlining views comes when you have overly complicated views made up of views joined to views made up of views joined to–well, you get the idea. That said, Radim does point out a variety of scenarios in which inlining doesn’t happen in PostgreSQL.
Leave a CommentSebastiao Pereira performs an analysis:
Regression analysis is a statistical technique to identify relationships between a dependent variable (outcome) and one or more independent variables (features). Is it possible to do this in SQL Server without using any external tools?
Read on for the answer. I’d file this under “neat but probably not something I’d want to rely upon.”
Leave a CommentInteresting news dropped – Microsoft announced that Azure Data Studio is going to be retired in 2026. You can read the official announcement here. In some ways, I have to admit that I was a little surprised to see this.
I’ve been a very regular user of Azure Data Studio over the past several years, especially because it was the option for Linux. I believe the most likely reason they’re deprecating the product is because there’s a lot of effort in keeping up with Visual Studio Code’s changes and forking that code base every month for Azure Data Studio.
My concern is that the mssql extension for Visual Studio Code is nowhere near ready for prime time, and I wonder if it will be sufficiently capable by the time Azure Data Studio is gone for good.
1 Comment