Loading…
DSLUG is the only event exclusively for Dynamics SL users, partners, and solution providers and you won’t want to miss it. With over 124 sessions in four days, you’ll have the opportunity to explore solutions and gain a deeper understanding of Dynamics SL. No matter how experienced you are or what version you’re using, you’re guaranteed to walk away with valuable tools and connections that you can leverage all year.

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

SQL [clear filter]
Tuesday, April 16
 

10:15am PDT

Disaster Recovery
What would happen if Dynamics was not operational in your organization?  How long could you be down?  What is your confidence level in your ability to recover from an issue?  We are going to review how to conduct an internal assessment of your readiness for a disaster and the key components you need to protect your self and your company from a disaster.

Speakers

Tuesday April 16, 2019 10:15am - 11:15am PDT
Elite 3
  SQL

10:15am PDT

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.
 
Learning Objectives: 
Be able to write basic select statements to fetch data from a Dynamics SL database.
Learn some of the pitfalls to avoid when starting out with SQL.



Speakers
avatar for Marc DeLozier

Marc DeLozier

Financial System Administrator, DEA



Tuesday April 16, 2019 10:15am - 11:15am PDT
Platinum 7
  SQL

11:30am PDT

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.

Speakers
avatar for Michael Lee

Michael Lee

President, IT Evolution Management, LLC
I provide Dynamics SL service and support to clients across the country, and I have worked with the product line since 1987.


Tuesday April 16, 2019 11:30am - 12:30pm PDT
Platinum 7
  SQL

3:00pm PDT

How Dynamics SL Uses SQL Server
You use Dynamics SL every day, but what do you know about the database engine behind the scenes? How does it store, retrieve, manipulate, validate, and secure the data? What’s the difference between a SQL Server and Windows login? What type of security does Dynamics SL use when launching an application? This session aims at helping accounting users who sometimes need to talk with the I.T. staff or a developer, and I.T. staff who would like to understand the technical basics of Dynamics SL.
Learning Objective
Understand what tables, views, and stored procedures are, and how they are used in Dynamics SL.

Speakers
avatar for Delmer Johnson

Delmer Johnson

President, SteadyCode
I've been customizing and integrating Dynamics SL with other systems for over 20 years. I've written lots of custom programs using the SL SDK with VB.Net, regular applications with C# and F#, and imported and exported with SSIS. I've worked with every major Dynamics SL module and... Read More →


Tuesday April 16, 2019 3:00pm - 4:30pm PDT
Platinum 4
  SQL

4:45pm PDT

SQL Toolbox: sharing SQL code
An interactive session sharing commonly used SQL code for various issues; working together to solve problems and gather the data we all need. 



Speakers
avatar for Malissa Oberle

Malissa Oberle

Apex Solutions USA
avatar for Paige Hodson

Paige Hodson

Consultant & Trainer, RTX Solutions


Tuesday April 16, 2019 4:45pm - 5:45pm PDT
Platinum 4
  SQL
 
Wednesday, April 17
 

8:30am PDT

SQL 301 - Advanced SQL queries
Take your SQL knowledge to the next level by learning how to use the APPLY operator, table-valued functions, SQL window functions, pivoting and unpivoting, common table expressions, table-value constructors, and more. We will show examples of useful queries in the Dynamics SL database. If you are comfortable writing SQL statements and want to learn some advanced methods, then this deep dive is for you!
 
CPE learning objective: Learn advanced techniques of SQL querying.



Speakers

Wednesday April 17, 2019 8:30am - 10:00am PDT
Elite 1
  SQL

10:15am PDT

SQL 401 - Expert SQL queries
Supercharge your advanced knowledge of T-SQL by learning techniques like dynamic SQL, the FOR XML clause, and advanced JOINs. We will cover some of the newer SQL Server functions such as TRY_CONVERT and FORMAT. All examples will be practical code using the Dynamics SL schema. We will also demonstrate some methods to make your SQL code perform better, including temporary intermediate tables, speed testing, and recasting. If you liked the SQL 301 session, you should be ready for SQL 401.
 
CPE learning objective: Learn some expert techniques to use with SQL queries.



Speakers
avatar for Jonathan Van Houtte

Jonathan Van Houtte

System Architect, XLstatements
I have been a Dynamics SL consultant for more than 30 years. I also consult on SQL Server and Excel. I am the principal designer ("System Architect") of the XLstatements for Dynamics SL financial reporting application.


SQL401 sql
SQL 401 pptx

Wednesday April 17, 2019 10:15am - 11:45am PDT
Elite 1
  SQL

4:00pm PDT

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 2017.
Learning Objective
Know how to have SQL Server send you an email when a backup job fails.

Speakers
avatar for Delmer Johnson

Delmer Johnson

President, SteadyCode
I've been customizing and integrating Dynamics SL with other systems for over 20 years. I've written lots of custom programs using the SL SDK with VB.Net, regular applications with C# and F#, and imported and exported with SSIS. I've worked with every major Dynamics SL module and... Read More →


Wednesday April 17, 2019 4:00pm - 5:00pm PDT
Elite 2
  SQL
 
Thursday, April 18
 

10:00am PDT

DBA topics: maintaining databases
Provide information on database maintenance best practices for the non DBAs.
Learning Objective: Learn top tips for Effective Database Maintenance.



Speakers
JL

Jeff Larson

Dynamics ERP Environment Specialist, Boyer & Associates
I have been installing, upgrading and providing technical support for Dynamics SL for 20 years.



Thursday April 18, 2019 10:00am - 11:00am PDT
Platinum 3
  SQL