A place to collect abstracts & links to presentations I’ve given.
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.
- Rochester SQL Server User Group, March 2019
- SQL Saturday #877 Boston, September 2019
Slides (may be out of date, see event website for the version presented at a given event)
dbatools for the Unintiated
You’ve just inherited a large SQL Server estate, and next month’s merger will double the number of instances you’re responsible for. Or maybe you have one big instance with thousands of databases on it. Are there backups? Are they good? Are your systems in good health?
The department just decided to reorganize and consolidate databases ahead of an upgrade to the next release of SQL Server. How are you going to manage all this?
It’s time to automate with the dbatools Powershell module. We’ll briefly talk about the project itself, then take a tour of functions commonly used to manage SQL Server environments and data. When you leave, you’ll be ready to level up your administration toolkit and start reducing your daily workload.
Andy is a SQL Server DBA, PowerShell fan, former developer, SQL Saturday organizer and user group leader. He’s been in IT full-time since 1999, doing web development, system integration, and presently database administration. 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.
Posts about speaking on flxsql.com