Poorly written SQL queries and missing indexes can have a significant impact on SQL Server performance. IDERA’s DB PowerStudio tools can help identify problem SQL and missing indexes, even for third-party applications. IDERA’s Gary Smith will show you how to use DBArtisan and DB Optimizer to obtain index recommendations, query rewrites and hints to make your SQL more efficient.
Please join Microsoft Program Manager Vin Yu and Quest database expert Martin Wild in this informative session on Microsoft SQL Server vNext and learn how easy it is to deploy the new SQL Server on Linux technology.
As SQL Server environments become more complex, it is imperative for DBAs to effectively audit each database and instance. Join Bullett Manale as he demonstrates how IDERA SQL Compliance Manager monitors Extended Events for SELECT and DML events and helps you improve any SQL Server audit.
In this session we go back to the fundamentals and review the types of backups available in SQL Server and discuss how and when to use each and how to combine them to form a complete recovery plan.
In this webcast, we will demonstrate the IDERA ER/Studio data modeling tool and show how data model changes can be tracked and aligned with development user stories and tasks, including those in a JIRA project.
Join this webinar to get up to speed on SQL Server Columnstore Indexes for Data Warehousing. You'll learn which types of columnstore indexes there are, how you can integrate them into your data warehouse and what performance gains you can expect.
