SQL Sever T-SQL PowerShell SQL Server DBA SQL Microsoft SQL Server
Rochester, New York, United States
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 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.