Monday May 21st 6:00 PM - Columbus Public Library
All About Execution Plans
Come see Jonathan Boulineau show how to dissect an execution plan. Execution plans hold excellent information to help tune your SQL Server queries. Learn how the click of a button within SSMS can unlock a treasure trove of information. Whether you have never viewed an execution plan or if you have a great deal of experience, you are sure to learn some new tips and tricks.
Our sponsor for the evening is DBA24HRS. DBA24HRS will be doing a short demo of DBLaunch, a tool that can automate many daily DBA tasks. Whether you are in the market for such a tool or not, you are sure to pick up some valuable information.
About DBLaunch Presentation:
HIGH LEVEL OVERVIEW of DBLaunch Software:
• Remove all your mundane day-to-day repeatable activities
• Pushing out patches/hotfixes
• Installation of SQL server and service pack deployments
• Running T-SQL scripts against multiple servers
• Pushing out DB configuration across multiple servers (i.e tempdb)
• Standardize installations of SQL Server, all versions
• Upgrade multiple instances at one time with customizable workflow options
• Easily migrate multiple databases with all logins, users and passwords
• Deploy SQL scripts, programs and utilities across multiple instances and servers
• Monitor and administrate your SQL Server environment with the daily dashboard reports
• Setup database mirroring and log shipping for multiple databases at one time
• Audit your SQL environment your way with easy integration of your scripts
• Restoring DBs and re-syncing logins
• Developers requesting restores from Prod to Dev
• Resync permissions at the DEV level after the restore has been completed.
• Inventory reports (SQL Server version, OS version, configuration, etc.)
• Implementing standards for alerts and logins
• Configuring auditing across servers
• Changing SQL login passwords
• Perform all these activities from one centralized location with no server side agents installed
******************************************
See you then, and don't forget to friend Columbus PASS on facebook (http://facebook.com/columbussql).
Tim