SQLSaturday #218 - Philippines 2013 3/9/2013 12:00:00 AM (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat218 Jose Rizal University 80 Shaw Boulevard Mandaluyong City , Philippines http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 3074 Edgewood Solutions, LLC Gold Sponsor http://www.mssqltips.com/ http://www.mssqltips.com/images/mslogo_113x60.gif 60 170 3085 Magenic Manila Silver Sponsor http://www.magenic.com http://magenic.com/Portals/0/images/manila.png 60 170 3184 Takecare Insurance Company Inc. Bronze Sponsor http://www.takecareasia.com/ http://www.takecareasia.com/wp/wp-content/uploads/2013/03/TakeCare170x60-01.jpg 60 170 3062 Data On Wheels - Steve Hughes Personal Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2013/02/data-on-wheels-1.png 40 100 3183 Julie Koesmarno Personal Sponsor http://www.mssqlgirl.com http://www.mssqlgirl.com/wp-content/uploads/2013/03/mssqlgirl_logo_text_small.jpg 40 100 13284 SQLSatruday 218 Database Administration Auditorium 3/9/2013 10:15:00 AM 3/9/2013 10:45:00 AM 13284 SQLSatruday 218 Database Administration Auditorium 3/9/2013 2:30:00 PM 3/9/2013 3:00:00 PM 13284 SQLSatruday 218 Developer Room 2 3/9/2013 10:15:00 AM 3/9/2013 10:45:00 AM 13284 SQLSatruday 218 Developer Room 2 3/9/2013 2:30:00 PM 3/9/2013 3:00:00 PM 13285 SQLSaturday 218 Developer Room 2 3/9/2013 12:00:00 PM 3/9/2013 1:15:00 PM 13285 SQLSaturday 218 Database Administration Auditorium 3/9/2013 12:00:00 PM 3/9/2013 1:15:00 PM 13286 SQLSaturday 218 Database Administration Auditorium 3/9/2013 7:30:00 AM 3/9/2013 8:30:00 AM 13286 SQLSaturday 218 Developer Room 2 3/9/2013 7:30:00 AM 3/9/2013 8:30:00 AM 13287 SQLSaturday 218 Developer Room 2 3/9/2013 4:15:00 PM 3/9/2013 5:30:00 PM 13287 SQLSaturday 218 Database Administration Auditorium 3/9/2013 4:15:00 PM 3/9/2013 5:30:00 PM 13339 Edwin Sarmiento Developer Room 2 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. 3/9/2013 9:00:00 AM 3/9/2013 10:15:00 AM 13499 Henry Hutalle Developer Room 2 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. 3/9/2013 1:15:00 PM 3/9/2013 2:30:00 PM 13500 Jennifer Osorio Database Administration Auditorium It will discuss a different ways of doing an automated backup and restoring database based in a real world scenario. 3/9/2013 9:00:00 AM 3/9/2013 10:15:00 AM 13883 Mark Nathaniel Ortigas Developer Room 2 SQL Window Functions Overview SQL Server 2008 Functions SQL Server 2012 Functions Wrap Up 3/9/2013 3:00:00 PM 3/9/2013 4:15:00 PM 14043 Edwin Sarmiento Database Administration Auditorium 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. 3/9/2013 1:15:00 PM 3/9/2013 2:30:00 PM 14064 Edwin Sarmiento Database Administration Auditorium 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. 3/9/2013 10:45:00 AM 3/9/2013 12:00:00 PM 14086 Jon Limjap Developer Room 2 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. 3/9/2013 10:45:00 AM 3/9/2013 12:00:00 PM