- 7
- 60 670
Vinod Jain
Registrace 19. 09. 2008
In Memory OLTP-Introduction
In this video, you will get basic idea about In-Memory OLTP.
I've covered following topics in this video-
1. Basic introduction to In-Memory OLTP
2. Popular myths
3. High level Architecture
4. Performance factors
5. Candidate applications/workloads
Videos in this series-
1. In-Memory OLTP- Introduction - czcams.com/video/ZUBV8Ne8ddo/video.html
Your suggestions and comments are most welcome. If you have any question, please let me know in the comment section.
Please like and subscribe :)
I've covered following topics in this video-
1. Basic introduction to In-Memory OLTP
2. Popular myths
3. High level Architecture
4. Performance factors
5. Candidate applications/workloads
Videos in this series-
1. In-Memory OLTP- Introduction - czcams.com/video/ZUBV8Ne8ddo/video.html
Your suggestions and comments are most welcome. If you have any question, please let me know in the comment section.
Please like and subscribe :)
zhlédnutí: 1 974
Video
SSAS Tabular Model-Security-Part-3-Adnvance Dynamic Security
zhlédnutí 4,9KPřed 8 lety
This video is the last video of this series. This video is about how to implement Advance Dynamic Data Security in Tabular model. The main benefit of this approach is performance. You’ll see how to design a model in such a way that your security implementation will always perform same irrespective to number of dimension columns on which you have implemented security. Videos in this series- 1. S...
SSAS Tabular Model-Security-Part-2-Dynamic Security
zhlédnutí 10KPřed 8 lety
Implementing Dynamic Data Security using- - 1 or 2 Roles - USERNAME() function - CONTAINS function Videos in this series- 1. SSAS Tabular Model-Security-Part-3-Role Based Security- czcams.com/video/yJrLJ95j-ho/video.html 2. SSAS Tabular Model-Security-Part-3-Dynamic Security- czcams.com/video/Rs1llS4cZUE/video.html 3. SSAS Tabular Model-Security-Part-3-Advance Dynamic Security- czcams.com/video...
SSAS Tabular Model-Security-Part-1-Role Based Security
zhlédnutí 16KPřed 8 lety
In this video, you will see how to implement Data Security using Roles and simple DAX expression. I've covered following topics in this video- 1. Simple Security Scenario 2. Create Roles and apply security 3. Validate security implementation 4. Membership of multiple roles 5. More complex security scenario Videos in this series- 1. SSAS Tabular Model-Security-Part-3-Role Based Security- czcams....
MDX-Part-3-Sorting Results
zhlédnutí 2,1KPřed 8 lety
This is my second video on MDX series. This series is meant for those people who wants to learn MDX very badly but think that learning MDX is very hard. This video covers followings- 1. Order function 2. Hierarchize function 3. How to use Order and CrossJoin together Please comment if you have any question or suggestion. And, don't forget to subscribe :) All videos in this series- 1. MDX-Part-1...
MDX-Part-2-Dimension
zhlédnutí 6KPřed 8 lety
This is my second video on MDX series. This series is meant for those people who wants to learn MDX very badly but think that learning MDX is very hard. This video covers followings- 1. Hierarchy Types, Dimension Types (from number of hierarchies point of view), 2. How to access [All] level in a hierarchy explicitly. 3. How to access individual members in a hierarchy. 4. Few rules that you shou...
MDX-Part-1-MDX Query Basics
zhlédnutí 20KPřed 8 lety
This is my first video on MDX series. This series is meant for those people who wants to learn MDX very badly but think that learning MDX is very hard. This video covers prerequisites, MDX editor and basic MDX queries. Below are few links that I used in this video- 1. To download AdventureWorksDW2012 database- msftdbprodsamples.codeplex.com... 2. To attach a database file- msdn.microsoft.com/en...
thank you for your share ！！
Hi sir I need some help regarding the SSAS Tabular model. I have three date tables first one Creation data second one End date and Assigned data. Hence all the columns names are the same naming convention in all three tables, while dragging the fields to excel pivot table filter I am not able to identify which field is it and from where it is coming. Could you please help me how to differentiate that . Is there any option to make a table name dot column.
You can use translation feature to give each field a meaningful name. That way, even if the attribute names are same in the physical data model, they will have different display label in the Excel pivot table.
in membership we are adding user manually how can we add user dynamically as there are 100 or more user for each role
Hi, Thank you for making this useful video, could you upload the scripts!
Thank you. This is very helpful
Hi Brother! These videos are really helping me out!! You explained very nicely. Can you make video about Filtering!!
Thank you @vinod Jain for this great work and your efforts. This video is very helpful to me to learn MDX queries as a beginner.
Good video for beginners.
This saved my team so much time! Thank you.
Hi Vinod, Great article. My question is about how to implement dynamic row-level security for a database schema that has multiple fact tables?
Good article. However, when I tried to implement dynamic role level security, I could not do it. When I try to Evaluate vw_dimUserPermissions, I get two rows instead of only one row assigned to the user Jeff Bravo. What else am I doing wrong here?
Great videos!!! Could you please teach us how to apply the row level security to some columns? Thank you very much for the 3 videos! They are really great!
Its good explanation about SSAS Vinod. If you have any chance to create video real time prospective performance /storage how to maintain load balancing
Thanks a lot for explaining so clearly and simple. This video saved my day!!
Excellent
Pretty good basics
Thank you for the videos, really clear and detailed - great work! May I ask why you use CONTAINS() function in the Part2 and CALCULATE(COUNTROWS...) in this advanced part? CONTAINS appears to be more intuitive and valid for both implementations?
Really nice videos ..can you please provide me some solution on column level security in tabular model
Very nice and clear! Thank You!!
No proper context.... Terrible...
fantastic video!thanks
Once again thank you for putting up this video. I was struggling to understand the crossjoin function but only after watching your video I have a clear understanding. Really excellent work.
Thank you Vinod. You explained very well and organized. I learned so much from your video
sir please share adventureworks.bak file that is related video
Why we use roles not the user in connection?
Sumit Kumar please watch my other videos. I tried to explain all possible approaches known to me there
Great video and presentation! thanks
I tried to implement the security but it is nor working
Nice video and nicely explained
Very good presentation, thank you!
Really good one
Merci beaucoup pour ce tutoriel simple et clair !
Merci !
can we hide the base model from the user and can they only see the perspective?
Great work once again -- really enjoying your videos!
Another exceptional presentation -- thanks a bunch!!
Top-notch work -- thanks a bunch!!
Hi vinod I am implementing rls in ssas cube and visualising data in power bi. I have a sales table with salesmanid and I have users table. When I put my sales measure in barchart I am getting desired results .But when I just drag my sales measure in kpi I get the full sales not sales of that particular user.
Great work
Hi nice explanation .... is column level security possible in tabular model ?
Very helpful!
very good any easy to understand. Thank you for video and knowledge sharing .
sir please share adventureworks.bak file that is related video
You are a beautiful man
Excellent VJ, how about if you have 4 other columns on the same fact table that you want everybody to have access to. Can you create another Role just for the other 4 columns ?
Thanks for the video vinod sir.. it was really helpful.. you're truly genius
Sir thanks for the video. Can you please help me with the below? How can I dynamically process the table? can I do It through SSIS package? In the video you're saving ODC file. what is the significance and usage of that file? I need to calculate running total for 2.5million rows/day so can I calculate it through DAX in new column or shall I do it new view , which will be faster?
super
Hi the video is quite helpful. i have a query. I created a cube , but in dimensions it showing only the columns which have a foreign key relationship with measure table. rest are not displayed. can u tell where i went wrong or something i miss or don't know. it will be very kind as i am eager to learn the cubes. And also if i take example of your Date Dimension, then After Date --> Calender--> Members but in mine After date-->Members. i feel i missed something while creating.
Great effort......Thanks .... please keep the videos coming
Nice explanation . But I have some doubts :-1. SQL gets the data from table ( which is stored in rows and column ) while mdx gets the data from the cube which is stored in which format ( I searched on google and found that it is stored in 3-d , but it is logical I want to know how physically it stores the data in the cube , because data gets stored in rows and column in database only ) 2. By seeing the MDX example , now it is clear that it working like dynamic pivot , means it depends on us how we want to project the data .If cube stores the data inside the db in table format how it thinks about what will go for column and what will go for row and does it stores all the possible combination , if it is like that then for each combination the table structure will change then how sql projects it inside the same cube ?Please reply ,Since I am stuck how cube works from inside.
Aditya Kumar let's you have a 3D cube. And every dimension/fact is stored in as a table. And you want to retrieve ( sales , for year 2017, in Asia) . Now MDX will pull these tables and take their intersection. And where they intersect is your desired value/aggregation.
How can we apply security to only specific measures? Say if I have 5 measures in my cube and users can see 3 measures unrestricted but will have restricted access for the other 2 measures