Andy Levy

Information & Communications Technology

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

Rochester, New York, United States

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

Andy Levy

Database Administrator, dbatools fanatic, and transportation for @SqlHat

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 helping out with his son’s Boy Scout troop, making BBQ ribs for his daughter, or planning the next family vacation with his wife.

Andy's full speaker profile