Where in the world is Quacky?

Where in the world is Quacky?

Each year, Idera sponsors a variety of events worldwide to support education, training and networking opportunities for Microsoft IT professionals. Check out the list below to find events near you. We look forward to meeting you!

If you’d like Idera to sponsor an upcoming event, please contact us at sponsorships@idera.com

Webcasts

 
DATE & TIME LOCATION DESCRIPTION REGISTER
08/22/2017
02 PM CT
Online
Exploring the Plan Cache to Optimize SQL Server Performance
Reusing compiled query plans is a key part of getting great performance. This session is about discovering how plans are cached and then looking into the cache to see which plans are used a lot (perhaps worth tuning those more), which are rarely used, and which plans are being compiled over and over again because the query is written in a way that keeps the optimizer from matching it to an existing plan. We'll look at how to evict a single plan from cache, talk about plan guides as a way to force the plan you want into cache, and do a brief look at the Query Store that was added in SQL 2016.

After this session you (or your DBA) will want to run a few queries to see what your plan cache looks like and you'll find some interesting stuff in the results!

Speaker(s): Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.
Register
08/24/2017
02 PM CT
Online
Five Key Features of SQL Diagnostic Manager
DBAs typically manage many database instances so that it is vital to glance at the health of all SQL Server instances in a single window, and to drill down to find and troubleshoot problems. However, DBAs cannot continuously stare at a window and wait for problems to occur so that it is important to see the state of an instance when a problem happened in the past; this also allows for capacity planning. When there is a database performance problem, often DBAs are blamed so that it is critical to check performance issues down to the level of SQL queries and their details.

DBAs are very busy so that it is vital to take corrective action before the user experience diminishes and to automate the remediation of known issues. Every environment is different so that it is important to have access to a flexible tool with custom counters, dashboards, and reports. Join Mark Slavens as he demonstrates how IDERA SQL Diagnostic Manager makes the lives of DBAs easier with five key features.
Register
08/29/2017
02 PM CT
Online
Improve SQL Server Business Intelligence Analysis Performance

When a business analyst complains that business intelligence (BI) queries run slowly or reports won’t run, how should a DBA respond and provide performance improvements?

Having a specialized tool that provides insight into your SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) environment makes it easy to identify issues that can quickly be resolved to optimize your business environment.

Join Stan Geiger as he demonstrates how IDERA SQL BI Manager monitors your SQL Server BI stack to track health and availability, identify performance issues, and keep your analysis services running at peak efficiency.

Register
09/05/2017
10AM
UK Time
Online
Introduction to Configuring and Using SQL Diagnostic Manager
This webinar will focus on the steps to consider and take when installing and configuring IDERA's SQL Diagnostic Manager, our monitoring product for SQL Server.

There will be a wide variety of topics covered in this webinar including an introduction to the user interface, along with a demonstration of the ease of use when configuring alerts, and then talking about what it is like to spend a day in the life of a DBA, starting with responding to an email alert of a problem.

Participants of the webcast will also have the opportunity to shape the topics discussed as questions will be taken and answered live during the webcast.
Register
09/12/2017
2PM CT
Online
Improve application performance with SQL Diagnostic Manager Pro

Problematic SQL queries can severely reduce the performance of SQL Server and the business-critical applications that it supports. Consequently, it is essential to have access to detailed, real-time information on the performance of entire instances and databases, along with diagnostic tools to quickly locate and resolve specific performance issues.

Join Dan Cardno as he demonstrates how IDERA SQL Diagnostic Manager Pro continuously monitors and analyzes server workload -- focusing on wait states and application performance. Troubleshoot problematic SQL queries and index issues, validate the impact of problems and suggested fixes, uncover recurring and chronic performance bottlenecks to see degradation patterns, interrogate problem code to see impact trends for execution plan statistics, and use a shared tool to improve collaboration.

Register
09/19/2017
2PM CT
Online
Improve Database Performance by Tuning Problematic SQL Queries

Problematic SQL queries can severely reduce the performance of SQL Server and the business-critical applications that it supports. Consequently, it is essential to have access to detailed, real-time information on the performance of entire instances and databases, along with diagnostic tools to quickly locate and resolve specific performance issues.

Join Scott Walz as he demonstrates how IDERA DB Optimizer identifies previously undetected performance issues, accelerates SQL profiling and tuning, and visualizes complex SQL queries. Subsequently, Bullett Manale will show how IDERA SQL Doctor profiles SQL queries and generates expert recommendations to tune the performance of SQL queries and database indexes. See how these tools compare against your SQL performance needs.

Register
09/26/2017
2PM CT
Online
Get your Data Model Repository to the Cloud

Many data modelers and database professionals are working with servers that are located in the cloud rather than on-premises, and need to access and share data models using one of those systems. Setting up a model repository in the cloud includes configuring security groups and validating the environment. Anil Mahadev will show you how easy it is to configure your ER/Studio Repository on AWS as an example for storing your models and related metadata in the cloud.

Register