Kamil

My name is Kamil Nowinski and I'm the founder & owner of SQLPlayer blog.
I'm Microsoft Data Platform MVP, MCSE. Senior Data Engineer, data geek and friend of Redgate. I speak at user groups and conferences across Europe. Love #SQLfamily and Community around Microsoft Data Platform - that's why my podcast is called "Ask SQL Family" where I talk to well-known and valued specialists in the industry (including Microsoft employees).

Blog Post

Last Weeks Reading (2024-02-11)

đź“° News Power BI Project (PBIP) and Azure DevOps build pipelines for continuous integration Integrating the PBIP format with Azure DevOps lets you use Azure Pipelines to automate CI/CD...

2024-02-11

11 reads

Blog Post

Last Weeks Reading (2024-01-28)

📰 News Fabric end-to-end use case: Data Engineering part 2 – Pipelines If you’re new in Microsoft Fabric – check this series and build it with Sam. Set up...

2024-01-29

7 reads

Blog Post

SQLPlayer is renaming

It was about time. The blog and all related services are being changed the name. From SQL Player to Azure Player. You probably noticed over several years that the...

2023-01-02 (first published: )

47 reads

Blog Post

InvalidAbfsRestOperationException in Azure Synapse notebook

Problem The first issue that developers in my team noticed was when they tried to create database with Spark: Error message: org.apache.spark.sql.AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(meesage: Got exception:  org.apache.hadoop.fs.azurebfs.contracts.exceptions.InvalidAbfsRestOperationException Status code:...

2022-12-05

274 reads

Blogs

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

A New Word: Aesthosis

By

aesthosis– n. the state of feeling trapped inside your own subjective tastes – not...

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Read the latest Blogs

Forums

Linked Server Connection Issue

By dinomike20

Hi all, I have 2 SQL servers on different domains (lets call them SQL-A...

Frustrated trying to get Cross DB Access by Signing SP with Certificate

By Ken McKelvey

Maybe it is lack of caffeine, but I cannot see why the following test...

SSIS Execute Package Fail in SSMS but Agent Job Succeeds

By jerryszz

Hello, I created a SSIS package to transfer data from an XML file to...

Visit the forum

Question of the Day

Writing to Clones

I run this code on SQL Server 2019:

DBCC CLONEDATABASE(imdb, imdb_dev)
I then change to the cloned database, imdb_dev, and run some queries. I then run this code while testing:
INSERT dbo.Title (TitleID, Title, DateReleased) VALUES (3234, 'Maestro', '2023')
GO
What happens?

See possible answers