Answering Questions On Dropped Columns
Answering a couple of questions from the previous posts about dropping columns.
2026-03-18
1,986 reads
SQL
2026-03-04
3,277 reads
Fabric Analytics for SQL folks: Part 1 - Fabric demystified
Unlock new opportunities for data-driven decision-making by grasping the significance of SQL and structured data in current data and analytics ecosystems like Microsoft Fabric.
2025-03-21
6,565 reads
Takeaways from Data Grillen 2024
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
453 reads
Will AI end with SQL, Is this the end of SQL?
An experienced DBA asks an AI to perform some common tasks. Read to see how it fairs and if an AI will impact DBA jobs.
2024-03-11
7,846 reads
SQL Window Functions Series: NTILE()
Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.
2024-02-03 (first published: 2024-01-03)
5,149 reads
SQL Window Functions Series: LAG() and LEAD()
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
10,312 reads
SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
2023-11-20 (first published: 2023-11-15)
15,108 reads
How to Use SQL to Analyze the Bitcoin Blockchain
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
2023-09-08
5,090 reads
SQL WHERE LIKE to Construct More Efficient Queries
In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries.
2023-06-02
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Puri Kembangan TLP/WA 08216977749
Jl. Kembangan Raya No.3A, Kedoya Sel., Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
BCA KCU KALIMALANG CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren Sawit,...
BCA Finance Kelapa Gading Layanan Mobil TLP/WA 08216977701
Ruko Mall Of Indonesia Blok B 32-33, RT.18/RW.8, Klp. Gading Bar., Kec. Klp. Gading,...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers