Video

Hey dear, god bless your efforts in this channel. I have a general enquiry as a new sql learner. How could i create a pipeline to extract and load data from existing accounting program into our SQL server instances. How can i know if the export mechanism in the software permits me to undertake this extraction process, and how can i know if an application have an api? Thanks for taking care of my enquires. Looking forward to gain more knowledge from you.

hello please i need your help with my pipeline.

also provide mmoree solution sir

some solutions for this performance

great videos

Where can I get the script of demo?

Guys how old is this video?

I was waiting for this topic.. Thank you 🙏🏻

Wonderful speech Sir🙏🙏🙏

You may want to work on better sound quality.

Wow! Super useful tutorial

I absolutely love this. Thank you for taking the time to put this together and publish it.

Is this report available for download?

In case we have multiple entries in version store table how we can delete particular entries

This is an amazing class. Thanks, Erland.

Sort happens in Memory. And it gets spilled to TempDB only in times of Memory bottleneck

Please don't mind but the presentation could have been better.. it is disengaging.

What a Great Session!! Thank you Amit!!!

Great One from my friend

Another great video, hats off Amit!

Amit, you are one of the best presenters!! Salute you

Tom this is an excellent session. When we started the MVP program you were the sort of person we had in mind. Thank you for all that you do.

😃

😃

Awesome Amit .

choosing code based implementation for a demo...not a great idea....

I liked the way you explained it. Learned a lot of new stuff. Thanks!

I heard that if you have legacy SSIS packages, you need to still use Data Factory. Is that true?

Dear, Can we get Query wise CPU in % with respect to highly utilized queries/procedures/functions?

Greetings! Beautiful video beautiful post.

This is a clever virtual conference facility to offer during these difficult pandemic times. Looking forward to participating.

Beautiful day! Beautiful video beautiful priorities beautiful post.

h1sew vyn.fyi

love it thanks

GREAT presentation, it would more great if you told how to fix the query (or minimize resources) at the end of the presentation and also saw blockings at the end of the Resource Semaphore wait. How do you fix the blocking on this case. I am not asking about general blockings. Thanks again.

Good Evening #KOSOVO Bro. AWESOME Al !!!!

awesome

Nicely covered the concept in short time. Thanks.

💛

Can we get the SQL used in the videos please ?

FYI, the primary goal of partitioning is ease of data management not performance. Though it may improve performance it is not meant to be used as a performance tuning technique.

Stats at 06:40

Great Video... That ALTER Table blocking SELECT is classic DW ETL problem & isolation levels are no help for it

6144GB is wrong. /2 is the right result.

How difficult to manage daily partitions

Awesome

you're the best

Great session, Thanks for making it available on CZcams. One question here, looks like Tabular model is extension of multidimensional model, so what is the counter part of semantic model. For example, in SSRS 2008, there was a concept of semantic model which could connect to cubes as well as directly to database. It was a user friendly model, which gave business users capability to create their own reports. Suppose we want to migrate those SSRS reports to Power BI, for example there are two categories of reports, Semantic model based SSRS reports which use cubes and which do not use cubes. The ones which use cubes can be migrated using this video , by creating a user friendly model, is there any way we can migrate the semantic reports which don't use cubes, there is a way that we generate physical SQL query for them but that approach is not good for business users so I am looking for an approach which will create a semantic kind of model. Please let me know if my question is not clear. Thanks in advance for your suggestion,

Wasted 57 mins to Just see execution plan and wait type...we are actually looking for how do you troubleshoot these issues