Scheduled to happen today at 6 pm onward at Microsoft Sri Lanka premises.
More info : here.
Dinesh finishes his session quickly since we are running out of time.
Dinesh asks questions from the crowd and gives away freebies.
SQL Server relational engine, integration services and analysis services are the tools MS offers for this process. – Dinesh
There are 4 steps you have to go through to design your dimensional model.
1 select your business process
2 declare the grain
3 Identify the dimension
4 Identify the facts – Dinesh
This is how RDBMS forms star schema. Fact table sits in the middle. – Dinesh
‘grain’ is the lowest level to be set in a row in a fact table.
Fact table usually consumes 90% of the space of the model. – Dinesh
Multidimenshional Database Management System (RDBMS) implementations are referred as OLAP cubes. – Dinesh
Relational Database Management System (RDBMS) implementations are referred as Star-schema. – Dinesh
Facts represent business measurement. and it is quantitative.
Dimensions are textual descriptions that provide context for facts.
Facts and Dimensions are the key elements of Dimensional modeling. – Dinesh
The benefits of Dimensional Modeling:
It is all about simple structure.
deliver data to the user in an understandable way.
deliver quick. – Dinesh
Dimensional Modeling is a longstanding widely accepted technique for presenting analytically data in databases that hold data in a simple dimensional structure to match the fundamental human need for simplicity. – Dinesh
“Dimensional Modeling with SQL Server” is the topic of discuss with Dinesh today.
We are back.
Next up, we have Dinesh Priyankara, an MVP and an Architect at CAMMS.
We are now having a small break. Be right back.
Sudaraka concludes his session.
Asks few questions from the crowd and gives away goodies as well.
Cons of CLR:
It is expensive to re write.
Pros are :
we have the power of .Net Framework
Complex Calculations are made easy
CLR is faster than a cursor – Sudaraka
these are the available security level options available here in this scenario to deploy this particular project.
Sudaraka was able to write a piece of code where in the end, an email has to be sent to the customer as a notification of over usage of his Credit Card.
Sudaraka now gets on with a demonstration where he will explain why CLR integration is better than executing manual triggers.
As the requirements are getting hard, the only option is to use SQL Integration rather than writing manual triggers. – Sudaraka
Process of authorizing stored procedures, triggers, user defined functions. In simple language. – Sudaraka
Sudaraka recalls an incident where he used CLR to write an app for the gov sector when he was in Singapore.
What is SQL Server CLR Integration? Sudaraka asks.
intro to CLR
into to SQL server CLR integration
pros and cons
are the pointers Sudaraka will be talking on.
1st up, we have Sudaraka, who is a Solutions Architect at CAMMS.
He is going to talk on CLR integration with SQL.
Good Evening everyone.
This is digit team, live from Microsoft Sri Lanka Office to bring you Live updates from SQL Server Sri Lanka User Group Meetup.