What we’re about
Welcome to the Triangle SQL Server User Group (TriPASS)! We are an active group of SQL Server professionals that meet monthly for formal presentations on many SQL Server topics. We cover everything from database design, development, deployment, performance, and IT support. We also Business Intelligence topics like data warehousing, reporting, ETL and Big Data. Visit us at our monthly meetings where our sponsors always provide us with free food and beverages. Many times we will have a raffle for books and other items provided by our sponsors.
Upcoming events (2)See all
- Memory Grant in Microsoft SQL ServerLink visible for attendees
When SQL Server executes a query, memory is required to store temporary data while rows are sorted or joined. This memory grant is controlled by the resource semaphore to avoid that a query monopolizes the whole memory for itself and thus all other queries must wait for their memory allocation. In this session, we will cover the different memory grants and its DOP and server memory dependency, the impact of the resource governor, spilling into tempdb as a result of missing memory, and finally the functionality of the memory grant feedback feature, which was introduced in SQL Server 2019. Thereby, we will also learn how to identify and optimize memory intensive queries to increase overall throughput.
- Principles of architecting a cloud data migrationNeeds location
Is your company planning to move your on-prem, hosted application to the cloud? Have you been asked to assess your on-prem data workload and design the new castle in the cloud?
1Designing the new castle is an important aspect but also it is more important to live happily in that castle once you migrate to the cloud. That’s where the art of architecting the operationalization aspect comes into play.
In this demo centric session, we will understand the fundamental building blocks of migrating on-prem SQL server workload to cloud via lift and shift or to Azure SQL/Managed Instance. We will build our hierarchy of needs checklist, a secured data migration plan and perform a sample migration to IaaS and PaaS Azure SQL databases keeping Data Security, Size, Performance, and Cost aspects in mind. By the end of this session, you will have a good idea on how to execute a secured and scalable cloud data migration solution.