sqlsathistory

Nr: 218

Back to Main list

SQLSaturday #218 - Philippines 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Edwin Sarmiento	Developer	SQL Server Index Internals
00:00:00	Edwin Sarmiento	Database Administration	Windows PowerShell for the SQL Server DBA
00:00:00	Edwin Sarmiento	Database Administration	The Transaction Log and How It Affects HA/DR
00:00:00	Henry Hutalle	Developer	SQL Tools for Maintaining Data Integrity
00:00:00	Jennifer Osorio	Database Administration	Different ways of SQL Server Backup and Restoring
00:00:00	Jon Limjap	Developer	SQL vs. NoSQL - Data in the world of social media
00:00:00	Mark Nathaniel Ortigas	Developer	Using SQL Window Functions

SessionID: 10119

SQL Server Index Internals

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Edwin Sarmiento

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.

SessionID: 10122

Windows PowerShell for the SQL Server DBA

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Database Administration

Speaker: Edwin Sarmiento

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.

SessionID: 10123

The Transaction Log and How It Affects HA/DR

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Database Administration

Speaker: Edwin Sarmiento

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.

SessionID: 14962

SQL Tools for Maintaining Data Integrity

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Henry Hutalle

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.

SessionID: 16522

Different ways of SQL Server Backup and Restoring

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Database Administration

Speaker: Jennifer Osorio

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.

SessionID: 17349

SQL vs. NoSQL - Data in the world of social media

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Jon Limjap

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.

SessionID: 19678

Using SQL Window Functions

Back to calendar

Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Mark Nathaniel Ortigas

Title: Using SQL Window Functions

Abstract:

SQL Window Functions Overview

SQL Server 2008 Functions SQL Server 2012 Functions Wrap Up

This site is open source. Improve this page.