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

Live Blog – SQL Server Sri Lanka User Group February Meetup

2597

We bring to you today, SQL Server Sri Lanka User Group February Meetup 2014.

Event info including the agenda and speaker profiles can be found here.

Stay tuned with us since the event will take off at 6 pm.

 

Video Full Coverage:

Photo Album on Facebook: here.

From Press From Press Feb 19, 20147:42 pm

This is digit team, signing off. Have a pleasant night.

From Press From Press Feb 19, 20147:41 pm

And with that, we call it a night.
Thanks for turning up with the Live Blog.

From Press From Press Feb 19, 20147:38 pm

Goodies were given away.
Gogula, before wrapping up the session takes some topic suggestions from the crowd for the next month session.

From Press From Press Feb 19, 20147:31 pm

And seems like Asanka is blank. So one of the organizers will be asking questions behalf of Asanka.

From Press From Press Feb 19, 20147:30 pm

Asanka concludes his demonstration as well.
It is now his time to ask question from the crowd.

From Press From Press Feb 19, 20147:22 pm

Asanka will now demonstrate all the new functions he just talked about with us.

From Press From Press Feb 19, 20147:21 pm

Throw –> which you can use to throw a custom message for your error messages to be displayed. – Asanka

From Press From Press Feb 19, 20147:16 pm

There is even a new function to get the last date of any month, which used to be a hassle in the past SQL versions. – Asanka

From Press From Press Feb 19, 20147:14 pm

‘CHOOSE” is a new function which allows you to pick something from any given options. – Asanka

From Press From Press Feb 19, 20147:10 pm

.Net CLR is used in both conversions of values and non-values. – Asanka

From Press From Press Feb 19, 20147:06 pm

‘cast’ and ‘convert’ functions will be able to convert a value into an integer? Asanka asks from the crowd.

From Press From Press Feb 19, 20147:03 pm

Fetch is the available function in SQL server 2012 to fetch a offset paging info of a particular database. – Asanka

From Press From Press Feb 19, 20147:02 pm

Asanka explaining about finding the trend in 2008 SQL server.

Image via @sqluniverse from twitter

From Press From Press Feb 19, 20147:01 pm

He says, in 2012 SQL server, it is very easy to find the function than 2008.

From Press From Press Feb 19, 20146:58 pm

Asanka talks about finding the trend in a given dataBase in both 2008 and 2012 versions.

From Press From Press Feb 19, 20146:57 pm

SQL Server 2012 introduces many new rich built-in functions that offer more solutions to common T-SQL challenges. Join Asanka as he takes you through key functions while explaining where they have to be used along with their pros and cons. – Asanka

From Press From Press Feb 19, 20146:57 pm

Understanding SQL Server 2012 Built-in Functions is the topic he is is about to talk to the crowd.

From Press From Press Feb 19, 20146:56 pm

We are back.

Next up, we have Asanka Padmakumara, a Senior BI Software Engineer from CAMMS.

From Press From Press Feb 19, 20146:42 pm

We will be having a real quick refreshments break before the second session. Be right back in 10 minutes. Stay tuned.

From Press From Press Feb 19, 20146:38 pm

With that quick and easy demo, Sadheera concludes his session.
He will ask couple of questions from the audience regarding his presentation, and will give away goodies.

From Press From Press Feb 19, 20146:34 pm

A common location also should be assigned to save the log files so that all the nodes can access. – Sadheepa

From Press From Press Feb 19, 20146:33 pm

You might as well want to have a full backup of your system before you carry on so that you can add more nodes as you carry on with your work. – Sadheepa

From Press From Press Feb 19, 20146:32 pm

Sadheepa is now onto showing us a shall demonstration with his virtual machines and servers.

From Press From Press Feb 19, 20146:26 pm

The database should be in fill recovery model.

Primary Data Storage centers and backup to the disaster data recovery center through windows server failover cluster. – Sadheepa

From Press From Press Feb 19, 20146:23 pm

Sadheera talks about Multi side FDI for HA and DR

From Press From Press Feb 19, 20146:20 pm

In SQL Server 2012, they have flexible design choices and groups available.

Popular Design patters are available as well.

From Press From Press Feb 19, 20146:17 pm

In a production environment, we don’t want to loose data.

Clustering, Mirroring and Replication are the methods which are the traditional ways of securing your data. – Sadheera

From Press From Press Feb 19, 20146:15 pm

This will focus on availability and disaster recovery and benefits over in newer versions of SQL server than old ones.

From Press From Press Feb 19, 20146:10 pm

Who will be talking on ‘Availability Enhancements in SQL Server 2012′.

SQL Server 2012 comes with different ways of overcoming server downtime. Join this session to learn about the enhancements that overcome issues in conventional availability approaches, and a demo on one such high availability design pattern.

From Press From Press Feb 19, 20146:09 pm

Our first speaker would be Sadheera Vithanage, Production DBA from Pearson Lanka.

From Press From Press Feb 19, 20146:08 pm

Agenda and more about the event is available here. http://digit.lk/event/ss-slug-february-2014-meet-up/

From Press From Press Feb 19, 20146:07 pm

We are just about to start. We will be get going once everything is set and good to go.

From Press From Press Feb 19, 20146:07 pm

Basith and digit team here, Live from Microsoft Office bringing live updates to you from ‘SQL Server, Sri Lanka User Group’ February Meetup for 2014.

From Press From Press Feb 19, 20146:06 pm

Hi everyone.

Comments

comments

NO COMMENTS

Leave a Reply