SQLSaturday #218 - Philippines 2013
Event Date: 03/09/2013 00:00:00
Event Location:
- Jose Rizal University
- 80 Shaw Boulevard
- Mandaluyong City,Philippines
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL vs. NoSQL - Data in the world of social media
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
Track and Room: Developer - N/A
Title: SQL Server Index Internals
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
Track and Room: Developer - N/A
Title: Windows PowerShell for the SQL Server DBA
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
Track and Room: Database Administration - N/A
Title: Different ways of SQL Server Backup and Restoring
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
Track and Room: Database Administration - N/A
Title: The Transaction Log and How It Affects HA/DR
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
Track and Room: Database Administration - N/A
Title: Using SQL Window Functions
Abstract: SQL Window Functions Overview SQL Server 2008 Functions SQL Server 2012 Functions Wrap Up
Speaker(s):
- Mark Nathaniel Ortigas
Track and Room: Developer - N/A
Title: SQL Tools for Maintaining Data Integrity
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
Track and Room: Developer - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Edwin Sarmiento
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.”
Jon Limjap
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.
Edwin Sarmiento
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 Osorio
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.
Edwin Sarmiento
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.”
Henry Hutalle
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
Mark Nathaniel Ortigas
Principal Developer with Magenic Manila
Sponsors
The following is a list of sponsors that helped fund the event: