Andy Levy

Information & Communications Technology

SQL Sever T-SQL PowerShell SQL Server DBA SQL Microsoft SQL Server

Rochester, New York, United States

Andy Levy

Database Administrator & dbatools fanatic

Andy is a database administrator, PowerShell fan, former developer, Open Source contributor, SQL Saturday organizer and user group leader. He’s worn a number of IT hats since 1999 before landing in database administration, including web server administration and development, systems integration, and database development. When he isn’t picking queries apart and wrangling an unruly herd of databases, he can be found making BBQ ribs or planning the next family vacation with his wife.

Current sessions

Better, Safer SQL Queries from Powershell

If you're working with SQL Server from Powershell as a DBA, developer, analyst, or anyone else running queries, you've probably used functions like Invoke-SqlCmd or Invoke-DbaQuery. But depending on how you're building your queries, this can introduce errors into your data or even cause a huge security problem for the organization!

With the help of the dbatools module, I'll show you how to make these queries safer and at the same time, make them easier to work into your existing Powershell scripts.


Keys to a Healthy Relationship with SQL Server

Developers and DBAs have had a long, sometimes strained relationship. Some developers see DBAs as roadblocks standing in the way of getting their work shipped; some DBAs see developers as agents of chaos bent on ruining their perfect database environments.

In this talk designed for application and database developers, we’ll talk about why SQL Server behaves the way it does, common database and query design pain points, and how we look for them. With real-world examples and tales of troublesome T-SQL, past and present, you’ll start to get a picture of what to do and not to do in your applications. Along the way, you’ll learn how to build a better relationship with both SQL Server and the DBAs responsible for it.

Runtime approx. 60 minutes. Target audience is DBAs, developers, and anyone who writes SQL or does system design


Backup Basics with Powershell and dbatools

As DBAs, one of our top priorities is keeping the organization's data backed up and ready to be restored when needed. We also need to be prepared to answer questions about those backups. Do you have a standard backup process? Can you meet your recovery time requirements? Do you know the backups are good? Do you have documentation of your backup history and verification? Are you backing up your instance configuration as well as the databases themselves?

dbatools has a suite of versatile Powershell functions designed to help you answer those questions confidently and quickly. In this presentation filled with practical examples, we'll take a tour of the core dbatools functions for creating, restoring, and monitoring your backups, whether you're manging one instance or dozens of them.

Runtime is 75-90 minutes. Target audience is DBAs, Powershell experience is not necessary.


The Social Network in SQL Server

You’ve been told for years that it’s important to have a professional network. The community that has grown around SQL Server is one of the strongest and most supportive networks around for technical professionals. We’re more than acquaintances who see each other at meetups – we’re SQLFamily. This introduction to SQLFamily will help you learn where to find folks, how to get involved, and how it can positively change your life and career.

Approx. runtime 30 minutes