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.
This is digit team, signing off. Have a pleasant night.
And with that, we call it a night.
Thanks for turning up with the Live Blog.
Goodies were given away.
Gogula, before wrapping up the session takes some topic suggestions from the crowd for the next month session.
And seems like Asanka is blank. So one of the organizers will be asking questions behalf of Asanka.
Asanka concludes his demonstration as well.
It is now his time to ask question from the crowd.
Asanka will now demonstrate all the new functions he just talked about with us.
Throw –> which you can use to throw a custom message for your error messages to be displayed. – Asanka
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
‘CHOOSE” is a new function which allows you to pick something from any given options. – Asanka
.Net CLR is used in both conversions of values and non-values. – Asanka
‘cast’ and ‘convert’ functions will be able to convert a value into an integer? Asanka asks from the crowd.
Fetch is the available function in SQL server 2012 to fetch a offset paging info of a particular database. – Asanka
Asanka explaining about finding the trend in 2008 SQL server.
Image via @sqluniverse from twitter
He says, in 2012 SQL server, it is very easy to find the function than 2008.
Asanka talks about finding the trend in a given dataBase in both 2008 and 2012 versions.
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
Understanding SQL Server 2012 Built-in Functions is the topic he is is about to talk to the crowd.
We are back.
Next up, we have Asanka Padmakumara, a Senior BI Software Engineer from CAMMS.
We will be having a real quick refreshments break before the second session. Be right back in 10 minutes. Stay tuned.
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.
A common location also should be assigned to save the log files so that all the nodes can access. – Sadheepa
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
Sadheepa is now onto showing us a shall demonstration with his virtual machines and servers.
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
Sadheera talks about Multi side FDI for HA and DR
In SQL Server 2012, they have flexible design choices and groups available.
Popular Design patters are available as well.
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
This will focus on availability and disaster recovery and benefits over in newer versions of SQL server than old ones.
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.
Our first speaker would be Sadheera Vithanage, Production DBA from Pearson Lanka.
Agenda and more about the event is available here. http://digit.lk/event/ss-slug-february-2014-meet-up/
We are just about to start. We will be get going once everything is set and good to go.
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.