A Fine Slice Of SQL Server
Kevin Chant invites you to a swank lakhouse:
By the end of this post, you will have a good overview of Microsoft Fabric Data Lakehouses, including CI/CD options. In addition, where your SQL Server background can prove to be useful and where some Power BI knowledge can come in handy.
Plus, I share plenty of links in this post. For instance, there are a couple of useful resources to help you get started towards the bottom of this post.
Click through for the article.
Comments closedThomas Rushton gives Ask SQLServerCentral a Viking funeral:
When I started out as a full-time DBA back in 2010, it was the first Q&A site I found that was active, friendly, and easy to use.
It differs from the main SQLServerCentral Q&A boards by not being broken down into questions relating to a particular version of SQL Server, and a particular aspect of that version. This makes it easier for someone to just ask a question without worrying about if their question is going to the right place. A great benefit to those new to the scene.
Right around the time Thomas started, I was also getting into it and was active for a couple of years until a job change made it tougher for me to dedicate the time. I appreciate everything the crew did for so long, especially because it was a really good alternative to a dedicated Stack Exchange site for databases (which I think had officially started after Ask SQLServerCentral).
Comments closedMatt Allington relates a couple of slicers:
Have you ever had a situation where you have a slicer selection that “sticks”? You make a selection in a slicer, then make some changes somewhere else, but the first selection you made “sticks” when it is no longer valid? Take a look at this animated demo below to see what I mean.
Click through for the demo, as well as the solution to this problem.
Comments closedThis is a quick blog to “document” a T-SQL technique for generating random numbers. I’ve been using this for years, but don’t use it frequently enough to have it fully memorized. So whenever I do need it, I must constantly have to go look up whenever I need to use it.
Click through for Andy’s method. This will generate random numbers based on a uniform distribution: the likelihood of getting any value in the range is equal. If you want to build out some data that approximates a normal distribution, I have a blog post for that.
Comments closedChad Callihan pivots to a new idea:
How can you PIVOT or UNPIVOT data in SQL Server? What do these terms mean in SQL Server?
Let’s take a look a few examples using PIVOT and UNPIVOT.
Admission time: I can never remember the syntax for PIVOT or UNPIVOT. I always need to look it up.
Erik Darling takes a tour of the land mine garden:
When you think about formatting code, you probably think primarily of organizing a single query so that it’s inoffensive to civilized society.
But you should also apply this to your code as a whole, too. People who use words wrong will call this “holistic”.
I won’t get too deep into level of agreement here (probably about 60-70% of Erik’s list I can agree on), but I do argue that the best standards are the ones your team agrees on. It’s frustrating seeing hairball messes of T-SQL. Especially when developers’ non-SQL code looks a lot neater.
Comments closedSteven Sanderson performs a different form of regression:
Spline regression is particularly useful when the relationship between the independent and dependent variables is not adequately captured by a linear model. It involves fitting a piecewise continuous curve (spline) to the data. Let’s dive into the process using R.
Click through and you’ll be reticulating splines just like it’s Sim City 2000.
Comments closedKiana Harris lays out some challenges:
As organizations embrace containerization and Kubernetes for their applications, the need for seamless portability across the Kubernetes ecosystem coupled with cloud object storage and local persistence has become a pressing concern. In this blog post, we will dive into the core problem and dissect the complex challenges that customers face in achieving containerized app portability.
Read on for the list of challenges, followed by what you can do to address them. This is at a really high level but can provide food for thought.
Comments closedBang Nguyen wants to see what’s going on:
Observability of a system includes Logging, Tracing and Metric. Today, we will go to detail how to implement observability’s elements on a K8S environment use Promtail, Open Telemetry Collector, Loki, Tempo and Grafana bellow is the demonstration of system we will implement
Click through for a detailed guide showing how to do this.
Comments closedSandeep Pawar doesn’t have time to refresh everything:
The latest version of Semantic Link (0.4.0) has many methods that provide a convenient abstraction for calling Fabric/Power BI REST APIs. You can see them here. In this blog, I will show how to use the
.refresh_dataset()which uses the Enhanced Refresh API to refresh Power BI semantic models, tables and partitions.
Read on for two ways to do it.
Comments closed