What we’re about
The New England SQL Server User Group, a member of the Azure Data Community, is one of the oldest user groups focused on the Microsoft Data Platform. Our meetings feature high-quality presentations on all aspects of the database engine and its related features wherever the data lives - on prem, in the cloud, or in a hybrid environment.
We strive to have an inclusive environment with speakers of all backgrounds represented. We also support and encourage our local community members getting started as speakers by providing opportunities to speak at the meetings. Our goal is to create a welcoming environment for all to network, grow and learn with others.
This is a FREE group that meets the second Wednesday of every month (usually). We meet at the Microsoft offices at 5 Wayside Road, Burlington, MA. RSVPs generally open up 1 week prior to the meeting. An email will be sent out announcing the meeting. We look forward to seeing you.
NESQL Code of Conduct: https://www.meetup.com/NESQLUG/pages/30525259/NESQL_Code_of_Conduct/
Upcoming events (4+)See all
- Brent Ozar: Mastering Query Tuning (Full day in-person)Microsoft, Burlington, MA
All-day in-person SQL Saturday Boston pre-con by Brent Ozar.
Mastering Query Tuning - Live!
When indexes alone aren't enough, and every second counts.Not open
- SQL Saturday Boston October 14th, 2023Microsoft, Burlington, MA
SQL Saturday is a one-day IN-PERSON free training event for people that work with the Microsoft Data Platform
This is a free event for the tech community organized by SQLSatuday and New England SQL Server User Group (NESQL)
We encourage you to register early. If your plans change please cancel your registration so that others can attend.
Friday, October 13th, 2023.
Full-Day Pre-Con: Brent Ozar: Mastering Query Tuning
Register at https://training.brentozar.com/p/mastering-query-tuning-live
Saturday, October 14th, 2023.
The schedule is published: https://sqlsaturday.com/2023-10-14-sqlsaturday1046/
8:00 AM: Check-in is open. Enjoy coffee, tea, and pastry while you visit with our great sponsors and socialize with your peers.
8:45 AM: Event starts. Coffee and pastry are provided
12:10 PM: Lunch break. Lunch and the afternoon snack are provided
1:30 PM: Sessions resume.
5:00 PM: End of Day Gathering & Raffles
Register at https://www.eventbrite.com/e/sql-saturday-boston-2023-tickets-515858234867Not open
- Control your data lake with Databricks SQL Warehouse ~ John MinerMicrosoft, Burlington, MA
Many companies are migrating their data to the cloud. Files are typically classified as containing unstructured, semi structured, and structured data. A data warehouse is best suited to working with structured data while a data lake can store all three. What if
you can use one product to work with all
three types of data?
Azure Databricks SQL Warehouse is an
interface that makes the spark cluster look
like a SQL database. In general, the syntax
is compliant with the core ANSI SQL
language. However, additional features are
available for working with remote storage,
loading files into delta tables, and managing
the hive catalog. Last but not least, SQL
queries can be visualized and combined
At the end of this talk, you will have a good
understanding of the Azure Databricks SQL
- That’s So Metadata: Discover Your Database From the Inside ~ Rob VolkMicrosoft, Burlington, MA
Have you ever needed to learn a new database design and don’t know where to begin? Or are trying to find out why a query doesn’t perform well? Or need to provide security information to auditors or your security team? SQL Server has a number of metadata facilities available to help you with these tasks, and more. Functions, dynamic management views, and system stored procedures can illuminate details from the smallest column up through an entire SQL Server instance and everything in-between. We will demonstrate metadata techniques to help you: Document your database schema objects such as procedures, functions, tables, columns and indexes Investigate performance and look for bottlenecks Discover metadata to administer your databases backups, index maintenance, and security Apply your own metadata using extended properties