More info of the event: here
Photo Album: here.
And we conclude this session with that note. Thanks for tuning in. Good Night.
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.
While using views, there are some commonly used methods.
Indexed View – Gogula
ensure that the data that you want is always there.
ensure schema changes do not break the view. – Gogula
A standard view does not increases data retrieval performance. – Gogula
Now Gogula takes over and will continue from there.
Use appropriate data types
maintain data integrity
break large tables into small ones
place on appropriate file group and file system – Dinesh
From database designing, Dinesh now is about to give you some pointers to consider while designing your TABLE.
Dinesh is explaining all the Database design considerations he would consider.
You can pass new DBs to existing DBs with updates in the new version. – Dinesh
Denormalization Dbs are to retrieve data from the DB. – Dinesh
There are set of rules which we should consider before designing the DB. Whether if it is a normalized one or a denormalized one.
We always try to optimize our db to the transaction. – Dinesh
Normalized vs de-normalized
Transaction and Concurrency
DB size and growth
location and system type
are the key focusing points Dinesh and Gogula will talk the most.
Dinesh and Gogula introduce themselves.
We are back.
before that we will go for a small refreshment break.
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.
Tuan’s slides will be uploaded to the .net forums facebook pages.
Tuan now takes questions.
MS also uses BLOB technology with their OneDrive service.
Knowing your customers geo location is very important. – Tuan
Tuan now is trying to run the DB from the actual Azure storage with an Emulator, on his Oracle VM VirtualBox.
Tuan now gets on to the second part of his presentation.
What is is a BLOB? (Binary Language OBject) Tuan asks.
Tuan is showing us a demo on how to create a DB and do a query on Windows Azure Platform.
data that needs to be queried together, must be kept together in the same partition. – Tuan
Azure storage explorer is one of the famous tools used to access your table properties.
In a same column, you can have different data types. Which isn’t allowed to do in a SQL enabled table. – Tuan.
Relationships aren’t allowed in Azure tables.
Rows are called entities in Azure table.
Azure has provided restfful APIs through which you can access your data.
Azure table is extremely simple, cost effective and highly scalable. – Tuan
Azure is a huge area to cover. Today we will be focusing on tables and blobs. – Tuan
Tables are non-relational structured data.
Tuan now shows a demo of creating a widows azure storage account.
You can use the Windows Azure storage services with a trial key or an organization pass.
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
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
Scalability is one of the key features of MS Azure. It allows us to increase the resources seamlessly. – Tuan
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
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
He will be talking about Windows Azure Storage, from scratch.
As the first speaker, we have Tuan from Navantis who is the Senior Software Engineer. This is his first public speech session.
Basith here, with the digit crew at Microsoft Sri Lanka Office for .Net User Group Meetup.
Good evening everyone.