Home Events Live Blog – Sri Lanka .Net User group Meetup

Live Blog – Sri Lanka .Net User group Meetup

2559

More info of the event: here

 

Full Video:

 

Photo Album: here.

 

From Press From Press Mar 6, 20148:27 pm

And we conclude this session with that note. Thanks for tuning in. Good Night.

From Press From Press Mar 6, 20148:25 pm

Gogula is still going on with his considerations to optimize the queries.

Since we are running out of time, Gogula is wrapping it up for now.

From Press From Press Mar 6, 20148:09 pm

While using views, there are some commonly used methods.

sp_refreshview
ORDER BY
Nested View
Indexed View – Gogula

From Press From Press Mar 6, 20148:02 pm

ensure that the data that you want is always there.

ensure schema changes do not break the view. – Gogula

From Press From Press Mar 6, 20148:00 pm

A standard view does not increases data retrieval performance. – Gogula

From Press From Press Mar 6, 20147:59 pm

Now Gogula takes over and will continue from there.

From Press From Press Mar 6, 20147:50 pm

Use appropriate data types
maintain data integrity
break large tables into small ones
place on appropriate file group and file system – Dinesh

From Press From Press Mar 6, 20147:48 pm

From database designing, Dinesh now is about to give you some pointers to consider while designing your TABLE.

From Press From Press Mar 6, 20147:43 pm

Dinesh is explaining all the Database design considerations he would consider.

From Press From Press Mar 6, 20147:37 pm

You can pass new DBs to existing DBs with updates in the new version. – Dinesh

From Press From Press Mar 6, 20147:31 pm

Denormalization Dbs are to retrieve data from the DB. – Dinesh

From Press From Press Mar 6, 20147:31 pm

There are set of rules which we should consider before designing the DB. Whether if it is a normalized one or a denormalized one.

From Press From Press Mar 6, 20147:29 pm

We always try to optimize our db to the transaction. – Dinesh

From Press From Press Mar 6, 20147:27 pm

DB types
DB models
Normalized vs de-normalized
Transaction and Concurrency
Security
DB size and growth
location and system type

are the key focusing points Dinesh and Gogula will talk the most.

From Press From Press Mar 6, 20147:25 pm

Dinesh and Gogula introduce themselves.

From Press From Press Mar 6, 20147:23 pm

We are back.

From Press From Press Mar 6, 20147:14 pm

before that we will go for a small refreshment break.

From Press From Press Mar 6, 20147:12 pm

Next up, we have Dinesh and Gogula, MS MVPs who will be talking and sharing their thoughts about the Mantras about Databases for a software engineer.

From Press From Press Mar 6, 20147:09 pm

Tuan’s slides will be uploaded to the .net forums facebook pages.

Tuan now takes questions.
He concludes.

From Press From Press Mar 6, 20147:06 pm

MS also uses BLOB technology with their OneDrive service.

Knowing your customers geo location is very important. – Tuan

From Press From Press Mar 6, 20147:02 pm

Tuan now is trying to run the DB from the actual Azure storage with an Emulator, on his Oracle VM VirtualBox.

From Press From Press Mar 6, 20146:54 pm

Tuan now gets on to the second part of his presentation.

What is is a BLOB? (Binary Language OBject) Tuan asks.

From Press From Press Mar 6, 20146:49 pm

Tuan is showing us a demo on how to create a DB and do a query on Windows Azure Platform.

From Press From Press Mar 6, 20146:42 pm

data that needs to be queried together, must be kept together in the same partition. – Tuan

From Press From Press Mar 6, 20146:41 pm

Azure storage explorer is one of the famous tools used to access your table properties.

From Press From Press Mar 6, 20146:39 pm

In a same column, you can have different data types. Which isn’t allowed to do in a SQL enabled table. – Tuan.

From Press From Press Mar 6, 20146:37 pm

Relationships aren’t allowed in Azure tables.

Rows are called entities in Azure table.

From Press From Press Mar 6, 20146:32 pm

Azure has provided restfful APIs through which you can access your data.

Azure table is extremely simple, cost effective and highly scalable. – Tuan

From Press From Press Mar 6, 20146:30 pm

Azure is a huge area to cover. Today we will be focusing on tables and blobs. – Tuan

Tables are non-relational structured data.

From Press From Press Mar 6, 20146:27 pm

Tuan now shows a demo of creating a widows azure storage account.

From Press From Press Mar 6, 20146:26 pm

You can use the Windows Azure storage services with a trial key or an organization pass.

From Press From Press Mar 6, 20146:22 pm

MS Azure allows you 3 options as a backup. Your data will be backed up to another server too in a different geo location in case if one of the locations hits a natural incident or something like that. – Tuan

From Press From Press Mar 6, 20146:17 pm

These Clod storage centers are rapidly increasing as well. Recently they opened a new location in Japan as well.

Focus on region. It makes more sense. – Tuan

From Press From Press Mar 6, 20146:16 pm

Scalability is one of the key features of MS Azure. It allows us to increase the resources seamlessly. – Tuan

From Press From Press Mar 6, 20146:15 pm

Azure is an automated service. As developers, we should develop apps than waiting for proper infrastructure. But MS Azure provides this feature including MS security. – Tuan

From Press From Press Mar 6, 20146:13 pm

Tuan will be focusing on why people use Windows Azure Storage? Why Clouds and why some dont use it.

Azure is the Cloud competing service provided by Ms. – Tuan

From Press From Press Mar 6, 20146:10 pm

He will be talking about Windows Azure Storage, from scratch.

From Press From Press Mar 6, 20146:10 pm

As the first speaker, we have Tuan from Navantis who is the Senior Software Engineer. This is his first public speech session.

From Press From Press Mar 6, 20146:09 pm

Basith here, with the digit crew at Microsoft Sri Lanka Office for .Net User Group Meetup.

From Press From Press Mar 6, 20146:08 pm

Good evening everyone.

Comments

comments

NO COMMENTS

Leave a Reply