Home latest news SQL Server Sri Lanka User Group January Meetup

SQL Server Sri Lanka User Group January Meetup

2584

A new year filled with data, good wishes and SQL Server! Kicking things off this year at the SS SLUG, are two SQL Server MVPs with sessions on data mining and database development.

More info on the event, including the Agenda can be found here. http://digit.lk/event/ss-slug-january-2014-meet-up/

 

From Press From Press Jan 22, 20148:22 pm

Good Night.
Team digit, off for now.
Catch you all tomorrow.

From Press From Press Jan 22, 20148:21 pm

Since we are running a little behind schedule, we would like to wrap this up real quick.

From Press From Press Jan 22, 20148:20 pm

Okay folks. thanks for turning up with the Live Blog.

From Press From Press Jan 22, 20148:17 pm

That’s the end of this session.
Gogula will now take question.

From Press From Press Jan 22, 20148:06 pm

In a transaction database, a deadlock happens when two processes each within its own transaction updates two rows of information but in the opposite order. – Gogula

From Press From Press Jan 22, 20147:59 pm

A transaction is something which should have the following properties: atomic, consistent, isolated, and durable. – Gogula.

From Press From Press Jan 22, 20147:55 pm

No matter how correct and precise your code is, some setting tend to screw things up. alwats keep an eye. – Gogula

From Press From Press Jan 22, 20147:51 pm

Error handling is the next topic we are about to discuss with Gogula.
Easiest methods is the Transaction for data modifications. – Gogula.

From Press From Press Jan 22, 20147:48 pm

Gogula carries on with his demonstration.

From Press From Press Jan 22, 20147:44 pm

There re few misconceptions people have about SQL Server. And Gogula is ridding them out..

From Press From Press Jan 22, 20147:40 pm

If wrong assumptations are taken while coding defensively, those assumptions should be corrected. One good way of doing this is via testing the code. – Gogula

From Press From Press Jan 22, 20147:38 pm

Gogula now quickly gets to his laptop and starts the demo he has to present.

From Press From Press Jan 22, 20147:36 pm

Gogula will be continuing from where he left off from November’s session, Gogula will guide you through writing better T-SQL code that is more resilient to unexpected issues and common code failures. This session is based on the book Defensive Database Programming by Alex Kuznetsov.

From Press From Press Jan 22, 20147:34 pm

Programming Defensively is the fist thing in his session he is going to talk about.

Define and understand assumptions
test as many use cases as possible
modulalize into fully testable and fully tested code
reuse code when feasible – Gogula

From Press From Press Jan 22, 20147:31 pm

Gogula will talk to us today on Writing Resilient T-SQL Code – Part II.

He encourages everyone to try out the stuff what is about to be demonstrated here.

From Press From Press Jan 22, 20147:29 pm

We are back.
Next up, we have Gogula G. Aryalingam, who is a Technical Architect at Navantis.

From Press From Press Jan 22, 20147:17 pm

Keep an eye at this space.

From Press From Press Jan 22, 20147:16 pm

Now we break for a small refreshment break for about 10 minutes and we will be back for the 2nd session.

From Press From Press Jan 22, 20147:16 pm

And with that note, Dinesh Asanka concludes his session.

From Press From Press Jan 22, 20147:14 pm

Dinesh will take question now.
And since no one has questions for him, he asks some questions for which there are gifts up for grabs.

From Press From Press Jan 22, 20147:10 pm

Dinesh now shares some reference sites with the audience.

From Press From Press Jan 22, 20147:02 pm

Limitations in Naive Bayes

Attributes are independent from each other
Continuous attributes cannot be used

From Press From Press Jan 22, 20146:59 pm

There are some parameters for this algorithm, such as

-Maximum input attributes
-Maximum states

From Press From Press Jan 22, 20146:49 pm

Mostly we use Naive Bayes Databases and data mining to predict our data and to build modules. – Dinesh

From Press From Press Jan 22, 20146:44 pm

Attributes are very critical to define your predictions. – Dinesh

From Press From Press Jan 22, 20146:41 pm

Since the Databse Dinesh was working on has some errors, we move on. He now shows us another actual research database used by the US government to predict the vote casting patterns for democratic and non democratic parties.

From Press From Press Jan 22, 20146:35 pm

Seems like there is an error. Dinesh gives another try at the procedure.

From Press From Press Jan 22, 20146:33 pm

Let the Data mining start.

From Press From Press Jan 22, 20146:31 pm

He already has an old database which he could use for this demo he says.

Now he selects the attributes which he thinks are relevant to this particular database to mine and predict data.

From Press From Press Jan 22, 20146:26 pm

Dinesh is getting ready to show us a small demonstration on the NB Database, where the Database will predict the potential targeted male customers for a Bike purchasing.

From Press From Press Jan 22, 20146:22 pm

This algorithm consumes less computational intense.
In NB algorithm, it will not count interrelated attributes together. – Dinesh

From Press From Press Jan 22, 20146:16 pm

The MS Naive Bayes is based on the Bayes Theorem. – Dinesh

From Press From Press Jan 22, 20146:16 pm

What is a Naive Bayes?

Naive Bayes model will tell you how your attributes are related to each other. – Dinesh.

From Press From Press Jan 22, 20146:15 pm

Catch Dinesh’s writing at his own blog http://www.dbfriend.net/

From Press From Press Jan 22, 20146:14 pm

To start off the proceeding s for tonight, Dinesh Asanka (MVP), Database Specialist Pearson Lanka will take the stage now.
He is about to talk on Business Intelligence (Data Mining).

From Press From Press Jan 22, 20146:12 pm

Catch the conversation on Twitter, under #SQLServerMeetup hashtag.

From Press From Press Jan 22, 20146:11 pm

We are setting up till the speakers are all set, the crowd is all present.

Stay tuned with us for more time to time latest updates.

From Press From Press Jan 22, 20146:10 pm

Agenda for the evening.

Session #1: Predictive Modeling with the Microsoft Naïve Bayes algorithm
===============================================
Join this session where Dinesh showcases the capabilities of predictive analysis using the Microsoft Naïve Bayes algorithm. Naïve Bayes is a classification algorithm that ships with SQL Server Analysis Services and is used to mine for and predict outcomes based on selected parameters.

CATEGORY: Business Intelligence (Data Mining)
SPEAKER: Dinesh Asanka (MVP), Database Specialist (Pearson Lanka)
Blog: http://www.dbfriend.net/

https://www.facebook.com/dinesh.asanka

DURATION: 45 minutes approx.

Session #2: Writing Resilient T-SQL Code – Part II
================================
Continuing from where he left off from November’s session, Gogula will guide you through writing better T-SQL code that is more resilient to unexpected issues and common code failures. This session is based on the book Defensive Database Programming by Alex Kuznetsov.

CATEGORY: Development
SPEAKER: Gogula G. Aryalingam (MVP), Technical Architect (Navantis)
Blog: http://dbantics.wordpress.com/
DURATION: 45 minutes approx.

From Press From Press Jan 22, 20146:10 pm

Team diGIT is Live and running from the event, SQL Server Sri Lanka User Group January Meetup.

Comments

comments

NO COMMENTS

Leave a Reply