Ohio North SQL Server User Group

Choose a meeting below to view its details


Tuesday,

November

03

ONSSUG November Meeting

  • In-Person @ 6050 Oak Tree Blvd. Independence, Ohio, United States (map)
  • 17:00 - 20:00 (UTC-05:00) Eastern Time (US & Canada)
  • Language: English


ATTENTION: Due to construction at the Microsoft offices, this month's meeting will be held on the lower level, rather than Suite 300.


RSVP: https://www.eventbrite.com/e/onssug-november-meeting-tickets-19346467806


5:00 - 6:00 - Pre-Session Video:  ETL Recovery and Rollback (John Welch)

So your ETL process is humming along, loading your data warehouse night after night. Then one day, your manager comes in and announces "That business rule change we put in last month? The business wants it reverted and all the data updated since the change needs to be fixed. And they want it done tomorrow." What do you do? During this session, we'll discuss several methods for handling scenarios that require you to redo work in your data warehouse. We'll cover both recovering from failed loads and rolling back changes that completely successfully, but later need to be reverted. We'll demonstrate how you can use SSIS in conjunction with SQL Server database engine features to build support for this into your ETL framework. We'll also show the process for actually recovering in these scenarios.

6:00 - 6:15 - Opening & Announcements

6:15 - 7:30 - Feature Presentation:  DQ What? DQ Who? DQ How? (Brian Davis)

Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question..."What is the quality of our data?". A business runs off of it's data and if that data isn't complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We'll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we'll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.

Sponsor:  Pure Storage

Our data storage company believes in flash. Your IT experience should be as fast as Google and as intuitive as the iPhone. Your data center should enable incredible productivity. And the fastest storage should be available to every application, every organization, every budget. This is why Pure Storage believes in the power of an all-flash data center.

The Pure Storage all-flash array doesn’t inhibit the growth of your business—it accelerates it. It’s as simple as that.

A new way to do Flash. Flash has brought speed and efficiency to every aspect of computing: smart phones, web searches, social media, and more. But cost has kept the broad deployment of flash out of the data center. Pure Storage changes this through an entirely new platform. The best attributes of flash memory. The most advanced operating system in enterprise flash. And the greatest hardware architecture ever designed for enterprise flash applications.

Featured Presentation:

DQ What? DQ Who? DQ How?

Brian Davis, Product Integration Engineer SentryOne

Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question..."What is the quality of our data?". A business runs off of it's data and if that data isn't complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We'll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we'll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.

About Brian:
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids