Geek Sync Webcast : Practical PowerShell For The Busy DBA
Many DBAs don’t have time to learn PowerShell. Thankfully, there is an excellent PowerShell library already created specifically for handling many of the tasks that SQL Server DBAs regularly perform, and you will be surprised at just how easy it is to use! How would you like to be able to patch all, or just a few, of your SQL Servers by calling 1 command? What about backing up and restoring multiple databases to your Dev and QA environments with a single click? Do you need to migrate all of your logins, or SQL Agent jobs, from one server to another? There’s a simple command for that. You can even have a single script that configures a new server in minutes, or ensures your existing servers match your desired configuration. In this Geek Sync, Eric Cobb will show you just how easy it is to use the dbatools PowerShell module, and take PowerShell from a “Nice To Have” to “I Must Have That!”
After a 14-year programming career as a web and software developer, Eric Cobb decided to move full time into the world of databases and became a SQL Server database administrator. He earned 2 SQL Server MCSE certifications along the way, and now manages a team of SQL Server professionals. Eric regularly presents and blogs about SQL Server, with a focus on teaching database administration and design concepts to the developer community. He frequently speaks at Developer and Database conferences throughout the country. In 2019 Eric was selected to be a 2020 IDERA ACE, for showing a passion in helping the developer community and sharing his knowledge.
24X7 SQL performance monitoring, alerting and diagnostics
- Monitor performance for physical, virtual, and cloud environments.
- Monitor queries and query plans to see the causes of blocks and deadlocks.
- Monitor application transactions with SQL Workload Analysis add-on.
- View expert recommendations from SQL Doctor to optimize performance.
- Alert predictively with settings to avoid false alerts.
- View summary of top issues and alerts with the web console add-on.