Where in the world is Quacky?

Are your SQL Server Databases Suffering from Deadlocks?

Deadlocks are required for concurrent operations of SQL Server to prevent data inconsistency and loss. However, deadlocks impair the performance of databases. Addressing deadlocks requires tuning of applications, databases, and systems. When deadlocks are a persistent problem, changes in the design of applications and databases may be needed. Join IDERA’s Todd Phillippe to learn how to monitor, alert, diagnose, and report on deadlocks with SQL Diagnostic Manager for SQL Server. View deadlocks for session and query performance, analyze locked and blocked sessions with deadlocks, and detect deadlocks with prescriptive analysis. Also, access deadlock metrics for managed cloud instances, display deadlocks on mobile devices, and set activity monitor options for deadlocks.

Are you spending most of your time with SQL Server being reactive or proactive?

Be proactive rather than reactive by analyzing SQL Server instances to address issues before they become problems that affect performance preemptively. Join IDERA’s Michael Otey to learn how to determine issues before they become problems that affect the organization with SQL Diagnostic Manager for SQL Server. Tune SQL Server via prescriptive analysis with expert recommendations, corrective scripts, and links to relevant online content. Displays trends in historical data in interactive charts via the history browser. View growth forecasts of SQL Server environments to plan capacity for future needs. With the SQL Query Tuner add-on, tune queries via visual diagrams, analyze indexes, and load test in simulated production environments.

Data Architecture - The Foundation for Enterprise Architecture and Governance

Organizations are faced with an increasingly complex data landscape, finding themselves unable to cope with exponentially increasing data volumes, compounded by additional regulatory requirements with increased fines for non-compliance. Enterprise architecture and data governance are often discussed at length, but often with different stakeholder audiences. This can result in complementary and sometimes conflicting initiatives rather than a focused, integrated approach. Data governance requires a solid data architecture foundation in order to support the pillars of enterprise architecture. In this session, IDERA’s Ron Huizenga will discuss a practical, integrated approach to effectively understand, define and implement an cohesive enterprise architecture and data governance discipline with integrated modeling and metadata management.

Do you Need to Manage SQL Server Instances in Hybrid Environments?

As organizations migrate their databases to the cloud, database administrators need to manage databases on-premise and in the cloud consistently. A typical concern is managing databases in the cloud and on-premise without learning multiple tools. Join IDERA’s Justin Wilkes to learn how to monitor the performance of SQL Server for physical, virtual, and cloud environments with SQL Diagnostic Manager for SQL Server. Deploy this flexible monitoring solution to meet the unique needs of any SQL Server environment. There is no need to fear the cloud when managing the performance and availability of cloud and traditional databases with a single tool.

SQL Server Database Administration Made Easy

If you want to simplify administration for your SQL Server environment, you need a multi-purpose database tool that can help you handle many of your daily tasks. Whether it’s managing sessions and security, comparing schema and files, or reviewing explain plans, the end goal is to keep the SQL Server instances running at optimal performance. Join IDERA’s Devin Gallagher as he demonstrates how Aqua Data Studio enables DBAs to effectively manage a complex SQL Server or multi-platform environment with a rich set of features that improve your productivity.

How to Pass a SQL Server Compliance Audit

It comes around at least once a year, if not more often. As a DBA, you are on the hook for demonstrating that your databases are compliant to one or more corporate and industry regulations. This could involve reports on user activity, database accesses, and other critical information for the environment. Join this session to learn how to prepare for and pass your audits using SQL Compliance Manager.

Are You Worried About Failures with SQL Server's High Availability?

Microsoft markets a variety of SQL Server availability technologies under the term Always On. The Always On features help to achieve a certain level of high availability. However, 100% uptime is not a realistic expectation. Additionally, it is not merely up to the feature to remain online. It requires an effort to make it useful. The two main Always On features are Availability Groups and Failover Cluster Instances. Achieving high availability with these two features requires proper planning, proper hardware, and a solid understanding of the technology.

Join us to learn how to avoid pitfalls with SQL Server’s Always On that can cause unexpected failures. With SQL Diagnostic Manager for SQL Server, monitor Always On availability groups, availability databases, and availability replicas.