Видео

Hi Kamil, great video. I have few doubts, can we define user defined scalar function and use cursor command in fabric, if not what would be the work arround, please let me know. Thank you

Thanks for posting this video. I got stuck on the notebook part too. Microsoft Learn needs to update the instructions on that part.

I have a SQL server stored procedure which updates, deletes and merges data into a table , how do I convert the stored procedure to pyspark job, is it possible to update a table in fabric using pyspark?, please make a video on this topic

Great video, thank you for making

Is it possible to restore a deleted dataflow gen2 by the user and some version control?

😂😂😂Microsoft sucks get hell out of from open source suckers

Great Video! Thanks. You have a great knowledge in coding.

Thanks for Sharing - Great Reason(s): #1 - Keep skills up to Date #2 - Help Learning #3 - Demonstrate your commitment #4 - Build a case for promotions #5 - Help Job Seekers #6 - Gain new Networking Opportunities #7 - Validate a Higher Salary #8 - Gain Problem solving skills #9 - Build Self Confidence #10 - Show Professional Credibility 👍

Thanks Kamil, just what I needed!

Very interesting Kamil, please keep it going. Waiting for more videos.

👍

thanks, it was easier than I thought. I installed PowerShell 7 and somethings were not working so I had to install the cmdlets again, no big deal. Way faster than using ISE.

Thank's Kamil, very interesting

yea

How do we manage logins and users permission when deploying multiple environments? For example: if we have users User1 & User2, User1 should not be present on Dev and User2 should not exists on UAT?

Super :)

This is a cool video Kamil. Thanks for compiling all our MVP Summit memories in a nutshell 😊

🥇 Certifications not only validate your knowledge and skills but also signify your commitment to professional growth. Employers, seeking competent and qualified individuals, often prioritize candidates who possess relevant certifications. 🤔 How much do you agree or disagree? Share your thoughts and experiences.

Hi dear Kamil, Trust you are doing great. Am Tresor writting from Kinshasa DRCongo,I love your video and am realy want to lean more about that Databricks. I do not have much experience on databricks, but I will like you to help me or work with you so that I could prepare my exam...Please am waiting for feedback sir.

Interesting and convincing video! Thank you for that.

I always learn something when I take a cert exam. Sometimes you just need the motivation to learn and certs provide the push. Nice video.

Great video Kamil - really useful for final preparations for the exam. Thanks

Hello Kamil. What permission did you grant for local user agent? Thanks

Thanks for the video. Do you still need to import the module after V3?

Hi @kamil, getting error "A project which specifies SQL Server 2016 as the target platform cannot be published to Microsoft Azure SQL Database v12." I tried solution provided by you but still getting same error can you please suggest

Very Insightful video. Can you please let me know what trainings I would never do to become a Databricks Data Engineer? I visited the Databricks website and got confused. I am beginner in Databricks. Thank you!

how does it work for transferring large number of xml files from fileshare to rest endpoint using ADF with certificate authentication?

How can we implement a ci/cd pipeline for multi tenant db

Hi @Kamil, I have setup CD Pipeline successfully. I tried to delete existing Trigger in Dev and published successfully. New artifacte doesn't have that deleted trigger i mean parameter.json file doesn't have that deleted trigger but when i create Release deployment to UA this trigger is not getting deleted. Does the deleted activity doesn't move through Release? Do we need to delete it manually? Thanks, Deepak

Thank you. Demos were explained very well and simple manner. It was useful and informative.

Awesome. Would also be good if you could share a few use cases where a client may find this useful.

Great video!! Can we have the same demo that showcase how we upload for the different file format pdf and excel? That would be great! Also what is the alternate solution to add the contents of the file instead of using the variables?

@Kamil, thanks for the video really helpful. It works fine, but when I delete a table in DEV it doesn't delete it in prod. I created in VS SSDT a publish.xml which states : <DropObjectsNotInSource>True</DropObjectsNotInSource> However it still doesn't drop the tables in SQL. I tried to find this .xml file in the Publish Profile in my release pipeline but I can't select it.... Anybody has a clue?

What if the file you need to change is multiple levels down within a folder? ie: managedVirtualNetwork\default\managedPrivateEndpoint How would you go about changing that in the environment csv to use a different end point?

hi everyone i was created a new table in visual studio project and pushed to repo, CICD got succeed, but table is not deployed in target database. can any know the reason and help me. note : i am able to add new columns in existing table and its got deployed in target database.

Your video at 7:34 just completely jumps to another topic and misses the main bit of inserting the tasks into the release pipeline. 😢

Thanks for the video. It has resolved all my queries. Explained in simple way and to the point. Very helpful!

hi @kamil, thanks for the videos it helps us a lot but getting this error when trying to execute the release SQL72014: .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line 6 Rows were detected. The schema update is terminating because data loss might occur. SQL72045: Script execution error. The executed script: RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT; if you reply it will be appreciated.

If I create a new view and pushed the update to repo and pipeline deployed that changes to target DB and if I revert that new view commit, will the release pipeline will delete that view or else need to create a new script in ssdt for droping that view.

Hi @Kamil, I have a question… I have a bunch of sql scripts in a repo folder . And I want to deploy those script files which has only changes … Thanks

Great explanation , Thanks for taking to time put in all the remedial steps, generally where I get frustrated. I got as far as generating the script in VS I want to publish(59 min) , Repo version has a view with a comment --TEST, I have an existing DB in Azure I want to update with the change (Alter view with a comment --TEST,) , when I generate the script, no code is generated to make the update but if I was to create a new DB all object code is created, what am I doing wrong? I want to update existing DB's with new or altered objects

what is the key sequence to start PS?

I am getting this error 2023-02-27T09:39:37.6420094Z ##[error]*** Verification of the deployment plan failed. 2023-02-27T09:39:37.6483928Z ##[error]Error SQL72031: This deployment may encounter errors during execution because changes to [***] are blocked by [db_ddladmin]'s dependency in the target database.

Hi @Kamil, How can we deploy with user permissions ?

I'm getting a Powershell error. It says it cannot find type [System.IO.Compression.ZipFile] when the UseDotNet@2 task is executed.

Hi Kamil, thanks for the video! I have a question, how is granted the network permission to Azure SQL from Devops agent? And in case of being deployed in a SQL VM how could I grant the network access? Thanks.

Very good information and session thanks a lot. I am looking for the same using Jenkins could you please have the one using Jenkins will be greatly helpful for me. Thanks in advance .

Is there any way to link databricks with same permission in databricks? I just allow my A user to use A folder in databricks and just allow to access A folder when A user use data factory to create pipeline with databricks?

Very helpful tutorial, thank you. I wonder if you could answer a question I have about self hosted agents...... If I want to deploy code to several servers in my environment is it possible to have just one self hosted agent in my environment that deploys the code to my target servers? or do I need to have a self hosted agent on each of my target servers? The reason being I need to limit external connections from my environment to a minimum. So if I could have an 'intermediate' server that connects to azure devops with the self hosted agent and deploys to other servers that don't need a direct connection to azure devops that would be my ideal solution. Many thanks