Home Events Live Blog – SQL Server Sri Lanka User Group Meetup – March...

Live Blog – SQL Server Sri Lanka User Group Meetup – March 2014

2208

Scheduled to happen today at 6 pm onward at Microsoft Sri Lanka premises.

More info : here.

From Press From Press Mar 19, 20148:30 pm

With that note, we conclude this event. Good Night everyone. See you tomorrow.

From Press From Press Mar 19, 20148:26 pm

Dinesh finishes his session quickly since we are running out of time.
Dinesh asks questions from the crowd and gives away freebies.

From Press From Press Mar 19, 20148:23 pm

SQL Server relational engine, integration services and analysis services are the tools MS offers for this process. – Dinesh

From Press From Press Mar 19, 20148:20 pm

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

From Press From Press Mar 19, 20148:13 pm

This is how RDBMS forms star schema. Fact table sits in the middle. – Dinesh

From Press From Press Mar 19, 20148:08 pm

‘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

From Press From Press Mar 19, 20148:02 pm

Multidimenshional Database Management System (RDBMS) implementations are referred as OLAP cubes. – Dinesh

From Press From Press Mar 19, 20147:59 pm

Relational Database Management System (RDBMS) implementations are referred as Star-schema. – Dinesh

From Press From Press Mar 19, 20147:57 pm

Facts represent business measurement. and it is quantitative.

Dimensions are textual descriptions that provide context for facts.

From Press From Press Mar 19, 20147:55 pm

Facts and Dimensions are the key elements of Dimensional modeling. – Dinesh

From Press From Press Mar 19, 20147:51 pm

The benefits of Dimensional Modeling:

It is all about simple structure.
re-usability.
deliver data to the user in an understandable way.
deliver quick. – Dinesh

From Press From Press Mar 19, 20147:48 pm

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

From Press From Press Mar 19, 20147:42 pm

“Dimensional Modeling with SQL Server” is the topic of discuss with Dinesh today.

From Press From Press Mar 19, 20147:41 pm

We are back.
Next up, we have Dinesh Priyankara, an MVP and an Architect at CAMMS.

From Press From Press Mar 19, 20147:30 pm

We are now having a small break. Be right back.

From Press From Press Mar 19, 20147:26 pm

Sudaraka concludes his session.

Asks few questions from the crowd and gives away goodies as well.

From Press From Press Mar 19, 20147:25 pm

Cons of CLR:

It is expensive to re write.

From Press From Press Mar 19, 20147:24 pm

Pros are :

we have the power of .Net Framework
Complex Calculations are made easy
CLR is faster than a cursor – Sudaraka

From Press From Press Mar 19, 20147:19 pm

Security Level:

Safe (default)
External Access
Unsafe

these are the available security level options available here in this scenario to deploy this particular project.

From Press From Press Mar 19, 20147:08 pm

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.

From Press From Press Mar 19, 20146:49 pm

Sudaraka now gets on with a demonstration where he will explain why CLR integration is better than executing manual triggers.

From Press From Press Mar 19, 20146:45 pm

As the requirements are getting hard, the only option is to use SQL Integration rather than writing manual triggers. – Sudaraka

From Press From Press Mar 19, 20146:40 pm

Process of authorizing stored procedures, triggers, user defined functions. In simple language. – Sudaraka

From Press From Press Mar 19, 20146:39 pm

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.

From Press From Press Mar 19, 20146:33 pm

intro to CLR
into to SQL server CLR integration
lab time
pros and cons

are the pointers Sudaraka will be talking on.

From Press From Press Mar 19, 20146:32 pm

1st up, we have Sudaraka, who is a Solutions Architect at CAMMS.
He is going to talk on CLR integration with SQL.

From Press From Press Mar 19, 20146:30 pm

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.

Comments

comments

NO COMMENTS

Leave a Reply