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 (3)

Analyzing Azure Monitor Log data for Azure Resources ~ Taiob Ali

Kusto is a service for storing and running interactive analytics over Big Data. Kusto was designed from scratch to be a “big data” repository for Azure and easy to query using Kusto Query Language (KQL). We learn new ways to monitor and alert resources and services as we migrate to the cloud. Microsoft has consolidated many services under the umbrella of ‘Azure Monitor.’ Whether you are detecting and diagnosing issues across applications and dependencies,’ ‘correlating infrastructure issues with Azure Monitor for VMs,’ ‘or drilling into your SQL database monitoring data with Log Analytics, you will be using ‘Azure Monitor.’ Azure Monitor uses a version of the KQL used by Azure Data Explorer.

In this 100% demo session, I will show an example with Azure SQL Database, which you can use for any Azure resource:
1. How to enable event logging (auditing and diagnostic) for the Azure SQL database?
2. How do you consume the data once you enable event logging?
3. How do you find anomalies to alert, establish a baseline, and look at trends?
4. How do you consume this data with python and kql notebook from Azure Data Studio using kql magic, kql kernel, and the recently released Azure Monitor Logs extension?

2
The Ins and Outs of SQL Server Data Compression ~ Bob Pusateri

While data compression is best-known for reducing a database's size on disk, it's also an effective tool for making your queries fly. Come see how reduced disk usage and increased performance mean that with compression, less really can be more! This session will arm you with the knowledge and understanding to capitalize on both of these aspects of SQL Server's row and page compression features, as well as columnstore and updateable columnstore indexes. We'll combine a lesson on the internals of compression with real-world scenarios to show you how to determine the most appropriate compression type for any situation. Since there's no such thing as a "free lunch" in computing, the drawbacks of these features will also be discussed.

Bio
Bob Pusateri is a Microsoft Data Platform MVP, Microsoft Certified Master, DBA, and systems architect with over 15 years experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is very active in the Chicago data platform community, and a frequent speaker at local, national, and international events.

Treating Tables Like Legos: Partitioning basics ~ Brandon Leach

Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!

With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata-only operations.

We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll also look at how partitioning affects things under the hood. Finally, you'll see some cool demos/tricks around index maintenance and data movement.

At the end of this session, you’ll have a firm understanding of how partitioning works and be able to make decisions on how and when to partition.

You'll learn…
• The components of table partitioning and how they fit together • How to make your index maintenance partition aware
• How Partition elimination can help your queries
• How to split different parts of tables over different storage tiers • How to manage partitions. We'll demo this by implementing the sliding window technique.

Find us also at