# SQL

# SQL
CONTENT

...
...

The 5-Star GP System Administration Presentation

Let's discuss the best practices for GP deployment in these areas: GP Network Infrastructure, GP SQL Server Installs, SQL Configurations specific to GP, SQL Maintenance specific to GP and how to enhance performance of SQL Server with GP, GP User Security and Active Directory securities and how best to maintain, GP Application Configurations to enhance user experience, troubleshooting GP issues and how best to liaise between Accounting and IT! This session is geared for an audience with an intermediate skill set. This session will be available for CPE credits pending completion of session survey post event.

...
+1
...

Be A Lazy GP Admin - Automate Repetitive Tasks!

Are you or your small team charged with managing GP for an organization with lots of GP companies and similar tasks daily, weekly or monthly? If you're performing the same task more than once (ok twice) there's opportunity for automation because you have better things to do with your time!  I'm the sole admin for 49 GP databases and I'll show you how I use SQL to automagically open the GP fiscal period for a new month, run an automatic daily AR aging process and more across our entire GP enterprise. Participants will learn how to: 1.Create a SQL process to automatically open the new fiscal period for one or more GP companies; 2.Use SQL to automatically ‘age’ all accounts receivable customers daily; 3.Automatically generate an AR Aging and email it as an attachment directly from SQL This session is geared for an audience with an intermediate skill set. This session will be available for CPE credits pending completion of session survey post event.

...
+2
...

Easily Set Up an Azure SQL Warehouse with Azure Data Factory

How do you expand reporting when your GP SQL server is overloaded? Set up a new server...isnt that costly?  What if it was less than $100/month? Don't we need a SQL DBA? No, with Azure Data Factory it's easy for a business analyst with intermediate SQL skills to copy tables, transform data, and build sophisticated workflows. Power Platform offers similar capabilities, but you might need a full database where you can build views and stored procedures. In this session, we will walk you through the process of installing a gateway and programming all the logic from the Azure portal. This session is geared for an audience with an intermediate skill set. This session will be available for CPE credits pending completion of session survey post event.

...
+1
...

Intermediate Level DBA Topics: What's Happening?

This session covers the SQL Server Agent, with its Jobs and Alerts, along with newer features like Database Mail and Extended Events (which is replacing Profiler). You can use SQL Jobs to schedule SQL Scripts and Database Maintenance Plans. Alerts can notify you when jobs or maintenance plans fail. Extended Events can help troubleshoot and improve performance. Profiler preceded Extended Events but hasn’t advanced since 2008. What are some pros and cons of using the independent SQL Server Management Studio with any version from SQL Server 2008 through 2019. Learning Objective: Know how to have SQL Server send you an email when a backup job fails.                                                                                                                                                                                                                               This session will be available for CPE credits pending completion of session survey post event. Level: Intermediate

...
+1
...

Speed Demon SQL Server Reporting Services (SSRS)

Join us for this session to learn how to make your reports run efficiently and the benefits of utilizing SQL Server Reporting Services (SSRS). This session will be available for CPE credits pending completion of session survey post event. Level: Intermediate

...
+1
...

SQL 101 - Basic SQL Queries for Beginners

Learn enough basic SQL to retrieve data from your Dynamics SL database. We will focus on the select statement and joining tables together in one query. You will learn enough to use SQL with Quick Query, Excel, and reports. SQL 101 caters to those with no (or limited) SQL experience.  This session will be available for CPE credits pending completion of session survey post event. Level: Basic

...
+2
...

SQL 101 (GP)

For GP admins, there is often a need for some basic SQL skills and knowledge. You may not have an IT background, but with some light training you can find the details on how to navigate SQL Server Management Studio and perform some valuable SQL tasks. This session with give an overview of that navigation as well as cover some of those key SQL functions including backups and maintenance as well as the table structure and the intro to report writing with views. If you are a GP admin looking for additional SQL knowledge, this session is for you. This session is geared for an audience with a basic skill set. This session will be available for CPE credits pending completion of session survey post event.

...
+1
...

SQL 201 - Intermediate SQL Statements

Build on your basic knowledge of T-SQL queries to present Dynamics SL data in a useful and readable format.  We will use T-SQL string functions, data type conversions, and the LIKE operator with SQL SELECT statements to format, join, and filter Dynamics SL data. Upon completion of this session, participants should be able to: •     Build T-SQL queries to present Dynamics SL data in a useful and readable  format. •     Understand and use SQL string functions and data type conversions with Dynamics SL data. •     Understand and use the SQL LIKE operator when filtering Dynamics SL  data.         This session will be available for CPE credits pending completion of session survey post event. Level: Intermediate

...
+1
...

SQL Basics and SQL Views – Why Do I Need Them and Where Do I Use Them?

Leverage the power of SQL Server to create queries and reports from all of the data from GP.  This session will take a tour of Management Studio and walk through the basics of writing basic SQL queries and creating Views to be used in multiple locations in GP.  Topics will include using Management Studio, basic joins and functions, creating views, and using your views in Smartlist, Smartlist Builder, SQL Reporting Services, and any other reporting tool that you might use. This session is geared for an audience with a basic skill set. This session will be available for CPE credits pending completion of session survey post event.

...
+1
...

SQL Reporting Services and You, A Match Made in GP Heaven

SQL Reporting Services is Microsoft’s powerful reporting engine that can allow you to deploy reports to your entire organization.  With the integration of Power BI visuals, SSRS can be the one-stop shop for all of your reporting needs.  This session will look at the setup and deployment of SSRS in your organization and some report designing tips and tricks to take your reports beyond simple tables of data! This session is geared for an audience with a basic skill set. This session will be available for CPE credits pending completion of session survey post event.

...
+2
...

Streamlining Implementations with Virtual Entities

The cost of storage and API calls in the Common Data Service and Dynamics 365 can be a concern for many organizations. The good news is there are ways to reduce your cost for storage and for integrations by leveraging Virtual Entities. In this session we'll take a look at building a custom data provider that connects to Azure SQL and eliminates the need to push certain kinds of data out of your Azure hosted or on-prem databases and into the potentially more costly CDS storage for your Model Driven App to consume. The content of this session is geared toward an audience with advanced-level knowledge of the subject area.