October 2019 PSSUG Meeting

Event Information

Share this event

Date and Time

Location

Location

Microsoft Corporation

45 Liberty Boulevard

Malvern, PA 19355

View Map

Event description

Description


-->> This Month We Are Back At Microsoft <<--


Agenda


We have two exciting sessions this month. Our first session is by Emmanuel Emore who is presenting for the first time. Join us to show him some support. The second session is by Formulus Black and is diving into an in-memory storage appliance that goes beyond what comes built-in with SQL Server.

SESSION 1:

Emmanuel Emore – Backup and Restore in SQL Server Database.

Abstract:

Backing Up and Restoring SQL Databases.

· What is Database Backup

· Importance of Backup

· Types of Backup

  • Full
  • Differential
  • Transaction Log
  • Filegroup
  • Mirror

Testing Backup

· Restoring Backup

  • Full Restore
  • Differential
  • Transaction Log
  • Page Level Restore

· Backup and Restore Commands

· Backup Tools

  • Third Party
  • Open Source

Bio:

Emmanuel Emore is a Microsoft SQL DBA since 2007. First as a production support DBA with TD Bank from 2007 to 2013 and recently Pinnacle Foods from 2013 to July of 2019. Before that, I worked mostly as a developer/analyst from 1990 to 2013 with various organizations. I first started working with SQL 2000 in 2001 as a Management System Analyst with South Jersey Industries in Folsom, NJ.

I have a BA in Economics and a BS in Computer Science from Glassboro State College, now Rowan University. I also have a MS in Computer Information System the University of Phoenix.



SESSION 2:

Formulus Black - High-Performance SQL Server through Forsa In-Memory Technology

Please Join Formulus Black to learn how to Dramatically Increase Performance by running SQL Server IN-Memory!

Forsa is a memory-based storage technology enabling you to accelerate the performance of I/O intensive applications. Unlike legacy solutions that rely on peripheral storage, Forsa enables server memory to be easily provisioned & managed as a high-performance block storage media. Forsa is for software leaders who are running I/O intensive, latency-sensitive SQL Server and other applications & need the fastest storage solution commercially available.

Additional Benefits

  • Read & Write to Memory with a cost-effective and simple solution

  • Run SQL Server and other I/O intensive applications on high-performance memory-based storage vs. on traditional peripheral-bound storage

  • No modifications to SQL Server required

  • Achieve dramatically higher transactions per second, lower latency, and reduce the number of CPU cores and the associated 3rd party software license costs all at the same time.

Share this event on Facebook and Twitter.

We hope you can make it!

Sponsor


Date and Time

Location

Microsoft Corporation

45 Liberty Boulevard

Malvern, PA 19355

View Map

Save This Event

Event Saved