TSQL Rollup and Cube
2:24
7 жыл бұрын
TSQL Grouping Sets
4:08
7 жыл бұрын
Codd's laws - Rules of Normalization
3:05
SSAS MDX Queries
50:20
7 жыл бұрын
15 SSIS SCD Type 2 and 3
16:18
7 жыл бұрын
14 SSIS SCD Type 0 and 1
13:36
7 жыл бұрын
05 SSIS Bulk Insert
2:47
7 жыл бұрын
04C SSIS Event Handlers
3:52
7 жыл бұрын
04B SSIS Logging
2:52
7 жыл бұрын
04A SSIS Audit Data Task
1:50
7 жыл бұрын
03 SSIS SQL Server to Excel File
6:07
TSQL Sparse Columns
5:26
7 жыл бұрын
TSQL Grouping Sets
2:57
7 жыл бұрын
TSQL Common Table Expression CTE
8:08
12 SSRS Linked Reports
3:32
7 жыл бұрын
17 SSRS Deployment
4:01
7 жыл бұрын
16 SSRS Basic Map
3:54
7 жыл бұрын
15 SSRS Subreports
2:55
7 жыл бұрын
14 SSRS Switch Case Expression
5:58
7 жыл бұрын
13 SSRS Basic Line and Bar Charts
9:03
01 SSRS Basic Table
10:47
7 жыл бұрын
02 SSRS Header Trick For Matrix
3:18
11 SSRS List with Chart
7:05
7 жыл бұрын
Пікірлер
@yuvarajarul5074
@yuvarajarul5074 4 ай бұрын
thanks ted worked 🙂
@christinaash1793
@christinaash1793 Жыл бұрын
Hello. This video is so helpful. I would like the data conversion table you show. I apologize, but cannot find video note...I am dumb to navigate KZbin and find it :( Could you please send or post some other way? Thank you for this video either way. You are so clear in your direction.
@MattDonnelly-xg6bz
@MattDonnelly-xg6bz Жыл бұрын
Thanks Ted for the great video. Very useful and easy to follow.
@MH-zq8zt
@MH-zq8zt Жыл бұрын
Thank you very much for this incredible video
@rahul-zh6ir
@rahul-zh6ir 2 жыл бұрын
Thanks partner this helped me alot
@christianreed669
@christianreed669 2 жыл бұрын
Crazy g, my mans spanking
@MkMc80
@MkMc80 2 жыл бұрын
This video has been a huge help to me. Thank you!
@biggriz24
@biggriz24 2 жыл бұрын
Thank you, you really articulated this in such a clear and easy to understand manner. Much appreciated!
@pupycron4302
@pupycron4302 2 жыл бұрын
I could not find this info anywhere else. Thanks! Also loved the outro. No messing around :)
@techbrojoe
@techbrojoe 3 жыл бұрын
Thank you for this. I was trying to follow Microsoft's documentation and their instructions didn't really make any sense since they don't explain the variable you're putting on the ForEach Loop is actually the ConnectionString value via an expression.
@bli240
@bli240 3 жыл бұрын
This is a gold mine. Any chance you might be able to share the slides/notes?
@imsteven3044
@imsteven3044 3 жыл бұрын
Hi, Could you help me please? How can I use DAX to create measures?
@EasyStreet88599
@EasyStreet88599 Жыл бұрын
You don't create measure with DAX you create calculations with DAX.
@Gordon342007
@Gordon342007 3 жыл бұрын
Thanks Ted. I had tried other explanations to no success but this worked perfectly.
@XxPIOJIxX
@XxPIOJIxX 3 жыл бұрын
Thanks!! Very helpful
@sanjayakumarpadhy9999
@sanjayakumarpadhy9999 3 жыл бұрын
Thanks Ted. It is an excellent video and the explanation given by you is outstanding. It helps me lot.
@PigsOnBook
@PigsOnBook 3 жыл бұрын
Cool video. At 3:05, if Xact_abort equals =-1, then it seems redundant to have a rollback transaction statement. I am somewhat new to how the engine works. If the rollback statement was not there, would SQLServer rollback the transaction anyway? When are rollbacks implicit?
@mokhot
@mokhot 3 жыл бұрын
well explained but need to speed up the tone a bit - I had to use 1.5 speed
@rohitravi8557
@rohitravi8557 3 жыл бұрын
Thank you so much! I have looked everywhere for an MDX tutorial, but with no luck. This was extremely helpful. I really appreciate it!
@tarakdarapu6183
@tarakdarapu6183 3 жыл бұрын
Very helpful
@teunkruijer
@teunkruijer 3 жыл бұрын
So Simple but so usefull. Thanks a lot!
@173062j
@173062j 3 жыл бұрын
Thank you very much for the incredible useful video. It clears up all important and confusing points about cube and MDX. I wish I had found it earlier :)
@mohsenhs
@mohsenhs 4 жыл бұрын
Hi Ted ( I assume this is your name), thanks a lot for this video, this was a great and really helpful video, This is a great start for me and much appreciated. Just a simple point: The AccountDescription must be selected as the NameCoulumn for AccountKey in the DimAccount, otherwise the cube shows the numbers (i.e. account key) instead of account description.
@dalton_nbg
@dalton_nbg 4 жыл бұрын
Great explanation...my favorite part? The length, haha.
@ahamednj5969
@ahamednj5969 4 жыл бұрын
thanks for the help.
@user-vx8yo3br6r
@user-vx8yo3br6r 4 жыл бұрын
thanks... it was really helpfully
@TavandtheTadpole
@TavandtheTadpole 4 жыл бұрын
Thank you!
@GuyBehindTheScreen1
@GuyBehindTheScreen1 4 жыл бұрын
Simple quick and to the point. Very helpful. Thank you!
@majojepan9
@majojepan9 4 жыл бұрын
Will this "start analyze button" actually run this query? I want to optimize update query but i dont want to run it. Ty
@MrPapeBoubacar
@MrPapeBoubacar 4 жыл бұрын
Great Ted ! The black screen does not help though.
@wrestlingarchitect4399
@wrestlingarchitect4399 4 жыл бұрын
Cool mate
@ClintonEg
@ClintonEg 5 жыл бұрын
Does map visual have drill down feature?
@arnabgupta4391
@arnabgupta4391 5 жыл бұрын
Thanks, Ted for the video. It has been of great help, I literally was struggling for a long time as I assumed Delay validation = True was to be set in the property for the FOREACH Loop Container.
@ridethecatbus
@ridethecatbus 5 жыл бұрын
Could you re-link the data type chart from Excel to SQL you mentioned in the video? The link doesn't work and i would be so grateful to have that cheat sheet.
@mario17-t34
@mario17-t34 5 жыл бұрын
it's Nov 2018 I'm on all most recent versions and I don't have <Directory> option under Collection in <For each loop> , can anybody knows why,
@Eleochess
@Eleochess 5 жыл бұрын
Excelent!! Thank you!!!
@emadahmed2652
@emadahmed2652 6 жыл бұрын
Nice
@1shcw
@1shcw 6 жыл бұрын
So clear and to the point. Thank you!
@normanknutsen8253
@normanknutsen8253 6 жыл бұрын
Thank you. Didn't understand that I had to set the group by in "(details)" until I saw your video. Saved me a lot of banging my head against the wall.
@raginikommera2889
@raginikommera2889 6 жыл бұрын
Thank you so much for the wonderful video :) Very neat presentation. I would recommend others
@nicholasrennie8906
@nicholasrennie8906 6 жыл бұрын
Great job, and thank you! I'm completely new to MDX, but this tutorial gave me a great breadth of knowledge quickly. Many videos are way too simple or too complex, this struck a very nice balance.
@dingmaster001
@dingmaster001 6 жыл бұрын
hi. The link is no longer working.
@rezakhan1304
@rezakhan1304 6 жыл бұрын
This is GREAT video , thanks for taking the time to make this !
@hfarmanesh1
@hfarmanesh1 6 жыл бұрын
Thanks a lot. It is the best session on MDX
@jesseolivarez704
@jesseolivarez704 6 жыл бұрын
Thanks for creating...Great Video!
@jerish123
@jerish123 6 жыл бұрын
Very nice. Detailed and precise at the same time. Can I get a link to download the presentation or email to [email protected]
@mario17-t34
@mario17-t34 6 жыл бұрын
Tx, do you know how to refer to Worksheet name dinamically (single, or first one) Tx
@claudioaguirre6532
@claudioaguirre6532 6 жыл бұрын
Excellent Tutorial!! Very helpful, thanks!
@claudioaguirre6532
@claudioaguirre6532 6 жыл бұрын
Great! Thanks
@TheDistractionStudio
@TheDistractionStudio 7 жыл бұрын
Learned something new today! Thank You!