Видео

My JSON payload column Datatype is stored as "Text" in DB. I want to run a query to fetch a particular value from key/value pair of the JSON object/array. How can i do that? im always getting error that -> and ->> operator doesn't exist. I'm using PostgresSQL version 12.17. Help here.

bro i think you should increase your display size because there is not seeing properly and i have already expanded to my display size but even then i am being unable to watch screen properly

Great explanation

this was grat

your explanation is perfect for a beginner like me! Don't know why you have stopped making videos.. Hope you'll start making videos on complex topics of sql server (ssms).

Thank you. This is very helpful description.

Things are not clear in the video. Typical school/college type of teacher.

Thank you. It very helpful..

Awesome 😎

If the dop os 0 then it is good -like it will use all the cpu and the query results will be fast?

Hi there, thank you! I do have a question, I have 1 member and hub db is in same sql azure server, I have error for “Database re-provisioning failed” for both hub and azure member. On prime is ok. Also, when trying to add table into sync, it cannot retrieved any table for any azure db. Looks like permission issue. Can you provide permission you need to setup for azuremember and hub DB sql login? Thank you!

Hello Sir, do you give training on SQL/Azure. Pls let me know.

Super ❤❤❤ may I have your contact or gmail id please

Hi there, thank you for the video. But I have a question do I need to add an azure database or can I directly add an on premises database?

Thank god, bro I have resolved this issue after watching your video, thank you 🎉

can we present datbase which is there on Azure data sync to Azure sql vm

superb explaination

Good introduction. Thank you.

This was very helpful, thank you!

When I import a bacpac file via Azure portal (not via Management Studio) there are no tables or data present, why is that? Your method works, thank you. But why when i import the same bacpac file via Azure portal there is no data or tables?

You explained in detail. It is usefull. Thanks

audio not clear, font size too small.

Whre can I find the PDF used in this presentation?

thanks

It was a great explanation for JSON types in the PostgreSQL. Thanks.

Can we alter the table and remove this memory_optimized = on??

thank you for this

Good Job! or in mexican ¡Te rifaste carnal!

Does this method help us to run a Stored Procedure and move data from DB1 to DB2?

Thanks a lot for this great and clear explanation!

If instance level value set 0 and db level set 4 that time query will take 4 value or 0 value?

Is it mandatory update statistics once rebuild operation completed

I am not able to find this file on the given path. Also checked all folders in the installation.

in an environment where concurrency is high, can I use this approach. Assume I am going to use temporal table in memory...

Nice

If chatgpt stopped generating text, you can write "continue" and will resume

i hope companies willow chatgpt to be used for sql, excel jobs...data scientist jobs

This is amazing. It will help for time management. But I'm sure that due to this employers will reduce their employees and give the burden of remaining employees.

Thank you for this beautiful demonstration, sir! Four mins into the video and I'm already understanding things!!

Great video. Thanks!

Keep on posting videos. It really helps us . I am a SQL server Dba

Good content. thank you

👍

Very Good Thank you.

Thankyou so much Sir!! Clearly understandable n Very helpful for us.. Keep Uploading.

Thanks 😊

Great video

Hi Jitendra Need your help in User-defined table type In oracle we have a user-defined table type create or replace TYPE "names" as TABLE OF VARCHAR(50) In the table we have a column ACTNAMES and when we execute that table result is like below SELECT * FROM Organization Output: ACTNAMES names('SSM - Respond to Surveys is Good','SSM - View All Response is Good') -- This is properly fit with the user-defined table type in oracle How can we do the same thing in sql server with user-defined table type? I have created a sample table CREATE TABLE Test(ACTIVITY_NAMES VARCHAR(50)) CREATE TYPE ACTIVITY_NAMES_NT AS TABLE ( ACTIVITY_NAMES VARCHAR(50) ) I want data should be saved in the column ACTIVITY_NAMES like this 'SSM - Respond to Surveys is Good' ,'SSM - View All Response is Good' Note: This complete ['SSM - Respond to Surveys is Good' ,'SSM - View All Response is Good'] value must be in single column and it must be fit with VARCHAR(50)

Good Job keep it up jitubhai. Nice demostraration

Hello man, God bless your efforts. I have a simple enquiry as a new sql learner. How does the term b-tree relate to the index function in sql? Thanks for taking care of this.