Consolidating Cloud Backups
I am a big fan of the cloud. While I appreciate local storage and privacy/control/security, etc., that stuff can also go away locally. Plus, I like the convenience, and...
2024-01-24
43 reads
Blog Posts
Switching between different active physical relationships in a Power BI model
A couple of weeks ago, I encountered a DAX question that I had not previously considered. They had a situation where there were two paths between two tables: on...
2024-01-24 (first published: 2024-01-09)
499 reads
Using Spark Connect from .NET to run Spark jobs on Databricks
All Spark Connect Posts
Goal of this post This post aims to show how we can create a .NET application, deploy it to Databricks, and then run a Databricks job...
2024-01-24 (first published: 2024-01-23)
118 reads
Your gradient fill bar charts in Power BI have poor color contrast, but you can fix them
Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient...
2024-01-23
24 reads
Common Data Mesh exceptions
When it comes to data meshes that have been constructed or are currently under development, I have not observed any instances where the four core data mesh principles have...
2024-01-22 (first published: 2024-01-04)
226 reads
Using AI to create test data
Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production? Many of us manage databases...
2024-01-22 (first published: 2024-01-08)
646 reads
A New Word: Altschemerz
altschmerz – n. a sense of weariness with the same old problems that you’ve always had, the same boring issues and anxieties you’ve been gnawing on for decades, which...
2024-01-19
19 reads
Building a Docker image from a Github repository
To build a custom Docker image we create a docker file with instructions in it. For example, a really simple custom SQL Server 2019 Docker image can be built...
2024-01-19 (first published: 2024-01-05)
291 reads
I’m Speaking!
After a long hiatus of not blogging, I’m trying to get back into writing. So, to kick it off first thing in 2024, I’m speaking! I’m honored to have been...
2024-01-19
23 reads
Prompt EAP AI Experiments: Creating a History Table
SQL Prompt has an EAP using an AI model to help write code. I’ve been lightly experimenting with it, since I think AI is an interesting tech and it’s...
2024-01-19 (first published: 2024-01-05)
263 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
BCA KCU BOGOR | Tlp/Wa:0818751777
Tlp/Wa_Cs:0818-751-777. Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa...
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers