This folder contains 138 articles

Spring 2022 AeriesCon

Session 990 - Aeries New Year Cycle – Rollover and Update from Aeries Web Version
Session Description This session will cover the Aeries New Year Cycle Rollover process. Topics include: procedures for preparing databases for rollover, cr...

Sat, Feb 26, 2022 at 9:21 PM

Session 990 - Aeries New Year Cycle Rollover
Session Description This session will cover this New year Cycle Rollover process. Topics include: procedures for preparing databases for rollover, creating...

Wed, Apr 6, 2022 at 12:29 PM

Session 1001 - Data Extracts & Automation
Description Attendees will be able to create new extracts for the purpose of integrating with third party vendors or to utilize in-house data projects. Imp...

Wed, Mar 9, 2022 at 8:08 AM

Session 1002 - SQL Query Advanced
Description Discuss and demonstrate good techniques for writing Stored Procedures, Functions, and ensuring queries are SARGable whenever possible. Show ...

Mon, Oct 18, 2021 at 1:37 PM

Session 1003 - Tips & Tools for Recovering from Data Outages, Mistakes, & More
Description Discuss prevention strategies, best practices, and disaster recovery plans that should be in place to help a DBA avoid major issues. Strategies...

Fri, Mar 11, 2022 at 1:29 PM

Session 1006 - Adventures in Automation
Session Description A journey through customization examples on a larger scale to see how far your ideas may go. Just how automated can we make bigger i...

Mon, Mar 7, 2022 at 5:46 PM

Session 1007 - Power BI
Session Description This session will give a brief intro to Aeries APIs, ways of integrating the API responses in Power BI, manipulating the datasets, esta...

Wed, Mar 9, 2022 at 12:10 PM

Session 1008 - Querying a REST API - Posh-AeriesApi
Session Description This session will discuss what makes an API special, different kinds of requests, how to utilize PowerShell to make API requests, insta...

Mon, Mar 7, 2022 at 2:50 PM