Moving towards the DataFrame API using the Spark Connect gRPC API in .NET
All Spark Connect Posts
Code
Goal of this post So there are two goals of this post, the first is to take a look at Apache Arrow and how we can...
2024-02-05
101 reads
Blog Posts
SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes
SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes
As we know, the SQL Server buffer cache is an area or region inside the server's memory where SQL Server...
2024-02-05 (first published: 2024-01-24)
536 reads
The DevOps Airways Roadshow
I love this logo. Our marketing people were very creative. After the van tour last year, we decided to go with a plane this year. I wrote about the...
2024-02-05
47 reads
Azure Function App doesn’t retrieve most recent secret value from Azure Key Vault
Quite a long title for quite an annoying issue. Let me explain the set-up first: I have pipelines running in Azure Data Factory and I want to send e-mails...
2024-02-03 (first published: 2024-02-02)
32 reads
A New Word: Tarrion
tarrion – n. an odd interval of blankness you feel after something big happens to you bt before you feel the resulting emotional reaction – stunned by a sudden...
2024-02-02
84 reads
Best Practice Tip #1: Beware of Best Practices
Best Practice Tip #1: Beware of Best Practices
It may sound contractionary that the first item of a best practices list is to be wary of...
2024-02-02 (first published: 2024-01-18)
748 reads
Friday Flyway Tips–Linking a GitHub Issue to a Code Commit
Recently I was doing a demo and a customer asked how I had linked my commit in Azure DevOps to the work item that existed. It’s easy, and tldr;...
2024-02-02 (first published: 2024-01-19)
155 reads
ISACA Journal Article on AI
The first issue of 2024 for the ISACA Journal has been published and the articles are available both in written and on-line format. I have a regular column on...
2024-02-02
40 reads
Exploring the Spark Connect gRPC API more
All Spark Connect Posts
Code
Goal of this post In this post we will continue looking at the gRPC API and the AnalyzePlan method which takes a plan and analyzes it....
2024-02-01
122 reads
SQL Server Autogrowth Settings Changes
Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...
2024-02-01
3 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat BCA KCU BEKASI | Tlp/WA:0817819444
Wa:0817819444 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Alamat BCA KCU TUBAN | Tlp/WA:0817781222
Wa:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers