Event Location:
Jose Rizal University
80 Shaw Boulevard
Mandaluyong City, , Philippines
Abstract:
In this session I'll discuss about the differences between SQL and NoSQL, what roles these data stores play in IT, social media, and mobile, and how to figure out which one you need to learn and use for your applications.
Speaker(s): Jon Limjap,
Abstract:
Indexes allow SQL Server to access your data in the most efficient manner. Understanding how SQL Server indexes work under-the-hood will give you insights on how to design effective indexing strategies. In this session, you will learn what indexes are, how they work, basic indexing strategies and how query performance is affected by indexes.
Speaker(s): Edwin Sarmiento,
Abstract:
Windows PowerShell is becoming the scripting language of choice for managing Microsoft servers and workstations. And while T-SQL is still the scripting language for DBAs to administer and manage SQL Server, there are tons of stuff that can be easily done with Windows PowerShell. In this session, learn Windows PowerShell from the ground up and how you can use it with SQL Server Management Objects (SMO) to administer and manage a SQL Server instance.
Speaker(s): Edwin Sarmiento,
Abstract:
It will discuss a different ways of doing an automated backup and restoring database based in a real world scenario.
Speaker(s): Jennifer Osorio,
Abstract:
When choosing the appropriate SQL Server HA/DR solutions, it is important to understand the SQL Server Transaction Log as it affects any solution you choose. In this session, we will look at transaction log basics, how logging and recovery works and how it affects all of the HA/DR solutions available in SQL Server. You'll be surprised to know that the transaction log is the most important part of your database.
Speaker(s): Edwin Sarmiento,
Abstract:
SQL Window Functions Overview SQL Server 2008 Functions SQL Server 2012 Functions Wrap Up
Speaker(s): Mark Nathaniel Ortigas,
Abstract:
Protect the data consistency using all of the tools you have available that is usually in a behind-the-scenes manner that the client doesn’t really have to worry about. Upon the end of the presentation, audience will be able to learn and decide what type of protection to use and where it is applicable.
Speaker(s): Henry Hutalle,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them."
Contact: http://dotnet.kapenilattex.com
Jon is a senior software developer for ITRS and Microsoft MVP for C#. Jon has been writing software professionally for more than a decade. Earlier in his career he made enterprise Microsoft .NET applications for desktop and web, but recently has been developing web and mobile applications using iOS, Java, HTML and Javascript. Jon has been active in the development community since the mid-2000s and is a member of PHINUG, PHISSUG, and the Devcon Foundation.
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them."
Jennifer is currently working as an Enterprise Database Administrator of Takecare Insurance Company, Inc. prior to that, she has worked under developer capacity on J2EE and ABAP systems with MySQL and SAPDB before she joined Fortune Tobacco Corporation where she gained experience working in SQL Server.
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them."
Implementation Project Manager for SAS Institute Philippines Data Management. Analytics. Visualization Robotics Process Automation Director and Technology Evangelist for SQL Technologies of www.phil-it.org.ph
Principal Developer with Magenic Manila
The following is a list of sponsors that helped fund the event.