How to use a Script Activity in ADF as a Lookup
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a typical scenario where you retrieve some metadata from a database and then loop over...
2024-06-27
172 reads
6 Surprising Things You Can Do on WordPress.com Without a Plugin
Newsletters? Spam protection? Image galleries? We have you covered, no plugin needed.
2024-06-26
25 reads
Create a copy of an Azure SQL DB
Where I work, we will be migrating data from one set of databases into another. I will be making a copy of the destination databases to allow us to...
2024-07-10 (first published: 2024-06-25)
394 reads
Take the SQL Saturday Topic Survey
What topics do you want to see presented at a future SQL Saturday (or other event)? Steve Rezhener has built a survey that you can take. Take the survey...
2024-07-12 (first published: 2024-06-25)
97 reads
Resetting Git and Abandoning Changes–#SQLNewBlogger
I recently had an issue in one of my Git repos, and decided to drop all my local changes and just pull down from the remote. This post looks...
2024-06-24
111 reads
2024-06-24
30 reads
Transform yourself into an Invaluable Data Leader in just 6 weeks
I’ve collaborated with two industry experts to design a transformative course for data leaders: “The Technical and Strategic Data Leader.” This six-week intensive learning journey is crafted to elevate...
2024-06-24
48 reads
Exploring Window Functions Execution Plans
There are quite a few different ways that you’re likely to see window functions evidence themselves within your execution plan. Let’s take a look at one example. Window Functions...
2024-06-24
57 reads
Exploring Windows Function Execution Plans
There are quite a few different ways that you’re likely to see windows functions evidence themselves within your execution plan. Let’s take a look at one example. Windows Function...
2024-07-10 (first published: 2024-06-24)
290 reads
Database Build Error – Incorrect syntax near DISTINCT
I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks if two expressions are equal taking NULL into account....
2025-01-03 (first published: 2024-06-24)
729 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
DanDan Jl Panjang Cidodol | WA:083121526888
Jl. Cidodol Raya No.46, RT.6/RW.6, Grogol Sel., Kec. Kebayoran Lama, Kota Jakarta Selatan, Daerah...
DanDan Kavling Polri | WA:083121526888
Kavling Polri, Jl No.1601 Blok F 8, RT.8/RW.02, Jelambar, Grogol petamburan, West Jakarta City,...
Toko Kosmetik Sumber Ayu | WA:083121526888
Pasar Tomang Barat (Pasar Kopro) Lt Dasar Blok B-48, RT.14/RW.5 (depan parkiran motor), Tanjung...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers