Abstract
Due to varying definitions of Big Data, which confuse data volume and organization, the common perception is that Big Data requires using Hadoop, MongoDB, or another NoSQL database. SQL Server can easily store and manipulate large volumes of data and perform very well — provided the database is set up and tuned correctly. In this session, we’ll cover some of the definitions and misconceptions of Big Data, look at some Big Data solutions that went wrong, and review a case where Big Data was successfully implemented in SQL Server. Finally, we’ll look under the covers to see how SQL Server best handles Big Data through proper data models, table designs, performance tuning, and T-SQL techniques.
Presented at:
- Utah Data Engineers Meetup, Draper, UT on Oct 18, 2023
- SQL Saturday #946, Ft. Lauderdale, FL on Feb 22, 2020
- SQL Saturday #733, Atlanta, GA on May 19, 2018
- Saturday Night SQL, Virtual Chapter on March 10, 2018
- PASS Summit 2017, Seattle, WA on November 3, 2017 (video)
- CincyPASS, Cincinnati, OH on July 18, 2017
- Ohio North SQL User’s Group, Cleveland, OH on May 2, 2017